SQL Database Engineer

New York, New York, United States

Share with: Facebook LinkedIn Twitter Send to a friend

We are seeking a talented engineer in the Database Engineering team at Two Sigma. The Database Engineering team operates the most critical database systems which are integrated tightly with Two Sigma’s highly parallel research environment and core live trading systems. We are also developing new database services and solutions to further scale our research platform. As the Database Engineer, you will be charged with all aspects of the development and operations of database systems to enable high availability, continuous scaling and performance improvement.

Key Responsibilities Include:

  • Working closely with software engineering groups on schema, index, and query design to support application development

  • Leading performance monitoring and fine tuning for optimal performance

  • Collaborating with financial experts and software engineers to design data models

  • Owning a wide variety of technical projects using a combination of Windows and UNIX based applications, including Microsoft SQL Server & PostgreSQL, as well as several proprietary in-house file and database systems distributed over multiple sites.

Requirements Include:

  • A bachelor’s degree with minimum of 5 years in operating and supporting multiple relational databases (MS SQL Server, PostgreSQL, etc.) for performance critical and highly available systems

  • Strong system automation experience, operational excellence and best practice in database systems

  • Solid ability to program (structured and OO) with scripting languages (Python and/or Powershell) on Linux/Windows. Experience with Java, C, C++ is a plus

  • Experience planning and implementing backup and recovery procedures

  • Ability to work with data manipulation and database query languages (e.g., T-SQL, PL/SQL)

  • Ability to input and understand database identifiers in complex distributed environments, determine the optimum values of the physical database parameters, create database management system documentation, and automate processes already in place

  • Demonstrated success producing database wrappers and stored procedures is also desired

  • Knowledge of High Availability (HA) options for MSSQL Server and PostgreSQL

Interested in working at Two Sigma? Explore careers.