Oracle PL/SQL Developer

Centraprise, Corp.; Jacksonville (FL); On-site; USD 90,000 - 140,000; Full time

Job summary

Centraprise, Corp. in Jacksonville, FL is seeking an experienced Oracle PL/SQL Developer to design, develop, and optimize complex database solutions for high-availability applications.

You will work across the SDLC with developers, analysts, and QA, delivering efficient PL/SQL packages, tuning queries, and ensuring data integrity in Oracle databases.

Qualifications

• Design, develop, test, and maintain Oracle PL/SQL packages, procedures, functions, triggers, views, and database objects.
• Analyze business requirements and translate them into scalable database solutions.
• Develop and optimize complex SQL queries and batch processes for high-performance applications.

Responsibilities

• Design, develop, test, and maintain complex Oracle PL/SQL packages, procedures, functions, triggers, views, and database objects.
• Analyze business requirements and translate them into scalable and efficient database solutions.
• Develop and optimize complex SQL queries, PL/SQL code, and batch processes for high-performance applications.
• Perform database performance tuning using Explain Plan, SQL Hints, and indexing strategies.
• Design and maintain data models using ERWIN, TOAD Data Modeler, and ER diagrams.
• Develop data migration, loading, and ETL processes using SQL*Loader.
• Collaborate with developers, analysts, architects, and QA across the SDLC.
• Troubleshoot production issues and implement permanent solutions.

Skills

Oracle PL/SQL

Oracle Database

Advanced SQL

Stored Procedures

Functions

Packages & Triggers

Query Performance Tuning

Explain Plan

SQL Hints

Index Tuning

Data Modeling

ER Diagrams

SQL*Loader

Oracle Forms & Reports

TOAD

UNIX Shell Scripting

Database Design

Tools

ERWIN

TOAD Data Modeler

TOAD

SQL Navigator

UNIX Shell Scripting

Job description

Job Description

Primary Skills

Primary Skills: Oracle PL/SQL Development, Oracle Database (8i/9i/10g/11g and above), Advanced SQL Programming, Stored Procedures, Functions, Packages & Triggers, Query Performance Tuning & Optimization Explain Plan, SQL Hints & Index Tuning , Data Modeling (ERWIN, TOAD Data Modeler, ER Diagrams) SQL*Loader , Oracle Forms & Reports, TOAD, PL/SQL Developer & SQL Navigator, UNIX Shell Scripting Database Design, Development & Production Support

Secondary Skills

Secondary Skills: NIX / Linux Administration (RHEL, Solaris, AIX), Shell Scripting (Korn Shell, Bash), Python Programming, SQL Server, Oracle Forms & Reports, SQL*Loader, Tableau Reporting & Dashboard Development, Collibra Data Governance, Trino (Presto) Query Engine, Hue Analytics Platform, Quartz Scheduler, Data Warehousing Concepts, ETL Development & Data Migration, Database Performance Monitoring, Production Support (L2/L3), Version Control Tools (Git, SVN), Agile / Scrum Methodology, JIRA and Defect Tracking Tools , Application Support & Incident Management, BFSI Domain Knowledge

Responsibilities

• o Design, develop, test, and maintain complex Oracle PL/SQL packages, procedures, functions, triggers, views, and database objects.
• o Analyze business requirements and translate them into scalable and efficient database solutions.
• o Develop and optimize complex SQL queries, PL/SQL code, and batch processes for high-performance applications.
• o Perform database performance tuning using Explain Plan, SQL Hints, Indexing strategies, and query optimization techniques.
• o Design and maintain logical and physical data models using ERWIN, TOAD Data Modeler, and ER diagrams.
• o Develop and support data migration, data loading, and ETL processes using SQL*Loader and related tools.
• o Work closely with application developers, business analysts, architects, and QA teams throughout the SDLC lifecycle.
• o Troubleshoot production issues, analyze root causes, and implement permanent solutions to ensure system stability.
• o Support database deployments, release activities, and change management processes across multiple environments.
• o Develop UNIX/Linux shell scripts to automate database monitoring, maintenance, and batch processing activities.
• o Create and maintain technical design documents, code reviews, and database development standards.
• o Work with reporting and analytics tools such as Tableau, Trino, Hue, and Collibra to support business reporting requirements.
• o Monitor database health, ensure data integrity, and implement backup and recovery best practices.
• o Mentor junior developers and provide technical guidance on Oracle database development and tuning best practices.
• o Participate in Agile ceremonies including sprint planning, estimation, backlog refinement, code reviews, and retrospective meetings.
• o Collaborate with cross-functional teams to deliver secure, scalable, and high-quality database solutions.
• o Ensure compliance with organizational security, audit, and regulatory requirements, particularly in BFSI environments.
• o Provide L2/L3 production support and work on critical incidents, problem management, and service improvement initiatives.