SQL Server Database Administrator

JOB DESCRIPTION:

As a SQL Server Database Administrator (DBA), you will play a pivotal role in designing, implementing, and maintaining the organisation's SQL Server environments to ensure reliability, scalability, and optimal performance. This position offers an exciting opportunity to deepen your technical expertise in database architecture, administration, and performance tuning while contributing directly to the stability and efficiency of key business systems.

You will work collaboratively with application development, infrastructure, and storage teams to manage and optimise both development and production databases across SQL Server Standard and Enterprise editions. Your focus will be to deliver seamless data flow, ensure high system availability, and maintain exceptional performance across all environments — empowering the organisation to operate efficiently and make informed, data-driven decisions.

DUTIES / RESPONSIBILITIES:

• Take ownership of SQL Server environments across development, testing, and production, ensuring reliability, performance, and security.
• Install, configure, and manage SQL Server instances (Standard and Enterprise) while maintaining high availability and scalability.
• Proactively monitor database performance and health, resolving issues before they impact business operations.
• Implement robust backup, recovery, and disaster recovery (DR) solutions to protect business-critical data.
• Optimise queries, indexes, and resource utilisation to deliver fast, consistent performance across applications.
• Partner with developers, infrastructure, and security teams to design and deploy efficient, secure database solutions.
• Manage and enforce access controls, roles, and permissions in alignment with security and compliance standards.
• Automate repetitive administrative tasks through scripting and modern database management tools.
• Participate in release and deployment processes, ensuring smooth transitions between development and production.
• Plan and execute upgrades, patches, and migrations while minimising downtime and risk.
• Maintain detailed documentation of database configurations, standards, and operational procedures.
• Contribute to continuous improvement by identifying opportunities for optimisation and innovation.
• Provide mentorship and technical guidance to team members, fostering a culture of collaboration and knowledge sharing.
• Respond to production incidents when required.

EDUCATION / MINIMUM REQUIREMENTS / EXPERIENCE:

Education & Certification:

• BSc or MSc in related industry/field (prefer Computer Science, Computer Engineering, and Information Systems)
• Microsoft SQL Server certifications (e.g., MCSA, MCSE, or equivalent) preferred

Experience

• 5–10 years' experience administering Microsoft SQL Server databases in enterprise environments.
• Hands-on experience with SQL Server Standard and Enterprise editions in both on-premises and virtualised environments.
• Advanced knowledge of Microsoft SQL Server and other database systems in all aspects of the application lifecycle: requirements analysis & definition, system design, implementation, testing, deployment, and sustainment
• Strong background in SQL performance tuning, query optimisation, and capacity planning.
• Experience with SSRS, SSIS, and SSAS.
• Proven expertise with Always On, replication, and HA/DR architectures.
• Familiarity with Windows Server (2016–2025) and Active Directory integration.
• Experience with PowerShell scripting for automation and administration.
• Exposure to DevOps or CI/CD database deployment pipelines advantageous.
• Advanced knowledge of SQL replication and AlwaysOn HA (Availability Groups architecture)
• Thorough advanced knowledge of MS Availability Groups (HA) including Failover clustering, replication, Logshipping and Availability Group architecture design and troubleshooting
• Experience in SQL Performance Tuning and Optimization using native monitoring and monitoring tools

OTHER REQUIREMENTS:

Core Competencies:

• Strong analytical, diagnostic, and problem-solving ability.
• Excellent communication skills — able to explain complex technical issues clearly.
• Structured and detail-oriented approach to work, with focus on reliability and performance.
• Adaptable, collaborative, and proactive in resolving operational challenges.
• Excellent written and verbal communication
• Flexible, team player, get-it-done personality
• Ability to organise and plan work independently
• Ability to work in a rapidly changing environment
• Ability to multi-task and context-switch effectively between different activities and team

Personal Attributes:

• Demonstrates high levels of integrity, accountability, and meticulous attention to detail.
• Maintains composure and focus under pressure, particularly during critical incidents or problem resolution.
• Proactive and self-driven, with the ability to work independently and collaboratively within cross-functional teams.
• Reliable, disciplined, and dedicated to continuous learning and professional growth.
• Communicates effectively across all levels of the organisation, both verbally and in writing.
• Strong analytical and problem-solving mindset, with a practical approach to challenges.
• Dependable and responsible, with a commitment to operational excellence.
• Must have a clear credit and criminal record, and access to reliable personal transport.
• Own and live up to the Company values