Database Developer (PostgreSQL)

FlexTrade Systems is a global leader in high-performance multi-asset execution management and order management systems across equities, fixed income, foreign exchange, futures, and options. FlexTrade is internationally recognized for introducing FlexTRADER®, the world’s first broker-neutral execution management trading system, enabling clients to control and customize execution workflows while maintaining the confidentiality of their trading strategies.

At FlexTrade, we hold our values close to our hearts, with pride and gratitude, as they guide us in everything that we do. We are dedicated to giving our clients a competitive edge, taking ownership of our responsibilities, being flexible to adapt to an ever-changing environment and technology, bringing integrity to every interaction, and continuing to improve, grow together, and collaborate as one team. All of these, while having fun, truly make FlexTrade a wonderful place to work.

The Product:

FlexTCA is our Post & Pre-Trade transaction cost analysis and execution quality management solution offering historical and real-time analytics for trading portfolios and single securities across global equities, FX, futures, and fixed income. FlexTCA is used by investment managers and brokers to analyze, evaluate, and improve trader, algo, broker, and venue performance. The product includes an intuitive and flexible web interface for data visualization, exploration, and analysis.

CORE RESPONSIBILITIES:

• Design, develop, and maintain PostgreSQL database objects supporting FlexTCA data processing, analytics, and reporting workflows.

• Assist with schema design, schema evolution, indexing strategy, table structure, views, materialized views, and other database optimization efforts.

• Support the buildout of new product capabilities requiring PostgreSQL-backed data structures, including note-taking workflows, audit-style data capture, optimized reporting tables, and other schema enhancements.

• Write, debug, and optimize SQL used for data warehouse integrity checks, report validation, reconciliation, diagnostics, and production support.

• Contribute to the design, development, and maintenance of order, execution, market data, benchmark, and time-series-related FlexTCA datasets.

• Create and maintain ETL and data-load workflows for ingesting, validating, and organizing trading analytics data across development, QA, and production environments.

• Create, run, troubleshoot, and optimize Elasticube builds, data models, dashboard datasets, and related reporting dependencies.

• Support production, QA, and development database environments, including load validation, data integrity checks, operational diagnostics, and issue triage on Unix/Linux systems.

• Participate in Postgres performance tuning, including query-plan review, indexing, partitioning, vacuum/analyze strategy, materialized view refresh design, and schema-level optimization.

• Assist with database onboarding and deployment workflows for new clients, including database creation, schema setup, deployment scripts, credentials, validation checks, and downstream reporting connectivity.

• Develop Python and shell-based automation to improve the repeatability of database deployment, validation, monitoring, maintenance, and support tasks.

• Investigate production data issues such as missing records, stale data, inconsistent identifiers, failed loads, slow queries, or data mismatches across related tables.

• Partner with analytics, data engineering, reporting, and product teams to ensure the PostgreSQL model supports FlexTCA reporting, diagnostics, and future product needs.

• Create and maintain documentation for database setup, schema changes, materialized views, data-load procedures, production checks, and troubleshooting playbooks.