Database Administrator

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

Job Summary:

We are seeking a highly skilled and motivated Database Administrator (DBA) to join our dynamic team at Abacus. The ideal candidate will possess expertise in Oracle and PostgreSQL databases, along with a strong background in database replication, deployment, and cluster application architecture. This role requires an individual with excellent problem-solving skills, the ability to manage multi-terabyte datasets, and a proactive approach to database administration and project lifecycle management.

Key Responsibilities:

• Manage and maintain Oracle and PostgreSQL databases, ensuring high performance, availability, and scalability.
• Configure and manage database deployment, clustering, replication and load-balancing technologies to enhance performance.
• Write and optimize complex queries and stored procedures for efficient data management.
• Handle multi-terabyte datasets effectively, ensuring data integrity and security.
• Implement and maintain database security, backup, and recovery strategies according to industry best practices.
• Diagnose and resolve complex database issues, leveraging excellent problem-solving and analytical skills.
• Oversee the full project lifecycle, including initiation, planning, execution, control, and closure, while maintaining technical excellence.
• Provide daily production support and manage customer interface, proactively addressing issues to minimize downtime.
• Prepare functional and technical specification documents to align with project requirements.
• Manage and track ticket queues, ensuring compliance with SLAs, KPIs, and OLAs.
• Ensure adherence to Software Quality Processes and project timelines, delivering quality results within deadlines.
• Mentor and guide team members, fostering a collaborative and motivated work environment.
• Act as the single point of contact between the team and project stakeholders, facilitating effective communication and resolution of issues.
• Manage and optimize large data pipelines in a production support environment.

Requirements:

• Must-Have Skills: Proficiency in Oracle and PostgreSQL, database replication, deployment, and cluster application architecture.
• Minimum 3 years of experience in software development and database administration.
• Experience with database clustering and load-balancing technologies is highly advantageous.
• Knowledge of configuring active-active configuration for databases.
• Strong knowledge of database security, backup, and recovery best practices.
• Proven ability to manage multi-terabyte datasets in a production environment.
• Expertise in writing queries and stored procedures.
• Excellent problem-solving and analytical skills.
• Strong organizational and leadership abilities to oversee project lifecycles and mentor team members effectively.
• Familiarity with tracking and managing ticket queues, SLAs, KPIs, and OLAs.
• Proven ability to prepare detailed functional and technical specification documents.

Immediate joining preferred