Senior Oracle PL/SQL Developer

Motion Recruitment; Remote; USD 100,000 - 130,000; Full time

Job summary

A leading technology solutions provider is seeking a Senior Oracle PL/SQL Developer to work remotely. The ideal candidate will have over 8 years of experience with Oracle server-side programming and a strong background in SQL and data analysis. Responsibilities include designing and maintaining complex PL/SQL code, performance tuning, and automating tasks using UNIX Shell scripts. This position offers various benefits including health insurance and a 401(k) retirement plan.

Benefits

Medical Insurance

Dental and Orthodontia Benefits

Health Savings Account (HSA)

401(k) Retirement Plan

Long-Term and Short-Term Disability Insurance

Qualifications

• 8+ years of experience as an Oracle PL/SQL Developer.
• Extensive experience with Oracle server-side programming and SQL.
• Experience with UNIX Shell scripting for database automation.

Responsibilities

• Design, develop, test, debug, and maintain PL/SQL code.
• Perform complex data analysis and modeling tasks.
• Document all development efforts and manage production issues.

Skills

Analytical thinking and problem-solving

Strong organizational and documentation abilities

Team-oriented with the ability to work independently

Customer-focused with a commitment to high-quality service delivery

Education

Bachelor's degree in Computer Science, Information Systems, or related

Tools

Oracle SQL

PL/SQL

UNIX Shell scripting

Job description

Job Title: Senior Oracle PL/SQL Developer

Location: Remote

Contract

Position Overview:

Our client, a leading global provider of technology enabled claims and risk management solutions, is immediately seeking a skilled Oracle PL/SQL Developer to join their team. The ideal candidate will possess extensive experience in Oracle server-side programming, including PL/SQL, SQL, and related technologies. This role requires a strong background in data analysis, performance tuning, and automation, with hands‑on experience in working with complex database components and optimizing query performance to support mission‑critical applications.

Key Responsibilities:

• Design, develop, test, debug, and maintain PL/SQL code including packages, procedures, functions, triggers, and views.
• Perform complex data analysis, modeling, and documentation tasks.
• Develop and maintain scheduled jobs using UNIX Shell scripts and Oracle Schedulers to automate batch processes.
• Create and optimize Materialized Views, Indexes, and Dynamic SQL for performance improvement.
• Implement and troubleshoot XML generation within PL/SQL components.
• Conduct SQL tuning and performance optimization using tools such as Oracle Explain Plan.
• Write and maintain PL/SQL Web Services, Stored Procedures, and work with Oracle AQ.
• Use object‑oriented PL/SQL programming including user‑defined types, cursors, records, and collections (arrays/queues).
• Handle error and exception management with robust debugging and logging practices.
• Import and process high volumes of data using external tables and other Oracle features.
• Collaborate with business analysts and end users to define functional and technical requirements.
• Document all development efforts and provide support for production issues.
• Support the development of applications across various platforms, including Windows client/server environments.
• Participate in code reviews and contribute to technical mentoring and growth of the team.

Required Qualifications:

• Bachelor's degree in Computer Science, Information Systems, or a related field.
• 8+ years of experience as an Oracle PL/SQL Developer.
• Extensive experience with Oracle server‑side programming, including SQL, SQL*Plus, PL/SQL Packages, Stored Procedures, Functions, Cursors, Triggers, Views, Materialized Views, Temporary Tables, Object‑Oriented PL/SQL, Job Scheduling, PL/SQL Web Services, Java Stored Procedures, and Oracle AQ.
• Experience with UNIX Shell scripting for database automation
• Proficiency with Dynamic SQL, Exception handling, and debugging
• Expertise in SQL performance tuning and optimization
• Strong skills in data analysis, modeling, development, testing, and documentation.
• Experience automating tasks using UNIX Shell scripts.
• Expertise in writing cursors, user‑defined object types, records, and tables for PL/SQL programming.
• Extensive experience with exception handling and debugging PL/SQL code.
• Knowledge of performance tuning, query optimization, and the use of Oracle Explain Plan.
• Strong skills in the creation of materialized views, indexes, and dynamic SQL statements for better performance.

Preferred Qualifications:

• Degree specialization in Information Systems or Computer Science.
• Experience with additional platforms such as .NET, Microsoft SQL Server, or Progress 4GL.
• Familiarity with insurance domain applications and regulatory reporting is a plus.
• Experience in mentoring junior developers and collaborating in cross‑functional teams.

Key Skills:

• Analytical thinking and problem‑solving
• Strong organizational and documentation abilities
• Team‑oriented with the ability to work independently
• Customer‑focused with a commitment to high‑quality service delivery
• Medical Insurance – Four plans to choose from for you and your family
• Dental and Orthodontia Benefits
• Health Savings Account (HSA)
• Health and Dependent Care Flexible Spending Accounts (FSA)
• Voluntary Life Insurance, Long‑Term and Short‑Term Disability Insurance
• Hospital Indemnity Insurance
• 401(k) Retirement Plan
• Legal and Identity Protection Plans
• 529 College Savings Plan

Motion Recruitment Partners (MRP) is an Equal Opportunity Employer. All applicants must be currently authorized to work on a full‑time basis in the country for which they are applying; no sponsorship is currently available. Employment is contingent upon successful completion of a pre‑employment screening.

Accommodation will be provided throughout the hiring process as required under MRP’s Employment Accommodation Policy. Applicants are encouraged to make accommodation needs known in advance.