Oracle PL/SQL and kdb+/q

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.
• 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.

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.