Database Administrator

Abacus; Lahore; On-site; PKR 1,200,000 - 2,000,000; Full time

Benefits offered by this job

Restaurant d'entreprise

Job summary

Abacus in Lahore seeks a skilled Database Administrator to manage Oracle and PostgreSQL databases, focusing on replication, deployment, and cluster architecture. The role involves handling multi-terabyte datasets with secure backups and proactive lifecycle management.

You will oversee the full project lifecycle, optimize queries, and mentor engineers while ensuring high availability, performance, and adherence to SLAs in production support environments.

Qualifications

• Proficiency in Oracle and PostgreSQL, replication, deployment, and cluster architecture.
• Experience with multi-terabyte datasets and secure backups/recovery.
• Knowledge of clustering and load balancing techniques.
• Strong SQL proficiency and ability to optimize complex queries.
• Experience leading projects and mentoring team members.

Responsibilities

• Manage and maintain Oracle and PostgreSQL databases with high availability and scalability.
• Configure deployment, clustering, replication, and load-balancing to boost performance.
• Write and optimize complex queries and stored procedures.
• Handle multi-terabyte datasets with data integrity and security.
• Ensure database security, backup, and recovery best practices.
• Diagnose and resolve complex issues and oversee project lifecycle.
• Provide production support and coordinate with stakeholders to minimize downtime.
• Prepare functional and technical specification documents.
• Manage ticket queues, SLAs, KPIs, and OLAs.
• Mentor team members and facilitate effective communication with stakeholders.

Skills

Oracle

PostgreSQL

Replication

Deployment

Cluster design

Problem solving

SQL queries

Project lifecycle

Leadership

Data pipelines

Job description

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