Oracle developer

Company: Collabera
Location: Plano
Posted on: April 23, 2025

Job Description:

Pay Range: $60 - $65

Maximise your chances of a successful application to this job by ensuring your CV and skills are a good match.

Job Description:

Design and implement scalable, efficient data warehouse solutions to support large-scale data environments.


Develop and maintain high-performance ETL frameworks with strong error-handling and reliability.


Optimize Oracle database performance using execution plans, AWR reports, and advanced tuning techniques for queries, tables, and indexes.


Model data across conceptual, logical, and physical layers to meet data warehouse requirements.


Write, maintain, and optimize complex Oracle PL/SQL code for performance and scalability.


Manage advanced database features including partitions, indexes, CDC (Change Data Capture), purging strategies, and data virtualization.



Must Haves

12+ years of hands-on experience in large-scale data warehousing, with a focus on designing effective data solutions.


10+ years of advanced Oracle PL/SQL development and DBA experience, including deep expertise in performance tuning.


Strong ability to analyze Oracle execution/query plans and AWR reports to identify and resolve performance issues.


Proven experience in designing and implementing data models (conceptual, logical, and physical).


Expertise in building scalable, high-performance ETL frameworks with robust error handling.


In-depth knowledge of database management, including partitions, indexes, CDC, purging, and virtualization.



Plusses

Experience with data visualization tools such as Tableau (preferred) or Power BI.


Exposure to Python, Hadoop, and Generative AI/Machine Learning (Gen AI/ML).


Background in the financial services or banking industry.

Keywords: Collabera, Cedar Hill , Oracle developer, IT / Software / Systems , Plano, Texas