Database Engineer — Azure/SQL, DevOps & Automation

A&O Shearman; Warszawa; On-site; PLN 90,000 - 120,000; Full time

Job summary

A&O Shearman seeks an experienced database professional to support the firm’s MS SQL, Azure SQL, and related data services across on-premises and cloud deployments. You will collaborate with global IT and service teams to ensure availability, performance and security of critical applications used for finance, CRM, and operations.

Responsibilities include monitoring, backups, automation, migrations, and incident response.

Qualifications

• 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

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

Skills

MS SQL

Azure SQL

Azure Fundamentals

SQL AG & clustering

PowerShell

Query tuning

Linux server management

Database monitoring

Job description

A&O Shearman seeks an experienced database professional to support the firm’s MS SQL, Azure SQL, and related data services across on-premises and cloud deployments. You will collaborate with global IT and service teams to ensure availability, performance and security of critical applications used for finance, CRM, and operations.

Responsibilities include monitoring, backups, automation, migrations, and incident response.