Banner Default Image
Back to job search

SQL Database Infrastructure Engineer

  • Location:

    Newport

  • Sector:

    Cloud, Infrastructure and Services, Software Engineering

  • Job type:

    Contract

  • Job functions:

    Infrastructure Engineer, Engineer

  • Salary:

    £600 - £650 per day + Inside IR35

  • Contact:

    Danny Meehan

  • Contact email:

    danny.meehan@lafosse.com

  • Job ref:

    DM123_1650472083

  • Published:

    about 1 month ago

  • Duration:

    6 Months

  • Expiry date:

    2022-06-01

  • Startdate:

    ASAP

£600 Per day inside IR35

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

Desirable or

Essential

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

Essential

Windows Admin and scripting skills

Essential

Knowledge of POLYBASE

Desirable