Senior SQL Developer - Johannesburg at Reverside

Reverside is an IT services provider; we are always looking for professional candidates to join our team in Software Development, providing opportunities to work on exciting projects, within our well-established client base. We are looking for a Senior SQL Developer Professional with 5- 8 who is responsible for batch processing development as well as backend capability to support the application. SQL developers translate software requirements into workable programming code and maintain and develop programs for use in business.

The role usually involves writing technical specifications and designing, building, testing, implementing and sometimes supporting applications using programming languages and development tools.

The SQL Developer contributes to the development of software to support web, and multi-media applications that facilitates the achievement of business outcomes and improves business efficiencies and processes through leveraging technology.

Key Area of Responsibility

• Work as part of a project team, reporting to an IT Manager.
• Work closely with business staff to ensure solutions adhere to client standards and fit their strategic enterprise architecture.
• Definition and management of non-functional requirements, including working with others to ensure these requirements have been met.
• Definition and organization of development tasks and accurate estimation of these tasks.
• Work closely with members of the development team to ensure that the software design and implementation meets the architectural goals and quality standards.
• Provide support to the business analysts, and other project team members, during functional requirements definition to ensure that functionality is both technically achievable and feasible within the project constraints.
• Identification and ownership of technical project risks and issues, including owning mitigation activities and resolution of issues.
• Undertake other duties as directed by line managers commensurate with the post.
• Actively seeking opportunities to contribute improvements to Client's applications.
• Mentoring junior members of the development team including training.
• Acting as a focal point of expertise on key technologies or skills.

Qualification and Skill Requirements

• Computer Science or other relevant technical degree, diploma, or certification.
• At least 8+ years Development experience.
• Experience of the full software development lifecycle.
• Experience within an agile environment, with Scrum/KANBAN as methodology.
• Advanced working knowledge of SQL (DDL, DML, JSON, XML).
• Extensive experience in dealing with large datasets and managing incremental batch loading methodologies.
• Advanced understanding of relational data structures including keys, constraints, and triggers.
• Performance tuning and optimization of RDBMS.
• Highly skilled and experienced in using relational database technologies in an environment with high data volumes and many transactional systems.
• Understand how to design and implement a conceptual, logical, and physical data model that supports the needs of the organization.
• Solid understanding and experience in data modelling, data management and governance methodologies.
• Ability to develop unit testing of code components.
• Advantageous – Microsoft stack SSIS, SSRS, SSAS, Power BI, SQL Server.
• Experience building DevOps automation is beneficial.
• Previous experience in the Insurance Industry is beneficial.

Behavioral Competencies

• Good planning, organizational skills, task/project driven, deadline oriented.
• Good collaboration, communication, and interpersonal skills.
• Good people management skills.
• Good problem solving and decision-making ability.
• Ability to prioritize and work under pressure.
• High attention to quality and detail.
• Process and practices orientated.
• Analytical and problem-solving skills.