Who we are looking for

　　Leading technical contributor to the enhancement and maintenance of one or more Charles River IMS modules or components of an agile scrum team. Provide engineering troubleshooting assistance to customer support teams and other development teams within Charles River.

　　Why this role is important to us

　　The team you will be joining is a part of Charles River Development (or CRD), that became a part of State Street in 2018. CRD helps create enterprise investment management software solutions for large institutions in the areas of institutional investment, wealth management and hedge funds. Together we have created the first open front-to-back platform - State Street Alpha that was launched in 2019.

　　Join us if delivering next generation infrastructure, using emerging technologies like AI and Blockchain sounds like a challenge you are up for.

　　What you will be responsible for

　　• Database Design and Architecture

　　o Design and implement scalable, performant and highly available distributed database solutions

　　o Collaborate with peers across scrum teams to design and deliver database design conforming to database best practices and meet business and application requirements

　　o Create and maintain comprehensive documentation of database design, data models, configurations, and processes

　　• Database Development and optimization

　　o Write complex SQL queries, stored procedures, and script to support application development

　　o Optimize performance through indexing, SQL query optimization, and other database tuning techniques

　　o Monitor database performance metrics, analyze and identify bottlenecks, and recommend short-term and long-term solutions

　　o Collaborate with engineering teams to define performance test strategy, and develop toolsets to generate synthetic datasets for effective and repeatable performance tests

　　o Implement and manage database security, including access controls, encryption, and auditing

　　• Database Administration

　　o Perform database installation, configuration, and upgrades

　　o Monitor and maintain database health to ensure data integrity, availability, and disaster recovery

　　o Collaborate with production DBA team to troubleshoot and resolve database production issue in timely manner

　　• Collaboration and Leadership

　　o Provide thought leadership on the topic of database technologies and data modeling within and beyond the team's scope of responsibility

　　o Collaborate with cross-functional teams, including engineering, SaaS Operation, support, and implementation, to ensure seamless integration of database systems

　　o Provide technical mentorship to junior database engineers

　　What we value

　　• Extensive hands-on experience in RDBMS and distributed data platforms as a database developer or DBA

　　• 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

　　• Experience in NoSQL databases is preferred

　　• Experience with cloud database services such as Azure SQL Database or AWS RDS is a plus

　　• Programming experience in Java, C++, C#, JDBC, Sprint boot, and Microservices is a plus

　　• Experience with developing applications for the financial markets is a plus (Fixed Income, Trading, FX, Risk, Portfolio/Wealth Management, Market Data, FIX, etc.)

　　Education & Preferred Qualifications

　　• 5 to 7+ years of professional software engineering experience with enterprise applications backed with RDBMS databases or Snowflake

　　• Bachelor's degree in computer science, Information Technology, or a related field. Master's degree is a plus

　　• Expert experience with relational databases (RDBMS), hardware sizing and configuration, operating systems, scripting, and database technologies

　　• 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) with the ability to convey complex technical concepts to both technical and non-technical stakeholders

　　• A minimum of 5 years working with an Agile development methodology strongly desired

　　Salary Range:

　　$110,000 - $185,000 Annual

　　The range quoted above applies to the role in the primary location specified. If the candidate would ultimately work outside of the primary location above, the applicable range could differ.