Senior Database Administrator

Location: V&A Waterfront, Cape Town

Requirements:
Bachelor's Degree in Computer related field
Minimum of 5 years’ experience with MS SQL Server 2008, clustered SQL Servers, replication, log shipping, database mirroring and replication
Good working knowledge of MS SQL Server 2012
T-SQL scripting experience writing complex stored procedures
Experience using SQL profiler
Data modelling experience as well as SQL performance and tuning
Broad knowledge of technology platforms, products and services
Experience in a technical support organization

Duties:
Database Software Installation and Upgrades
Identify server hardware, software and configurations necessary for running MS SQL 2008, and 2012 in an optimal fashion.
Utilise and refine existing process descriptions for database software installation and configuration
Develop new processes, leveraging new technology, to streamline the process of building new database servers
Database Requirements Analysis and Design
Enforcement of database standards
Work with application development teams to design, and review designs for new databases, or changes to existing databases
Assess and identify database server resource requirements based on new application and customer requirements
Periodically assess and refine database standards based on new technologies and business direction
Database Monitoring and Tuning
Develop and improve procedures for automated monitoring of database availability and performance
Review performance stats and recommend changes for tuning database, server, storage configurations and applications
Database Backup and Recovery
Participate in backup audits, ensuring all databases and associated logs are being backed-up
Periodically conduct test database restores to validate backup integrity and refresh skills
Gather requirements and make recommendations for application backup and recovery
Implement new backup and recovery processes that leverages new techniques and technology
Database Problem Research and Resolution
Assume ownership of database related problems; pursuing short and long-term problem resolution and root cause analysis
Work with vendors and internal support representatives to gather information, determine and implement resolutions
Coordinate interaction with vendors in critical database problem situations
Database Support
Participate in a 24X7 standby