Oracle Core DBA

Cognizant; Pune District, Hyderabad; On-site; INR 1,400,000 - 2,200,000; Full time

Job summary

Cognizant is seeking an Oracle Core DBA with migration/upgrade experience and GoldenGate expertise to design and manage mission-critical financial systems using Oracle Autonomous Database Cloud and OCI Compute.

The role involves managing on-prem and cloud environments (OCI/ExaDB), performing backups, Data Guard operations, RAC implementations, and zero-downtime migrations. Strong PL/SQL and SQL tuning skills are required, along with excellent communication.

Qualifications

• Extensive experience as Oracle Core DBA with migration/upgrade expertise.
• Strong background in RAC, Data Guard and Grid infrastructure.
• Experience with backups, patching and memory management.
• Proficient in PL/SQL development and SQL tuning.

Responsibilities

• Manage Oracle database environments - on-premise and cloud (OCI).
• Setup and monitor backups; perform DR tests and Data Guard operations.
• Implement upgrades and migrations (19c/18c/12c) with zero downtime if possible.
• Tune performance: SQL, memory, I/O, and kernel parameters.
• Develop and optimize PL/SQL code; troubleshoot GoldenGate replication.
• On-call/support and issue escalation.

Skills

Oracle Core DBA

RAC

GoldenGate

Data Guard

Backups

PL/SQL

SQL tuning

Linux kernel tuning

Shell scripting

Migration/Upgrade

Tools

GoldenGate

OCI Cloud Compute

Oracle RAC

Job description

Oracle Core DBA - With Migration/Upgrade Experience and Golden Gate

-Develop detailed high level and low level designs using Oracle Autonomous Database Cloud and OCI Cloud Compute Service to meet stringent performance and reliability expectations for mission critical financial systems

• Managing Oracle database environment - In-Premise and/or Cloud Environment (preferably OCI and ExaDB), versions 19c
• Setup, Perform and monitor database backups for successful completion.
• Configure Data Guard databases, support, monitoring and rebuild standby DBs.
• Install and patch Oracle database software - RDBMS and Grid, RAC (11g, 12c, 18c, 19c) and related components
• Perform database performance tuning(indexing and optimizer strategies, stored procedures/triggers, partitioning, commit levels, rollbacks, locking schemes, temporary spaces/sort areas, and memory management).
• Strong RAC Implementation and support experience.
• 19c/18c/12 Database upgrades and migration experience.
• Proficient in instance (memory) tuning, database performance tuning, SQL tuning, configuring Linux Kernel for Oracle Database usage, and tuning contention for I/O.
• Proficient in PL/SQL code optimization, tuning and development.
• Good experience with Golden Gate Configuration and troubleshooting
• Exposure to Zero downtime migrations using Golden Gate and troubleshoot issues related to replication
• Good exposure in Unix shell scripting.
• Excellent oral/written communication
• Participate in on-call / Escalation till closure.
• Proficient in instance (memory) tuning, database performance tuning, SQL tuning, configuring Linux Kernel for Oracle Database usage, and tuning contention for I/O.
• Proficient in PL/SQL code optimization, tuning and development.
• Sound knowledge in SQL Tuning, SQL Plan management