Job title : Senior SQL Developer - Johannesburg Job Location : Gauteng, Johannesburg Deadline : December 21, 2024 Quick Recommended Links Jobs by Location Job by industries Job Description 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.
Inherent Requirements 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.
What Qualification Bachelor's degree in Computer Science, Information Technology, or a related field.
Advanced certific ICT jobs