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.
APPLY NOW
Please note: We work in the Information Technology and Financial Services Industry. We are not the Cosmetics Company!
#J-18808-Ljbffr
