Oracle Database Admin

HypTechie; Hyderabad; On-site; INR 1,200,000 - 1,600,000; Full time

Job summary

HypTechie is seeking a seasoned Oracle DBA to manage and optimize our global Oracle database estate. You will install, configure and maintain Oracle server instances, implement high-availability solutions, and support development, QA, PSE and production environments through ServiceNow.

You will review production performance, tune queries across Oracle, MSSQL and PostgreSQL, maintain backups and recovery strategies, and provide 24/7 L1–L3 support while documenting configurations and procedures

Qualifications

• Bachelor’s degree or equivalent experience.
• Proven Oracle DBA experience with 19c/21c/22c.
• Strong performance tuning and HA/DR knowledge.

Responsibilities

• Install, configure and maintain Oracle server instances.
• Implement high availability solutions, including Always On and clustering.
• Support development, QA, PSE and production environments via ServiceNow.
• Review production performance and tune variances.
• Optimize SQL queries and indexes across MSSQL, PostgreSQL and Oracle.
• Perform backup and recovery strategies with Oracle tools.
• Provide 3rd line support for critical production environments.
• Document database configurations and procedures.
• Lead L1–L3 support for a 24/7 global infrastructure.

Skills

Oracle 19c

Oracle 21c

Oracle 22c

MSSQL

PostgreSQL

Oracle GoldenGate

Python

Angular

PowerShell

HA/DR

Backup & Restore

Shell scripting

Team coordination

Incident management

Performance tuning

Education

Bachelor's degree or equivalent

Job description

What You’ll Do

• Software Installation, configure and maintain Oracle server instances
• Implement and handle High availability solutions including Always ON availability groups and clustering.
• Support development, QA, PSE and Production environments using ServiceNow ticketing system.
• Review production performance reports for variances from normal operation.
• Optimize SQL queries and indexes for better efficiency. Analyze query and recommend the tuning strategies.
• Maintain database performance by calculating optimum values for database parameters; implementing new releases; completing maintenance requirements; evaluating computer operating systems and hardware products.
• Perform database backup and recovery strategy using tools like SQL server backup, log shipping and other technologies.
• Provide 3rd level support for DTCC critical production environments.
• Participate in root cause analysis for database issues.
• Prepare users by conducting training; providing information; and resolving problems.
• Maintains quality service by establishing and enforcing organizational standards.
• Setup and maintain database replication and clustering solutions.
• Maintains professional and technical knowledge by attending educational workshops; reviewing professional publications; establishing personal networks; benchmarking innovative practices; participating in professional societies.
• Will have shared responsibility for off-hour support.
• Maintain documentation on database configurations and procedures.
• Provide leadership and direction for the Architecture, Design, Maintenance and L1, L2 and L3 Level Support of a 7 x 24 global infrastructure.

Qualifications

• Bachelor’s degree or equivalent experience

Talents Needed for Success

• Strong Oracle Experience of 19c, 21c and 22c.
• A minimum 4+ years of proven relevant experience in Oracle
• Solid experience in Oracle Database administration
• Strong knowledge in Python and Angular.
• Working knowledge of Oracle’s Golden gate Replication technology
• Demonstrate strong performance Tuning and Optimization skills in MSSQL, PostgreSQL and Oracle databases.
• Good Experience in High Availability and Disaster recovery (HA/DR) options for SQL server.
• Good experience in Backup and restore processes.
• Proficiency in power shell scripting for automation.
• Possess Good interpersonal skills and ability to coordinate with various stakeholders.
• Follow standard processes on Organizational change / Incident management / Problem management.
• Demonstrated ability to solve complex systems and database environment issues.