Senior Database Administrator

A&O Shearman is a new global industry-leading law firm, with 48 offices in 28 countries worldwide. Our fluency in English law, US law, and the laws of the world’s most dynamic markets, enables us to provide unmatched insight and seamless delivery to clients. We work on challenging and important deals and disputes that have the potential to shape the future.

We offer exceptional opportunities for our people; opportunities to work for the world’s leading businesses; to transform the status quo, and to deliver your best work,  helping you and your career to thrive, while delivering unparalleled outcomes for our clients.

Whether you’re helping clients solve complex challenges, transforming the ways we manage our business, or ensuring the smooth-running of our operations, this is an environment where you can belong and excel. We provide first-rate training and development, we are committed to  an inclusive environment, and we provide support and ways of working that help you optimise your wellbeing.

What truly defines a career with us? We recruit the best and ask for the best of you. And together, we will redefine success.

The Team
As a Database Administrator will be part of the local IT support team supporting the Enterprise Applications support team. We are here to support a wide range of critical applications used by our 7000+ users. Our team provides 24×7 support for these applications and is located across 3 time zones. IT teams are part of IT Infrastructure & Operations (I&O) which operates network, infrastructure, databases and applications for the firm. I&O is part of Technology Services, which provides world-class IT support and services to the firm.

What you will do
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.

Responsibilities
• 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
• 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 PowerShell, SQL, Linux preferred
• Collaborate with other engineering teams on production changes, incidents and problem management

Desired Skills
• Proficient Microsoft SQL
• 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 PowerShell scripting experience
• SQL and server performance tuning
• SQL Replication performance and monitoring tuning
• Understanding of Linux server management
 

A&O Shearman recognises the value of flexible working and embraces hybrid working, allowing our people to work from home up to 40% of their working time. We do however remain committed to working together in person for the remaining 60% of time so that we can learn, grow and succeed together.

Should you require additional support at any stage of the recruitment process due to a disability or a health condition, please do not hesitate to contact a member of our recruitment team who will work with you to provide any adjustments as required.

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.