Sr Oracle Developer

Raymond James • Saint Petersburg, FL

94d

About The Position

The individual in this senior developer role will enable the AMS technology team to develop the database-centric solutions that are required to support the improvements to the AMS systems and business processes that have been included in the AMS Modernization roadmap.

Requirements

• Experience with Oracle SQL including analytics and windowing functions, dynamic SQL and set operations.
• Experience with PL/SQL development including packages, procedures, functions, pipelined table functions and other database objects.
• Oracle SQL performance tuning using profiling tools, optimizer hints, query refactoring, table partitioning, and index design (including index-organized tables).
• Understanding of Oracle's automatic and manual locking mechanisms.
• Experience with developing custom exception handling in PL/SQL.
• Experience with Oracle APEX for low-code development.
• Experience with Unix and Shell scripting.
• Experience with job scheduler tools such as BMC Control-M or Autosys.
• Proven track record working in both waterfall and agile SDLC frameworks.
• Knowledge of the Financial Services industry including middle and back-office functions.
• Experience in collaborating with business counterparts to understand detailed requirements.
• Excellent verbal and written communication skills.

Nice To Haves

• Experience with SQL Server and MS Access.
• Experience with Oracle Data Integrator (ODI) for ETL.
• Experience with web application development using java and Angular.
• Experience with cloud technologies like AWS.
• Understanding of data governance frameworks.

Responsibilities

• Create and optimize complex queries, stored procedures, and database schemas.
• Design and develop low-code applications using Oracle APEX to support business users.
• Analyze and optimize database performance, ensuring efficient data retrieval and storage.
• Develop and maintain CI/CD pipelines using Jenkins and other tools to automate the build, test, and deployment processes.
• Create and maintain comprehensive technical documentation for all projects.
• Collaborate with both the technology team and our Business Partners throughout the entire development lifecycle, from requirements gathering through deployment and level 2 support, ensuring high-quality deliverables.

Benefits

• Development opportunities.
• Enriching networking groups.
• Prioritizing diversity and inclusion.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: Bachelor's degree
• Number of Employees: 1-10 employees