Senior Database Engineer

State Street is a global institution that helps investors manage risk and drive performance. They are seeking a Senior Database Engineer to lead the development and maintenance of database solutions for their Charles River Investment Management Solution, focusing on Azure DB and RDBMS technologies.

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 conforming to RDBMS best practices generally and RDBMS vendor implementations specifically
• Provide thought leadership on the topic of database technologies and data modeling within and beyond the team’s scope of responsibility
• Design, implement and maintain RDBMS infrastructure for the support of all teams within the R&D group
• Design, implement (or acquire) and maintain tooling used by CRD’s 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 as well as keeping abreast of emerging technologies impactful to CRDs business
• Write unit and automation tests to ensure a high quality end product
• Conduct manual tests to ensure a high quality end product
• Provide expert level troubleshooting on large, mission critical client implementations
• Be available outside of normal office hours to troubleshoot and resolve critical RDMBS issues for customers and the CRD R&D team
• Actively assist team leaders in the agile software development process by adhering to and advancing the CRD scrum methodology including attending all daily standups, sprint planning, backlog grooming, and retrospectives
• Plan and coordinate cross-team activities groups to complete assignments
• Manage large DBA projects, plan schedules, meet deadlines
• Provide expert guidance and critical analysis of proposed changes during code reviews
• Advise senior management on technical strategy
• Provide mentoring to technical staff of all levels

Requirements:

• Bachelor's degree (or foreign education equivalent) in Computer Science, Computer Engineering or 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 working with an Agile development methodology
• Demonstrated experience with performance optimization of database solutions
• 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 strong 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