Database Administrator

WHO WE ARE

At Abacus, we specialize in technology, outsourcing, and people solutions, bringing nearly 40 years of experience shaped alongside the organizations we support. As a global professional services leader, our focus remains on providing bespoke solutions that enable organizations to create the future of business and embrace change for sustainable growth, powered by a global team of over 5,000 people.

WHAT WE DO

Across digital transformation, emerging technologies, SAP enterprise solutions, outsourcing, and human capital, we support organizations in building environments that operate effectively and scale with the business. Today, this extends to more than 1,500 enterprise clients, where the focus remains on creating systems that are not only functional, but ready to adapt and evolve over time.

Location: Lahore

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, Oracle GoldenGate 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 Oracle GoldenGate, PostgreSQL, database replication, deployment, and cluster application architecture.
• Minimum 4+ 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 configurations 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