JOB PURPOSE

To support and maintain all new and existing Database infrastructure within the company

KEY PERFORMANCE AREAS

• Administer and support all database infrastructure (including cleanups) for the different IT environments e.g. (Dev, Test, Staging, Prod, DR)
• Provide second and third line technical support to IT staff and service desk. Knowledge sharing
• Provide input and action items on Projects
• Provide standby and after office hours
• Research and recommend innovative enhancements to the database infrastructure environment
• Administration and configuration of Database monitoring tools
• Administration of Database related infrastructure e.g. database size, table fragmentations and database performance
• Administration, maintenance and monitoring of database backup environment
• Support and maintain database infrastructure in the disaster recovery environment
• Identify database security risks and develop mitigation plans
• Adhere and maintain all relevant database policies, standards and procedures
• Administer the implementation of all new DB software in accordance to IT best practice and standards

EDUCATION, SKILLS AND EXPERIENCE

• Relevant recognised ICT certification such as MCITP (or equivalent) is a minimum requirement.
• Minimum of 4 years solid SQL Database Administration.
• Sound knowledge of the Microsoft SQL 2008R2 and SQL 2012/2014 (Working experience in SQL Server, which includes security, indexing, user management, upgrades, related DB and system upgrades and migrations to other Hosts, Patch rollouts and approx.
• Experience in performance tuning of database systems and IIS, with emphasis on architecture/application design, system parameters & settings, capacity planning, database/IIS/server parameters and disk layouts.
• Advanced troubleshooting skills
• Sound knowledge of Preventative / Proactive maintenance and monitoring of systems.
• SQL Database language knowledge is required (T-SQL)
• SSRS Report Design and Deployment based on Business Requirements
• Experience in supporting ETL SSIS Packages
The following will be considered as an advantage for this position:
• Development of SSIS Packages advantageous;
• Knowledge of importing and exporting XML data advantageous;
• Data warehousing, SSAS BI Cubes, Column Store Indexes, DQS and MDS knowledge advantageous;