PostgreSQL Database Administrator (DBA)

Recruiter:

Recru-it

Job Ref:

PE011082/LM

Date posted:

Friday, December 13, 2024

Location:

Johannesburg, South Africa

Salary:

market related Monthly

SUMMARY:
Role Overview
The PostgreSQL DBA is responsible for the performance, integrity, and security of PostgreSQL databases hosted on Azure. This role also involves leveraging Azure DevOps for continuous integration and continuous deployment (CI/CD) processes.

Key Responsibilities:

Database Management: Install, configure, and maintain PostgreSQL databases on Azure.
Performance Tuning: Optimize database performance and ensure high availability.
Security: Implement and manage database security measures.
Backup and Recovery: Develop and manage backup and recovery plans.
Monitoring: Use Azure tools to monitor database health and performance.
Troubleshooting: Diagnose and resolve database-related issues.
CI/CD Pipelines: Design and manage CI/CD pipelines using Azure DevOps for database updates and deployments.
Automation: Automate routine database tasks using Azure DevOps and other tools.
Advanced: Configure, troubleshooting and optimize triggers, replication, data imports and exports etc.

Required Skills and Qualifications

Technical Skills:
- Proficiency in PostgreSQL database management.
- Experience with Azure Database for PostgreSQL.
- Knowledge of SQL and database scripting.
- Familiarity with Azure tools and services (e.g., Azure Monitor, Azure Backup).
- Experience with Azure DevOps, including pipeline creation and management.
- Understanding of CI/CD principles and practices.

Soft Skills:
- Strong problem-solving abilities.
- Excellent communication skills.
- Ability to work independently and as part of a team.

Tools and Technologies

Primary Tools:
- PostgreSQL
- Azure Database for PostgreSQL
- Azure Monitor
- Azure Backup
- Azure DevOps
- Red-Hat Linux
Additional Tools:
- pgAdmin
- psql
- Azure CLI
- Git

Training and Development

Onboarding: Initial training on company policies and Azure environment.
Ongoing Training: Regular updates on new Azure features, PostgreSQL updates, and DevOps practices.
Certifications: Encouraged to obtain relevant certifications (e.g., Microsoft Certified: Azure Database Administrator Associate, Microsoft Certified: DevOps Engineer Expert).

Performance Metrics

Database Uptime: Maintain a high level of database availability.
Response Time: Quick resolution of database issues.
CI/CD Efficiency: Effective implementation and management of CI/CD pipelines.
Security Compliance: Adherence to security protocols and policies.

Career Path
Opportunities for advancement to Senior DBA, Database Manager, or other IT leadership

POSITION INFO:
Role Overview
The PostgreSQL DBA is responsible for the performance, integrity, and security of PostgreSQL databases hosted on Azure. This role also involves leveraging Azure DevOps for continuous integration and continuous deployment (CI/CD) processes.

Key Responsibilities:

Database Management: Install, configure, and maintain PostgreSQL databases on Azure.
Performance Tuning: Optimize database performance and ensure high availability.
Security: Implement and manage database security measures.
Backup and Recovery: Develop and manage backup and recovery plans.
Monitoring: Use Azure tools to monitor database health and performance.
Troubleshooting: Diagnose and resolve database-related issues.
CI/CD Pipelines: Design and manage CI/CD pipelines using Azure DevOps for database updates and deployments.
Automation: Automate routine database tasks using Azure DevOps and other tools.
Advanced: Configure, troubleshooting and optimize triggers, replication, data imports and exports etc.

Required Skills and Qualifications

Technical Skills:
- Proficiency in PostgreSQL database management.
- Experience with Azure Database for PostgreSQL.
- Knowledge of SQL and database scripting.
- Familiarity with Azure tools and services (e.g., Azure Monitor, Azure Backup).
- Experience with Azure DevOps, including pipeline creation and management.
- Understanding of CI/CD principles and practices.

Soft Skills:
- Strong problem-solving abilities.
- Excellent communication skills.
- Ability to work independently and as part of a team.

Tools and Technologies

Primary Tools:
- PostgreSQL
- Azure Database for PostgreSQL
- Azure Monitor
- Azure Backup
- Azure DevOps
- Red-Hat Linux
Additional Tools:
- pgAdmin
- psql
- Azure CLI
- Git

Training and Development

Onboarding: Initial training on company policies and Azure environment.
Ongoing Training: Regular updates on new Azure features, PostgreSQL updates, and DevOps practices.
Certifications: Encouraged to obtain relevant certifications (e.g., Microsoft Certified: Azure Database Administrator Associate, Microsoft Certified: DevOps Engineer Expert).

Performance Metrics

Database Uptime: Maintain a high level of database availability.
Response Time: Quick resolution of database issues.
CI/CD Efficiency: Effective implementation and management of CI/CD pipelines.
Security Compliance: Adherence to security protocols and policies.

Career Path
Opportunities for advancement to Senior DBA, Database Manager, or other IT leadership

Similar jobs you might be interested in:

PostgreSQL Database Administrator (DBA)
Location: Johannesburg
Salary: market related Monthly
Role OverviewThe postgresql dba is responsible for the performance, integrity, and security of postgresql databases hosted on Azure. This role also involves leveraging Azure DevOps for continuous integration and continuous deployment (CI/CD) processes. Key Responsibilities:database Management: Install, configure, and maintain postgresql databases on Azure.Performance Tuning: Optimize database...
5 days ago

Software Engineers
Location: Johannesburg
Salary:
Today

Technical Data Architect - Johannesburg - R1.8mil to R2mil per annum
Location: Johannesburg
Salary: 1800000
Technical Data Architect - Johannesburg - R1.8mil to R2mil per annum
1 day ago

Systems Administrator & Support Engineer
Location: Pretoria
Salary:
Are you an experienced Systems administrator with a passion for troubleshooting, maintaining, and optimizing IT infrastructure? Do you thrive in environments where your expertise in Linux, Network Administration, and end-user support can make a real impact? If so, we want to hear from you!About the Role:Our client is seeking a highly skilled Systems administrator to take on a key role within our t...
5 days ago

Senior Front-End Developer (ReactJS, GraphQL, Node.js)
Location: Johannesburg
Salary:
Our client looking for a passionate Senior Front-End Developer to join their dynamic team. In this role, you will be responsible for crafting intuitive and high-performance web applications using ReactJS, while collaborating closely with their back-end team to integrate GraphQL APIs and Node.js services. You will play a key role in enhancing user experiences and ensuring the scalability and respon...
5 days ago

Systems Engineer
Location: Pretoria
Salary: 600000.00 Annually
Our client, a leading tech company based in Pretoria, is looking for a talented Systems Engineer to join their dynamic team. This is an exciting opportunity for a proactive and skilled professional with experience in system administration, Linux, Active Directory, DNS management, and database administration.
7 days ago

Intermediate Python Developer
Location: Johannesburg
Salary: 480000.00 Annually
Our client is seeking an Intermediate Python Developer to join their dynamic development team. This exciting opportunity is perfect for an individual with a passion for technology and a strong background in API development and back-end systems.
8 days ago

Oracle Technical Lead Manager
Location: Centurion
Salary:
Our client based in Pretoria is looking for an Oracle Technical Lead Manager to join their team100 in office
9 days ago

Technical Data Architect - Johannesburg - R1.8mil to R2mil per annum
Location: Johannesburg
Salary: 1800000
Technical Data Architect - Johannesburg - R1.8mil to R2mil per annum
14 days ago

Senior/Intermediate Software Developer
Location: Centurion
Salary:
Our client, that is on their way to revolutionizing the way communities are managed, needs a Senior/Intermediate Full Stack Developer to lead the charge in developing their next-generation Community Management System. This is an exciting opportunity to influence the evolution of a product that will impact diverse users globally, while working with a cutting-edge tech stack and collaborating with p...
15 days ago