Postgre SQL Dba - Johannesburg, South Africa - AO Technology Group
2 weeks ago
Description
Who is AO Connect?
AO Connect is a proud AO Group company.
At AO Connect, we highly appreciate responsibility and ownership, the capability to execute and deliver, a strong customer-centric approach, integrity, teamwork, and initiative.
Our aim is to find innovative and talented individuals who aspire to create a significant impact within a dynamic environment, collaborating as part of our efficient and enthusiastic teams.
Summary
Key Areas of Responsibility:
- Design, implement, and maintain PostgreSQL database systems, including schema design, table creation, and data migration.
- Monitor and optimize database performance, identifying and resolving bottlenecks, and implementing tuning strategies.
- Develop and implement backup and recovery procedures to ensure data integrity and availability.
- Implement and maintain database security measures, including user access controls, data encryption, and audits.
- Perform database capacity planning and recommend infrastructure enhancements to support future growth.
- Develop and maintain documentation, including standard operating procedures, configuration guides, and troubleshooting resources.
- Participate in oncall rotation for 24/7 support and respond to databaserelated incidents in a timely manner.
- Stay uptodate with the latest PostgreSQL features, releases, and security patches, evaluating their potential impact on our database environment.
Qualifications and Experience Required:
- Relevant work experience will be considered in lieu of a diploma or degree.
- At least 5 years' experience as a PostgreSQL Database Administrator or in a similar role.
- Strong knowledge of PostgreSQL database concepts, administration, and performance tuning.
- Proficient in SQL and experience with database query optimization techniques.
- Experience with database installation, configuration, and maintenance on Linux/UNIX platforms.
- Familiarity with database security best practices and data protection techniques.
- Knowledge of backup and recovery strategies, including pointintime recovery and replication.
- Experience with monitoring and performance analysis tools for PostgreSQL databases.
- Strong problemsolving and troubleshooting skills, with the ability to analyse complex database issues and provide effective solutions.
- Excellent communication and interpersonal skills, with the ability to collaborate with crossfunctional teams.
Job Type:
Contract
Contract length: 12 months
More jobs from AO Technology Group
-
System Analyst
Johannesburg, South Africa - 3 weeks ago
-
Junior Finance Administrator
Centurion, South Africa - 3 weeks ago
-
Engineering Lead
Sandton, South Africa - 2 weeks ago
-
SQL Dba
Johannesburg, South Africa - 2 weeks ago