- Database Optimization
- Performance Tuning
- SQL Syntax Refinement
- Infrastructure and Storage Design
- Audit Tracking and SQL Auditing
- Data Extraction Techniques
- High Availability (HA) and Disaster Recovery (DR) Design
- Backup and Recovery Strategies
- Security Best Practices Implementation
- Operational Management and Guidelines Development
- Collaboration with Cross-Functional Teams
- Scripting for Automation and Process Optimization
Overview
We are seeking an experienced Senior DevOps Engineer / Database Administrator with a deep understanding of PostgreSQL and AWS services, particularly AWS Aurora and standalone PostgreSQL. The ideal candidate will be responsible for the optimization, performance tuning, security, and operational management of database infrastructure. This role will also involve designing and implementing high-availability/disaster recovery (HA/DR) solutions and ensuring best practices in database management.
Responsibilities
- Database Management & Optimization:
- Manage, optimize, and tune AWS Aurora and standalone PostgreSQL databases for performance and reliability.
- Design and implement database infrastructure and storage solutions.
- Perform SQL syntax tuning and overall infrastructure optimization.
- Develop and enforce security best practices for database systems.
- Performance & Security:
- Conduct performance tuning and implement operational guidelines to enhance database efficiency.
- Implement and maintain robust audit tracking and SQL auditing mechanisms.
- Establish and monitor backup and recovery practices to ensure data integrity and security.
- Operational Excellence:
- Develop operational guidelines and standard operating procedures for database management.
- Oversee data extraction techniques, including change tracking and SQL auditing.
- Design and implement infrastructure solutions with a focus on high availability and disaster recovery (HA/DR).
- Collaboration:
- Work closely with development teams to provide database expertise and support.
- Collaborate with infrastructure and security teams to align database operations with organizational objectives.
Experience
- Proven experience as a Senior DevOps Engineer or Database Administrator specializing in PostgreSQL.
- Hands-on experience with AWS Aurora and standalone PostgreSQL.
- Expertise in database optimization, performance tuning, and SQL syntax refinement.
- Strong knowledge of infrastructure/storage design and operational management.
- Proficiency in implementing security and performance best practices.
- Experience with data extraction techniques, change tracking, and audit tracking.
- Familiarity with HA/DR design, backup, and recovery strategies.
- Strong understanding of SQL auditing tools and methodologies.
- Ability to work in a fast-paced, collaborative environment.
Qualifications
- AWS certifications related to database or cloud architecture.
- Experience with large-scale database systems and distributed architectures.
- Strong scripting skills for automation and process optimization (e.g., Python, Bash).
- Familiarity with DevOps tools and pipelines (e.g., Jenkins, Terraform, Ansible).
Tools & Technologies
- PostgreSQL
- AWS Aurora
- AWS Cloud Services
- SQL Auditing Tools
- Terraform.
- Ansible.
- CI/CD Tools
- Scripting w/ Python
- Distributed Database Systems
- Monitoring Tools
- Logging Tools
- Git
Cape Town
Expected Salary
110 000 ZAR p/m
Work Policy
Hybrid
Team
Engineering
Industry
Software Development
Interview Process
- Initial Screening: (Conducted by Oneo.)
- 30-Minute Call: Focused on company culture and a technical dive.
- Codility Assessment: To assess coding capabilities.
- Whiteboarding/Live Technical Assessment:
- Culture Meet: Ensure team and cultural fit.
- Offer: Finalise and extend the employment offer.