Database Administrator

Abacus; Lahore; Presencial; PKR 1 800 000 - 2 600 000; Tempo integral

Resumo da oferta

Abacus in Lahore is seeking a skilled Database Administrator (DBA) with expertise in Oracle, Oracle GoldenGate and PostgreSQL. The role focuses on replication, deployment, and cluster architecture, handling multi-terabyte datasets with proactive problem-solving and lifecycle management.

The successful candidate will provide production support, manage tickets and interfaces with stakeholders to ensure high availability and performance, while following best practices for security, backup, and

Qualificações

• Proficiency in Oracle, Oracle GoldenGate and PostgreSQL databases.
• Experience with replication, deployment and cluster architectures.
• Knowledge of security, backup and recovery best practices.

Responsabilidades

• Manage and maintain Oracle, Oracle GoldenGate and PostgreSQL databases for performance and availability.
• Configure deployment, clustering, replication and load-balancing technologies.
• Write and optimize complex queries and stored procedures.
• Handle multi-terabyte datasets with emphasis on data integrity and security.
• Ensure database security, backup, and recovery per best practices.
• Oversee project lifecycle from initiation to closure with technical excellence.
• Provide daily production support and manage customer interface to minimize downtime.
• Prepare functional and technical specification documents for projects.
• Track tickets, SLAs, KPIs, and OLAs to ensure timelines.

Conhecimentos

Oracle

Oracle GoldenGate

PostgreSQL

Replication

Deployment

Cluster architecture

Load balancing

SQL queries

Problem solving

Descrição da oferta de emprego

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