S

State Street

Holds assets for institutions and runs index funds

Database Engineer

Database AdministrationConfirmed live in the last 24 hours
Full-time

About the Job

Requirements

  • A B.S. degree or foreign education equivalent in Computer Science, Engineering, Mathematics, Physics, or another technical course of study is required; an M.S. is strongly preferred.
  • Five to seven or more years of professional software engineering experience with enterprise applications backed by RDBMS databases or Snowflake.
  • Extensive hands-on experience in RDBMS and distributed data platforms as a database developer.
  • Strong analytical and problem-solving skills to troubleshoot and resolve database-related issues.
  • Proficiency in SQL performance tuning in MS SQL Server, Oracle, or Snowflake.
  • A 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 verbal and written communication skills to convey complex technical concepts to technical and non-technical stakeholders.

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 design, 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 DBA 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 engineering, SaaS Operations, support, and implementation teams to ensure seamless integration of database systems.
  • Provide technical mentorship to junior database engineers.

Desired Qualifications

  • A minimum of five years working with an Agile development methodology is strongly desired.
  • Expert experience with hardware sizing and configuration, operating systems, scripting, and database technologies.
  • Experience with NoSQL databases.
  • Experience with cloud database services such as Azure SQL Database or AWS RDS.
  • 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