Oracle PL/SQL Developer On-Site in Houston, TX

$104,000 - $145,600/Yr

Amtex Enterprises - Houston, TX

Full-time - Mid Level

Houston, TX

Professional, Scientific, and Technical Services

About the position

The Mid-Level Oracle PL/SQL Developer position is a contract role based in Houston, TX, focusing on PL/SQL development and data analysis. The role requires collaboration with UI teams and involves developing complex database solutions, optimizing performance, and executing ETL processes for Datawarehouse/OLAP projects. This position offers competitive compensation and the potential for multi-year engagement.

Responsibilities

• Develop and optimize complex PL/SQL procedures, functions, and packages.
• Design and implement database solutions utilizing partitions, DBMS jobs, and user-defined types.
• Collaborate with UI teams to integrate XML, JSON, and cursors into applications.
• Execute end-to-end ETL job development with a focus on Datawarehouse/OLAP projects.
• Perform detailed SQL tuning and resolve database performance issues.
• Conduct data analysis to debug, trace, and fix database issues efficiently.

Requirements

• 8+ years of Oracle PL/SQL Development experience.
• Expertise in database development, including partitions, DBMS jobs, and user-defined types.
• Proven ability to work with UI teams and handle XML/JSON data formats.
• Extensive knowledge of ETL processes, Datawarehouse, and OLAP concepts.
• Advanced SQL tuning and database performance optimization skills.

Nice-to-haves

• Familiarity with Oracle Exadata and SingleStore/MySQL.
• Experience with Python libraries such as requests, pandas, json, and others.
• Oil and Gas industry experience is a strong plus.

Benefits

• Competitive compensation based on experience and skills.