Senior Developer Database - Centurion at Secondments

Job Advert Summary   

• Responsible for developing new database applications and/or converting existing legacy database applications to support business requirements.
• Provide 2nd line production support for Helpdesk calls on business related issues
• Work with project teams and apply project standards and methodologies

Minimum Requirements    
Preferred Minimum Education and Experience

• National Diploma in IT
• 3-5years significant understanding and practical knowledge of database schema, development and scripting
• 3-5years experience in the development of database front-end development (Microsoft .Net framework)
• 3-5years understanding and practical knowledge of Relational Databases and Data Warehouse Concepts
• 3-5years database design, modelling, optimisation and performance improvement
• 3-5years understanding of Software Development Lifecycle (SDLC) methodologies
• 3-5years exposure to ETL tools and embedded SQL

Critical Competencies   

• Database application development and scripting
• Relational Databases and Data Warehouse Concepts
• Software Development Lifecycle (SDLC) methodologies
• ETL Tools and embedded SQL
• Database Security

Additional Requirements   

• Extended hours as and when required
• Travel as and when required

Duties and Responsibilities    
Key Performance Areas    
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

Database Administratior

• 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.