About the position
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.
Desired Skills:
- APIs
- Extract Transform Load (ETL)
- MySQL
- Software Development
- SQL
About The Employer:
A cutting-edge FinTech company
