MAIN PURPOSE OF THE JOB
- Responsible for developing new database applications and/or converting existing legacy database applications to support business requirements.
- Database Application Development and Scripts Interpret and compile technical design documentation
- Develop user database interfaces and front- end applications.
- Design Databases Perform Data Management Perform Database mirroring /replication Develop Database Views, Functions, User Defined Types, Stored Procedures in line with Business requirements .
- System Analysis and Design Facilitate scoping workshops / extract client business requirements Provide Business and Systems analysis functions
- Write functional technical design documents
- Provide 2nd line production support for Helpdesk calls on business related issues
- Work with project teams and apply project standards and methodologies 3.
- Database Administration Provide support for Database Administration tasks
- Proactively monitor the database systems to ensure secure services with minimum downtime
- Track and report database performance metrics and analyses database performance
- Perform regular maintenance and backup including monitoring disk space and maintaining database dictionaries
- Application Support, Maintenance and Changes to Business Solutions and Processes
- Develop, design and deliver the processes required to support the various Business Units.
- Ensure that appropriate service levels and quality standards are maintained.
- Ensure compliance to ICT Governance, SDLC, Project Management and Change Control standards and procedures.
- Analyse and apply required configuration changes or development to fulfil change requests.
- Develop and review business cases, functional specifications, blue prints, and all other associated documentation.
- Determine the dependencies with other modules /systems and the applicable impact of changes proposed.
- Provide Functional End User Support for Allocated Application.
- Provide second line support on Help Desk calls pertaining to function. Prioritise response in terms of the levels of severity.
- Role Based Training Develop and maintain Role Based Training documentation for all business roles using SAP Business Warehouse. Ensure availability of training courses, facilitators and facilities for IT Role Based Training throughout the year.
Requirements
- National Diploma in IT
- 3-5 years Significant understanding and practical knowledge of database schema, development and scripting
- 3-5 years Experience in the development of database front-end development (Microsoft .Net framework)
- 3-5 years Understanding and practical knowledge of Relational Databases and Data Warehouse Concepts
- 3-5 years Database design, modelling, optimisation and performance improvement 3-5 years Understanding of Software Development Lifecycle (SDLC) methodologies 3-5 years Exposure to ETL tools and embedded SQL
- Database application development and scripting Relational Databases and Data Warehouse Concepts Software Development Lifecycle (SDLC) methodologies ETL Tools and embedded SQL Database Security
- Extended hours as and when required Travel as and when required
Desired Skills:
- SDLC
- Embedded SQL
- Development SQL
- ETL
- .Net
- data warehousing
Desired Work Experience:
- 2 to 5 years
Desired Qualification Level:
- Diploma