We’re accepting applications for the position of Postgres (PostgreSQL) Database Engineer (SAS AML Platform). Our client is seeking a versatile and skilled Open-Source Database Administrator (DBA) to join their DBAs in the current support team. The successful candidate will be responsible for the installation, configuration, maintenance, management, optimization and securing of the open-source database environments that power critical business applications. You will have the opportunity to collaborate closely with business owners, developers, DevOps, infrastructure and SecOps teams to ensure high availability, performance, and security of data assets. (Based in Johannesburg).
Duties and Responsibilities:
- Supporting current PostgreSQL open-source databases
- Supporting future open-source databases including MySQL, MariaDB, MongoDB and Redis
- Supporting cloud database solutions such as Amazon Web Services (AWS) Relational Database Service (RDS), Google Cloud SQL and Microsoft Azure Database for PostgreSQL and MySQL
- Managing and maintaining the Oracle GoldenGate (OGG) replication environment, including troubleshooting and resolving issues related to OGG replication
- Providing 24/7 support for critical systems, including participating in on-call rotations
- Designing and implementing high-availability, replication and disaster recovery solutions
- Installing, configuring and maintaining open-source databases such as PostgreSQL, MySQL and MariaDB in development, testing and production environments
- Executing patch updates, upgrades and migrations
- Monitoring and tuning database performance to meet SLAs
- Performing capacity planning and resource allocation
- Developing and managing robust backup and recovery strategies
Minimum Requirements:
- Degree in STEM field
- At least 5 years’ experience in managing PostgreSQL or open-source databases in a production environment
- Strong knowledge of PostgreSQL architecture, internals, and tools
- Hands-on experience with replication, high availability, and disaster recovery
- Proficiency in writing and tuning SQL queries
- Have exposure to the SAFe Agile framework
- Have worked in Hybrid Cloud environments like Microsoft Azure
- Solid understanding of Linux administration (RHEL, CentOS, Ubuntu)
- Experience with monitoring tools (Prometheus, Grafana, Zabbix) and automation frameworks (Ansible, Terraform)
- Optional Certifications – EDB Certified PostgreSQL Associate/Professional; Relevant cloud platform certifications (AWS, Azure, GCP); Linux administration certifications
- ITIL Service Management experience desirable
- Demonstrable working knowledge and competence using JIRA and Confluence desirable
- Experience with DevOps and DevSecOps teams desirable
- Experience working within a multi-national team and serving customers from multiple countries would be of benefit desirable
- Familiarity with cloud-based database services (AWS RDS, GCP, Azure) is a plus
- Knowledge of Oracle databases with experience in the RAC, Grid, ASM and data guard technologies desirable
- Knowledge of Oracle engineered systems (EXADATA & ZFS) and familiarity with Exadata System Software and monitoring tools (e.g. ExaWatcher) desirable