What are the responsibilities and job description for the Oracle PL/SQL & kdb+/q Developer position at Excelon Solutions?
Role: Oracle PL/SQL & kdb /q Developer
Location: Jersey City, NJ (Hybrid – 3 days onsite)
Mode: Contract
Job Description
We are looking for a highly skilled Oracle PL/SQL and kdb /q Developer to design, develop, and optimize high-performance data solutions. The ideal candidate will have hands-on experience with large datasets, time-series data, and real-time analytics, preferably within the financial services or trading domain.
Key Responsibilities
- Design, develop, and maintain Oracle PL/SQL stored procedures, functions, triggers, and packages.
- Develop and optimize kdb /q scripts for time-series data ingestion, transformation, and querying.
- Integrate Oracle RDBMS with kdb to support hybrid data solutions.
- Collaborate with business analysts, quants, and traders to understand requirements and deliver efficient solutions.
- Perform database performance tuning, including query optimization and indexing strategies.
- Implement data quality checks, validation, and reconciliation processes.
- Provide production support, troubleshoot issues, and ensure high availability.
- Create and maintain technical documentation and best practices.
Required Skills & Experience
Oracle PL/SQL
- Strong experience with advanced SQL queries, stored procedures, functions, triggers, and packages.
- Expertise in performance tuning and query optimization.
kdb /q
- Hands-on experience writing efficient q queries and functions.
- Strong understanding of time-series data models and tick data processing.
- Experience designing data models for relational and time-series databases.
- Knowledge of memory and performance optimization in kdb .
Additional Skills
- Strong experience in Linux/Unix environments and shell scripting.
- Exposure to financial market data (Equities, FX, Fixed Income) is a plus.
- Excellent 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 (Bloomberg, Reuters, FIX).
- Knowledge of Python or Java for integration with Oracle and kdb .
- Exposure to Kafka, Spark, or streaming platforms is an advantage.
Tech Stack
- Databases: Oracle 12c/19c, kdb /q
- Languages: PL/SQL, q, SQL, Python (optional)
- OS: Linux/Unix
- Tools: Git, Jira, Confluence, CI/CD