Custom Software Engineer

Project Role :Custom Software Engineer


Project Role Description :Develop custom software solutions to design, code, and enhance components across systems or applications. Use modern frameworks and agile practices to deliver scalable, high-performing solutions tailored to specific business needs.
Must have skills :Oracle Procedural Language Extensions to SQL (PLSQL)

Good to have skills :NA
Minimum 5 year(s) of experience is required

Educational Qualification :15 years full time education

Summary:
A KDB+ / q-Language Developer is responsible for designing, developing, and maintaining high-performance time-series databases and real-time data processing systems. The role involves building q-based applications, optimizing queries, and ensuring low-latency ingestion of large financial datasets. The developer supports trading, analytics, and reporting teams by creating efficient data pipelines, real-time feeds, and analytical solutions. Key responsibilities include system performance tuning, production support, and integration with upstream/downstream platforms. The role requires strong analytical skills, proficiency in q-language, deep understanding of KDB+ architecture, and experience working in fast-paced financial environments.

Roles Responsibilities:
- Expected to be an SME.
- Design, develop, and maintain KDB+ databases
Create schema, tables, partitions, and data pipelines.
Implement reliable ingestion processes for real-time and historical data.
- Develop q-language scripts and applications
Build q functions, queries, APIs, and utilities for performance-sensitive use cases.
Optimize scripts for speed, memory usage, and scalability.
- Build analytics and reporting solutions
Create time-series analytics, dashboards, and query interfaces for end-users.
Support quants, traders, and data analysts with custom analytics.
- Troubleshoot slow queries, memory issues, and process bottlenecks.
Optimize HDB (Historical Database) and RDB (Real-time Database) performance.
- Documentation collaboration
Maintain documentation for scripts, design decisions, and architecture.
Collaborate with quants, traders, business users, and DevOps teams.
- Data quality, validation, and monitoring
Ensure accuracy, consistency, and completeness of large financial datasets.
Automate data checks and monitoring alerts.
- Engage with multiple teams and contribute on key decisions.
- Provide solutions to problems for their immediate team and across multiple teams.
- Facilitate knowledge sharing sessions to enhance team capabilities.
- Mentor junior team members to foster their professional growth.


Professional Technical Skills:

- Strong expertise in KDB+ database architecture (RDB, HDB, IDB).
- Advanced proficiency in q-language (vector programming, functional programming).
- Hands on Unix
- Strong experience with time-series data, tick data, and real-time processing.
- Hands-on with tick architecture, tickerplant, and real-time subscription systems.
- Understanding of memory-mapped files, partitions, and table schemas.
- Uses Q language which is an expressive functional language.
- Relational dB + Column-Oriented Data Storage which is Ideal for time-series operations such as
computing rolling averages, joins, and group-by on billions of records.
- In-Memory and On-Disk
kdb+tick:A real-time, in-memory streaming database that captures and analyzes live data.
Historical database (HDB):Persistent storage for historical data, usually on disk.
You can combine query both live and historical via a single interface (called kdb+ TP gateway
process )



Additional Information:

- Knowledge of capital markets, trading, derivatives, fixed income, FX.
- Exposure to cloud environments (AWS/Azure/GCP) with KDB integrations.
- Experience with data visualization tools (QStudio, KX Dashboards, Grafana)
- Minimum 15 years of education is required
Qualification 15 years full time education