Sr. Lead Oracle and PostgreSQL DBA (Gurugram)

Sr. Lead Oracle and PostgreSQL DBA (Gurugram)

17 Nov
|
Comviva
|
Gurugram

17 Nov

Comviva

Gurugram

Key Responsibilities

Oracle Database Administration

- Install, configure, administer, and upgrade Oracle Database environments, including Oracle RAC and Data Guard.
- Manage Oracle ASM, RMAN backup and recovery, and Oracle Enterprise Manager (OEM).
- Perform database patching, cloning, upgrades, migrations, and capacity planning.
- Configure, administer, and troubleshoot Oracle GoldenGate replication.
- Monitor database health, performance, and availability, implementing proactive tuning and optimization.
- Manage database security, user access, roles, privileges, and audit compliance.
- Support disaster recovery (DR) planning, implementation, testing, and failover activities.
- Analyze AWR, ASH, ADDM, and execution plans to identify and resolve database performance bottlenecks.
- Collaborate with application and infrastructure teams to ensure high availability and optimal database performance.

PostgreSQL Database Administration

- Install, configure, administer, and upgrade PostgreSQL databases (Community and Enterprise editions).
- Manage backup and recovery using pg_dump, pg_basebackup, WAL archiving, and Point-in-Time Recovery (PITR).
- Configure and administer PostgreSQL high availability and replication using Streaming Replication, Patroni, repmgr, or pgpool-II.
- Monitor and optimize PostgreSQL database performance through query tuning, indexing strategies, and configuration optimization.
- Perform database upgrades, patching, maintenance,



and troubleshooting with minimal downtime.
- Support Oracle-to-PostgreSQL database migration projects using tools such as Ora2Pg, AWS DMS, or equivalent migration utilities.
- Implement database security, access controls, monitoring, and compliance best practices.

Performance & Optimization

- Perform proactive database performance monitoring, troubleshooting, and capacity planning.
- Analyze SQL execution plans and optimize complex SQL queries.
- Identify and resolve performance bottlenecks related to CPU, memory, I/O, locking, and database configuration.
- Work closely with development teams to improve application and database performance.

Required Skills

- Strong hands-on experience with Oracle Database Administration (Oracle 12c/19c/21c or later).
- Solid hands-on experience with PostgreSQL Administration (Community and Enterprise editions).
- Expertise in Oracle RAC, ASM, Data Guard, RMAN, Oracle GoldenGate, and OEM.
- Experience with PostgreSQL replication, high availability, backup and recovery, and performance tuning.
- Strong SQL, PL/SQL, and SQL query optimization skills.
- Experience with database patching, upgrades, migrations, cloning, and disaster recovery.
- Good understanding of Linux/Unix administration and shell scripting.
- Strong analytical, troubleshooting, and problem-solving skills.
- Excellent communication and stakeholder management skills.

📌 Sr. Lead Oracle and PostgreSQL DBA (Gurugram)
🏢 Comviva
📍 Gurugram

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: sr. lead oracle and postgresql dba (gurugram) / gurugram

Subscribe to this job alert:

Get the latest job offers by email for: sr. lead oracle and postgresql dba (gurugram) / gurugram