Database Administrator

We have an exciting opportunity for a Database Administrator (Senior Admin) to join our IT team based in A&O Shearman Belfast office.

Information Technology team – Belfast

As a Database Administrator you will be part of the local IT support team supporting the Enterprise Applications support team. We support a wide range of critical applications used by our 7000+ users, providing 24x7 support across three time zones.

You will support key databases for applications used by A&O Shearman that keep the firm running, including finance, customer relationship management systems, business intake and time capture, file transfer, legal technology, and various application services.

You will work with 3rd parties who provide expertise in these systems. The firm's database infrastructure (MS‑SQL) will also be supported by you. You will also support the Dynamics 365 platform and applications built on it. Application servers and databases are a mixture of on‑premises and SaaS/cloud‑hosted.

As well as supporting the database stack, you will package, configure, test, and deploy applications to the firm. You will work with other service support teams in I&O, including End‑User Compute, Infrastructure and Networks, to provide a world‑class service to our business. You will also work with our global service desk, regional support teams and the global IT department. You will provide technical database expertise on projects when required.

Provide availability, scalability and performance of all application database systems through data metrics.

Capture, analyze database metrics and bring forward improvements of database systems.

Identify, design and implement robust monitoring alerts to identify potential issues early.

Maintain core database infrastructure servers in Azure, AVS and on‑premises.

Develop backup/restore procedures for major databases to ensure data integrity.

Develop and leverage automation procedures to turn repeatable actions into automated processes.

Analyze database capacity metrics on all server infrastructure.

Provide expertise for database engineering to optimise database migrations, queries and performance.

Management and monitoring of SQL availability groups and clustered SQL servers.

Lead in database related projects and ensure timely delivery.

Analyze and use data to identify and prioritise operations to find root cause of major issues.

Participate in on‑call and out‑of‑hours support for both application and databases.

Knowledge and use of Dev Ops and Git Hub and other collaboration tool sets.

Support maintenance reviews, vulnerability assessments of MS SQL.

Ability to work independently and good communication skills.

Document and knowledge share learnings to wider team with ability to multi‑task including team upskilling.

Experience with programming languages including Power Shell, SQL, Linux preferred.

Collaborate with other engineering teams on production changes, incidents and problem management.

Desired Skills

• Azure Server and SQL infrastructure
• AZ‑900 Azure Fundamentals and DP‑900 Azure Data Fundamentals preferred
• SQL AG, Clustering and high availability features experience
• SQL and Power Shell scripting experience
• SQL and server performance tuning
• SQL Replication performance and monitoring tuning
• Understanding of Linux server management

We recognise that our people are our most valuable asset, which is reflected in the wide range of benefits that are available to our employees. Some of these benefits include: our occupational pension scheme, group income protection cover, private medical insurance, mental health resources and free apps, health and wellbeing services encompassing GP service, emergency back‑up care support, parental and special leave, holiday entitlement increasing with length of service, holiday trading, online discounts and lifestyle management services.

We recognise the value of flexible working and embrace hybrid working, so that we can learn, grow and succeed together.

We are an equal opportunities recruiter and do not discriminate on the basis of race, colour, sex, religion, sexual orientation, national origin, disability, or any other protected characteristic.