Sr. Database Engineer II, AVP at State Street

📍 Job Overview

Job Title: Sr. Database Engineer II, AVP
Company: State Street
Location: Burlington, Massachusetts, United States
Job Type: Full-Time
Category: Database Administration & Engineering
Date Posted: June 19, 2025
Experience Level: 5-10 years
Remote Status: On-site

🚀 Role Summary

Lead technical contributor for enhancing and maintaining Charles River IMS modules or components within an agile scrum team.
Provide engineering troubleshooting assistance to customer support teams and other development teams.
Collaborate with cross-functional teams to ensure seamless integration of database systems.
Deliver next-generation infrastructure using emerging technologies like AI and Blockchain.

📝 Enhancement Note: This role requires a strong background in database design, development, and administration, with a focus on scalability, performance, and high availability. Experience with cloud database services and NoSQL databases is preferred.

💻 Primary Responsibilities

Database Design and Architecture:
- Design and implement scalable, performant, and highly available distributed database solutions.
- Collaborate with peers to design database solutions that meet business and application requirements.
- Create and maintain comprehensive documentation of database design, data models, configurations, and processes.
Database Development and Optimization:
- Write complex SQL queries, stored procedures, and scripts to support application development.
- Optimize database performance through indexing, SQL query optimization, and other tuning techniques.
- Monitor database performance metrics, analyze bottlenecks, and recommend short-term and long-term solutions.
- Collaborate with engineering teams to define performance test strategies and develop toolsets for repeatable performance tests.
- Implement and manage database security, including access controls, encryption, and auditing.
Database Administration:
- Perform database installation, configuration, and upgrades.
- Monitor and maintain database health to ensure data integrity, availability, and disaster recovery.
- Collaborate with production DBA teams to troubleshoot and resolve database production issues promptly.
Collaboration and Leadership:
- Provide thought leadership on database technologies and data modeling within and beyond the team's scope of responsibility.
- Collaborate with cross-functional teams, including engineering, SaaS Operation, support, and implementation, to ensure seamless integration of database systems.
- Provide technical mentorship to junior database engineers.

🎓 Skills & Qualifications

Education: Bachelor's degree in computer science, information technology, or a related field. Master's degree is a plus.

Experience: 5 to 7+ years of professional software engineering experience with enterprise applications backed by RDBMS databases or Snowflake.

Required Skills:

Extensive hands-on experience in RDBMS and distributed data platforms as a database developer or DBA.
Strong analytical and problem-solving skills with the ability to troubleshoot and resolve database-related issues.
Proficiency in SQL performance tuning in MS SQL Server, Oracle, or Snowflake.
Experience with developing applications for the financial markets (Fixed Income, Trading, FX, Risk, Portfolio/Wealth Management, Market Data, FIX, etc.) is a plus.

Preferred Skills:

Experience with NoSQL databases.
Experience with cloud database services such as Azure SQL Database or AWS RDS.
Programming experience in Java, C++, C#, JDBC, Spring Boot, and Microservices.

📊 Web Portfolio & Project Requirements

Portfolio Essentials:

Demonstrate a strong portfolio showcasing your experience with database design, development, and administration.
Include case studies highlighting your ability to optimize database performance, implement security measures, and ensure high availability.
Showcase your experience with cloud database services and NoSQL databases, if applicable.

Technical Documentation:

Provide comprehensive documentation of database design, data models, configurations, and processes.
Include examples of SQL queries, stored procedures, and scripts you have written to support application development.
Demonstrate your ability to monitor database performance metrics and analyze bottlenecks.

💵 Compensation & Benefits

Salary Range: $100,000 - $160,000 Annual

Benefits:

Medical care, insurance, and savings plans.
Flexible Work Program to help match your needs.
Development programs and educational support.

Working Hours: 40 hours per week, with flexibility for deployment windows, maintenance, and project deadlines.

📝 Enhancement Note: The salary range provided is specific to the Burlington, Massachusetts location. If the candidate works outside of this primary location, the applicable range could differ.

🎯 Team & Company Context

🏢 Company Culture

Industry: State Street is one of the largest custodian banks, asset managers, and asset intelligence companies in the world. They provide investment servicing, data & analytics, investments research & trading, and investment management to institutional clients.

Company Size: State Street has over 39,000 employees worldwide, providing a large and diverse team environment for web developers and server administrators.

Founded: 1792, with a rich history and established presence in the financial services industry.

Team Structure:

The database engineering team is part of Charles River Development (CRD), which became a part of State Street in 2018.
The team works within an agile scrum framework, collaborating with various cross-functional teams, including engineering, SaaS Operation, support, and implementation.
The database engineering team consists of experienced professionals focused on designing, developing, and maintaining high-performance database solutions.

Development Methodology:

Agile development methodology, with a focus on collaboration, continuous improvement, and delivering value to customers.
Regular sprint planning, code reviews, and testing processes to ensure high-quality software delivery.
CI/CD pipelines and automated deployment strategies to streamline the development process.

Company Website: State Street

📝 Enhancement Note: State Street's acquisition of Charles River Development in 2018 expanded its technology capabilities and offerings, providing opportunities for web developers and server administrators to work on cutting-edge projects and emerging technologies.

📈 Career & Growth Analysis

Database Engineer Career Level: This role is at the senior level, with a focus on leading technical contributions, thought leadership, and mentoring junior team members. The engineer will have significant influence on database systems and architecture decisions.

Reporting Structure: The senior database engineer reports directly to the manager of the database engineering team and collaborates with various cross-functional teams within Charles River Development and State Street.

Technical Impact: The senior database engineer's work directly impacts the performance, scalability, and security of Charles River IMS modules and other applications. Their decisions and expertise contribute to the overall success of the company's technology initiatives.

Growth Opportunities:

Technical Growth: Expand your expertise in emerging technologies, such as AI and Blockchain, and stay up-to-date with the latest database trends and best practices.
Leadership Development: Develop your leadership skills by mentoring junior team members, driving technical decisions, and collaborating with cross-functional teams.
Architecture & Design: Gain experience in designing and implementing large-scale, high-performance database solutions, and contribute to the company's architecture and design strategies.

📝 Enhancement Note: State Street's acquisition of Charles River Development has opened up new career growth opportunities for database engineers, allowing them to work on innovative projects and contribute to the company's continued success in the financial services industry.

🌐 Work Environment

Office Type: State Street's Burlington, Massachusetts office is a modern, collaborative workspace designed to facilitate team interaction and innovation.

Office Location(s): Burlington, Massachusetts, United States

Workspace Context:

State-of-the-art development tools, multiple monitors, and testing devices available to ensure optimal productivity.
Collaborative workspace with dedicated areas for team meetings, brainstorming sessions, and knowledge sharing.
Access to company-wide resources, including training, workshops, and mentorship programs to support professional growth.

Work Schedule: Flexible work arrangements, with core hours from 9:00 AM to 5:00 PM EST. The role requires availability for deployment windows, maintenance, and project deadlines as needed.

📝 Enhancement Note: State Street's flexible work arrangements and collaborative work environment foster a productive and engaging atmosphere for web developers and server administrators to thrive and grow professionally.

📄 Application & Technical Interview Process

Interview Process:

Technical Phone Screen: Assess your database design, development, and administration skills through a phone or video call.
On-site Technical Assessment: Demonstrate your ability to design, optimize, and maintain database solutions in a hands-on, real-world scenario.
Behavioral Interview: Discuss your problem-solving skills, collaboration, and leadership experiences within a team environment.
Final Review: Present your portfolio and case studies to a panel of State Street and Charles River Development team members, highlighting your technical expertise and cultural fit.

Portfolio Review Tips:

Highlight your experience with database design, development, and administration, focusing on scalability, performance, and security.
Include case studies demonstrating your ability to collaborate with cross-functional teams and drive technical decisions.
Showcase your experience with cloud database services and NoSQL databases, if applicable.

Technical Challenge Preparation:

Brush up on your SQL performance tuning skills, focusing on MS SQL Server, Oracle, or Snowflake.
Familiarize yourself with database design principles, data modeling, and normalization techniques.
Prepare for hands-on challenges that assess your ability to design, optimize, and maintain database solutions in a real-world scenario.

ATS Keywords: Database Design, SQL Performance Tuning, Database Administration, Agile Development, Problem Solving, Documentation, Database Security, Collaboration, Thought Leadership, Technical Mentorship, Distributed Database Solutions, NoSQL Databases, Cloud Database Services, Application Development, Performance Optimization, Data Modeling, RDBMS, Snowflake, MS SQL Server, Oracle, Java, C++, C#, JDBC, Spring Boot, Microservices, Charles River IMS, State Street, Charles River Development.

📝 Enhancement Note: State Street's interview process is designed to evaluate your technical expertise, problem-solving skills, and cultural fit within the organization. By preparing thoroughly and showcasing your relevant experience, you will increase your chances of success in the application and interview process.

📌 Application Steps

To apply for this senior database engineer role at State Street:

Customize Your Resume: Highlight your relevant database design, development, and administration experience, as well as your proficiency in SQL performance tuning and other required skills.
Prepare Your Portfolio: Showcase your experience with database design, development, and administration, focusing on scalability, performance, and security. Include case studies demonstrating your ability to collaborate with cross-functional teams and drive technical decisions.
Research the Company: Familiarize yourself with State Street's history, culture, and technology initiatives to ensure a strong understanding of the organization and its goals.
Practice Technical Interview Questions: Brush up on your SQL performance tuning skills, database design principles, and hands-on challenges to demonstrate your technical expertise in the interview process.

⚠️ Important Notice: This enhanced job description includes AI-generated insights and database administration industry-standard assumptions. All details should be verified directly with State Street before making application decisions.

Sr. Database Engineer II, AVP