Infrastructure Operations Senior Engineer - MSSQL Database, Assistant Vice President

Who we are looking for

The Infrastructure Operations (MSSQL Database) Senior Engineer -AVP is part of the Data Platform Engineering & Operations team, whose mission is to engineer and deliver self-service, performant and resilient database services platform to enable world class product development.

Why this role is important to us

This role will be responsible for leading the Data Platform Global SQL Server Database product, with a special emphasis on on-prem & cloud delivery, and optionally, as needed supporting the Cloud native databases. This role will be responsible for the day-to-day governance of all MSSQL Database  infrastructure platform operations processes, ensuring all technology SLA’s/OLA’s are met, driving platform availability. The individual in this role will continuously support engineering initiatives to build robust products and enhance security for operational processes.  The individual will mentor & mature a team of highly skilled engineers who repeatedly deliver highly secure, scalable, reliable, efficient and automated database technology operations services that are focused on the needs of all State Street businesses 24*7*365 days. The individual and team will also be responsible for Incident, Problem, Change, Knowledge and Configuration management for all relational database infrastructure platforms.  In collaboration with the business, technology peers, and vendor partners, you will ensure that State Street’s businesses have optimized services and operations, enabling greater availability, performance and reliability in the delivery of State Street products.

What you will be responsible for

As Infrastructure Operations MSSQL Database SME you will

• Function as a Technical bridge between Engineering team members including service providers
• Be an escalation point of contact for major incidents for Microsoft SQL Server database infrastructure
• Institute and govern KRI's, KPIs and Metrics related to operational procedures
• Be accountable for Incident, Change, Knowledge, and Problem Management
• Be responsible for end-to- end support for Microsoft SQL Server database Platform including MSSQL /Open systems Database monitoring, investigating problems and developing solutions
• Drive automation of both Engineering and Operational processes
• Manage and support Database life cycle activities, including SQL Server migrations to Cloud
• Work with internal and external auditors to enhance security and implement database auditing processes and participate in security audits .
• Adhere to the customers Incident Management Processes and proactively drive the continuous improvement of the Incident Management Process
• Manage in scope incidents in the Customer IT Environment in accordance with the customers Incident Management Process
• Open required Problem Tickets from Incident Tickets Improving the quality and usage of the Known Error Database and recommended workarounds

What we value

These skills will help you succeed in this role 

• Hands on experience on database backup and recovery/migration technologies
• In depth knowledge and expertise in Microsoft SQL Server Database Tuning, Performance Tuning , Query optimization.
• Experience in Database Monitoring and tuning using Query Store, DMVs, PerfMon, profiler , event viewer, Extended Events  and other tools.
• Experience working with vendors
• PowerShell or .Net experience
• Hands on experience on High Availability (HA) and Disaster Recovery (DR) options for SQL Server and clustering solutions.
• Working Knowledge of SSIS and Reporting  Services.
• Experience on Tanium and other Security products

Education & Preferred Qualifications

• Bachelor's or Master's Degree in Computer Science, Information Technology, Engineering, or a related discipline.
• 5+ years of experience in L3/L4 Production Support as a Microsoft SQL Server Database Administrator in enterprise environments.
• Strong expertise in Microsoft SQL Server architecture, administration, security, performance tuning, backup/recovery, and high-availability solutions.
• Experience with PowerShell scripting, Ansible, Terraform, and infrastructure automation.
• Hands-on experience implementing CI/CD pipelines, DevOps practices, and Infrastructure-as-Code.
• Microsoft SQL Server certifications (MCSA/MCSE/MCPS or equivalent) preferred.
• ITIL Foundation Certification preferred.

Additional Requirements

• 8 years of experience managing and supporting Microsoft SQL Server databases in 24x7x365 mission-critical production environments, preferably within Banking, Financial Services, or other highly regulated industries.
• Deep understanding of Microsoft SQL Server internals, performance optimization, clustering, Always On Availability Groups, replication, and disaster recovery solutions.
• Experience supporting large-scale SQL Server deployments across on-premises, AWS, and Azure cloud platforms.
• Strong troubleshooting, analytical, and critical-thinking skills with demonstrated experience in root cause analysis and permanent resolution implementation.
• Proven experience managing major incidents, severity outages, production stability initiatives, and service restoration activities.
• Experience in database monitoring, capacity planning, patch management, upgrades, security hardening, and vulnerability remediation.
• Strong understanding of database security, access controls, encryption, auditing, and regulatory compliance requirements.
• Experience leading automation initiatives to improve operational efficiency and reduce manual intervention.
• Experience automating database administration tasks, monitoring, patching, and operational workflows using scripting and Infrastructure-as-Code frameworks.
• Ability to coordinate with application, infrastructure, cloud, cybersecurity, and architecture teams during incident and project delivery activities.
• Strong verbal and written communication skills with experience interacting with senior stakeholders and business partners.
• Experience providing technical leadership, mentoring junior engineers, and driving operational excellence initiatives.

Good to Have Skills

• Thorough understanding of RDBMS architecture with advanced expertise in SQL Server.
• Exposure to other database technologies such as Oracle, PostgreSQL, MySQL, MongoDB, or NoSQL platforms.
• Experience supporting hybrid-cloud and multi-cloud database architectures.
• Familiarity with audit, risk, compliance, and regulatory frameworks within Financial Services organizations.
• Experience with enterprise monitoring and observability platforms.
• Knowledge of data protection, disaster recovery testing, and business continuity planning.
• Experience working with vendors, infrastructure partners, and cross-functional teams during project delivery and platform upgrades.
• Exposure to FinOps, cloud cost optimization, and infrastructure governance practices.

Work Requirement

On-premise / Hybrid

Salary Range:

$100,000 - $167,500 Annual

The range quoted above applies to the role in the primary location specified. If the candidate would ultimately work outside of the primary location above, the applicable range could differ.

Employees are eligible to participate in State Street’s comprehensive benefits program, which includes: our retirement savings plan (401K) with company match; insurance coverage including basic life, medical, dental, vision, long-term disability, and other optional additional coverages; paid-time off including vacation, sick leave, short term disability, and family care responsibilities; access to our Employee Assistance Program; incentive compensation including eligibility for annual performance-based awards (excluding certain sales roles subject to sales incentive plans); and, eligibility for certain tax advantaged savings plans.

For a full overview, visit https://hrportal.ehr.com/statestreet/Home.

About State Street

Across the globe, institutional investors rely on us to help them manage risk, respond to challenges, and drive performance and profitability. We keep our clients at the heart of everything we do, and smart, engaged employees are essential to our continued success.

We are committed to fostering an environment where every employee feels valued and empowered to reach their full potential. As an essential partner in our shared success, you’ll benefit from inclusive development opportunities, flexible work-life support, paid volunteer days, and vibrant employee networks that keep you connected to what matters most. Join us in shaping the future.

As an Equal Opportunity Employer, we consider all qualified applicants for all positions without regard to race, creed, color, religion, national origin, ancestry, ethnicity, age, disability, genetic information, sex, sexual orientation, gender identity or expression, citizenship, marital status, domestic partnership or civil union status, familial status, military and veteran status, and other characteristics protected by applicable law.

Discover more information on jobs at StateStreet.com/careers

Read our CEO Statement

Job Application Disclosure:

It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability.