Our client, a leader in mining technology, delivering advanced analytics and solutions to improve operational efficiency and safety is seeking a highly skilled and detail oriented Senior SQL Server Developer to join their team in Lonehill, Sandton. The ideal candidate will have extensive experience in developing, optimising and maintaining complex stored procedures in SQL Server.
Minimum Requirements:
- Minimum of 5-8 years of experience as a SQL Server T-SQL Developer.
- Proven track record of developing complex stored procedures for transactional and operational systems (not ETL-focused).
- Experience with SSRS report generation and deployment.
- Familiarity with GitHub for version control and collaboration on SQL code.
- Strong ability to translate business requirements into technical solutions, document these solutions effectively and communicate them to stakeholders for approval (Documentation is a critical requirement).
- Experience with SQL Server hosted on AWS RDS will be advantageous.
- Willingness to provide after-hours support when required.
Main duties will include, but are not limited to:
- SQL Development: Develop and maintain stored procedures, functions and queries to support various front-end teams, including cloud, site and mobile teams.
- Optimisation: Analyse and optimise existing SQL code to enhance performance and ensure efficient data handling.
- SSRS Reporting: Design, develop and deploy SSRS reports to meet business requirements.
- Collaboration: Work closely with multiple front-end teams to ensure seamless integration between applications and the database.
- Technical Solution Design: Collaborate with the CTO to understand business requirements and propose SQL Server-based solutions that meet these needs.
- Documentation: Develop detailed technical documentation outlining proposed solutions, including design rationale, implementation steps and potential risks.
- Presentation: Present proposed solutions to the CTO, clearly explaining the approach and seeking approval before implementation.
- GitHub Integration: Integrate and manage SQL stored procedures in GitHub, ensuring effective collaboration and version control in a multi-developer environment.
- Pressure Handling: Effectively manage workloads and deliver high-quality solutions under pressure and within tight deadlines.
- Support: Provide expert support for any database-related issues, ensuring high availability and reliability across all platforms.
Desired Skills:
- SQL
- Sql Server
- T-SQL
- SSRS
- Github
Desired Work Experience:
- 5 to 10 years
Desired Qualification Level:
- Diploma
About The Employer:
Our client is a leader in mining technology,