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).
- Solid 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.
- Strong 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