Cape Town City Centre: Database Administrator Cape Town

Job Summary

As a Database Administrator, you will be a key member of the Technology team, responsible for designing and developing logical and physical databases, as well as data architecture. You will ensure the integrity and performance of company databases and collaborate with other teams to diagnose and resolve issues, engineer high-quality solutions, and champion best practices to maintain optimal performance and scalability. You will also play a critical part in ensuring database security, implementing backup and recovery procedures, and proactively monitoring database systems to prevent downtime. Your expertise in tuning queries, optimizing database performance, and managing data storage solutions will directly contribute to the efficiency and success of the company’s operations. In addition to your primary responsibilities, the team is expanding its focus to include supporting Machine Learning (ML) and Artificial Intelligence (AI) initiatives. While this is not the core aspect of the role, it offers an exciting opportunity for you to gain exposure to cutting-edge ML and AI technologies and contribute to these innovative projects. This added function will provide you with the chance to broaden your skill set and engage with emerging technologies, positioning you at the forefront of technological advancements within the company. YOU WILL BE WORKING WITH THESE TECHNOLOGIES: 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 The ideal candidate will have exposure to several of the above technologies. While proficiency in all areas is not mandatory, familiarity with multiple technologies listed above will be considered advantageous: YOUR ROLE WILL INVOLVE: Collaborating with application developers and data engineers to design and evolve the data model and select appropriate technologies. Working with SRE & Cloud Engineering teams to improve stability, reliability, and observability. Designing and implementing high-availability database features using various replication and disaster recovery methodologies. Championing the design and development of database schemas, SQL queries, and stored procedures that adhere to best practices, ensuring high performance and scalability. Conduct tests and produce results to ensure accurate compliance with requirements. Administering and maintaining databases for both pre-production and production environments, ensuring they are tuned for optimal performance and minimal downtime. Performing problem resolution and root cause analysis, along with recommending and implementing preventative techniques. Regularly testing and implementing new database versions and patches to ensure optimal performance and security. Actively participating in team upskilling and demo sessions to share knowledge, promote best practices, and support continuous learning within the team. Providing time-critical support on production platforms through rotational on-call support. Ensuring adherence to all relevant risk and compliance policies and procedures, including GDPR and HIPAA where applicable. Authoring and maintaining documentation. Researching and developing new database technologies. Ensuring all traditional DBA operations such as backups, maintenance jobs, and disaster recovery plans are in place and successful. Integrating database management tasks into CI/CD pipelines to automate schema changes and deployments. WHAT WE ARE LOOKING FOR: 5 years of experience in operating highly transactional environments. A database-agnostic view and willingness to work with and learn different database technologies, including both relational and NoSQL databases. Strong experience with MySQL is essential, ideally with RDS. Experience in Microsoft SQL Server including Clustering and Always On. Experience with AWS data services and tools, including EC2, RDS, and S3. Experience in database performance tuning, query optimisation, and execution plan analysis. Familiarity with database encryption, GDPR, HIPAA, and other relevant data security and compliance frameworks. Experience in development with scripting languages such as Python and Unix/Linux Shell, with exposure to managing databases on Unix platforms Familiarity with Agile and Scrum methodologies and embracing their values and principles. Familiarity with Version Control Systems such as Git. Strong communication skills, both verbal and written. Ability to work reliably and responsibly with internal and external colleagues to achieve departmental and organisational goals. Sound critical judgement to make good decisions and be someone the team can respect, trust, and depend on. Customer Focus: able to identify and effectively respond to the diverse needs of the development department’s stakeholders. Exceptional problem-solving skills, logical thinking, and analytical abilities, with a high level of attention to detail. Display foresight, with systematic and orderly planning. Understanding the importance of systems change management. Experience with database migration across environments or platforms is a plus. Experience with containerisation and orchestration (e.g., Docker, Kubernetes) is a plus. BENEFITS: Hybrid Working Relaxed Dress Code Open Culture Flexible Work Hours Group Risk Cover Employee Wellbeing Program 20 Days Paid Leave Ongoing Staff Appreciation Events Access To Learning Platforms Working With Experts Across the Globe Home Internet Allowance FINAL THOUGHTS: We are an international SaaS based fintech company We work with up to date technology, promote from within wherever possible, and encourage our team members to use initiative, think out the box and share their ideas. We aim to transform how our customers – which includes the world`s most prestigious financial services firms – drive engagement with their audiences. Our aim is to give our customers the ability to target, knowledge share and nurture their community of prospects and clients to develop long standing relationships.

Database Administrator Cape Town position available in Cape Town Region, Cape Town City Centre. This job position was posted by . The job has been posted on 2024-10-26 in the It Computing Software category

Click Go Apply to apply online!

You might also like to look at the available jobs in the same area.

Here are some more related positions

Email Alerts

Click the button below and submit your email to receive email alerts with the latest jobs.
This service is offered by Result Generation
We do not save your information, and your email is the only information we forward to the service.
If you wish to unsubscribe, please click here

Subscribe to Email Alerts

×

Subscribe to Email Alerts.

To receive email alerts with the latest jobs. Please enter your email address to subscribe.

Email:

Subscribe to Email Alerts

Powered by