Database Administrator needed at Parvana
Job title : Database Administrator
Job Location : Western Cape, Cape Town
Deadline : January 24, 2025
Quick Recommended Links
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
How to Apply for this Offer
Interested and Qualified candidates should Click here to Apply Now
- Research / Data Analysis jobs