Johannesburg: Database Administrator (DBA)

iOCO is seeking an experienced SQL Server Database Administrator (DBA) to join our team on a short-term 6 month contract basis. The successful candidate will provide critical support for our existing Datahub platform, ensuring performance and stability during a key migration phase to Databricks. This role is pivotal in supporting business continuity and ensuring a seamless transition to the new platform. What you’ll do: Performance Optimisation: Apply techniques such as partitioning, compression, and optimized statistics management to enhance query performance on Datahub. Essential Maintenance: Conduct ongoing database maintenance to reduce fragmentation and maintain the availability and stability of Datahub. Query and ETL Tuning: Work closely with data engineers to improve the performance of long-running SQL queries and ETL pipelines, ensuring efficient resource use on the current platform. Datahub Stability Support: Provide hands-on support for Datahub operations, including performance monitoring, troubleshooting, and issue resolution, minimizing disruptions until the Databricks migration is complete. Maintain Stability Uptime: Ensure Datahub operates efficiently during this critical transition. Mitigate Risk: Avoid performance degradation or outages that could impact downstream systems. Support Smooth Migration: Facilitate a clean and efficient handover as systems transition to Databricks. Your expertise: Proven experience in SQL Server administration Strong understanding of query tuning , indexing , and partitioning Experience working with ETL pipelines and data engineers Excellent troubleshooting skills Ability to work independently in a fast-paced, project-driven environment Familiarity with cloud platforms and Databricks (advantageous but not required Other information applicable to the opportunity: Position: Permanent Location: Johannesburg Why work for us? Want to work for an organization that solves complex real-world problems with innovative software solutions? At iOCO, we believe anything is possible with modern technology, software, and development expertise. We are continuously pushing the boundaries of innovative solutions across multiple industries using an array of technologies.  You will be part of a consultancy, working with some of the most knowledgeable minds in the industry on interesting solutions across different business domains.  Our culture of continuous learning will ensure that you will have all the opportunities, tools, and support to hone and grow your craft.  By joining IOCO you will have an open invitation to developer inspiring forums. A place where you will be able to connect and learn from and with your peers by sharing ideas, experiences, practices, and solutions.  iOCO is an equal opportunity employer with an obligation to achieve its own unique EE objectives in the context of Employment Equity targets. Therefore, our employment strategy gives primary preference to previously disadvantaged individuals or groups.