S

State Street

Holds assets for institutions and runs index funds

Senior Database Engineer

Database AdministrationConfirmed live in the last 24 hours
Full-time

About the Job

Requirements

  • 10+ years of professional software engineering experience with enterprise applications backed by relational database management system databases.
  • 5+ years of experience as a Database Architect or in a similar role supporting enterprise applications.
  • Extensive hands-on experience in relational database management systems and distributed data platforms as a database developer.
  • Proficiency in SQL performance tuning in Microsoft SQL Server.

Responsibilities

  • Design and implement scalable, performant, and highly available distributed database solutions.
  • Collaborate with peers across scrum teams to design and deliver database designs that conform to database best practices and meet business and application requirements.
  • Create and maintain comprehensive documentation of database designs, data models, configurations, and processes.
  • Write complex SQL queries, stored procedures, and scripts 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.
  • Collaborate with the production database administration team to troubleshoot and resolve database production issues in a timely manner.
  • Monitor and maintain database health to ensure data integrity, availability, and disaster recovery.
  • Perform database installation, configuration, and upgrades in lower environments.
  • Provide thought leadership on database technologies and data modeling within and beyond the team's scope of responsibility.
  • Collaborate with cross-functional teams, including engineering, SaaS operations, support, and implementation, to ensure seamless integration of database systems.
  • Provide technical mentorship to junior database engineers.

Desired Qualifications

  • Expert experience with hardware sizing and configuration, operating systems, scripting, and database technologies.
  • Experience in NoSQL databases.
  • Experience with cloud database services such as Azure SQL Database.
  • A minimum of 7 years working with an Agile development methodology.
  • Experience developing applications for financial markets, including Fixed Income, Trading, FX, Risk, Portfolio/Wealth Management, Market Data, or FIX.

About the Company

State Street

Holds assets for institutions and runs index funds

State Street holds and services investments for pension funds, insurers, fund companies, and other large institutions, and it also runs index funds through State Street Investment Management. It launched the first US-listed exchange-traded fund, the SPDR S&P 500 ETF Trust, in 1993, and in 1924 it became custodian of the first US mutual fund. As a custody bank, it safekeeps clients' stocks and bonds, completes their trades, calculates what their funds are worth, and lends their securities to other investors. It earns fees on the assets it services and manages, plus income from currency trading and from interest on client cash. State Street traces its roots to a bank chartered in 1792 and is based in Boston, Massachusetts.

Company size
10,001+
Company stage
IPO
Headquarters
Boston, MA
Founded
1792

Recently Posted Jobs

Explore more opportunities at State Street

See more jobs