SQL Database Administrator

PURPOSE OF THE JOB

We are seeking a talented SQL Database Administrator with intermediate-level experience to join our dynamic team. The SQL DBA will play a pivotal role in maintaining, optimizing, and securing SQL database environments for our esteemed financial services clients.
Permanent role, based in Woodmead, Johannesburg.

Requirements

• Bachelor’s degree in computer science, Information Technology, or a related field.
• 3+ years of hands-on experience as a SQL Database Administrator in a production environment, preferably within the financial services industry.
• Proficiency in SQL Server database administration, including backup and recovery, performance tuning, and security management.
• Solid understanding of relational database concepts, SQL query optimization techniques, and database normalization principles.
• Experience with database monitoring tools and performance tuning utilities.
• Strong analytical and problem-solving skills with the ability to troubleshoot complex database issues.
• Excellent communication and interpersonal skills, with the ability to collaborate effectively with cross-functional teams.

Preferred Skills

• Certification in Microsoft SQL Server (e.g., MCSA: SQL Server, MCSE: Data Management and Analytics) or equivalent.
• Familiarity with other RDBMS platforms such as Oracle, MySQL, or PostgreSQL.
• Experience with database replication, clustering, and high availability solutions.
• Knowledge of cloud-based database services such as Azure SQL Database or Amazon RDS.
• Understanding of data warehousing concepts and ETL processes.

Duties & Responsibilities

Database Administration

• Perform regular database maintenance tasks such as backups, restores, and recovery procedures.
• Monitor database performance and proactively optimize SQL queries and database structures for improved efficiency.
• Implement and maintain database security protocols to ensure compliance with industry standards and client requirements.
• Troubleshoot and resolve database-related issues in a timely manner, minimizing downtime and ensuring maximum availability.

Database Development Support

• Collaborate with development teams to design, implement, and optimize database schemas, stored procedures, and triggers.
• Assist in database design reviews and provide recommendations for performance enhancements and scalability.
• Conduct database performance tuning and query optimization to support high-volume transaction processing.

Data Integrity and Compliance

• Implement data integrity constraints and enforce data quality standards to ensure accuracy and consistency of financial data.
• Support regulatory compliance efforts by implementing auditing mechanisms and assisting in compliance audits as needed.
• Stay abreast of industry regulations and best practices related to database security and compliance requirements.

Documentation and Training

• Maintain comprehensive documentation of database configurations, procedures, and troubleshooting steps.
• Provide training and guidance to junior DBAs and development teams on best practices for SQL database administration and performance optimization.