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.
