Oracle PL/SQL Developer (Only W2)

*Location: Plano, TX and Jersey City, NJ* We have *Oracle PL/SQL Developer openings* This is hands-on *Oracle PL/SQL development for Trade Surveillance, complex packages, procedures, functions, triggers, plus Actimize AIS knowledge* is not preferred. *10+ years hands-on dev experience* needed. *Daily Responsibilities / Priorities* * 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 * Support alert generation frameworks and case management data structures * Ensure data lineage, traceability, and auditability of trade data *Regular Points of Contact* * Enterprise Risk & Finance Technology team * Business Analysts * Global Compliance & Operational Risk partners * Audit and Regulatory stakeholders *Client Interaction* * No external client interaction * Regular engagement with internal business and compliance stakeholders 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 What Project They Are Working On * Enterprise trade surveillance and compliance applications within Enterprise Risk & Finance Technology * Regulatory driven initiatives delivered through the Oracle DB and CSDR platform * Surveillance and monitoring solutions covering Front Office and Global Markets activity Selling Points * High impact role supporting regulatory compliance and risk reduction * Strong ownership and visibility across senior technology and compliance stakeholders * Opportunity to work on complex datasets, surveillance logic. * Handson senior developer role with end-to-end accountability Hard Skills * 10+ years of hands-on software development experience * Strong, production level Oracle PLSQL * 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 Characteristics of a Top Performer * Lead design discussions and document design details * Partner with data engineers, architects, compliance, and business stakeholders * Drive best practices for database development, code quality, and documentation * Contribute to strategic initiatives (e.g., platform modernization, surveillance re-write programs) * Comfortable working in fast paced, regulatory driven environments * Produces high-quality, well tested, and scalable code Specific Industry Terms Useful for the Search * Trade Surveillance * Market Misconduct * Front Running * Compliance Technology * Global Markets * Regulatory Controls * Enterprise Risk Technology * Surveillance Controls Pay: $60.00 - $68.00 per hour Experience: * Strong, production level Oracle PLSQL : 10 years (Required) * relational and object databases: 10 years (Required) * Oracle PL/SQL development : 10 years (Required) Work Location: In person