Skip to content
Database Administrator, SQL Server

Database Administrator, SQL Server

Staines, UK

Key Responsibilities

Supporting Client Infrastructure Databases

To ensure the integrity of all managed databases and that data is always available through proactive management and monitoring of the databases. You will be responsible for:

  • Planning and maintenance of client's database systems.
  • Providing support to client’s databases and maintaining high availability through proactive measures.
  • Resolving technical issues escalated by the client or internal departments.
  • Administration and troubleshooting of database/server issues.
  • Ensuring clients & partners are regularly updated on status of issues.
  • Database patching – inputting into the strategy and mechanism for applying these.
  • Implementing operational procedures, utilising tools and database best-practice.
  • Helping achieve required levels of operational scalability & performance.
  • Available to help with out-of-hours work and participating in an on-call rota if required.

Measured by:

  • Successful resolution of escalated issues within agreed SLA’s.
  • Proactive analysis of issues.
  • Managing successful client solution projects.

Documentation & Knowledge Base

To ensure client-specific and database knowledge is captured and retained. You will be responsible for:

  • Documentation of procedures and knowledgebase articles.
  • Documentation of troubleshooting carried out (including root cause analysis etc).

Measured by:

  • Clear and concise documents made available for future reference.

Backup and Recovery

To protect databases against data loss and recover the data should loss occur. You will be responsible for:

  • Configuring backups for clients.
  • Reviewing and updating backup procedures for databases.
  • Ensuring that all new backup scenarios are documented and ready for the knowledge base.
  • Troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues etc.

Measured by:

  • Successful resolution of escalated backup & recovery issues within agreed SLAs.

Knowledge

  • Experience of SQL Server database administration in versions ranging from 2008 to current versions.
  • Experience of configuring and maintaining Always On Availability Groups.
  • Knowledge of methods used for backups, restores and recovery., shrink operations and DBCC commands.
  • Experience of configuring and administering log shipping, mirroring, replication, clustering and Always On availability groups.
  • Knowledge of methods used for index management, integrity checks, statistics, configuration and patching. 
  • Experience of creating jobs, Database mail, Alerts, and Maintenance plans in a production environment.
  • Able to detect and troubleshoot CPU, memory and I/O issues, I/O, disk and resource contention issues.
  • Experience in performance tuning, Performance Monitor, SQL Profiler and related tools.
  • Knowledge/experience of ITIL standards desirable.
  • Knowledge in a scripting language such as PowerShell desirable.
  • Knowledge of other Database technologies such as Oracle, MySQL or Postgres desirable.
  • Knowledge of database management Azure and AWS desirable.

Skills

  • Excellent written and verbal communication skills.
  • Good problem solving and decision-making skills.  
  • Willing to work as part of a Team across global regions. Strong interpersonal skills. Self-motivated with keen attention to detail.

Experience / Qualifications

  • Educated to a degree level in an IT-related subject.
  • Demonstrable experience in a database administration role.
  • Microsoft Certification for SQL and/or Azure Database Administration for example MCSA/MCSE/Azure Database Administrator Associate (exam DP-300) is desirable but not essential.

What do we offer?

•       25 days annual leave

•       ½ day birthday leave

•       Private medical care

•       Life insurance

•       Referral bonus

•       5 days study leave

•       One paid day off for charity events

•       Training and development programs

•       Home working

•       Perkbox

#LI-DB1

Your journey with Ensono starts here.

Apply now

More career opportunities at Ensono

Explore additional openings with our team, and apply today.

Start your digital transformation today.