Overview
The job purpose is to develop, maintain and test database solutions in line with FIC business requirements.
Responsibilities
- Analyse- and interpret of business requirements documents
- Compile and review of technical design specification
- Develop and maintain of database views, functions, user defined types, stored procedures amongst others in line with FIC business requirements
- Develop reports and dashboards
- Provide input to data architecture input
- Develop advanced ETL code
- Develop database code or scripts for testing of the data solution
- Compile and review systems analysis, impact analysis of database solutions
- Code reviews of database solutions
- Maintain of applications and system documentation
- Maintain and support of application solutions in operations
- Analyse and Resolve root-cause production problems and data issues,
- Define and adhere to database development standards and processes
- Data quality, data profiling, metadata management and master data management
Education, Skills And Experience
A Degree in computer science or equivalentAt least three (3) years\' experience in developing database solutions on Microsoft SQL server platformProficiency and experience in Microsoft SQL Server version 2012 and above as well as windows server version 2012 and above platformsMicrosoft Certified Solutions AssociatesMCSA : SQL 2016 BI Development or Certification in Microsoft Certified Solutions AssociatesMCSA : SQL 2016 BI Reporting or Microsoft Certified Solutions AssociatesMCSA : SQL 2016 Database DevelopmentSolid understanding of Microsoft Windows Server platform version 2012 and aboveMinimum three (3) years\' experience in writing Transact SQL codeProficiency in XML, XSD and JSONMinimum three (3) years\' experience in developing on PowerBI platform#J-18808-Ljbffr