17 Nov
|
Comviva
|
Gurugram
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.
• Robust 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.
📌 Sr. Lead Oracle and PostgreSQL DBA (Gurugram)
🏢 Comviva
📍 Gurugram