SQL Database Engineer
New York, New York, United States
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.
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