Job title : Database Administrator Job Location : Western Cape, Cape Town Deadline : January 24, 2025 Quick Recommended Links Jobs by Location Job by industries What you will be doing: Collaborate with developers and data engineers to design data models, select technologies, and enhance stability and observability with SRE & Cloud Engineering teams.
Design and implement high-availability database features, including replication and disaster recovery methodologies.
Develop optimised database schemas, SQL queries, and stored procedures that follow best practices for high performance and scalability.
Conduct compliance testing and ensure pre-production and production databases are tuned for peak performance and minimal downtime.
Resolve issues, perform root cause analysis, and implement preventative techniques.
Test and deploy new database versions and patches to maintain optimal performance and security.
Contribute to team knowledge-sharing and upskilling sessions, promoting best practices and supporting continuous learning.
Integrate database management into CI/CD pipelines and oversee traditional DBA tasks like backups, maintenance, and disaster recovery while ensuring regulatory compliance.
What you need: 5+ years of experience in operating highly transactional environments.
Open to working with various database technologies, both relational (e.g., MySQL with RDS, MS SQL Server) and NoSQL.
Proficient in AWS data services (EC2, RDS, S3) and skilled in database performance tuning, query optimisation, and execution plan analysis.
Knowledgeable in database encryption and compliance frameworks (e.g., GDPR, HIPAA).
Experience with scripting languages (Python, Unix/Linux Shell) and managing databases on Unix platforms.
Familiar with Agile/Scrum methodologies, version control systems like Git, and systems change management.
Strong communication, problem-solving, and critical judgement skills; able to collaborate effectively with internal and external colleagues.
Customer-focused, able to understand and address the needs of development stakeholders.
Detail-oriented and systematic, with planning foresight; experience with database migration and containerization tools (e.g., Docker, Kubernetes) is a plus.
Technologies you will be exposed to: AWS: RDS MySQL, RDS Microsoft SQL Server, RDS PostgreSQL, EC2/ECS/Lambda/Route 53, S3 RDBMS: MySQL, SingleStore, Microsoft SQL Server, PostgreSQL, Snowflake Scripting: PowerShell, Bash, Python Monitoring: Zabbix, AWS CloudWatch, Percona monitoring and management Security: MySQL ACL, Windows AD, Database Encryption (e.g., AWS KMS) Source Control: AWS CodePipeline, TeamCity, GitLab, Octopus, RedGate Source Control Operating Systems: Windows Server, Linux, Ubuntu Collaboration: Atlassian Jira/Confluence Research / Data Analysis jobs