Senior Oracle PL/SQL Developer

Senior Oracle PL/SQL DeveloperThis is a high-impact, hands-on senior developer role supporting regulatory compliance and risk reduction initiatives. The position offers strong ownership and visibility across senior technology and compliance stakeholders. The successful candidate will work on complex datasets and surveillance logic with end-to-end accountability for delivering regulator-ready solutions.Key ResponsibilitiesDesign, 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, such as market abuse detection and alert 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.Build and enhance trade surveillance data quality controls and remediate issues impacting surveillance outcomes.Review, understand, and re-engineer logic from Actimize AIS into PL/SQL.Perform query tuning, indexing, and execution plan optimization for large datasets.Required QualificationsExperience: 10+ years of hands-on software development experience.Technical SkillsStrong, production-level knowledge of Oracle PL/SQL and Actimize AIS.Experience with relational and object databases.Advanced SQL skills, including performance tuning and a strong understanding of database internals.Solid understanding of SDLC, CI/CD, and version control.Soft SkillsStrong 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 QualificationsWorking knowledge of Python or Shell scripting for automation.Familiarity with the trade lifecycle (orders, executions, etc.).Exposure to Trade Surveillance, Market Misconduct, or Global Markets Compliance.Exposure to the Actimize AIS platform.