SQL DBA (Shift Based)

SQL DBA (Shift Based)

  • Location

    UK - South East

  • Sector:

    ConsulTech

  • Job type:

    Permanent

  • Contact:

    BenDavis

  • Contact email:

    ben.davis@cloudstreamglobal.com

  • Job ref:

    JN -032018-57576

  • Published:

    3 months ago

  • Expiry date:

    2018-09-06

  • Startdate:

    2018-05-01

  • Consultant:

    #

MS SQL Database Administrator

Job LevelTechnical – T3
Career TrackTechnical
Leadership LevelIndividual Contributor
Number of direct reports-Total reports
Direct and indirect
-
Job Purpose/summaryAs a MS SQL Database Administrator (DBA), your primary function will be to operate and maintain SQL databases ensuring that systems are running optimally, ensuring availability, efficiency, security and recoverability.
Overlapping periods of build/project tasks may be expected, however this is not part of the primary function.
Key responsibilities
List the 8-12 key responsibilities
  • Understanding, articulating, and operating SQL Database platform management
  • Ensuring SQL database platforms are running 24/7
  • Monitoring incoming Database Events, Incident and Request Queues in line with SLAs and acting upon.
  • Using Database monitoring tools to manage events and incidents and improve monitoring thresholds in line with Database workload
  • Database and SQL performance tuning recommendations
  • Cultivating and maintaining effective working relationships with a variety of stakeholders, including end-users, change/incident managers, engineers, and senior staff members
  • Actively participate in multiple work-groups at one time, and disseminating information across all levels of the organisation
  • Review and contribute to technical documentation such as user guides, manuals system specifications and knowledge bases
  • Contribute to continual service improvement by challenging, reviewing, updating and where inexistent creating, processes and procedures in order to drive operational excellence.
  • Keeping up to date with current trends in IT
Primary internal stakeholders
Typically 1-3
  • Database Operations Team
  • Service Management Team
  • Operation SME’s
Primary external stakeholders
Typically 1-3
  • Vendors
  • Off-shore Partners
Business Application Owners
Required experience
  • Previous experience as a SQL Database Administrator.
  • Previous roles might include Development, Database Operator
Technical skills
  • Proven experience with Database Administration for MSSQL Server 2008 through 2017; troubleshooting and resolving database problems, Performance Tuning and Optimization, using native monitoring and troubleshooting tools.
  • Expertise with backups, restores and recovery models.  Knowledge and experience in High Availability (HA) and Disaster Recovery (DR) options for MSSQL Server would be desirable. Always-On, FCI and AG Replication.
  • Experience in implementing operational automation using scripts.
  • Good understanding of indexes, index management, and statistics.
  • Experience working with virtualised Windows environment   
  • Knowledge and or experience with management platforms (SCOM/SCCM) will be considered beneficial. 
  • Preferred certifications, but not required or limited to:
  • ITIL Foundation
MCTS
Business skills
  • Excellent communications skills
  • Strong sense of ownership
  • Strong analytical skills
  • Ability to work collaboratively with others
  • Ability to multi-task
  • Ability to influence and persuade
Personal profile
  • Strong interpersonal skills
  • Detail-oriented
  • Ability to take initiative and work independently
  • Results-oriented
  • Sense of urgency
  • Focused to deliver best in class service
Key measures
List 2-5 key measures/success criteria
  • Low number of incidents due to Database platforms
  • Prevent lost Business Hours
  • No high/medium risks on technical platforms
  • High alignment to Standards