SQL Developer

SUMMARY:
A global company with offices in Durban, Cape Town and Johannesburg has an urgent need for an Intermediate SQL Developer.

POSITION INFO:
Duties & Responsibilities:

• Design databases to be scalable with a view of how to migrate to Data Lake architecture as the quantity of data scales.
• Required to lead the Database development team, along with demonstrating best practice.
• Design and build databases for optimal performance.
• Ensure data security, scalability, and data integrity within all processes and solutions.
• Apply established DB design methodologies.
• Determine the most effective and efficient software design to meet specifications.
• Streamline data import and integration processes.
• Advise on areas that could be improved on and keep up to date with new trends in software development and technologies that can be used to benefit the company.

• Minimum 4 years database development experience
• IT related Degree or National IT Diploma
• MS SQL Database experience essential
• Preference for a person who has worked in a dynamic environment with a large volume of records
• Experience working with Data Lake architecture beneficial
• Skilled in importing data from various sources
• Ability to clearly document and execute processes relating to data setup, technical roadmaps for clients and solution design
• SQL code performance tuning
• Develop stored procedures for high performance
• Database performance troubleshooting and performance enhancements through performance analysis leading to SQL rewrites, table redesign, and/or indexing
• Strong working knowledge of developing Data Warehouse technologies
• Ability to self-manage
• Excellent written and verbal communication skills
• Able to effectively speak with Senior people
• Very solid work ethic
• Energetic and flexible
• Ability to work in a quickly growing team