Database Administrator

Details of the offer

Job title : Database Administrator
Job Location : Western Cape,

Deadline : December 18, 2024

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


Nominal Salary: To be agreed

Source: Whatjobs_Ppc

Requirements

Information Technology Manager

Location: King George, VA Desired Candidate Qualities: Ten (10) plus years of experience with demonstrated ability to plan and coordinate the installation, t...


Tech Wizards - South Africa

Published a month ago

Data & Analytics Industrial Placement

Data & Analytics Industrial PlacementJob Description SummaryPrior to submitting your application, please visit our early careers website to find out more abo...


Industry Placements - South Africa

Published a month ago

Specialist Technology Transfer Project

JOB PROFILE FIXED TERM CONTRACT (12 MONTHS) JOB TITLE: Specialist: Technology Transfer Projects JOB GRADE: C5 Minimum Midpoint TOTAL CTC: R507 409 - R596 9...


Small Enterprise Development Agency_Gov - South Africa

Published a month ago

Data Engineer

Please note that at this time, we are not accepting resumes from external agencies or recruiters. Any unsolicited resumes will not be considered and will not...


Hakkoda Inc. - South Africa

Published 12 days ago

Built at: 2024-12-23T09:56:24.607Z