Senior Cloud Database Performance Engineer, Officer

Senior Cloud Database Performance Engineer

Who we are looking for

Charles River Development, a State Street Company, is offering the opportunity for a talented database administrator with Data Architect and performance engineering skills to join its SaaS Platforms team.

We are looking for an expert SQL Server administrator, developer and database performance engineer in an Azure environment. We would prefer candidates with the combination of SQL database performance engineering, T-SQL development, automation, administration and Oracle to SQL Server migration skills where candidate will be responsible for identifying performance bottlenecks and performing query rewriting/tuning in Azure on SQL VM in IaaS and Azure SQL database. Candidates must possess strong knowledge of SQL Server database internals database design patterns and be able to provide insightful problem solving.

What you will be responsible for

As a Senior Azure Data Architect and Performance Engineer will:

• Ensure the availability and optimization of the MSSQL 2017, 2019, 2022 in IaaS SQL VM in Azure. Experience with Azure SQL Database and Managed Instance in Azure. Snowflake experience is a big plus!

• Expert level experience with T-SQL, Powershell automation.

• Monitor performance on application databases, queries and suggest/apply continuous tuning.

• The responsibilities include working closely with application teams and clients for tuning/re-writing queries for achieving optimal performance, experience with the Query Store, Extended Events and other third-party tools.

• Must have experience in tuning database instances, suggest architecture level changes.

• Responsible for conducting POCs on new custom requirements with Platform Engineering, coming up with standards to ensure that all application design and code is produced with proper integrity, security, and performance.

• Perform reviews on the design and code frequently to ensure the site standards are being adhered to.

• Experience with Oracle to SQL Server migration in Azure Cloud is highly preferred.

• Assist in resolving priority incidents to quickly eliminate impacts, participate in root-cause analysis, and support subsequent corrective and preventative actions.

• Work closely with SaaS Data team, On-Boarding team during client implementation phase, collaborating with various Application support and engineering teams to optimize database performance and reliability.

• Senior Database Performance Engineer are encouraged and supported to acquire relevant Azure certifications (e.g. DP-300, DP-900, AZ-104, AZ-900 Exam).

Education & Preferred Qualifications

• Bachelor’s degree in computer science (or a related technical field).

• 6-8 years of experience working with large MS SQL Server 2019, 2022 databases and Snowflake.

• Good performance tuning experience, using all available tools like SolarWinds, Query Store, Extended Events, and methods to investigate and make recommendations and re-write to improve slow performing queries and procedures at the database and server level.

• 6+ years of hands-on experience operating MS SQL servers and related technologies in Azure.

• Very good understanding of database encryption, high-availability, disaster recovery, database replication, backup/restore.

• Must be detailed oriented, have excellent written and verbal communication skills, and be an aggressive self-starter.

• A strong sense of customer service, attention to detail, and issue ownership.

• Understanding of ITIL concepts desired.

State Street's Speak Up Line