Database Administrator

• We support key databases for applications used across our firm, including finance, customer relationship management, business intake, and time capture systems.
• We support other business-critical applications, including file transfer, legal technology, and various application services.
• We work with third parties that provide expertise in these systems.
• We support our database infrastructure, including MS-SQL, and the Dynamics365 platform and applications built on it.
• We support application servers and databases across on-premises and SaaS/cloud-hosted environments.
• We package, configure, test, and deploy applications.
• We work with other service support teams in Infrastructure & Operations, including End-User Compute, Infrastructure, and Networks, to provide a world-class service.
• We work with our global service desk, regional support teams, and the global IT department.
• We provide technical database expertise on projects when required.
• We ensure availability, scalability, and performance of all application database systems through data metrics.
• We capture and analyse database metrics and identify improvements.
• We design and implement robust monitoring alerts to identify potential issues early.
• We maintain core database infrastructure servers in Azure, AVS, and on-premises environments.
• We develop backup and restore procedures for major databases to ensure data integrity.
• We develop and leverage automation procedures to turn repeatable actions into automated processes.
• We analyse database capacity metrics across server infrastructure.
• We provide database engineering expertise to optimise database migrations, queries, and performance.
• We manage and monitor SQL availability groups and clustered SQL servers.
• We lead database-related projects and ensure timely delivery.
• We analyse data to identify and prioritise operations and determine root causes of major issues.
• We participate in on-call and out-of-hours support for applications and databases.
• We support maintenance reviews and vulnerability assessments of MS SQL.
• We collaborate with other engineering teams on production changes, incidents, and problem management.
• We document our work and share learnings with the wider team, including team upskilling.

Technologies:

• Azure
• Cloud
• DevOps
• GitHub
• Support
• Linux
• MS-SQL
• PowerShell
• SQL

More:

We are A&O Shearman, and we offer a hybrid working environment that supports flexibility so our teams can learn, grow, and succeed together. We are committed to equal opportunities and do not discriminate on the basis of race, colour, sex, religion, sexual orientation, national origin, disability, or any other protected characteristic. We also note that we do not accept unsolicited CVs from agencies.

• We want you to be proficient in Microsoft SQL Server, Azure SQL Server, and SQL infrastructure.
• We prefer AZ-900 Azure Fundamentals and DP-900 Azure Data Fundamentals certifications.
• We want you to have experience with SQL Availability Groups, clustering, and high-availability features.
• We want you to have SQL and PowerShell scripting experience.
• We want you to have SQL and server performance tuning experience.
• We want you to have SQL replication performance and monitoring tuning experience.
• We want you to understand Linux server management.
• We want you to have experience with programming languages including PowerShell, SQL, and preferably Linux.
• We want you to be able to work independently and communicate well.
• We want you to be able to multi-task and share knowledge with the wider team.
• We want you to have knowledge of DevOps, GitHub, and other collaboration toolsets.