Senior SQL Server DBA Consultant

Boardroom Appointments; Cape Town; On-site; ZAR 900,000 - 1,500,000; Full time

Job summary

Boardroom Appointments in Cape Town seeks a Senior SQL Server DBA Consultant to own the full lifecycle of SQL Server platforms, including installations, upgrades, monitoring, tuning, and recovery strategies. Strong independent delivery and cloud awareness (AWS) are essential.

The role requires a Bachelor’s or Diploma in CS, 7+ years of experience with clustered SQL Servers and replication, and excellent written and verbal communication for technical reports and stakeholder updates.

Qualifications

• Must have Bachelor’s Degree or Diploma in Computer Science or related field.
• Excellent written and verbal communication skills.
• 7+ years of experience in SQL Server environments.

Responsibilities

• Database Software Installation and Upgrades for SQL Server versions.
• Develop processes to streamline creation of new database servers.
• Database Requirements Analysis and Design.
• Enforce database standards and review designs with development teams.
• Assess resource requirements for new applications and customer needs.
• Monitor and tune database performance and configurations.
• Backup and recovery planning and testing.

Skills

Communication skills

MS SQL Server

SQL Server Replication

Clustered SQL Servers

Education

BSc / Diploma in Computer Science

Tools

AWS

Job description

About the job Senior SQL Server DBA Consultant

Job purpose:

This position requires a highly competent, highly motivated, and driven individual who is able to work well on their own and within the team, with limited supervision, and who actively seeks ways of adding value to the business in their role as Senior DBA. Primary responsibilities include database software installation and upgrades, database requirements analysis and design, database creation, database monitoring, and tuning, database backup and recovery, and maintenance of existing database support scripts and related processes. Cloud experience (preferably AWS)

• Bachelors Degree or Diploma in Computer Science or related field
• Must have 7+ years of experience
• Must be able to work independently with little supervision.
• Required to have Cloud experience preferably in AWS.
• Must possess excellent communication skills, including writing and presenting technical reports, presentations, and general correspondence.
• Experience with MS SQL Server - Clustered SQL Servers, replication, database replication

Responsibilities:

• Database Software Installation and Upgrades. Identify server hardware, software and configurations necessary for the various SQL versions
• 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 leverage 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, and determine and implement resolutions. Coordinate interaction with vendors in critical database problem situations