Senior Database Engineer

Anywhere
Posted 4 years ago
This position has been filled

Website Technical Options

Senior Database Engineer will be responsible techn

Senior Database Engineer will be responsible technology selection and recommendation, development of stored procedures, data cleansing, database maintenance, performance tuning, and monitoring of database that are used by a critical trading system. You will also be actively involved in the ongoing enhancement and automation of system processes.

Responsibilities:

Perform logical database design review and physical database implementations.

Design/write SQL stored procedures used for core trading system software

Design relationships and constraints and develop monitoring to ensure referential integrity and data validity in production databases.

Perform database support and performance tuning

Troubleshoot production issues related to data and SQL code

Manage database code consistency between dev, QA, and production for multiple regions

Able to gather, understand, and suggest requirements for database usage for core development groups

Work with software developers, quantitative research, app support, and QA on data related development needs

Provide reporting services and Data Warehouse design/support

Requirements:

Experience with Data Warehousing

Experience with other DB technologies (Postgres, Oracle, InfluxDB, MongoDB, etc.)

At least 5 years of professional experience with Microsoft SQL

Must have T-SQL experience

Experience with Trading Securities data (futures, options, equities, currencies, corp actions, etc.) is a plus

PL/SQL experience is a plus