Database Engineer, hybrid, Assistant Vice President

Charles River Development (CRD) is the FinTech division of State Street.  Together with State Street’s Middle and Back-office services, Charles River’s cloud-based Front Office technology forms the foundation of the State Street Alpha® Platform, the first front-to-back solution in the industry. Our vision is to be the world’s leading investment platform, shaping the future of the industry and driving new levels of technology-led innovation, resiliency, efficiency and growth for investors and the people they serve. CRD Engineering organization is innovating and transforming the platform by moving away from monolithic software to utilising next generation cloud-based technology that leverages Microsoft Azure, Kafka, Snowflake, etc. As a digital innovation leader, we invest into our solutions, processes, systems, and talent.

Join us as a leading technical contributor to the enhancement and maintenance of one or more Charles River IMS modules or components of an agile scrum team. Be a part of strategic development projects and contribute to mission-critical optimization, resiliency, and performance improvement work for our clients. Collaborate with engineering, product, QA and sales teams to drive the platform innovation and modernization. This role requires a hybrid work model with at least 3 days in the office per week.

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 design conforming to database best practices and 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 script 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 to generate synthetic datasets for effective and repeatable performance tests Implement and manage database security, including access controls, encryption, and auditing Database Administration Collaborate with production DBA team to troubleshoot and resolve database production issue in timely manner Monitor and maintain database health to ensure data integrity, availability, and disaster recovery Perform database installation, configuration, and upgrades in lower environments 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 Qualifications Recommended 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.

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 Strong analytical and problem-solving skills with ability to troubleshoot and resolve database related issues Proficiency in SQL performance tuning in MS SQL Server, Oracle, or Snowflake 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)