17 Nov
|
Comviva
|
Gurugram
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.
• Positive analytical, communication, and problem-solving skills.
• Willingness to work in a 24x7 production support environment.
📌 Junior Oracle and PostgreSQL DBA (Gurugram)
🏢 Comviva
📍 Gurugram