Summary:
Contribute to the enhancement and maintenance of the Charles River IMS schema and database infrastructure as a technical leader on the DBA team. Provide engineering troubleshooting assistance to customer support teams and other development teams within Charles River.
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 operationCollaborate with peers across scrum teams to design and deliver features conforming to RDBMS best practices generally and RDBMS vendor implementations specificallyProvide thought leadership on the topic of database technologies and data modeling within and beyond the team's scope of responsibilityDesign, 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 performanceDevelop, 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 businessWrite unit and automation tests to ensure a high quality end productConduct manual tests to ensure a high quality end productProvide expert level troubleshooting on large, mission critical client implementationsBe available outside of normal office hours to troubleshoot and resolve critical RDMBS issues for customers and the CRD R&D teamActively 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 retrospectivesPlan and coordinate cross-team activities groups to complete assignmentsManage large DBA projects, plan schedules, meet deadlinesProvide expert guidance and critical analysis of proposed changes during code reviewsAdvise senior management on technical strategyProvide mentoring to technical staff of all levels
Qualifications:
Education:
B.S. degree (or foreign education equivalent) in Computer Science, Engineering, Mathematics, and Physics or other technical course of study required. MS degree strongly preferred.
Experience:
A minimum of 15 years of progressively responsible professional software engineering experience with enterprise applications backed with relational databasesA minimum of 10 years of experience in financial services developing solutions for Portfolio Management, Trading, Compliance, Post-Trade, IBOR or Wealth Management is strongly desiredA minimum of 10 years of experience developing solutions within the Charles River software development teamAuthoritative experience with relational databases (RDBMS), hardware sizing and configuration, operating systems, scripting and new/advanced database technologiesDemonstrated problem solving abilities involving multi-tiered, high-performance database applicationsAble to design and develop software solutions to business and technical problems of high complexityOutstanding written and verbal communication skillsAble to work constructively with peers in a collaborative team environmentA minimum of 5 years working with an Agile development methodology