ENVIRONMENT:
A prominent company in mining technology, focused on advanced analytics and solutions, is seeking a Senior SQL Server Developer to join their team in Sandton. The ideal candidate will have extensive experience in developing, optimizing, and maintaining complex stored procedures in SQL Server. This role requires strong problem-solving skills, the ability to design and document technical solutions, and effective communication to ensure alignment with business requirements. This is a full-time, in-office position.
DUTIES:
- 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.
- Unpredictable Support Requirements: on occasion after hours support may be required in order to address bugs or customer needs. Although these incidents have been infrequent, they do happen and the successful candidate will be willing to carry a reasonable share of the support load as and when needed.
REQUIREMENTS:
Experience:
- Minimum of 5 years of experience as a SQL Server Developer.
- Proven track record of developing complex stored procedures for transactional and operational systems (not ETL-focused).
- Strong experience with SQL Server hosted on AWS RDS and SQL Server Express.
- Experience with SSRS report generation and deployment.
- Familiarity with GitHub for version control and collaboration on SQL code.
- Technical Communication: Strong ability to translate business requirements into technical solutions, document these solutions effectively and communicate them to stakeholders for approval. Documentation will be a critical requirement.
Skills:
Desirable:
- Experience in the mining or heavy industry sector.
- Familiarity with cloud technologies and database migration processes.
ATTRIBUTES:
- Excellent attention to detail and problem-solving skills.
- Strong communication skills, both written and verbal.
- Ability to work independently and as part of a team.
- Prepared to work full-time in-office.
- Ability to handle multiple tasks and work under pressure.
While we would really like to respond to every application, should you not be contacted for this position within 10 working days please consider your application unsuccessful.
COMMENTS:
When applying for jobs, ensure that you have the minimum job requirements. Only SA Citizens will be considered for this role. If you are not in the mentioned location of any of the jobs, please note your relocation plans in all applications for jobs and correspondence. Apply here [URL Removed] e-mail a Word copy of your CV to [Email Address Removed] and mention the reference number of the job.
Desired Skills:
- Senior
- SQL
- Server