Junior Oracle And PostgreSQL DBA

Comviva

Gurugram District

On-site

INR 1,200,000 - 1,800,000

Full time

2 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Comviva is seeking a DBA to assist in managing Oracle and PostgreSQL databases in a 24x7 production environment. You will handle backups, patching, performance tuning, and migrations, with a strong emphasis on reliability and security.

The role involves monitoring, troubleshooting, and DR activities to ensure high availability across critical systems. Candidate should have hands-on Oracle and PostgreSQL experience, familiarity with RAC, Data Guard, and GoldenGate, and solid SQL skills.

Qualifications

  • Hands-on knowledge of Oracle and PostgreSQL administration.
  • Experience with Oracle RAC, Data Guard, ASM, RMAN, and GoldenGate.
  • Experience with PostgreSQL backup/recovery, WAL, replication, and HA.
  • Strong SQL and basic PL/SQL knowledge.
  • Basic Linux/Unix and shell scripting.

Responsibilities

  • Assist in administration and maintenance of Oracle databases (RAC, Data Guard).
  • Support RMAN backups, patching, upgrades, cloning, and migrations.
  • Monitor health, availability, alerts, sessions, and resources.
  • Assist with GoldenGate monitoring and troubleshooting.
  • Support user, role, privilege, and security management.
  • Assist with AWR/ASH analysis and performance troubleshooting.
  • Participate in DR drills, failover, and switchover activities.
  • Assist PostgreSQL administration and backup/recovery tasks.
  • Monitor PostgreSQL replication and performance.
  • Assist patching, upgrades, maintenance, and troubleshooting.
  • Assist in Oracle-to-PostgreSQL migration activities.
  • Perform daily health checks and proactive monitoring.
  • Analyze database logs and collect diagnostics for incident resolution.
  • Support backup validation, recovery, and DR activities.

Skills

Oracle DBA
PostgreSQL DBA
RAC
Data Guard
RMAN
SQL
Linux shell scripting

Tools

Oracle GoldenGate
pg_basebackup

Job description

Job Description:

Key Responsibilities
Oracle Database
  • Assist in administration and maintenance of Oracle databases, including RAC and Data Guard.
  • Support RMAN backup/recovery, database patching, upgrades, cloning, and migrations.
  • Monitor database health, availability, alerts, sessions, tablespaces, and resource utilization.
  • Assist with Oracle GoldenGate monitoring and troubleshooting.
  • Support database user, role, privilege, and security management.
  • Assist with AWR/ASH analysis and performance troubleshooting.
  • Participate in DR drills, failover, and switchover activities.
PostgreSQL Database
  • Assist in administration and maintenance of PostgreSQL Community and Enterprise databases.
  • Support backup/recovery using pg_dump, pg_basebackup, WAL archiving, and PITR.
  • Monitor PostgreSQL replication, database health, and performance.
  • Assist with patching, upgrades, maintenance, and troubleshooting.
  • Support user/role management and database security.
  • Assist in Oracle-to-PostgreSQL migration activities.
Performance & Operations
  • Perform daily database health checks and proactive monitoring.
  • Monitor CPU, memory, I/O, disk space, sessions, locks, and database availability.
  • Assist with SQL tuning, execution-plan analysis, and performance troubleshooting.
  • Analyze database logs and collect diagnostics for incident resolution.
  • Support backup validation, recovery, and DR activities.
Required Skills
  • Hands-on knowledge of Oracle and PostgreSQL administration.
  • Understanding of Oracle RAC, Data Guard, ASM, RMAN, and GoldenGate.
  • Understanding of PostgreSQL backup/recovery, WAL, replication, and HA.
  • Good knowledge of SQL and basic PL/SQL.
  • Basic Linux/Unix and shell scripting skills.
  • Exposure to database patching, upgrades, migrations, and troubleshooting.
  • Good analytical, communication, and problem-solving skills.
  • Willingness to work in a 24x7 production support environment.

Requirements:

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Sr Lead Oracle And PostgreSQL DBA
Sr Lead Oracle And PostgreSQL DBA

Comviva • Gurugram District

On-site
INR 2,500,000 - 4,500,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
Oracle Administrator
Oracle Administrator

People's Growth HR Solutions • Mumbai

On-site
INR 900,000 - 1,350,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 Database Administrator
Oracle Database Administrator

Simelabs - An Astek Company • Ernakulam

On-site
INR 800,000 - 1,500,000
Oracle Database Administrator
Oracle Database Administrator

Team Computers • Hyderabad

On-site
INR 1,200,000 - 1,800,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
Senior Oracle Administrator - Oracle Administration,PostgreSQL,MYSQL, MS SQL
Senior Oracle Administrator - Oracle Administration,PostgreSQL,MYSQL, MS SQL

HCLTech • Nagpur District

On-site
INR 1,500,000 - 2,000,000