SQL Database Administrator Job Description Template
Our company is looking for a SQL Database Administrator to join our team.
Responsibilities:
- Assisting with third level support issues as and when required via the Service Desk;
- Assist with covering in hours support as needed;
- Maintaining support for Managed Clients, responding to tickets and support functions;
- Production database responsibilities: instance installation and configuration, database creation and sizing;
- provide support to production application maintenance teams;
- continuous process improvement;
- ensure data integrity and business continuity, participating in annual disaster recovery tests, implement and help refine database maintenance tasks.
Requirements:
- Experience of troubleshooting and optimising database performance, alonside resolution of complex technical problems and incidents;
- Experience of supporting Microsoft SQL Server in virtualised server environments (Hyper-V, VMware) and Public Cloud (Azure/AWS);
- Experience of configuring and supporting high-availability, data replication and backup;
- Experience of indexes, index management, and statistics;
- A good understanding of Database storage technologies;
- A good understanding of Database security best practices;
- A good understanding of build and support of Microsoft Server technologies;
- Strong analytical and problem-solving skills;
- Proven ability to write clear documentation and articles for end-user and technical-user use;
- Experience with backups, restores and recovery models with knowledge of High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server;
- experience supporting and maintaining MSSQL Server (covering SQL 2008 R2, 2012, 2016 and 2017);
- Strong experience installing, configuring and supporting Microsoft SQL Server from version 2000 up to the latest version, plus SSAS, SSIS and SSRS;
- Correctly assess impact and urgency of issues and prioritise accordingly;
- Knowledge of ITIL and industry best practices;
- Experience in implementing operational automation using scripts.