Oracle Data Engineer Lead

Oracle Data EngineerMy 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, FLOptimize database and query performance to meet strict SLAs eg 2 seconds response timeAnalyze execution plans and recommend strategies for indexing partitioning and query optimizationCollaborate with DBAs to validate and implement performance tuning recommendationsOversee and enhance ETL/ELT workflows using Oracle Data Integrator ODI ensuring scalability efficiency and data qualityLeverage AWS services S3 Redshift Glue Lambda DMS for cloud-based data ingestion transformation and storageLead and mentor a team of data engineers fostering a culture of technical excellence and continuous improvementTranslate complex technical decisions into clear actionable insights for both technical and nontechnical stakeholdersEnsure data solutions align with business goals compliance standards and industry best practicesRequired QualificationsProven expertise in Oracle performance tuning including query optimization execution plans indexing partitioning and parallelismStrong proficiency in writing and optimizing complex SQL queriesStrong proficiency in understanding writing and debugging Stored Procedures Functions etcHands-on experience with Oracle Data Integrator ODISolid understanding of data warehouse design ETL/ELT processes and data modelingExperience with AWS data services S3 Redshift Glue Lambda DMSDemonstrated leadership experience including mentoring and guiding technical teamsExcellent verbal and written communication skillProven 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.