Oracle PL/SQL Developer

Centraprise, Corp.; Addison (TX); On-site; USD 120,000 - 180,000; Full time

Job summary

Centraprise, Corp. in Addison, TX is seeking an experienced Oracle SQL/PL-SQL expert with 10+ years of hands-on experience in designing, developing, and optimizing robust Oracle database solutions within the financial services sector.

The candidate will design database objects, write and tune PL/SQL code, and ensure deployment, migration, and rollback scripts support multiple environments (DEV/QA/PROD). Collaboration with cross-functional teams will be essential.

Qualifications

• 10+ years of experience in Oracle SQL/PL-SQL database development.
• Expert level in designing and tuning Oracle database objects and structures.
• Experience with deployment, migration, and rollback scripts across DEV/QA/PROD environments.

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.

Skills

Oracle SQL

PL-SQL

Relational DB Modeling

Unix Shell Scripting

AI-Assisted Development

ETL

Java

Python

Job description

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

• 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.