Oracle PL/SQL Developer

This is a fully remote position, open to applicants in United States.

📋 Description

• Design, develop, and maintain intricate PL/SQL packages, stored procedures, functions, triggers, and database objects.

• Create optimized SQL queries for extensive transactional and analytical databases.

• Design scalable schemas, indexing strategies, partitioning models, and performance enhancement techniques.

• Construct ETL processes and components for database integration.

• Develop batch processing jobs and automated workflows for databases.

• Analyze execution plans, pinpoint SQL bottlenecks, and enhance database performance.

• Collaborate with application developers on database access patterns and API integrations.

• Implement database security measures, auditing, role-based access controls, and data encryption.

• Create database migration scripts, deployment packages, and processes for release automation.

• Conduct code reviews, troubleshoot production issues, and resolve data integrity challenges.

• Support database modernization projects involving OCI, Azure, or AWS.

• Engage in Agile activities, architecture reviews, and production support rotations.

• Contribute to database architecture, cloud migration efforts, production support, and the continuous improvement of enterprise Oracle platforms.

⛳️ Requirements

• Six or more years of professional experience in developing enterprise Oracle database solutions.

• Strong expertise in Oracle PL/SQL, encompassing packages, stored procedures, functions, cursors, triggers, collections, exceptions, and dynamic SQL.

• Advanced SQL development skills, including complex joins, CTEs, analytical functions, window functions, and query optimization.

• Extensive experience with Oracle Database versions 12c, 19c, or later.

• Deep understanding of Oracle indexing, partitioning, materialized views, execution plans, and optimizer statistics.

• Experience in optimizing high-volume OLTP and OLAP workloads.

• Practical experience with Oracle SQL Developer, TOAD, SQL*Plus, or similar tools.

• Proven experience in developing ETL processes and integrating Oracle databases with external systems.

• Familiarity with Oracle Data Pump, RMAN, and database migration methodologies.

• Experience with Oracle Advanced Queuing, Scheduler, and database jobs.

• Experience in integrating Oracle databases with Java, .NET, Python, or RESTful applications.

• Understanding of database normalization, data modeling, and relational database design.

• Experience using Git, Azure DevOps, Jenkins, or CI/CD pipelines for automating database deployment.

• Strong skills in troubleshooting, debugging, and performance tuning.

• Experience working within Agile Scrum environments.

• U.S. work authorization as a U.S. Citizen, Green Card Holder, EAD Holder, or H-1B transfer candidate; new H-1B sponsorship is unavailable.

• Preferred: Experience with Oracle Cloud Infrastructure Database Services or Autonomous Database.

• Preferred: Knowledge of Oracle Exadata, RAC, Data Guard, GoldenGate, OIC, Oracle SOA Suite, or Oracle APEX.

• Preferred: Experience in financial, healthcare, insurance, retail, or government enterprise applications.

• Preferred: Proficiency in shell scripting, Python, or PowerShell for database automation.

• Preferred: Knowledge of enterprise data warehousing and dimensional modeling.

• Oracle Database Administration or OCP certifications are highly desirable.

• Preferred: Experience in supporting regulated environments requiring auditability, compliance, and data governance.

🏝️ Benefits

• Comprehensive benefits package.

• Competitive compensation structure.

• Supportive work-life balance.

• Opportunities for career advancement.

• Continuous learning and growth opportunities.