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 3 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;