Senior DBA: Oracle & PostgreSQL Replication Expert

Abacus; Lahore; Presencial; PKR 1.800.000 - 3.200.000; Jornada completa

Descripción de la vacante

Abacus is seeking a highly skilled Database Administrator to join our Lahore team. The ideal candidate will manage Oracle and PostgreSQL environments, implement replication, deployment, and clustering strategies, and ensure data integrity for multi-terabyte datasets.

You will own performance tuning, security, backups, and incident response, while collaborating with development and operations to support large enterprise-grade applications. Immediate joining is preferred.

Formación

• Proficiency in Oracle and Oracle GoldenGate, PostgreSQL, replication, deployment, and cluster architecture best practices.
• Minimum 4+ years of software development and database administration experience.
• Experience with database clustering and load-balancing technologies is advantageous.
• Knowledge of configuring active-active configurations for databases.
• Strong knowledge of database security, backup, and recovery practices.
• Ability to manage multi-terabyte datasets in production environments.
• Expertise in writing efficient queries and stored procedures.
• Excellent problem-solving and analytical skills.
• Leadership abilities to oversee project lifecycles and mentor team members.
• Familiarity with tracking SLAs, KPIs, and OLAs.

Responsabilidades

• Manage and maintain Oracle, Oracle GoldenGate and PostgreSQL databases with high performance, availability, and scalability.
• Configure and manage database deployment, clustering, replication and load-balancing technologies.
• Write and optimize complex queries and stored procedures for data management.
• Handle multi-terabyte datasets while ensuring data integrity and security.
• Implement and maintain database security, backup, and recovery strategies.
• Diagnose and resolve complex database issues with strong problem-solving skills.
• Oversee entire project lifecycle from initiation to closure with technical excellence.
• Provide daily production support and manage customer interfaces to minimize downtime.
• Prepare functional and technical specification documents to align with project requirements.
• Manage and track ticket queues, ensuring SLA/KPI/OLA compliance.
• Ensure adherence to Software Quality Processes and project timelines.
• Mentor and guide team members to foster a collaborative environment.
• Act as single point of contact between team and stakeholders for effective communication.
• Manage and optimize large data pipelines in a production support environment.

Conocimientos

Oracle

Oracle GoldenGate

PostgreSQL

Data replication

Deployment

Cluster architecture

Descripción del empleo

Abacus is seeking a highly skilled Database Administrator to join our Lahore team. The ideal candidate will manage Oracle and PostgreSQL environments, implement replication, deployment, and clustering strategies, and ensure data integrity for multi-terabyte datasets.

You will own performance tuning, security, backups, and incident response, while collaborating with development and operations to support large enterprise-grade applications. Immediate joining is preferred.