PL/SQL Developer

Raas Infotek LTD; Texas City (TX); On-site; USD 90,000 - 130,000; Full time

Job summary

Raas Infotek LTD in Texas City seeks an experienced PL/SQL Developer to design, develop, and optimize Oracle database solutions in an enterprise setting.

You will work with SQL, PL/SQL, and ETL processes, ensuring data integrity and performance while collaborating with cross-functional teams across development, QA, and operations.

Strong problem-solving skills and experience with large-volume data are required.

Qualifications

• 10+ years of Oracle PL/SQL Development experience.
• Strong SQL skills and ability to write complex queries.
• Experience with Stored Procedures, Functions, Packages, Triggers, Cursors, and Views.
• Knowledge of Oracle database design, data modeling, and data integrity.
• Experience with performance tuning and query optimization.
• Experience with data migration, ETL processes, and data validation.
• Unix/Linux familiarity; shell scripting preferred.
• Experience with Git, Jira, and Agile/Scrum environments.
• Ability to analyze requirements and translate them into efficient database solutions.
• Experience with large-volume data and complex databases.

Responsibilities

• Develop, enhance, and maintain complex PL/SQL programs and database objects.
• Design and optimize SQL queries, stored procedures, and database processes.
• Perform database performance tuning and resolve SQL performance issues.
• Support data migration, integration, and reconciliation activities.
• Troubleshoot application and database issues and perform root-cause analysis.
• Work closely with developers, QA, BA, and DBA teams.
• Participate in code reviews, testing, deployments, and production support.
• Prepare technical documentation and follow established development standards.
• Support application releases and database deployment activities.
• Identify opportunities to improve database performance, reliability, and maintainability.

Skills

Oracle PL/SQL

SQL

Data modeling

Performance tuning

Unix/Linux

Git

Agile/Scrum

Troubleshooting

Data migration

ETL

Tools

Informatica

Oracle Data Integrator (ODI)

ETL tools

Job description

Job Description

We are looking for an experienced

Experience:

10+ Years

Job Description

We are looking for an experienced PL/SQL Developer with strong expertise in Oracle database development, SQL, data processing, and performance tuning. The candidate will be responsible for developing database solutions, supporting application integrations, and troubleshooting production issues in an enterprise environment.

Required Skills

• 10+ years of experience in Oracle PL/SQL Development.
• Strong hands-on experience with SQL and complex queries.
• Experience with Stored Procedures, Functions, Packages, Triggers, Cursors, and Views.
• Strong knowledge of Oracle database design, data modeling, and data integrity.
• Experience with SQL/PLSQL performance tuning and query optimization.
• Experience with data migration, ETL processes, and data validation.
• Good knowledge of Oracle 11g/12c/19c or later.
• Experience with Unix/Linux and shell scripting is preferred.
• Experience with Git, Jira, and Agile/Scrum environments.
• Strong analytical, troubleshooting, and problem-solving skills.
• Experience working with large-volume data and complex database environments.
• Knowledge of database security, access controls, and transaction management.
• Experience supporting development, QA, UAT, and production environments.
• Ability to analyze requirements and translate them into efficient database solutions.

Responsibilities

• Develop, enhance, and maintain complex PL/SQL programs and database objects.
• Design and optimize SQL queries, stored procedures, and database processes.
• Perform database performance tuning and resolve SQL performance issues.
• Support data migration, integration, and reconciliation activities.
• Troubleshoot application and database issues and perform root-cause analysis.
• Work closely with developers, QA, BA, and DBA teams.
• Participate in code reviews, testing, deployments, and production support.
• Prepare technical documentation and follow established development standards.
• Support application releases and database deployment activities.
• Identify opportunities to improve database performance, reliability, and maintainability.

Preferred Skills

• Experience with Informatica, Oracle Data Integrator (ODI), or other ETL tools.
• Knowledge of Oracle RAC, partitioning, and large-volume databases.
• Experience with cloud or enterprise database environments.
• Experience working with batch processing and scheduling tools.
• Knowledge of REST APIs, JSON/XML, and application integration is a plus.

Key Skills:

Oracle | PL/SQL | SQL | Stored Procedures | Packages | Functions | Triggers | Performance Tuning | ETL | Data Integration | Unix/Linux | Git | Agile/Scrum