Senior SQL Developer
Our client in the Technology Services sector based in Midrand is looking for a Senior SQL Developer
KEY DUTIES
- Design, test, implement and maintain the integrated spatial database to ensure 24 / 7 database availability and operation.
- Establish and maintain database replication.
- Develop and maintain stored procedures, triggers, functions, CTEs, security configurations, index optimization, query performance tuning, database normalization and design, RBAC, encryption, partitioning and sharding, and data auditing.
- Collaborate with product managers and designers to ensure a successful, high-quality product and great user experience.
- Analyse, maintain and enhance existing application and troubleshoot issues with efficiency.
- Perform accurate development estimation.
- Produce technical specifications and designs. Participate in new business development through ideation, prototype development, and project estimates.
- Research new techniques, tools, and best practices and share that knowledge with the team and community.
- Maintain high data integrity and security standards.
- Can help with quality assurance and provide comments.
EDUCATIONAL & SKILLS REQUIREMENTS
Essential Qualifications :
Matric / Grade 12Degree in Software Engineering, Computer Science or relatedAdvantageous Qualifications :
Bachelor of Honours Degree in Software related qualificationSoftware Language / Database Specific QualificationExperience required
3+ year DBA experience3+ year Database Development experienceProject experience : 2 yearsOther experience : 3 years in a software / mobile / database development or a combinationFamiliarity with Agile development methodologiesKnowledge of OO design principles and development patternsExposure in ASPNET, ASP.NET Core, WebAPI, SQL, PostgreSQL, PostGIS extension and XAML is advantageousExcellent understanding and application of design principles