FORMAL EDUCATION:· Grade 12· Diploma / Bachelors degree in Computer Science, Information Systems, Business Management or related discipline from an accredited tertiary institution. EXPERIENCE:· 5 Years experience developing data management systems, tools and architectures using MS SQL tools.· Experience designing and operating very large Data Warehouses and web facing online transaction processing databases TECHNICAL / LEGAL CERTIFICATION:· MS SQL Certification in database administration· Demonstrable proficiency and experience in MS SQL Server, DB2, Linux, and programming languages such as R, Python, Ruby or Java.· Demonstrated experience with database technologies and API interfaces to WebApps and Administration in one or more of the following MS SQL, PL/SQL, MySQL, Oracle, or NoSQL (minimum of 5 years).· Experience in Unix AIX, Linux and MS Windows operating systems will be advantageous· ITIL v3 Foundation certification OTHER REQUIREMENTS:· A results-oriented individual who thrives working in a fast-paced environment and under pressure.· Strong written and oral communication skills.· Strong organizational and project management skills with effective results focus within an information systems environment.· Strong analytical and problem-solving skills.· Self-motivated with the ability to manage changing priorities and meet deadlines.· Proven ability to be flexible and work hard, both independently and in a team environment, in a high priority customer service, on-call environment with changing priorities.· Willingness to work occasionally outside of normal business hours in response to needs of the systems being supported RESPONSIBILITIES:Key areas of responsibility: The SQL Database Administrator will be required to perform the following duties, amongst others:· Ensure all database servers are backed up in a way that meets the businesss Recovery Point Objectives (RPO).· Test backups to ensure we can meet the business Recovery Time Objectives (RTO).· Troubleshoot SQL Database Server service outages as they occur, including after-hours and weekends.· Configure SQL Database Server monitoring utilities to minimize false alarms.· As new systems are brought in-house, choose whether to use clustering, log shipping, mirroring or other appropriate technologies.· Install and configure new SQL Database Servers.· Upgrading the SQL database software as and when required.· Deploy database change scripts provided by third party vendors.· Troubleshooting SQL database issues.· Troubleshooting hardware using technology toolsets.· Document the Departments database environment.· Failover clustering, SAN replication, and other high availability technologies.· Root Cause Analysis of production-related database issues.· Daily maintenance, monitoring, problem resolution and internal customer/development support.· Review, design and develop data models in conjunction with the application development teams.· The role might require traveling nationally and work after hours as and when required
