Database Administrator Cape Town

2 months ago

Cape Town, South Africa Pro Tem Full time

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.

  • Sales Representative

    5 months ago

    Cape Town, South Africa Safetymate - Cape Town Full time

    **Sales Rep position** Well-spoken and presentable female Residing (Living) in Cape Town Minimum 5 years’ experience in sales Driven and motivated Must have own vehicle **Package includes**: Basic Comm Car allowance Cell allowance **Job Type**: Temp to perm **Salary**: From R123,00 per month **Education**: - Certificate...

  • Database Administrator

    6 months ago

    Cape Town, South Africa Job Crystal Full time

    REQUIREMENTS Ingres Database Admin Ingres Database enhancements Unix Linux Intermediate knowledge: Oracle Exadata administration backup/recovery using RMAN PL/SQL coding background logical and physical data models partitioning Knowledge of Oracle RAC, Cluster Resource software, and Oracle 12C features DevOps Experience Experience with Application servers...

  • Junior Tax Compliance Administrator Pkf Cape Town

    5 months ago

    Cape Town, South Africa PKF Cape Town (Bellville and Stellenbosch) Full time

    PKF Cape Town is seeking a skilled **Junior Tax Compliance Administrator** to join their firm. The **duties and responsibilities** include, but are not limited to: - Completion and submission of income tax returns for Companies Trusts and Individuals. - Reviewing of income tax assessments for companies, Trusts, and Individuals. - Preparation, completion,...

  • Ad Hoc Musicians Required in Cape Town

    3 months ago

    Cape Town, South Africa Cape Town Audtions Full time

    **Ad Hoc Musicians (Cape Town)** **Position**: Ad Hoc Musicians **Location**: Cape Town, South Africa **Type**: Freelance/Part-Time **About Us**: We are a diverse arts organization based in Cape Town, dedicated to creating exceptional musical and theatrical experiences across a wide range of genres. Our performances span classical, jazz, contemporary, and...

  • Sales Rep Vacancy in Cape Town

    1 month ago

    Cape Town, South Africa Safetymate - Cape Town Full time

    Well spoken and presentable Minimum 5 years’ experience in sales Driven and motivated Must have own vehicle **Package includes**: Basic Comm Car allowance Cell allowance **Job Types**: Full-time, Permanent Pay: From R123,00 per month Ability to commute/relocate: - Cape Town, Western Cape: Reliably commute or planning to relocate before starting...

  • SQL Database Administrator

    6 months ago

    Cape Town, South Africa SET Recruitment Consultants Full time

    **SQL Database Administrator** **R360k per annum** **Cape Town** A Medium-Sized International Financial Services firm specialising in wealth management solutions is looking for a SQL Database Administrator to report to the IT Operations Manager in their Cape Town Operations department. **Key Performance Areas** - Maintaining high levels of performance,...

  • Database Administrator

    1 week ago

    Cape Town, South Africa Salt South Africa Full time

    Job title : Database AdministratorJob Location : Western Cape, Cape TownDeadline : December 18, 2024Quick Recommended Links Jobs by Location Job by industries What You’ll Do: Design and manage high-performance databases across various platforms. Collaborate with teams to enhance data models, implement high-availability features, and troubleshoot issues....

  • Database Administrator

    3 days ago

    Cape Town, South Africa Salt South Africa Full time

    Job title : Database Administrator Job Location : Western Cape, Cape Town Deadline : December 18, 2024 Quick Recommended Links Jobs by Location Job by industries What You’ll Do: Design and manage high-performance databases across various platforms. Collaborate with teams to enhance data models, implement high-availability features,...

  • Database Administrator Ftc

    6 months ago

    Cape Town, South Africa Tych Business Solutions Full time

    **Job ID**: 66938**Date Posted**: Posted 20 hours ago**Location**: Cape Town Centre**Job Title**: DATABASE ADMINISTRATOR FTC - CAPE TOWN - WESTERN CAPE **Duties & Responsibilities**: - Managing installations and upgrades - Assisting Development Teams in designing and optimizing systems carrying out database administration tasks - Working with SECURITY team...

  • Database Administrator

    1 week ago

    Cape Town, South Africa WatersEdge Solutions Full time

    We are seeking a highly skilled Database Administrator to join our team inCape Town,South Africa ..Responsibilities :Database Standards and Best Practices:Develop, implement, and maintain database standards and best practices aligned with industry standards and company policies.Database Administration:Install, configure, and administer SQL Server databases...

  • Training Office Administrator Pkf Cape Town

    6 months ago

    Cape Town, South Africa PKF Cape Town (Bellville and Stellenbosch) Full time

    PKF Cape Town is currently looking for** **a** Training Office Administrator** to join their team! **Duties and responsibilities include,** but will not be limited to: Administration of SAICA Training Office Program *** - Provide assistance with the scheduling of inhouse training and technical sessions. - Prepare and maintain attendance registers/records...

  • Company Secretarial Administrator Pkf Cape Town

    6 months ago

    Cape Town, South Africa PKF Cape Town and PKF Stellenbosch Full time

    PKF Cape Town is recruiting a **Company Secretarial Administrator** to join their team! The main purpose of this role is to maintain and organise company documents, files, and records, both in physical and electronic formats. Also, to ensure easy retrieval of information for the Company Secretarial department. **Duties and responsibilities** will include,...

  • Data Security Specialist

    1 day ago

    Cape Town, Western Cape, South Africa City of Cape Town Full time

    Job Title: Data Security SpecialistWe are seeking a highly skilled Data Security Specialist to join our team at the City of Cape Town. This is an exciting opportunity for a professional with expertise in Microsoft Enterprise Active Directory and Azure Active Directory (Entra-ID) management.

  • Member Relationships

    6 months ago

    Cape Town, South Africa Cape Town Tourism Full time

    Join Cape Town Tourism as our Member Relationships & Services Coordinator. **Why Choose Cape Town Tourism**: - Inspire Success: Fuel your passion and purpose by supporting our Industry Services Team as they support CTT members. - Embrace Innovation: Work with an agile team that is unafraid of ambitious challenges and eager to embrace change. - Lifelong...

  • Database Administrator

    3 months ago

    Cape Town, South Africa WatersEdge Solutions Full time

    We are seeking a highly skilled Database Administrator to join our team in Cape Town, South Africa ..Responsibilities : Database Standards and Best Practices: Develop, implement, and maintain database standards and best practices aligned with industry standards and company policies. Database Administration: Install, configure, and administer SQL Server...

  • Database Administrator

    1 week ago

    Cape Town, South Africa Jambo Home Loans Full time

    **Job Posting: Database Administrator** **Location**: Cape Town **Salary**: R12,000 - R25,000 per month **About Us**: Jambo Home Loans is a dynamic company working in conjunction with a leading real estate firm. We specialise in operations, financing, and real estate services, making us a one-stop solution for our clients. We pride ourselves on delivering...

  • Database Administrator Cape Town

    2 months ago

    Cape Town, South Africa Pro Tem Recruitment Full time

    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...

  • Database Administrator Cape Town

    2 months ago

    Cape Town, South Africa Pro Tem Recruitment Full time

    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...

  • Database Administrator

    1 month ago

    Cape Town Southern Suburbs, South Africa Sable International Full time

    About the RoleWe are seeking a skilled Junior SQL Database Administrator to join our Cape Town Operations team.ResponsibilitiesMaintain Database Performance and Security: Ensure high levels of performance, availability, and security are maintained.Data Quality and Server Security: Maintain data quality and server and database security as per the user...

  • Database Administrator

    6 months ago

    Cape Town, South Africa Job Tool Kit Full time

    Are you currently unemployed, and have advanced excel skills? If so, we need you for: Database Management Reporting on the performance of the data Setting up sales campaigns on the CRM Exporting data from the CRM Deduping the data Formatting the data Reporting on data performance to internal and external clients askOsca is a B2B Marketing organisation...