Oracle PL​/SQL and kdb​/q

Position: Oracle PL/SQL and kdb+/q
Job :
Jersey City, NJSalary: USD 45-50 / Hourly (C2C)

Employment Type:

1099, C2C, W-2

Company: SRI Tech Solutions Role:
Oracle PL/SQL and kdb+/q

Location:

Jersey City, NJ (3 days work from office)

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 SRI Tech Solutions is an equal opportunity employer and does not discriminate on the basis of race, color, gender, religion, age, sexual orientation, national origin or citizenship status or ethnic origin, disability, marital status, veteran status, or any other occupationally irrelevant criteria.