Permanent - Senior SQL Developer - Johannesburg (CBD) - South Africa

We are seeking an experienced Senior SQL Developer to design, implement, and optimize database systems that support our business operations and analytics. The ideal candidate will have a deep understanding of SQL, database architecture, and performance optimization, with a proven ability to handle complex data challenges in a dynamic environment.

Responsibilities

• Design, develop, and maintain efficient database solutions, including schemas, tables, views, and stored procedures.
• Optimize database performance, ensuring reliability, scalability, and security.
• Write, debug, and maintain complex SQL queries and scripts for data extraction, transformation, and reporting.
• Collaborate with software development and analytics teams to support data needs and ensure seamless integration.
• Monitor database performance and resolve issues related to queries, indexing, and locking.
• Implement and maintain backup, recovery, and archiving strategies.
• Stay updated on emerging database technologies and best practices.
• Provide technical guidance and mentorship to junior developers and team members.

Requirements

• Advanced proficiency in SQL and database systems such as Microsoft SQL Server, MySQL, or PostgreSQL.
• Strong understanding of relational database design principles and normalization.
• Experience with performance tuning, query optimization, and indexing strategies.
• Familiarity with ETL processes and data warehousing concepts.
• Knowledge of database security standards and compliance.
• Excellent analytical and problem-solving skills.
• Strong communication skills and the ability to work collaboratively in a team environment.

Preferred Qualifications

• Experience with cloud databases (e.g., AWS RDS, Azure SQL, Google Cloud SQL).
• Familiarity with BI tools like Power BI or Tableau.
• Knowledge of NoSQL databases and scripting languages like Python or PowerShell.