Database Administrator

Job summary

Database Administrator

This is an exciting time to join the IPO as we’re undergoing a major transformation programme, and this is a unique opportunity for you join our database team as we make fundamental changes to our data and IT systems to modernise our platforms. We are beginning our Microsoft Azure and SQL PaaS journey to build resilient, reliable and robust systems for the future, while still maintaining a traditional SQL server estate for our current systems.

As a SQL Server Database Administrator, you will be expected to support the IPO’s multi-terabyte on-premises SQL Server estate whilst helping to drive our adoption of Azure SQL technologies. You will be responsible for the monitoring, maintenance, performance, security and availability of critical database platforms that underpin key business services.

The role is primarily focused on Microsoft SQL Server, supporting a large on-premises and growing Azure SQL estate, although there may be opportunities to work with MySQL and Azure Cosmos DB platforms.

Working Style

This role will be carried out in-line with IPO Hybrid working arrangements where staff are currently expected to spend at least 20% of their time working onsite from one of our offices. This role is based in our NewportOffice.

The requirement for attendance at an office location can vary by role so we would encourage candidates to discuss working arrangements with the recruiting manager to agree a reasonable balance between working from home and the office.

The IPO holds a visa sponsor licence however; this role is not eligible for sponsorship under the Skilled Worker route. Candidates will therefore need to have an existing right to work in the UK at the time of application.

Job description

Main duties consist of but are not limited to:

• Proactively manage and maintain all aspects of the Microsoft SQL database estate.
• Help to automate routine administration tasks using T-SQL, PowerShell and other tooling where appropriate.
• Review and execute T-SQL scripts against multiple environments in a safe, documented way.
• Investigation and resolution of database alerts, incidents and service interruptions
• Manage and maintain database access ensuring Principle of Least Privilege
• Maintain technical knowledge of the tools and skills required to monitor, manage, and maintain a medium sized Microsoft SQL Server estate
• As a DBA at the IPO, you will have the drive to stay abreast of the latest developments in cloud-based database solutions

For a full list of your roles and responsibilities as a DBA, take a look at the role profile we have attached at the end of the advert.

Person specification

Essential Criteria

• Experience of RDBMS systems and their uses
• Experience of supporting/Installing Microsoft SQL Server and its components
• The ability to understand the internal workings and performance tuning options in Microsoft SQL Server
• Administration best practices of Microsoft SQL Server
• ITIL v3 Foundation
• Experience in writing and understanding T-SQL coding to an intermediate level
• Capable of recognising trends in a range of data, and drawing conclusions
• An ability to think methodically, and apply logic to technical problem solving
• Good communication skills, both verbal and written, to contribute effectively with team members and support customers
• Flexible interpersonal skills required to build effective relationships with colleagues within the team and across the business
• An ability to organise and prioritise work in an effective manner whilst working to agreed timescales
• Experience of working with the Windows operating systems
• A good understanding of computer hardware components (CPU, RAM, Disks, etc) and their relevance/impact to database operations
• Familiarity with Microsoft office (Mostly Word, Excel, Outlook)
• Motivated and with a can-do attitude
• A desire to learn and advance skills in RDBMS technologies, primarily Microsoft

How to Apply

Click the 'Applynow' button and complete the application form by providing the following:

Your CV

• Upload an anonymised copy of your current CV. Please remove all identifying markers such as name, title, education institution etc.
• Make sure it clearly shows how you meet the essential criteria listed in the Person Specification.

For further information on the sift and interview stages of this recruitment campaign, please head to our 'Things you need to know' section below.

Please visit our Civil Service Careers page - IPO – Recruitment Support , Civil Service Careers (civil-service-careers.gov.uk)

If you require job-specific information, please contact Alex Morgan
E-mail: [email removed]
Telephone: [phone removed]

Behaviours

We'll assess you against these behaviours during the selection process:

• Delivering at Pace
• Changing and Improving
• Seeing the Big Picture
• Making Effective Decisions

Technical skills

We'll assess you against these technical skills during the selection process:

• We will assess you on the following Technical criteria at interview:Microsoft SQL Server

Benefits

Alongside your salary of £36,736, Intellectual Property Office contributes £10,642 towards you being a member of the Civil Service Defined Benefit Pension scheme. Find out what benefits a Civil Service Pension provides (opens in a new window).

• Unlimited Pluralsight video learning access
• Access to Microsoft’s ESI training suite
• Hybrid working with no core hours
• Substantial support for career progression
• 25 days annual leave moving to 30 days in annual increments
• You will also get 8 days public leave and 1 day privilege leave

For more information about what’s on offer at the Intellectual Property Office please review our IPO benefit pack attached to the bottom of this advert.

Please note that benefits may be subject to change.

Things you need to know

Artificial intelligence

Artificial intelligence can be a useful tool to support your application, however, all examples and statements provided must be truthful, factually accurate and taken directly from your own experience. Where plagiarism has been identified (presenting the ideas and experiences of others, or generated by artificial intelligence, as your own) applications may be withdrawn and internal candidates may be subject to disciplinary action. Please see our candidate guidance (opens in a new window) for more information on appropriate and inappropriate use.

Selection process details

This vacancy is using Success Profiles (opens in a new window), and will assess your Behaviours, Experience and Technical skills.

Additional details on security and vetting

Successful candidates must pass a disclosure and barring security check and if successful you must also hold, or be willing to obtain,