Purpose
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 the web and multimedia applications that facilitate 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 nonfunctional 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 Clients applications
- Mentoring junior members of the development team including training
- Acting as a focal point of expertise on key technologies or skills
KINDLY TAKE NOTE THAT THE RECRUITMENT AND SELECTION PROCESS WILL INVOLVE
PSYCHOMETRIC ASSESSMENTS.
Requirements
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 problemsolving skills.