Oracle PL / SQL and kdb+ / q

Job Description :

We are seeking a highly skilled developer with strong expertise in Oracle PL / SQL and kdb+ / q to design, develop, and optimize high-performance data solutions. The ideal candidate will have experience working with large datasets, time-series data, and real-time analytics, preferably in the financial services or trading industry.

Key Responsibilities

Design, develop, and maintain PL / SQL stored procedures, functions, triggers, and packages for data processing and reporting.

Develop and optimize kdb+ / q scripts for time-series data ingestion, transformation, and querying.

Integrate Oracle RDBMS with kdb+ for hybrid data solutions.

Work closely with business analysts, quants, and traders to understand requirements and deliver efficient solutions.

Optimize database performance, including query tuning and indexing strategies.

Implement data quality checks, validation, and reconciliation processes.

Support production systems, troubleshoot issues, and ensure high availability.

Document technical designs, workflows, and best practices.

Required Skills & Experience

Strong PL / SQL skills :

Advanced SQL queries, stored procedures, functions, triggers, and packages.

Performance tuning and query optimization.

KDB+ / q expertise :

Writing efficient q queries and functions.

Understanding of time-series data structures and tick data processing.

Experience with data modeling for both relational and time-series databases.

Strong understanding of database performance tuning and memory optimization.

Familiarity with UNIX / Linux environments and shell scripting.

Experience in financial markets data (e.g., equities, FX, fixed income) is a plus.

Strong problem-solving skills and ability to work in a fast-paced environment.

Preferred Qualifications

Bachelor's or Master's degree in Computer Science, Engineering, Mathematics, or related field.

Experience with real-time market data feeds (e.g., Bloomberg, Reuters, FIX).

Knowledge of Python or Java for integration with kdb+ and Oracle.

Exposure to big data or streaming platforms (Kafka, Spark) is an advantage.

Example Tech Stack

Databases : Oracle 12c / 19c, kdb+ / q

Languages : PL / SQL, q, SQL, Python (optional)

OS : Linux / Unix

Tools : Git, Jira, Confluence, CI / CD pipelines