Sr Lead Oracle And PostgreSQL DBA

Comviva

Gurugram District

On-site

INR 2,500,000 - 4,500,000

Full time

2 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Comviva is seeking an experienced Oracle and PostgreSQL Database Administrator to manage multi-engine database environments. You will install, configure, upgrade, patch, and monitor Oracle RAC/Data Guard and PostgreSQL clusters, ensuring high availability and disaster recovery.

The role requires strong SQL/PLSQL skills, backup/recovery expertise, and collaboration with developers and operations teams to optimize performance and reliability across Linux/Unix systems.

Qualifications

  • Proficient in Oracle database administration including RAC, Data Guard, RMAN and OEM.
  • Proficient in PostgreSQL administration including replication, PITR, and high availability.
  • Strong SQL/PLSQL development and query optimization skills.
  • Experience with Linux/Unix administration and shell scripting.
  • Experience with database patching, upgrades, migrations and DR planning.

Responsibilities

  • Install, configure, administer, and upgrade Oracle Database environments (RAC, Data Guard).
  • Manage Oracle ASM, RMAN backup/recovery and OEM.
  • Perform patching, cloning, upgrades, migrations and capacity planning.
  • Configure and administer Oracle GoldenGate replication and DR testing.
  • Monitor health, performance, and availability; tune proactively.
  • Manage security, access, roles, and audit compliance.
  • Collaborate with app/infrastructure teams for high availability.
  • Install, configure, and administer PostgreSQL databases (Community/Enterprise).
  • Manage backup/recovery using pg_dump, pg_basebackup, WAL archiving, PITR.
  • Configure PostgreSQL high availability with Streaming Replication, Patroni, repmgr, pgpool-II.
  • Monitor and optimize PostgreSQL performance via tuning and indexing.
  • Perform upgrades, maintenance, and troubleshooting with minimal downtime.
  • Assist Oracle-to-PostgreSQL migrations using Ora2Pg, AWS DMS, or equivalents.

Skills

Oracle DBA
PostgreSQL DBA
SQL/PLSQL
Linux/Unix
Shell scripting
Oracle RAC
Data Guard
RMAN
Oracle GoldenGate
OEM
Backup & Recovery

Tools

Ora2Pg
AWS DMS
pg_dump
pg_basebackup
Patroni
repmgr
pgpool-II

Job description

Job Description:

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).
  • Strong 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.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Junior Oracle And PostgreSQL DBA
Junior Oracle And PostgreSQL DBA

Comviva • Gurugram District

On-site
INR 1,200,000 - 1,800,000
Senior Software Engineer-Oracle-Postgres
Senior Software Engineer-Oracle-Postgres

Prodapt • Tamil Nadu

On-site
INR 1,200,000 - 2,400,000
Senior Software Engineer-Oracle-Postgres
Senior Software Engineer-Oracle-Postgres

Prodapt Solutions Private Limited • Chennai District

On-site
INR 1,200,000 - 1,800,000
Multi-Platform Database Administrator (Oracle EBS, PostgreSQL & Exadata)
Multi-Platform Database Administrator (Oracle EBS, PostgreSQL & Exadata)

Litmus7 Systems Consulting Ltd • Ernakulam, Thiruvananthapuram, Bengaluru

On-site
INR 1,500,000 - 2,100,000
Multi-Platform Database Administrator (Oracle EBS, PostgreSQL & Exadata)
Multi-Platform Database Administrator (Oracle EBS, PostgreSQL & Exadata)

Litmus7 • Thiruvananthapuram

On-site
INR 1,200,000 - 1,800,000
Senior Database Administrator (Oracle / SQL Server / PostgreSQL)
Senior Database Administrator (Oracle / SQL Server / PostgreSQL)

VMC Soft Technologies • Bengaluru Urban

On-site
INR 1,500,000 - 2,600,000
Senior Oracle Administrator - Oracle Administration,PostgreSQL,MYSQL, MS SQL
Senior Oracle Administrator - Oracle Administration,PostgreSQL,MYSQL, MS SQL

HCLTech • Pandhurna

On-site
INR 600,000 - 1,000,000
Oracle DBA / Azure Database for PostgreSQL
Oracle DBA / Azure Database for PostgreSQL

Info Way Solutions • Bengaluru

On-site
INR 1,000,000 - 1,500,000
PostgreSQL admin_Jl4
PostgreSQL admin_Jl4

Infosys • Pune District

On-site
INR 1,400,000 - 2,400,000
Senior PostgreSQL DBA
Senior PostgreSQL DBA

Programmers • Hyderabad

On-site
INR 1,200,000 - 2,100,000