Oracle PL/SQL Developer

Job Summary

Enterprise trade surveillance and compliance applications within Enterprise Risk & Finance Technology, Jersey City, New Jersey. Job type: Contract. Salary: $54.00 - 64.62 per hour. Work hours: 9am to 5pm. Education: Bachelors.

Responsibilities

• Design, develop, and maintain complex PL/SQL packages, procedures, functions, and triggers for trade data processing
• Build scalable data pipelines to support Trade Surveillance use cases (e.g., market abuse detection, alerts generation)
• Develop and optimize high-volume batch processing jobs
• Write complex SQL queries for data extraction, reconciliation, and reporting
• Collaborate with compliance and surveillance teams to translate surveillance scenarios into technical solutions

Qualifications

• Design, develop, and maintain complex PL/SQL packages, procedures, functions, and triggers for trade data processing
• Build scalable data pipelines to support Trade Surveillance use cases (e.g., market abuse detection, alerts generation)
• Develop and optimize high-volume batch processing jobs
• Write complex SQL queries for data extraction, reconciliation, and reporting
• Collaborate with compliance and surveillance teams to translate surveillance scenarios into technical solutions

Example Projects & Expected End Result

• Build and enhance trade surveillance Data Quality controls
• Investigate and remediate data quality issues impacting surveillance outcomes
• Review and understand the code implemented in Actimize AIS, then re-engineer the underlying logic into PL/SQL
• Perform query tuning, indexing, and execution plan optimization for large datasets
• Deliver regulator ready solutions with measurable improvements in alert quality, coverage, and control effectiveness

Hard Skills

• 10+ years of hands on software development experience
• Strong, production level Oracle PLSQL and Actimize AIS knowledge
• Experience with relational and object databases
• Advanced SQL skills, including performance tuning and strong understanding of Database internals
• Solid understanding of SDLC, CI/CD, and version control

Soft Skills

• Strong analytical and problem-solving skills
• High attention to data accuracy and control effectiveness
• Ability to manage multiple priorities in a regulatory-driven environment
• Excellent communication skills with both technical and business stakeholders
• Proactive mindset with ownership and accountability

Preferred Skills / Experience

• Working knowledge of Python or Shell scripting for automation
• Familiarity with trade lifecycle (orders, executions, etc)
• Exposure to Trade Surveillance, Market Misconduct, Global Markets Compliance
• Exposure to Actimize AIS platform

Pay Offered to a Successful Candidate

Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc.

Benefits Package

• Medical, prescription, dental, vision, AD&D, and life insurance offerings
• Short-term disability
• A 401K plan (all benefits are based on eligibility)

Equal Opportunity Employer

At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com.