Lead the design, development, and performance optimization of Oracle-based systems supporting asset management operations including portfolio accounting, performance reporting, and trade lifecycle automation. Own end-to-end delivery for enterprise applications across Oracle environments, from requirement gathering through development, testing, deployment, and support. Apply advanced Oracle SQL and PL/SQL techniques, including set operations, analytics and windowing functions, dynamic SQL, table functions, and complex logic patterns. Lead performance tuning using Oracle profiling tools, optimizer hints, query refactoring, table partitioning, and advanced index strategies including index-organized tables. Architect and maintain OLTP, OLAP, data mart, and data warehouse solutions tailored to financial services and investment operations needs. Design solutions for full trade lifecycle, including reference data mastering, tax lot accounting, cost basis processing, and performance measurement. Oversee development of ETL pipelines and data transformation processes, bridging legacy and enterprise platforms. Prototype and deliver internal tools and applications using Oracle APEX. Provide senior-level production support, leading root cause analysis and incident resolution for high-availability systems. Interact with business leaders and technical teams to develop detailed requirements and propose technical solutions to address process deficiencies and pain points, leading to actionable, scalable system designs. Manage complex projects across cross-functional teams, budgets, and timelines while also mentoring team members and leading solution reviews. Lead development and integration of a consolidated Transaction Manager platform to standardize trade ingestion from multiple Order Management Systems (OMS) and FX sources, routing transactions to downstream systems for accounting, SWIFT processing, and reconciliation. Ensure data integrity and compliance in core asset management services such as trade execution, shadow accounting, portfolio cash management, and regulatory reporting. Support broader technology modernization initiatives involving integration with third party vendors, internal reporting frameworks, and data governance policies. Utilize experience with supporting technologies, including Java, used in the development of internal tools and process enhancements.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
Job Type
Full-time
Career Level
Mid Level