SQL Developer – Durban
Our client is looking for a highly skilled SQL Developer to join their Durban team.
The successful candidate for this role should possess a deep understanding of SQL and be passionate about data.
The ideal candidate should have a strong background in database design, data modelling, and ETL processes.
If you are a skilled SQL Developer who is passionate about data and enjoys working in a dynamic and engaging environment, this could be the perfect opportunity for you to grow your career.
Overview:
- Responsible for designing and implementing scalable database solutions using SQL programming language.
- Responsible for writing and debugging complex T-SQL code, with a focus on developing stored procedures, views, and user-defined functions.
- Utilize your expertise in SQL to create impactful analytics using SSRS and Dev Express.
Responsibilities:
• Develop and maintain SQL-based applications and databases.
• Design and implement scalable database solutions using SQL programming language.
• Create and modify complex stored procedures and user-defined functions.
• Develop and maintain ETL (Extract, Transform, Load) processes to transfer data between systems.
• Troubleshoot and debug issues related to database performance, data accuracy, and data integrity.
• Develop SSRS, Crystal & DevExpress reports that provide accurate information to system users.
• Create and manage data models that accurately reflect business requirements and are scalable.
• Collaborate with other members of the development team, including data analysts, data scientists, and software engineers.
• Ensure security best practices are implemented, including user authentication and authorization.
• Keep up to date with new developments in the field, including new database technologies.
• SQL programming: A strong command over SQL programming language, including querying, data manipulation, and data definition.
• ETL processes: Ability to design and implement ETL (Extract, Transform, Load) processes to transfer data between systems.
• Reporting and analytics: Ability to create reports and dashboards using SQL-based tools and have a good understanding of data analytics concepts.
• Troubleshooting and debugging: Ability to troubleshoot and debug issues related to database performance, data accuracy, and data integrity.
• Database design: Ability to design efficient database structures and understand concepts like normalization, denormalization, and indexing. Experience in performance tuning, query optimization, using Performance Monitor, SQL Profiler, and other related monitoring and troubleshooting tools.
• Database administration: Familiarity with database administration tasks, such as user management, backup and recovery, and performance tuning.
• Data modelling: Ability to create and manage data models that accurately reflect business requirements and are scalable.
• Collaboration: Ability to collaborate effectively with other members of the development team, including data analysts, data scientists, and software engineers.
Requirements:
• Bachelor’s degree in Computer Science or related field.
• Minimum of 3 years of experience in SQL development.
• Strong command over SQL programming language, including querying, data manipulation, and data definition.
• Experience with database design and data modelling.
• Familiarity with database administration tasks, such as backup and recovery and performance tuning.
• Will be required to pass a remote SQL assessment.
