Oracle Data Engineer Lead

Oracle Data Engineer

My client is a global technology consulting and digital solutions company that enables enterprises across industries to reimagine business models, accelerate innovation, and maximize growth by harnessing digital technologies. As a digital transformation partner to more than 700+ clients, client brings extensive domain and technology expertise to help drive superior competitive differentiation, customer experiences, and business outcomes in a converging world. Powered by nearly 90,000 talented and entrepreneurial professionals across more than 30 countries.

Location -- Tampa, FL

Optimize database and query performance to meet strict SLAs eg 2 seconds response time

Analyze execution plans and recommend strategies for indexing partitioning and query optimization

Collaborate with DBAs to validate and implement performance tuning recommendations

Oversee and enhance ETL/ELT workflows using Oracle Data Integrator ODI ensuring scalability efficiency and data quality

Leverage AWS services S3 Redshift Glue Lambda DMS for cloud-based data ingestion transformation and storage

Lead and mentor a team of data engineers fostering a culture of technical excellence and continuous improvement

Translate complex technical decisions into clear actionable insights for both technical and nontechnical stakeholders

Ensure data solutions align with business goals compliance standards and industry best practices

Required Qualifications

Proven expertise in Oracle performance tuning including query optimization execution plans indexing partitioning and parallelism

Strong proficiency in writing and optimizing complex SQL queries

Strong proficiency in understanding writing and debugging Stored Procedures Functions etc

Hands-on experience with Oracle Data Integrator ODI

Solid understanding of data warehouse design ETL/ELT processes and data modeling

Experience with AWS data services S3 Redshift Glue Lambda DMS

Demonstrated leadership experience including mentoring and guiding technical teams

Excellent verbal and written communication skill

• Proven expertise in Oracle performance tuning, including query optimization, execution plans, indexing, partitioning, and parallelism.
• Strong proficiency in writing and optimizing complex SQL queries.
• Strong proficiency in understanding, writing and debugging Stored Procedures, Functions, etc.
• Hands-on experience with Oracle Data Integrator (ODI).
• Solid understanding of data warehouse design, ETL/ELT processes, and data modeling.

Mandatory Skills : Oracle Data Integrator (ODI), Oracle ETL & Scripting.

Disclaimer: E-Solutions Inc. provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. We especially invite women, minorities, veterans, and individuals with disabilities to apply.