Oracle PL/SQL Developer — Centraprise, Addison, TX

Role: Oracle PL/SQL Developer

Location: NJ/Addison/Charlotte, NC- Onsite

Duration: Full Time

Job Description:

Must Have Technical/Functional Skills

Primary Skill: Oracle SQL / PL-SQL( Expert Level) , Relational database modeling, Unix shell Scripting, Financial services / banking tax operations, AI-Assisted Development Skills

Secondary: ETL, Java/Python

Experience: 10+ years

Roles & Responsibilities

· Design, develop, and maintain Oracle database objects — tables, views, indexes, constraints, synonyms, and sequences — following naming and design standards.

· Write, optimize, and tune SQL queries and PL/SQL code (stored procedures, functions, packages, triggers) for performance and reliability.

· Analyze business/functional requirements and translate them into robust database designs and data models.

· Develop and maintain deployment, migration, and rollback scripts, supporting releases across DEV, QA, and PROD environments.

· Perform data analysis, debugging, and troubleshooting of database issues, ensuring data integrity, security, and quality.

· Collaborate with application teams, DBAs, and QA, and participate in code reviews, documentation, and production support.