Oracle Database Developer

As an Oracle Database Developer with 6+ years of experience, you will play a crucial role in transforming raw data into high-performance analytical assets. Your expertise in PL/SQL and Oracle Autonomous Data Warehouse (ADW) will be essential in ensuring the speed and reliability of our data. Key Responsibilities: - Develop & Maintain: Design and implement complex PL/SQL packages, procedures, and triggers to support core business logic. - Performance Engineering: Proactively identify bottlenecks using Execution Plans and AWR reports; perform advanced SQL tuning to ensure sub-second response times. - Cloud Architecture: Manage and optimize data workflows within Oracle ADW, leveraging cloud-native features for scalability. - Data Modeling: Design robust logical and physical data models (Star/Snowflake schemas) that support both high-speed transactions and complex reporting. - Migration & Integration: Lead data migration efforts and ensure data integrity across various environments. Qualifications: - PL/SQL Mastery: Deep "under the hood" knowledge of Oracle databases. - The "Tuning" Mindset: Experience with indexing strategies and partition management to achieve optimal performance. - Cloud Experience: Practical, hands-on experience with Oracle Autonomous Data Warehouse (ADW). - Analytical Design: Proficiency in Data Modeling tools (e.g., Erwin, SQL Developer Data Modeler) and a strong understanding of Normalization vs. Denormalization. If you join our team, you will have the opportunity to work on challenging projects and contribute to the continuous growth and success of our data engineering team. As an Oracle Database Developer with 6+ years of experience, you will play a crucial role in transforming raw data into high-performance analytical assets. Your expertise in PL/SQL and Oracle Autonomous Data Warehouse (ADW) will be essential in ensuring the speed and reliability of our data. Key Responsibilities: - Develop & Maintain: Design and implement complex PL/SQL packages, procedures, and triggers to support core business logic. - Performance Engineering: Proactively identify bottlenecks using Execution Plans and AWR reports; perform advanced SQL tuning to ensure sub-second response times. - Cloud Architecture: Manage and optimize data workflows within Oracle ADW, leveraging cloud-native features for scalability. - Data Modeling: Design robust logical and physical data models (Star/Snowflake schemas) that support both high-speed transactions and complex reporting. - Migration & Integration: Lead data migration efforts and ensure data integrity across various environments. Qualifications: - PL/SQL Mastery: Deep "under the hood" knowledge of Oracle databases. - The "Tuning" Mindset: Experience with indexing strategies and partition management to achieve optimal performance. - Cloud Experience: Practical, hands-on experience with Oracle Autonomous Data Warehouse (ADW). - Analytical Design: Proficiency in Data Modeling tools (e.g., Erwin, SQL Developer Data Modeler) and a strong understanding of Normalization vs. Denormalization. If you join our team, you will have the opportunity to work on challenging projects and contribute to the continuous growth and success of our data engineering team.