Database Administrator

You will support key database for applications used by A&O Shearman that keep the firm running.

These include the firm’s finance and customer relationship management systems, as well business intake and time capture.

You will support other business critical applications, including 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 Dynamics365 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 databases 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, analyse 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

Analyse 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.

Analyse 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 DevOps and GitHub and other collaboration tool sets