Job Description:
We are seeking an experienced and skilled professional to lead the design, development, and delivery of enterprise-grade data integration and analytics solutions.
The ideal candidate will have deep expertise in Oracle performance tuning and Oracle Data Integrator (ODI), combined with strong leadership and communication skills.
In this role, you will lead technical decision-making, mentor team members, and collaborate with DBAs and business stakeholders to deliver high-performance scalable data solutions.
Key Responsibilities:
* Optimize Query and Database Performance: Meet strict SLAs (< 2 seconds) by analyzing execution plans and recommending indexing, partitioning, and optimization strategies.
* Analyze Execution Plans: Recommend indexing, partitioning, and optimization strategies to improve query performance.
* Partner with DBAs: Validate and implement tuning recommendations to ensure optimal database performance.
* Oversee ETL/ELT Workflows: Ensure scalability, efficiency, and data quality by leveraging AWS services (S3, Redshift, Glue, Lambda, DMS).
* Lead and Mentor the Team: Foster technical excellence and continuous improvement by mentoring team members and leading by example.
* Translate Technical Decisions: Clearly explain technical decisions to both technical and business stakeholders.
Required Skills and Qualifications:
* 7+ Years of Experience: Proven experience in data engineering within enterprise-scale environments.
* Expertise in Oracle Performance Tuning: Deep knowledge of Oracle performance tuning, including query optimization, execution plans, indexes, partitioning, and parallelism.
* Hands-on Experience: Proficient in writing and optimizing complex SQL queries.
* Oracle Data Integrator (ODI): Expertise in using ODI for data integration and analytics solutions.
* Data Warehouse Design: Experience in designing and developing data warehouses, ETL/ELT processes, and data modeling.
* Proven Leadership: Proven track record of leading teams, mentoring team members, and providing technical guidance.
* Excellent Communication: Excellent communication skills with the ability to collaborate effectively with DBAs, technical teams, and business stakeholders.
* Fluent in English: Fluent in English language.
Benefits:
Work-Life Balance: Opportunity to work from anywhere in Brazil and around the world.
Autonomy: Clear goals and a dynamic environment where professionals can interact with different technologies, participate in various projects, and bring new ideas.
Professional Growth: Opportunity to grow and learn together with the team, fostering innovation and creativity.
Equal Opportunities: All people are welcome regardless of their condition, disability, ethnicity, religious belief, sexual orientation, appearance, age, or others.