Lead DBA: Oracle & PostgreSQL with Clustering

abacus-consulting-3; Lahore; On-site; PKR 1,800,000 - 3,000,000; Full time

Job summary

Abacus is seeking a skilled Database Administrator (DBA) to manage Oracle and PostgreSQL databases, ensure high performance, availability, and security. The role involves deployment, clustering, and replication, with responsibility for multi-terabyte datasets and proactive project lifecycle management.

You will optimize queries, implement backup/recovery strategies, and mentor team members while coordinating with stakeholders to meet SLAs and timelines.

Qualifications

• 3+ years of software development and DBA experience.
• Experience with Oracle and PostgreSQL clustering.
• Ability to manage multi-terabyte datasets.

Responsibilities

• Manage and maintain Oracle and PostgreSQL databases for performance and availability.
• Configure deployment, clustering, replication, and load balancing.
• Write and optimize complex queries and stored procedures.
• Handle multi-terabyte datasets with data integrity and security.
• Implement backup and recovery strategies.
• Diagnose and resolve complex database issues and mentor teammates.

Skills

Oracle

PostgreSQL

Replication

Deployment

Cluster architecture

Security & backups

Tools

SQL

SQL tooling

Job description

Abacus is seeking a skilled Database Administrator (DBA) to manage Oracle and PostgreSQL databases, ensure high performance, availability, and security. The role involves deployment, clustering, and replication, with responsibility for multi-terabyte datasets and proactive project lifecycle management.

You will optimize queries, implement backup/recovery strategies, and mentor team members while coordinating with stakeholders to meet SLAs and timelines.