Overview
On Site
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - 16 day((s))
Skills
ETL
SQL queries
Informatica
Stored Procedures
Data warehouse
OEM
Triggers
Performance tuning
TOAD
OLTP
queries
oracle developer
pl/sql packages
functions
pl/sql code
work flows
oracle 12c
oracle 19c
oracle 21c
12c/19c/21c
oracle internals
execution plans
indexing
partitioning
awr
ash
tkprof
sql trace
oracle enterprise manager
datawarhouse
Job Details
Senior Oracle Developer
Westlake TX (100% Onsite)
Contract
Westlake TX (100% Onsite)
Contract
LOCALS Preferred
Job Summary:
We are seeking a Senior Oracle Developer with extensive experience in performance tuning of Oracle PL/SQL packages, procedures, and queries. The ideal candidate will be responsible for designing, developing, and optimizing complex Oracle-based solutions to support high-volume enterprise applications. This role requires deep knowledge of Oracle architecture and hands-on expertise in identifying and resolving performance bottlenecks.
Key Responsibilities:
Design, develop, and maintain complex PL/SQL packages, procedures, functions, and triggers.
Perform advanced performance tuning of PL/SQL code, queries, and database structures.
Analyze and refactor poorly performing database code and provide recommendations for improvements.
Collaborate with DBAs, application developers, and system architects to implement best practices for performance and scalability.
Utilize tools like AWR, ASH, SQL Trace, and SQL Plan Baselines to monitor and enhance performance.
Hands on with Informatica ETL work flows
We are seeking a Senior Oracle Developer with extensive experience in performance tuning of Oracle PL/SQL packages, procedures, and queries. The ideal candidate will be responsible for designing, developing, and optimizing complex Oracle-based solutions to support high-volume enterprise applications. This role requires deep knowledge of Oracle architecture and hands-on expertise in identifying and resolving performance bottlenecks.
Key Responsibilities:
Design, develop, and maintain complex PL/SQL packages, procedures, functions, and triggers.
Perform advanced performance tuning of PL/SQL code, queries, and database structures.
Analyze and refactor poorly performing database code and provide recommendations for improvements.
Collaborate with DBAs, application developers, and system architects to implement best practices for performance and scalability.
Utilize tools like AWR, ASH, SQL Trace, and SQL Plan Baselines to monitor and enhance performance.
Hands on with Informatica ETL work flows
Required Skills and Qualifications:
Bachelor's degree in Computer Science, Information Systems, or a related field.
10+ years of experience in Oracle PL/SQL development.
5+ years of experience in Informatica ETL work flows
Deep expertise in performance tuning Oracle packages and SQL queries (Oracle 12c/19c/21c).
Strong understanding of Oracle internals, execution plans, indexing, partitioning, and optimizer behavior.
Hands-on experience with tools such as SQL Developer, TOAD, AWR, ASH, TKPROF, SQL Trace, and Oracle Enterprise Manager.
Preferred Qualifications:
Oracle Certified Professional (OCP) certification.
Exposure to Agile or DevOps environments.
Experience with performance tuning in cloud-based Oracle environments
Bachelor's degree in Computer Science, Information Systems, or a related field.
10+ years of experience in Oracle PL/SQL development.
5+ years of experience in Informatica ETL work flows
Deep expertise in performance tuning Oracle packages and SQL queries (Oracle 12c/19c/21c).
Strong understanding of Oracle internals, execution plans, indexing, partitioning, and optimizer behavior.
Hands-on experience with tools such as SQL Developer, TOAD, AWR, ASH, TKPROF, SQL Trace, and Oracle Enterprise Manager.
Preferred Qualifications:
Oracle Certified Professional (OCP) certification.
Exposure to Agile or DevOps environments.
Experience with performance tuning in cloud-based Oracle environments
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.