Comviva logo

Sr. Lead Oracle and PostgreSQL DBA

Comviva
Gurugram

Posted:1 day ago

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.

Skills Required

Oracle Postgresql Oracle Database Oracle RAC Backup and Recovery Capacity Planning Database Security Audit Compliance Disaster Recovery High Availability Database Administration Troubleshooting

Learn the skills this job asks for

See your skill gap for Database Administrator →

Free courses, interview questions and practice for each skill.

Job Type

Full Time

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Comviva logo
Comviva

RecommendedJobs for You