Oracle PL/SQL Developer

We are seeking a highly skilled and experienced PL/SQL Developer with exposure to cloud platforms (AWS or Azure) to build, optimize, and maintain high-performance database solutions. This is a hands-on individual contributor role requiring deep expertise in Oracle PL/SQL along with the ability to work in modern cloud-enabled data environments. Key Responsibilities PL/SQL Development Design, develop, and maintain complex PL/SQL packages, procedures, functions, and triggers. Write efficient, scalable, and reusable database code. Develop and optimize complex SQL queries for large-scale data processing and reporting. Troubleshoot and resolve database-related performance and production issues. Database Design & Performance Optimization Collaborate with architects and DBAs on data modeling, schema design, and indexing strategies. Perform advanced query tuning using explain plans and performance tools. Optimize database workloads for high-volume and high-throughput systems. Ensure data consistency, integrity, and performance across systems. Cloud Integration (AWS / Azure) Work with databases deployed on cloud platforms (AWS RDS, Aurora, Azure SQL, Oracle on Cloud). Support migration of on-prem databases to cloud environments. Optimize database workloads for cloud performance, scalability, and cost efficiency. Integrate PL/SQL-based systems with cloud services, APIs, and data pipelines. Collaborate with cloud engineers on architecture and deployment strategies. Data Processing & ETL Develop and maintain ETL processes, batch jobs, and data pipelines. Handle large datasets efficiently in both on-premises and cloud environments. Support data transformation, ingestion, and reporting needs. Quality & Standards Follow best practices for coding, version control, and documentation. Conduct self-reviews and participate in peer code reviews. Ensure compliance with performance, security, and data governance standards. Collaboration Partner with business analysts, application teams, and cloud architects to deliver solutions. Participate in technical design discussions and provide database expertise. Support testing, deployment, and release cycles. Production Support Provide L2/L3 support for database and data-related issues. Diagnose and resolve performance bottlenecks and failures. Monitor systems and proactively improve stability and efficiency. Required Qualifications Bachelor's degree in computer science, IT, or related field. 7-12+ years of strong hands-on Oracle PL/SQL development experience. Deep expertise in: PL/SQL (packages, procedures, functions, triggers) Advanced SQL and performance tuning Oracle Database (11g/12c/19c or higher) Cloud Requirements (Must Have / Strongly Preferred) Hands-on experience with: Oracle Autonomous Data Warehouse (ADW) on Azure Amazon Redshift Strong understanding of: Cloud-based data warehousing architectures Performance tuning in ADW and Redshift environments Workload management, query optimization, and storage strategies in cloud DW platforms Experience in: Managing and optimizing cloud data processing for scalability and cost efficiency Familiarity with: Azure ecosystem (e.g., networking, security, integration with ADW) AWS ecosystem (e.g., S3, IAM, data ingestion into Redshift) Preferred Skills Experience with data warehousing and large-scale data processing. Knowledge of performance tuning tools (AWR, ASH, SQL Trace). Familiarity with Unix/Linux shell scripting. Experience with ETL frameworks/tools. Exposure to CI/CD pipelines and DevOps practices. Experience with version control tools (Git). Soft Skills Strong analytical and problem-solving skills. Ability to work independently in an individual contributor role. Excellent communication and collaboration abilities. Detail-oriented with strong focus on performance and quality. Omni Inclusive