Pretoria: Senior SQL Developer

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 12 Degree in Software Engineering, Computer Science or related Advantageous Qualifications: Bachelor of Honours Degree in Software related qualification Software Language/Database Specific Qualification Experience required 3 year DBA experience 3 year Database Development experience Project experience: 2 years Other experience: 3 years in a software/mobile/database development or a combination Familiarity with Agile development methodologies Knowledge of OO design principles and development patterns Exposure in ASPNET, ASP.NET Core, WebAPI, SQL, PostgreSQL, PostGIS extension and XAML is advantageous Excellent understanding and application of design principles