Overall Role Purpose:
Responsible for SQL DB Administration and developing reports (SAP Business Objects data warehouse as well as SQL Server operational databases).
ResponsibilitiesReport Writing:
- Liaise with internal users and/or development team to establish their detailed reporting requirements.
- Analyse data sources, tables, objects, universes and data relationships to gain knowledge of the data for accurate retrieval and use in reports.
- Design and develop optimized high performing SQL queries
- Design reports (and report parameters) for operational systems in conjunction with the development team
- Develop and test reports / validate output in conjunction with end users.
- Develop standardized generic reports for external clients based on common requirements (and in line with Hellmann standards).
- Extract and format data from relevant databases according to the needs of internal users and management.
- Testing of reports and validating the output in the context of applications developed.
- Provide accurate timelines for development timeline.
- Technology alignment. Continuous learning to stay abreast of the latest technology.
- Knowledge of data manipulation via SQL, Excel
- Experience with tools such as SQL report writer, Qlikview, Microsoft BI advantageous.
Administration:
- Administer Microsoft SQL Server database environments
- T-SQL Scripting and development on both new and existing functions
- Troubleshoot and resolve server, database and data issues
- Security maintenance of server and database
- Maintenance and monitoring of SQL environment
- Assist developers with performance tuning on databases
- Support developers with any database related requests or incidents
- Monitoring and completion of all DBA related Servicedesk calls
- Backup setup and monitoring
- Understanding the data sources and relationships in the context of the business domain
- Strong analytical skills, thoroughness, and attention to detail
- Strong problem solving skills
- Team player
- Personal Competencies:
Education:
- IT Degree / Diploma / Certification and/or relevant SQL DBA & report writing work experience
Experience:
- At least 2 years experience as a Database Administrator & Report Writer
- Experience of Logistics and Supply Chain highly desirable
Technologies (Required):
- SSRS / Report Builder (1+ Years)
- Microsoft SQL Server 2008 / 2012 / 2014 experience with database administration, including installation and troubleshooting issues
- T-SQL Scripting experience
- Database Security
- MS Excel skills (advanced)
Technologies (Beneficial):
- Backup and recovery experience
- SAP Business Objects
- SharePoint
-
Business Intelligence (QlikView, MS BI Stack)
-
SSIS
Please note that only SA Citizens may apply.
Only applications with a detailed CV will be considered.