Sr. Database Engineer II, AVP

📍 Job Overview

• Job Title: Sr. Database Engineer II, AVP
• Company: State Street
• Location: Burlington, Massachusetts
• Job Type: On-site
• Category: Database Engineering
• Date Posted: June 18, 2025
• Experience Level: 5-10 years
• Remote Status: On-site

🚀 Role Summary

• Lead technical contributor to the enhancement and maintenance of Charles River IMS modules or components within an agile scrum team.
• Provide engineering troubleshooting assistance to customer support teams and other development teams within Charles River.
• Collaborate with peers across scrum teams to design and deliver database solutions that meet business and application requirements.
• Design and implement scalable, performant, and highly available distributed database solutions.

📝 Enhancement Note: This role requires a strong background in database design, architecture, and optimization, with a focus on distributed data platforms and cloud database services. Experience in an Agile development methodology is crucial for success in this collaborative, cross-functional environment.

💻 Primary Responsibilities

• Database Design and Architecture:

  • Design and implement scalable, performant, and highly available distributed database solutions.
  • Collaborate with peers across scrum teams to design and deliver 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 performance through indexing, SQL query optimization, and other database tuning techniques.
  • Monitor database performance metrics, analyze and identify bottlenecks, and recommend short-term and long-term solutions.
  • Collaborate with engineering teams to define performance test strategy and develop toolsets for effective and 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 in a timely manner.

• Collaboration and Leadership:

  • Provide thought leadership on the topic of 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 with RDBMS databases or Snowflake.
• 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 in NoSQL databases is preferred.
• Experience with cloud database services such as Azure SQL Database or AWS RDS is a plus.
• Programming experience in Java, C++, C#, JDBC, Spring Boot, and Microservices is a plus.
• Experience with developing applications for the financial markets is a plus (Fixed Income, Trading, FX, Risk, Portfolio/Wealth Management, Market Data, FIX, etc.).

Required Skills:

• Expert experience with relational databases (RDBMS), hardware sizing and configuration, operating systems, scripting, and database technologies.
• Strong track record of building high-performance, production-quality software on schedule.
• Ability to work independently, handle multiple tasks simultaneously, and adapt quickly to changes.
• Excellent communication skills (verbal and written) with the ability to convey complex technical concepts to both technical and non-technical stakeholders.
• A minimum of 5 years working with an Agile development methodology strongly desired.

Preferred Skills:

• Experience with developing applications for the financial markets.
• Programming experience in Java, C++, C#, JDBC, Spring Boot, and Microservices.

📊 Web Portfolio & Project Requirements

• Portfolio Essentials:

  • Demonstrate a strong understanding of database design, architecture, and optimization through previous projects.
  • Showcase experience with distributed data platforms, cloud database services, and NoSQL databases.
  • Highlight successful collaboration with cross-functional teams and experience working in an Agile development methodology.

• Technical Documentation:

  • Provide comprehensive documentation of database design, data models, configurations, and processes for previous projects.
  • Showcase experience with database security, including access controls, encryption, and auditing.
  • Demonstrate problem-solving skills and the ability to troubleshoot and resolve database-related issues.

💵 Compensation & Benefits

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

📝 Enhancement Note: The provided salary range is based on the information given in the job listing. However, it is essential to consider that the range may vary depending on the candidate's experience, skills, and the company's internal compensation structure.

Benefits:

• Medical Care
• Insurance
• Savings Plans
• Flexible Work Program
• Development Programs
• Educational Support
• Paid Volunteer Days
• Matching Gift Program

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

🎯 Team & Company Context

🏢 Company Culture

Industry: Financial Services, focusing on investment management software solutions for large institutions.

Company Size: Large, with over 39,000 employees worldwide, providing ample opportunities for collaboration and growth.

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

Team Structure:

• The team is part of Charles River Development (CRD), which became a part of State Street in 2018.
• The role is within an agile scrum team, working on Charles River IMS modules or components.
• The team collaborates with cross-functional teams, including engineering, SaaS Operation, support, and implementation.

Development Methodology:

• Agile development methodology, with a focus on collaboration, iterative development, and continuous improvement.
• The team works in sprints, with regular planning, review, and retrospective meetings.

Company Website: www.statestreet.com

📝 Enhancement Note: State Street is a large, established company with a strong presence in the financial industry. This role offers the opportunity to work on enterprise-level applications and collaborate with diverse teams to deliver high-quality software solutions.

📈 Career & Growth Analysis

Database Engineering Career Level: This role is at the senior level, focusing on leading technical contributions to database design, development, and optimization. The role requires extensive experience in database technologies, with a strong track record of building high-performance, production-quality software.

Reporting Structure: The role reports to the team lead or manager within the Charles River Development group at State Street. The team collaborates with various cross-functional teams, including engineering, SaaS Operation, support, and implementation.

Technical Impact: The role has a significant impact on the performance, scalability, and availability of Charles River IMS modules or components. The successful candidate will design and implement database solutions that meet business and application requirements, ensuring optimal performance and data integrity.

Growth Opportunities:

• Technical Growth: Deepen expertise in database design, architecture, and optimization, with opportunities to work on emerging technologies and cloud database services.
• Leadership Growth: Develop leadership skills through mentoring junior database engineers and collaborating with cross-functional teams to ensure seamless integration of database systems.
• Career Progression: Progress to more senior roles within the database engineering team or explore opportunities in related fields, such as data architecture or data engineering.

📝 Enhancement Note: This role offers significant growth opportunities for experienced database engineers looking to advance their careers in a large, established financial services company. The role provides the opportunity to work on enterprise-level applications, collaborate with diverse teams, and make a substantial impact on the performance and scalability of critical financial systems.

🌐 Work Environment

Office Type: State Street's office is a large, modern facility with ample space for collaboration and teamwork. The office is designed to support agile development methodologies, with dedicated areas for scrum teams, meetings, and quiet workspaces.

Office Location(s): The role is based in Burlington, Massachusetts, with easy access to major highways and public transportation. The office is located in a suburban area with nearby amenities, including restaurants, shops, and recreational facilities.

Workspace Context:

• Collaboration: The office is designed to foster collaboration, with open-plan workspaces, dedicated meeting rooms, and breakout areas.
• Technology: The office is equipped with modern technology, including high-speed internet, multiple monitors, and testing devices.
• Team Interaction: The role involves close collaboration with cross-functional teams, including engineering, SaaS Operation, support, and implementation. The office layout encourages interaction and communication between team members.

Work Schedule: The role follows a standard workweek of 40 hours, with flexibility for project deadlines and maintenance windows. The team works in sprints, with regular planning, review, and retrospective meetings to ensure efficient project management and continuous improvement.

📝 Enhancement Note: State Street's office in Burlington, Massachusetts, provides a modern, collaborative work environment designed to support agile development methodologies. The office is conveniently located with easy access to amenities, and the role offers a flexible work schedule with opportunities for career growth and development.

📄 Application & Technical Interview Process

Interview Process:

• Technical Assessment (1 hour): A hands-on technical assessment focused on database design, development, and optimization. The assessment may include tasks such as designing a database schema, writing SQL queries, and optimizing performance.
• Cultural Fit Interview (30 minutes): A conversation with the team lead or manager to assess cultural fit and communication skills. The interviewer will discuss the team's dynamics, collaboration style, and expectations for the role.
• Final Interview (30 minutes): A meeting with the hiring manager or a panel of stakeholders to discuss the candidate's fit for the role, technical skills, and career aspirations.

Portfolio Review Tips:

• Highlight previous projects that demonstrate strong database design, architecture, and optimization skills.
• Showcase experience with distributed data platforms, cloud database services, and NoSQL databases.
• Emphasize successful collaboration with cross-functional teams and experience working in an Agile development methodology.
• Prepare comprehensive documentation of database design, data models, configurations, and processes for previous projects.

Technical Challenge Preparation:

• Brush up on SQL performance tuning techniques for MS SQL Server, Oracle, or Snowflake.
• Familiarize yourself with database security best practices, including access controls, encryption, and auditing.
• Review your problem-solving skills and be prepared to discuss your approach to troubleshooting and resolving database-related issues.

ATS Keywords:

• Database Design
• SQL
• Performance Tuning
• Database Security
• Agile Development
• Documentation
• Collaboration
• Troubleshooting
• Data Modeling
• Cloud Database Services
• NoSQL
• Java
• C++
• C#
• Microservices
• Scripting

📝 Enhancement Note: The interview process for this role is designed to assess the candidate's technical skills, cultural fit, and potential for growth within the team. The process includes a hands-on technical assessment, a cultural fit interview, and a final interview with the hiring manager or a panel of stakeholders. Candidates should prepare by reviewing their database design, development, and optimization skills, as well as their experience with distributed data platforms, cloud database services, and NoSQL databases.

🛠 Technology Stack & Web Infrastructure

Database Technologies:

• MS SQL Server
• Oracle
• Snowflake
• NoSQL databases (preferred experience)
• Cloud database services (Azure SQL Database or AWS RDS, preferred experience)

Programming Languages:

• Java
• C++
• C#
• JDBC
• Spring Boot
• Microservices (preferred experience)

Scripting Languages:

• SQL
• Shell scripting
• PowerShell (preferred experience)

Infrastructure Tools:

• Version control systems (Git, preferred experience)
• CI/CD pipelines (Jenkins, preferred experience)
• Monitoring tools (New Relic, preferred experience)

📝 Enhancement Note: The technology stack for this role includes a mix of relational database management systems, cloud database services, and NoSQL databases. The role requires proficiency in SQL performance tuning, experience with cloud database services, and familiarity with scripting languages and infrastructure tools. Candidates should be comfortable working with modern development methodologies and tools, as well as collaborating with cross-functional teams to deliver high-quality software solutions.

👥 Team Culture & Values

Database Engineering Values:

• Expertise: Demonstrate deep understanding of database design, architecture, and optimization principles.
• Collaboration: Work effectively with cross-functional teams, including engineering, SaaS Operation, support, and implementation.
• Innovation: Stay up-to-date with emerging technologies, such as cloud database services and NoSQL databases, and explore new approaches to database design and optimization.
• Performance: Focus on delivering high-performance, scalable, and highly available database solutions that meet business and application requirements.
• Quality: Maintain high standards for database design, documentation, and code quality, ensuring optimal performance and data integrity.

Collaboration Style:

• Agile Development: Work in sprints, with regular planning, review, and retrospective meetings to ensure efficient project management and continuous improvement.
• Cross-Functional Integration: Collaborate with diverse teams, including engineering, SaaS Operation, support, and implementation, to ensure seamless integration of database systems.
• Code Review Culture: Participate in code reviews to ensure high-quality database design, development, and optimization.
• Peer Programming: Collaborate with team members to share knowledge, improve skills, and ensure high-quality database solutions.

📝 Enhancement Note: The team culture for this role emphasizes expertise, collaboration, innovation, performance, and quality in database engineering. The team works in an agile development environment, with a focus on cross-functional integration, code review culture, and peer programming. Candidates should be comfortable working in a collaborative, fast-paced environment and be eager to share their knowledge and learn from their teammates.

⚡ Challenges & Growth Opportunities

Technical Challenges:

• Database Design and Architecture: Design and implement scalable, performant, and highly available distributed database solutions that meet business and application requirements.
• Performance Optimization: Optimize database performance through indexing, SQL query optimization, and other database tuning techniques, as well as monitoring performance metrics and identifying bottlenecks.
• Cloud Database Services: Gain experience with cloud database services, such as Azure SQL Database or AWS RDS, and explore the benefits of cloud-based database solutions for scalability, availability, and cost-efficiency.
• NoSQL Databases: Familiarize yourself with NoSQL databases and explore the use cases and benefits of these data storage solutions in modern application development.

Learning & Development Opportunities:

• Technical Skill Development: Deepen your expertise in database design, architecture, and optimization, with opportunities to work on emerging technologies and cloud database services.
• Leadership Development: Develop leadership skills through mentoring junior database engineers and collaborating with cross-functional teams to ensure seamless integration of database systems.
• Career Progression: Progress to more senior roles within the database engineering team or explore opportunities in related fields, such as data architecture or data engineering.
• Industry Connections: Build relationships with industry peers, attend conferences, and participate in online forums to stay up-to-date with the latest trends and best practices in database engineering.

📝 Enhancement Note: This role offers significant technical challenges and growth opportunities for experienced database engineers looking to advance their careers in a large, established financial services company. The role provides the opportunity to work on enterprise-level applications, collaborate with diverse teams, and make a substantial impact on the performance and scalability of critical financial systems. Additionally, the role offers ample opportunities for learning and development, with a focus on technical skill development, leadership development, and career progression.

💡 Interview Preparation

Technical Questions:

• Database Design and Architecture:

  • Can you describe your approach to designing and implementing scalable, performant, and highly available distributed database solutions?
  • How do you ensure that your database design meets business and application requirements?
  • Can you walk us through an example of a complex database design project you've worked on, and how you approached it?

• Database Development and Optimization:

  • How do you optimize database performance through indexing, SQL query optimization, and other database tuning techniques?
  • Can you describe a situation where you had to analyze and identify bottlenecks in a database, and how you recommended short-term and long-term solutions?
  • How do you monitor database performance metrics, and what tools do you use to generate synthetic datasets for effective and repeatable performance tests?

• Database Administration:

  • Can you describe your experience with database installation, configuration, and upgrades?
  • How do you ensure data integrity, availability, and disaster recovery for the databases you manage?
  • Can you walk us through a situation where you had to troubleshoot and resolve a database production issue, and how you collaborated with the production DBA team to address it?

Company & Culture Questions:

• Company Culture: What do you think makes State Street's company culture unique, and how does it align with your personal values and workstyle?
• Team Dynamics: How do you approach working in a cross-functional team environment, and what strategies do you use to ensure effective collaboration and communication?
• Agile Development: Can you describe your experience with Agile development methodologies, and how you've contributed to the success of projects in this environment?

Portfolio Presentation Strategy:

• Database Design and Architecture: Highlight your experience with database design and architecture, and provide examples of your work that demonstrate your expertise in this area.
• Database Development and Optimization: Showcase your skills in database development and optimization, and provide examples of your work that demonstrate your ability to deliver high-performance, scalable, and highly available database solutions.
• Database Administration: Emphasize your experience with database administration, and provide examples of your work that demonstrate your ability to ensure data integrity, availability, and disaster recovery.

📝 Enhancement Note: The interview process for this role is designed to assess the candidate's technical skills, cultural fit, and potential for growth within the team. The process includes a hands-on technical assessment, a cultural fit interview, and a final interview with the hiring manager or a panel of stakeholders. Candidates should prepare by reviewing their database design, development, and optimization skills, as well as their experience with distributed data platforms, cloud database services, and NoSQL databases.

📌 Application Steps

To apply for this Sr. Database Engineer II, AVP role at State Street:

1. Customize Your Portfolio: Tailor your portfolio to highlight your experience with database design, development, and optimization, as well as your experience with distributed data platforms, cloud database services, and NoSQL databases. Ensure that your portfolio demonstrates your ability to deliver high-performance, scalable, and highly available database solutions.
2. Optimize Your Resume: Highlight your relevant experience with database engineering, as well as your experience with Agile development methodologies, cross-functional team collaboration, and database administration. Include specific examples of your work that demonstrate your technical skills and achievements in the field.
3. Prepare for Technical Assessment: Brush up on your SQL performance tuning techniques, database security best practices, and problem-solving skills. Familiarize yourself with the technology stack and be prepared to discuss your approach to database design, development, and optimization.
4. Research the Company: Learn about State Street's company culture, values, and mission. Understand the company's role in the financial services industry and the impact of the Sr. Database Engineer II, AVP role on the organization's success. Prepare thoughtful questions to ask during the interview process to demonstrate your interest in the role and the company.

⚠️ Important Notice: This enhanced job description includes AI-generated insights and web development/server administration industry-standard assumptions. All details should be verified directly with the hiring organization before making application decisions.