Senior Database Engineer

Senior Database Engineer – Boston, Massachusetts (State Street Bank & Trust Company) Senior Database Engineer responsible for the development, certification, and maintenance of Azure Database and Managed Instance for State Street’s Charles River Investment Management Solution (CRIMS). The role serves as a technical leader on the DBA team, providing engineering troubleshooting assistance to customer support and development teams. Responsibilities Work independently to analyze, design, develop, test, and debug large and complex software enhancements and solutions within Charles River’s business and technical problem domains, including modifications to core frameworks and other primary facilities critical to system operation. Design, prototype, and implement migration of existing on‑premise database solutions to Azure cloud. Collaborate with peers across scrum teams to design and deliver features that conform to general RDBMS best practices and vendor‑specific implementations. Provide thought leadership on database technologies and data modeling within and beyond the team’s scope of responsibility. Design, implement, and maintain RDBMS infrastructure to support all teams within the R&D group. Design, implement (or acquire) and maintain tooling used by the R&D group and customers to maintain the Charles River IMS schema. Lead efforts focused on analysis and tuning of RDBMS performance. Develop, test, debug, and implement software programs, applications, and projects using Transact‑SQL, PL/SQL, SQL, and C# or other related software engineering languages. Write unit and automation tests and conduct manual tests to ensure a high‑quality end product. Provide expert‑level troubleshooting on large, mission‑critical client implementations and be available outside normal office hours to resolve critical RDBMS issues for customers and the R&D team. Assist team leaders in the agile software development process by adhering to and advancing the scrum methodology, including daily stand‑ups, sprint planning, backlog grooming, and retrospectives. Plan and coordinate cross‑team activity groups to complete assignments; manage large DBA projects, plan schedules, and meet deadlines. Provide expert guidance and critical analysis of proposed changes during code reviews, advise senior management on technical strategy, and mentor technical staff of all levels. Qualifications Bachelor’s degree (or foreign education equivalent) in Computer Science, Computer Engineering, or a related technical field. 5+ years of progressively responsible professional software engineering experience with enterprise applications backed with relational databases. 3+ years of experience on Azure DB and/or Managed Instance. 3+ years of experience working with an Agile development methodology. Demonstrated experience with performance optimization of database solutions and strong knowledge of database development and tuning concepts and tools. Demonstrated authoritative experience with relational databases (RDBMS), hardware sizing and configuration, operating systems, scripting, and new/advanced database technologies. Demonstrated problem‑solving abilities involving multi‑tiered, high‑performance database applications. Proven ability to design and develop software solutions to business and technical problems of high complexity. Demonstrated outstanding written and verbal communication skills. Proven ability to work constructively with peers in a collaborative team environment. All experience can be gained concurrently. Salary Salary Range: $178,131 – $230,000 per year (primary location: Boston, Massachusetts). The range quoted above applies to the role in the primary location specified; it could differ for other locations. Benefits 401(k) retirement savings plan with company match. Insurance coverage including basic life, medical, dental, vision, long‑term disability, and other optional coverages. Paid‑time off including vacation, sick leave, short‑term disability, and family care responsibilities. Employee Assistance Program. Incentive compensation including eligibility for annual performance‑based awards. Eligibility for certain tax‑advantaged savings plans. EEO Statement An Equal Opportunity Employer (“EOE”). State Street considers 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, or other characteristics protected by applicable law. #J-18808-Ljbffr State Street