Oracle PL/SQL Developer

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

📋 Description

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

• Generate optimized SQL queries for expansive 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 automate database workflows.

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

• Collaborate with application development teams regarding database access patterns and API integrations.

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

• Create migration scripts, deployment packages, and automate release processes.

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

• Assist in database modernization efforts involving OCI, Azure, or AWS.

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

• Contribute to database architecture, PL/SQL development, SQL optimization, cloud migration, production support, and the ongoing enhancement of enterprise Oracle platforms.

⛳️ Requirements

• A minimum of six years of professional experience in developing enterprise Oracle database solutions.

• In-depth knowledge of Oracle PL/SQL, including packages, stored procedures, functions, cursors, triggers, collections, exceptions, and dynamic SQL.

• Advanced SQL development capabilities with complex joins, CTEs, analytical functions, window functions, and query optimization.

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

• Strong comprehension of Oracle indexing, partitioning, materialized views, execution plans, and optimizer statistics.

• Proven experience in optimizing high-volume OLTP and OLAP workloads.

• Hands-on experience with Oracle SQL Developer, TOAD, SQL*Plus, or similar tools.

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

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

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

• Experience in integrating Oracle databases with Java, .NET, Python, or REST-based applications.

• Strong understanding of database normalization, data modeling, and relational database design.

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

• Excellent troubleshooting, debugging, and performance tuning abilities.

• Experience in Agile Scrum environments.

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

🏝️ Benefits

• Comprehensive benefits package.

• Competitive compensation structure.

• Supportive work-life balance.

• Opportunities for career advancement.

• Continuous learning and development opportunities.