linkedin

Connecting...

Job Search / Cloud & Infrastructure

SQL Database Administrator - Active SC Clearance required

Location
England
Salary
£550 - £650 per day + inside IR35
Job Type
Contract
Ref
BBBH30050_1650384093
Contact
James Norval

SQL Database Administrator

*** Active SC level security clearance required, used within the last 12 months ***

  • Rate 550/650 per day inside IR35
  • 3 months
  • Deadline 12 Noon 22/04/22

Description of Requirement

MS SQL (Microsoft SQL Server Software Installation and Configuration
* MS SQL for database software installation and net client installations for use with application servers and clients.
* This would include configuration of HA clusters and other MS SQL software elements
* Post s/w installation activities. Eg: Performance and tuning.
Problem investigation and resolution

Monitoring and Administration using MS SQL and Admin Tools
Using admin tools to monitor and administer databases
* Knowledge of marketplace monitoring tools or scripts.
* Using tools to back up and restore databases
* DR principals.

Troubleshooting software issues under daily running. Experience of liaising with software supplier Microsoft, to resolve issues quickly and effectively.
Application-Facing
Dealing with ad-hoc problems raised by application support teams.
Knowledge of programming using various programming languages to allow for quicker insights into queries from applications support team's dbas.
Some knowledge of POLYBASE can be advantageous as ONS has an installation of this, especially around problem solving and troubleshooting alongside development teams.
Coaching and mentoring junior members of the team to teach them MS SQL and assist in their growth and development to becoming an effective MS SQL DBA.
Operating System and Network
Thorough knowledge of o/s commands for windows servers and admin tasks - ideally o/s admin level knowledge.
Good working knowledge of scripting techniques to create and maintain scripts.
Knowledge of SSH/SCP for moving files between servers and WinSCP for moving files between Linux and Windows.
Understanding of o/s level backups to collaborate effectively with Veeam/Netbackup team.

Responsibilities

MS SQL DBA duties to assist in supporting all our MS SQL estate and suggest improvements. This includes, but is not limited to incident, change and problem investigations and management. There is also a requirement to coach, mentor and develop junior members of the team in MS SQL admin.


Relevant Skills and Experience

Database Administration skills for MS SQL version 2014 upwards (including HA Clusters and DR/Backup technologies and methods)

Windows Admin and scripting skills

Knowledge of POLYBASE