[LPS] Database Administrator - MSSQL

Role overview

The Database Administrator owns the availability, performance, security and recoverability of the organisation's DB2 and SQL Server databases. The role acts as the technical authority for database matters, working day to day with the Server, Data Center and Network domains.

This is a collaborative role. The successful candidate keeps engineers, vendors and stakeholders informed, shares knowledge openly and works as part of the team.

Key responsibilities:

The role covers the full lifecycle of the DB2 and MSSQL estate, plus clear communication around every change and incident.

• Keep DB2 and MSSQL databases highly available and reliable across PROD, DR, and UAT
• Perform daily health checks, routine database maintenance and database security self-assessments
• Create, configure and migrate databases, and apply patches and upgrades to keep them at supported levels
• Design, build and maintain MSSQL Always On Availability Groups, including failover testing
• Define and own the backup, restore and DR strategy, and test it regularly
• Plan database capacity and lead performance tuning, using historical and real-time monitoring
• Implement and maintain database hardening baselines and encryption, including Transparent Data Encryption (TDE) and its key management
• Ensure databases comply with security policies and standards, including periodic account reviews, and close vulnerability and audit findings on schedule
• Act as L3 escalation point: troubleshoot integrity, performance, blocking, deadlock, connectivity and security issues, and lead root-cause analysis with users and vendors
• Plan and lead maintenance windows, including after-office-hours work, with proper change control and stakeholder communication
• Work with the privileged access and virtualisation teams, requesting DB account onboarding and VM resources and following their processes
• Collaborate with the Server, Data Center and Network teams on shared changes and incidents
• Document database policies, architecture and design artefacts, plus runbooks, KBs and topology diagrams
• Provide technical expertise and solutions for database-related projects, and recommend platform roadmap improvements
• Set database standards and best practices, and mentor junior engineers

Requirements:

• Candidates need 6+ years of hands-on DBA experience, strong DB2 and MSSQL skills, and the communication and teamwork to work well across several technical teams.
• 6+ years of hands-on DBA experience, with strong working knowledge of both DB2 and MSSQL, supporting PROD, DR, and UAT environments
• Proven experience building and supporting Always On Availability Groups in production
• Hands-on experience with Transparent Data Encryption(TDE), including encryption key and certificate management
• Experience developing and applying database hardening standards, security policies and procedures, and remediating vulnerabilities
• Strong experience in backup and recovery, database migration and cloning, and evaluating and installing new releases, patches and upgrades
• Strong troubleshooting skills for integrity, performance, blocking, deadlocking, connectivity and security issues
• Experience producing performance and health reports using native tools and scripts
• Strong knowledge of Windows and Unix/Linux operating systems
• Familiarity with CyberArk (PAM) and VMware vCenter, enough to work with those teams. No administration of either is expected.
• Experience with other RDBMS, NoSQL or cloud platforms is an advantage
• Strong team player who shares knowledge, supports colleagues and works well across Server, Data Center and Network teams
• Good written and spoken English, able to explain issues, risks and changes clearly to engineers, vendors and non-technical stakeholders
• Strong documentation skills for processes and procedures, including KBs, runbooks and topology diagrams
• Disciplined approach to change control, working with users and vendors to resolve issues promptly within service levels
• Proactive in keeping stakeholders updated during incidents and maintenance windows
• Willing and able to work after-office-hours maintenance windows as scheduled, including nights and weekends where required

Certifications:

Must have 1 of the following:

• Microsoft Certified: Azure Database Administrator Associate (DP-300)
• AWS Certified Database - Specialty, or an equivalent cloud certification

Preferred

• IBM Certified Administrator for Db2
• A relevant Microsoft SQL Server certification
• ITIL 4 Foundation