Comviva logo

Junior Oracle and PostgreSQL DBA

Comviva
Gurugram

Posted:1 day ago

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.

Skills Required

Oracle Postgresql Oracle Database Resource Utilization Troubleshooting Security Management Database Security SQL Tuning Oracle RAC SQL Pl/sql Linux

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