SQL Developer

Job Title: SQL Developer Capital Markets & Back-Office Systems (MS-SQL)

Experience Required:

Minimum 5 years of hands-on experience in MS-SQL Server

Job Location:

Borivali, Mumbai

Job Type:

Full-time

About Secmark:

Secmark Consultancy Limited is a BSE and NSE listed company providing comprehensive back-office and compliance software solutions to stock brokers and depository participants across India. Serving over 200+ broking clients , Secmarks systems are widely trusted for their reliability, accuracy, and regulatory compliance in the capital markets ecosystem.

Job Summary:

We are seeking an experienced SQL Developer to work on mission-critical back-office and compliance applications used by stock brokers. The role involves extensive handling of complex transactional, reporting, and regulatory data , including advanced processing of JSON and XML exchanged with Exchanges, Depositories, and third-party systems.

The ideal candidate will have strong expertise in MS-SQL Server , data transformation, and performance-optimized reporting in high-volume capital markets environments .

Key Responsibilities:

• Design, develop, and maintain complex MS-SQL stored procedures, functions, and views supporting:
• Trading back-office operations
• Client accounting
• Settlement and reconciliation
• Regulatory and compliance reporting
• Read, parse, validate, and transform JSON and XML payloads received from:
• Stock Exchanges (NSE/BSE)
• Clearing Corporations
• Depositories (NSDL/CDSL)
• Integrated third-party applications
• Design and manage nested JSON/XML structures , including masterchild (parentchild) relationships such as:
• Client Accounts Transactions
• Trades Obligations Settlements
• Convert relational database structures into JSON/XML formats and vice-versa for system integrations and reporting.
• Write and optimize dynamic SQL to handle variable JSON/XML schemas driven by regulatory or exchange-mandated changes.
• Develop and manage complex operational and regulatory reports using:
• Advanced SQL queries
• Temporary tables
• Cursors
• CTEs
• Optimize database performance for large data volumes , end-of-day (EOD) processing, and time-critical reports.
• Ensure data accuracy, integrity, and auditability , critical to capital markets operations.
• Work closely with functional, compliance, and support teams to translate regulatory requirements into system logic.
• Assist in troubleshooting production issues and providing root-cause analysis.

Required Skills & Qualifications:

• Minimum 5 years of hands-on experience in MS-SQL Server development .
• Strong expertise in:
• JSON processing (OPENJSON, FOR JSON, etc.)
• XML processing (nodes(), value(), query(), FOR XML)
• Proven experience handling complex hierarchical and nested data structures .
• Strong understanding of relational database design , normalization, and data integrity.
• Extensive experience in dynamic SQL and schema-driven data processing.
• Advanced knowledge of:
• Query optimization
• Indexing strategies
• Execution plan analysis
• Experience working with large transactional datasets and reporting systems.
• Strong analytical, problem-solving, and documentation skills.

Preferred / Good-to-Have:

• Prior experience in:
• Stock broker back-office systems
• Capital markets operations
• Exchange / Depository integrations
• Understanding of:
• Trade lifecycle
• Settlement processes
• Client accounting and ledger management
• Regulatory reporting requirements
• Exposure to compliance-oriented systems where accuracy and audit trails are critical.

What Secmark Offers:

• Opportunity to work on industry-leading capital markets software
• Exposure to exchange-driven and regulatory-driven system design
• Stable and professionally managed organization
• Long-term career growth in a niche domain