Senior Database Engineer
About The Position
Senior Database Engineer (State Street Bank and Trust Company; Boston, Massachusetts): Will contribute to the development and certification of Azure DB and Managed Instance of State Street's Charles River Investment Management Solution (CRIMS) and enhancement and maintenance of CRIMS schema and database infrastructure as a technical leader on the DBA team. The Senior Database Engineer will provide engineering troubleshooting assistance to customer support teams and other development teams within Charles River. Specific duties of the position include: 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; and provide mentoring to technical staff of all levels. Telecommuting from within the U.S. permitted pursuant to company policy.
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 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 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
Responsibilities
- 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
Benefits
- 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
- eligibility for certain tax advantaged savings plans
- inclusive development opportunities
- flexible work-life support
- paid volunteer days
- vibrant employee networks
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Senior
