Senior Database Administrator - Cape Town
Salary Negotiable
Cape Town, Western Cape
Cape Town,
Western Cape
more than 14 days ago
02-09-2015 4:00:05 PM
30-09-2015 4:00:05 PM
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