Senior Postgresql Dba – L2/L3 (Contract / Permanent) Pretoria/Onsite

Isanqa Resourcing; Pretoria; On-site; ZAR 800,000 - 1,200,000; Full time

Job summary

Isanqa Resourcing in Pretoria is seeking a Senior PostgreSQL DBA (L2/L3) to manage enterprise production databases onsite. You will ensure availability, performance, security and resilience in highly transactional environments.

The role focuses on production support, troubleshooting, disaster recovery, high availability and ongoing maintenance, with standby/on-call duties as required. 5+ years' hands-on PostgreSQL experience is essential.

Qualifications

• 5+ years' relevant database administration experience.
• Experience supporting production database environments.
• Availability for standby/after-hours support.
• Strong PostgreSQL administration in production environments.

Responsibilities

• Administer and support PostgreSQL databases across enterprise production environments.
• Monitor database health, performance, capacity and availability.
• Perform performance tuning and query optimisation to resolve issues.
• Diagnose and resolve production incidents including blocking, deadlocks and performance issues.
• Implement backup and recovery strategies and test DR processes.
• Support high availability and replication solutions.

Skills

PostgreSQL

DBA

Performance tuning

High availability

Production support

Education

Relevant tertiary qualification

Job description

Senior PostgreSQL DBA L2/L3 (Contract / Permanent) Pretoria/Onsite

We are looking for an experienced Senior PostgreSQL Database Administrator to support and maintain enterprise-level production database environments.

The successful candidate will be responsible for the administration, availability, performance, security and resilience of critical databases, with a strong focus on production support, troubleshooting, performance tuning, high availability and disaster recovery.

The role is suited to a strong L2 or L3 DBA who is comfortable working independently in a highly transactional environment and participating in standby / after-hours support when required.

Key Responsibilities

• Administer and support PostgreSQL databases across enterprise production environments.
• Monitor database health, performance, capacity and availability.
• Perform performance tuning and query optimisation to resolve database and application performance issues.
• Diagnose and resolve complex production incidents, including blocking, locking, deadlocks and database performance issues.
• Implement and maintain backup and recovery strategies.
• Support and test Disaster Recovery (DR) processes and procedures.
• Implement and maintain High Availability (HA) and replication solutions.
• Perform database installations, upgrades, patching and maintenance.
• Manage database security, users, roles, permissions and access controls.
• Monitor database growth, storage utilisation and overall environment health.
• Perform database migrations and support infrastructure or platform changes.
• Develop and maintain database monitoring, maintenance and automation processes.
• Participate in change management, incident management and production support processes.
• Maintain accurate technical documentation and operational procedures.
• Participate in standby / on-call support for critical production environments.

Technical Requirements

• Strong hands-on experience as a PostgreSQL DBA in production environments.
• Experience supporting enterprise and/or highly transactional databases.
• Strong knowledge of PostgreSQL administration, configuration and maintenance.
• Strong SQL and query optimisation capabilities.
• Practical experience with performance tuning and troubleshooting.
• Experience with PostgreSQL backup and recovery.
• Experience with replication and High Availability technologies.
• Practical Disaster Recovery experience, including DR testing.
• Strong understanding of database security, roles and permissions.
• Experience with database monitoring and health checks.
• Experience with database migrations and upgrades.
• Ability to investigate and resolve high-priority production incidents.
• Experience working in 24/7 production environments.
• Willingness to participate in standby / on-call support.

Advantageous Experience

• SQL Server DBA experience.
• Microsoft SQL Server HA/DR, Always On, replication or clustering experience.
• PowerShell or scripting/automation experience.
• Microsoft Azure / cloud database experience.
• Experience supporting large-scale enterprise database estates.
• Experience in regulated financial services, logistics, or other highly transactional environments.

Seniority / Level

Candidates should demonstrate either:

• L3-level capability, with the ability to independently manage complex production database environments and resolve advanced technical issues; or
• Strong L2 capability with demonstrable experience operating independently and the technical depth to develop into an L3 role.

Personal Attributes

• Strong analytical and troubleshooting skills.
• Able to work independently in production environments.
• Comfortable working under pressure during critical incidents.
• Strong attention to detail and operational discipline.
• Good communication and stakeholder management skills.
• Proactive approach to monitoring, performance and database reliability.
• Strong documentation and change-control discipline.

Minimum Requirements

• Relevant tertiary qualification and/or recognised database certification preferred.
• 5+ years' relevant database administration experience, with strong hands-on PostgreSQL experience.
• Proven experience supporting production database environments.
• Availability for standby / after-hours support where required.

#FuelledbyPassionIntegrityExcellence #isanqa #isanqaresourcing #isanqajobs #PostgreSQL #PostgreSQLDBA #DatabaseAdministrator #DBA #DatabaseAdministration #PerformanceTuning #HighAvailability #DisasterRecovery #ProductionSupport #DatabaseMigration #SQLServer #Azure #ITJobs #TechJobs #SouthAfricaJobs

iSanqa

iSanqa is your trusted Level 2 BEE recruitment partner, dedicated to continuous improvement in delivering exceptional service. Specializing in seamless placements for permanent staff, temporary resources, and efficient contract management and billing facilitation, iSanqa Resourcing is powered by a team of professionals with an outstanding track record. With over 100 years of combined experience, we are committed to evolving our practices to ensure ongoing excellence.