Job Summary
As a senior data engineer, you will play a key role in optimizing query and database performance to meet strict service level agreements (SLAs) of less than 2 seconds. You will be responsible for analyzing execution plans and recommending indexing, partitioning, and optimization strategies to improve database efficiency.
Key Responsibilities:
* Optimize query and database performance to meet strict SLAs (<2 seconds).
* Analyze execution plans and recommend indexing, partitioning, and optimization strategies.
* Partner with database administrators (DBAs) to validate and implement tuning recommendations.
* Oversee extract, transform, load/extract, load, transform (ETL/ELT) workflows, ensuring scalability, efficiency, and data quality.
* Leverage AWS services (S3, Redshift, Glue, Lambda, DMS) for ingestion, transformation, and storage.
Requirements:
* 7+ years of experience in data engineering within enterprise-scale environments.
* Expertise in Oracle performance tuning, including query optimization, execution plans, indexes, partitioning, and parallelism.
* Hands-on experience writing and optimizing complex SQL queries.
* Expertise in Oracle Data Integrator (ODI).
* Experience in data warehouse design, ETL/ELT processes, and data modeling.
* Proven leadership experience, including team mentoring and technical guidance.
* Excellent communication skills, with the ability to collaborate effectively with DBAs, technical teams, and business stakeholders.
Bonus Points:
* Proficiency in at least one programming language (Java, Python, or C++).
* Knowledge of cloud-based data platforms and services (AWS, Azure, Google Cloud Platform).
What We Offer:
* A competitive salary and benefits package.
* The opportunity to work with a talented team of professionals in the field of data engineering.
* The chance to develop your skills and expertise in a rapidly evolving industry.