Oracle PLSQL and kdb+q

Jersey, NJ - USA

Monthly Salary: Not Disclosed

Posted on: 6 hours ago

Vacancies: 1 Vacancy

Job Summary

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

Bachelors or Masters 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

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