DBA Specialist

Abacus Global; Lahore; On-site; PKR 892,800 - 1,227,600; Full time

Job summary

A leading tech firm is seeking an experienced DBA Specialist to manage Oracle and PostgreSQL databases. The successful candidate will be responsible for performance tuning, backup/recovery, and automation tasks across production and development environments. Applicants should have 3-4 years of experience in database administration, strong SQL skills, and Linux knowledge. Familiarity with replication, clustering, and various backup tools is essential. This role promises dynamic challenges in a supportive environment.

Qualifications

• 3-4 years DBA experience with Oracle & PostgreSQL.
• Strong SQL/PLpgSQL and Linux knowledge.
• Experience with replication, clustering, and backup tools.

Responsibilities

• Administer, monitor, and maintain Oracle & PostgreSQL databases.
• Perform installation, patching, and configuration.
• Manage backup, recovery, and disaster recovery strategies.
• Implement security measures and troubleshoot database issues.
• Write automation scripts and collaborate with cross-functional teams.

Skills

Oracle database management

PostgreSQL database management

SQL/PLpgSQL

Linux knowledge (RHEL, CentOS, Ubuntu)

Database automation tools

Education

Bachelors in Computer Science, IT, or related field

Tools

RMAN

pgBackRest

Dataguard

RAC

Patroni

Job description

Job Summary

We are looking for an experienced DBA Specialist to manage and optimize Oracle and PostgreSQL databases in production, UAT, and development environments. The role involves performance tuning, replication, backup/recovery, security, and automation.

Key Responsibilities

• Administer, monitor, and maintain Oracle & PostgreSQL databases.
• Perform installation, patching, and configuration.
• Manage backup, recovery, and disaster recovery strategies.
• Configure replication, high availability, and clustering solutions.
• Implement security measures and troubleshoot database issues.
• Write automation scripts and collaborate with cross-functional teams.

Required Skills

3-4 years DBA experience with Oracle & PostgreSQL.

Strong SQL/PLpgSQL and Linux knowledge (RHEL, CentOS, Ubuntu).

Experience with replication, clustering, and backup tools (RMAN, pgBackRest, Dataguard, RAC, Patroni).

Preferred

• Database certifications (OCP), cloud DB experience (AWS RDS, Azure), automation tools (Ansible, Puppet, Chef).

Education

Bachelors in Computer Science, IT, or related field.

Soft Skills

• Strong communication, problem-solving, and collaboration skills.
• Ability to work under pressure in production environments.