Oracle PL/SQL Developer

Envision Technology Solutions; Addison (TX); On-site; USD 110,000 - 160,000; Full time

Job summary

Envision Technology Solutions seeks an experienced Oracle DBA/Developer to design, implement, and optimize Oracle database objects and PL/SQL code. You will translate business needs into solid data models and support deployments across development, testing, and production environments.

The role requires 10+ years of experience in Oracle SQL/PL-SQL, relational modeling, and scripting. Collaboration with cross‑functional teams and a focus on data integrity and security are essential.

Qualifications

• Expert level Oracle SQL/PL-SQL development and tuning.
• Strong relational data modeling and schema design.
• Unix shell scripting for automation and deployment tasks.
• Experience in financial services or banking tax operations.

Responsibilities

• Design, develop, and maintain Oracle database objects (tables, views, indexes, constraints, synonyms, sequences) following standards.
• Write, optimize, and tune SQL queries and PL/SQL code for performance and reliability.
• Translate business requirements into robust data models and designs.
• Develop deployment, migration, and rollback scripts for DEV/QA/PROD environments.
• Perform data analysis, debugging, and troubleshooting to ensure data integrity and security.
• Collaborate with application teams, DBAs, QA, and participate in code reviews and production support.

Skills

Oracle SQL/PL-SQL

Relational DB modeling

Unix shell scripting

AI-assisted development

Banking tax operations

Tools

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.