Senior SQL Developer (JHB) at Datafin Recruitment

ENVIRONMENT:

• DESIGN, develop, implement, and maintain all application systems and associated technologies, with a strong focus on SQL database development as the next Senior SQL Developer wanted by a cutting-edge FinTech company.
• You will be responsible for ensuring optimum performance, efficiency, and high availability of data systems and related applications for internal and external clients.
• The successful incumbent must have Matric/Grade 12, a BSc Degree (Computer Science) or related tertiary qualification with 5-10 years in SQL and Software Development, with demonstrable experience in database design, query optimisation, and application development.
• You must also be proficiency with MSSQL and/or MySQL, Java, C# or PHP.

DUTIES:

SQL Development & Database Engineering –

• Write advanced SQL queries, stored procedures, functions, views, and triggers.
• Design, normalise, and implement relational database models and schemas.
• Perform performance tuning and query optimisation, including execution plan analysis and troubleshooting.
• Define and implement indexing strategies, including clustered, non-clustered, and columnstore indexes.
• Develop and maintain ETL pipelines and data integration processes.
• Apply data warehousing concepts and dimensional modelling techniques.
• Manage database security, permissions, and access control.
• Plan and execute backup, recovery, and disaster recovery procedures.
• Handle transaction management and concurrency control in high-volume environments.
• Support data migration initiatives and database deployments.

Design –

• Meet with Developers and Development team leaders to discuss the scope of software projects and delivery deadlines.
• Analyse existing programs and database structures for modification and improvement purposes.
• Research and design new software systems, data models, and application components.

Development –

• Write clean, scalable, and well-documented code in Java, C#, or PHP as required.
• Troubleshoot and debug application code and database scripts.
• Review code for accuracy, functionality, and adherence to standards.
• Perform coding assignments as directed by the Development Team Lead.

Implementation –

• Verify and deploy software systems and database changes across environments.
• Create and execute implementation plans, ensuring minimal disruption to production systems.

Maintenance –

• Evaluate user feedback and translate it into actionable improvements.
• Recommend and implement software and database enhancements.
• Maintain application code, database scripts, and security configurations.
• Create technical documentation and provide training to staff where required.
• Conduct regular code and database reviews to ensure ongoing quality.
• Stay abreast of new technologies and developments in the SQL and Software Development space.

REQUIREMENTS:

Qualifications –

• Matric / Grade 12.
• BSc Degree (Computer Science) or related tertiary qualification.

Experience/Skills –

• 5 – 10 Years in SQL and Software Development, with demonstrable experience in database design, query optimisation, and application development.
• Proficiency Level – Advanced: Applied Theory.
• Proficient in MSSQL and/or MySQL database development and administration.
• Capable of writing application code in Java, C#, or PHP.
• Strong understanding of relational database theory and normalisation.
• Experience with stored procedures, functions, views, triggers, and indexing strategies.
• Familiarity with ETL development, data warehousing, and dimensional modelling.
• Solid understanding of Web API integration and consumption.
• Proficient in version control using Git or SVN.
• Experience with large-scale databases and high-volume data processing environments.

Advantageous –

• Software Development related qualification.

ATTRIBUTES:

• Excellent written and verbal communication skills.
• Strong time management and organisational skills.
• Demonstrated leadership and mentoring ability.
• Conflict resolution and team collaboration skills.
• Strong analytical, critical thinking, and problem-solving abilities.
• Sound understanding of both procedural and object-oriented programming principles.