Oracle Database Developer (PL/SQL & ADW)

Job Title: Oracle Database Developer (PL/SQL & ADW)

Remote Opportunity

Experience Level: 6+ Years

About the Role

We are looking for a performance-driven Database Developer to join our data engineering team. You won't just be writing queries; you will be the architect of our datas speed and reliability. Your expertise in PL/SQL and Oracle Autonomous Data Warehouse (ADW) will be critical in transforming raw data into high-performance analytical assets.

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.

What Were Looking For

• PL/SQL Mastery: Deep "under the hood" knowledge of Oracle databases.
• The "Tuning" Mindset: You dont just make it work; you make it fast. Experience with indexing strategies and partition management is a must.
• 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.

Interested Candidates can mail their cv at simmi@hiresquad.in or call at 8467054123