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