Senior Sql Developer

Boikago Group; Pretoria; On-site; ZAR 450 000 - 600 000; Full time

Job summary

A technology services firm in Midrand is seeking a Senior SQL Developer. The role involves designing and maintaining spatial databases, collaborating with teams for high-quality product outcomes, and enhancing existing applications. The ideal candidate has over 3 years of experience in Database Administration and Development, a relevant degree, and familiarity with Agile methodologies.

Qualifications

• 3+ years of Database Administration experience.
• 3+ years of Database Development experience.
• Familiarity with Agile development methodologies.

Responsibilities

• Design, test, implement and maintain the integrated spatial database.
• Collaborate with product managers and designers.
• Analyse, maintain and enhance existing applications.

Skills

Database Development

Database Administration

SQL

PostgreSQL

Agile methodologies

Education

Degree in Software Engineering, Computer Science or related

Matric / Grade 12

Tools

ASP.NET

XAML

Job description

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
  • 3+ year DBA experience
  • 3+ year Database Development experience
• Advantageous Qualifications:
  • Bachelor of Honours Degree in Software related qualification
  • Software Language / Database Specific Qualification
  • 2 years Project 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 ASP.NET, ASP.NET Core, WebAPI, SQL, PostgreSQL, PostGIS extension and XAML is advantageous
  • Excellent understanding and application of design principles