Oracle PL/SQL Developer

Bright Vision Technologies

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

Posted 11/4/2026full-timeRemote • United StatesMid-LevelSenior💰 $120,000 - $180,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates extensive expertise in Oracle PL/SQL development, including complex SQL query optimization and database performance tuning. Proficient in building ETL processes and integrating Oracle databases with various applications while ensuring compliance and security.

Highest-signal resume keywords

Oracle PL/SQL DevelopmentSQL Query OptimizationETL Process DevelopmentDatabase Performance TuningOracle Database Administration

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

PL/SQL PackagesStored ProceduresSQL QueriesDatabase OptimizationDatabase MigrationData ModelingRelational Database DesignOracle Advanced QueuingShell ScriptingDimensional Modeling

Soft Skills

TroubleshootingDebuggingCollaborationAgile MethodologiesPerformance Tuning

Tools & Technologies

Oracle SQL DeveloperTOADSQL*PlusGitAzure DevOpsJenkinsOracle Cloud InfrastructureOracle ExadataOracle APEXOracle Data Pump

Certifications & Qualifications

Oracle Database AdministrationOCP Certification

Industry Keywords

Financial ApplicationsHealthcare ApplicationsInsurance ApplicationsRetail ApplicationsGovernment ApplicationsData GovernanceComplianceAuditability

Tech Stack

Tools & technologies

AWSAzureCloudETLJavaJenkinsOraclePythonShell ScriptingSQL.NET

About the role

Key responsibilities & impact

Design, develop, and maintain complex PL/SQL packages, stored procedures, functions, triggers, and database objects
Develop optimized SQL queries for large transactional and analytical databases
Design scalable schemas, indexing strategies, partitioning models, and performance optimization techniques
Build ETL processes and database integration components
Develop batch processing jobs and automated database workflows
Analyze execution plans, identify SQL bottlenecks, and optimize database performance
Collaborate with application developers on database access patterns and API integrations
Implement database security, auditing, role-based access controls, and data encryption
Develop database migration scripts, deployment packages, and release automation processes
Perform code reviews, troubleshoot production issues, and resolve data integrity problems
Support database modernization initiatives involving OCI, Azure, or AWS
Participate in Agile activities, architecture reviews, and production support rotations
Contribute to database architecture, cloud migration, production support, and continuous improvement of enterprise Oracle platforms

Requirements

What you’ll need

Six or more years of professional experience developing enterprise Oracle database solutions
Strong expertise in Oracle PL/SQL, including packages, stored procedures, functions, cursors, triggers, collections, exceptions, and dynamic SQL
Advanced SQL development skills with complex joins, CTEs, analytical functions, window functions, and query optimization
Extensive experience with Oracle Database 12c, 19c, or newer
Strong understanding of Oracle indexing, partitioning, materialized views, execution plans, and optimizer statistics
Experience optimizing high-volume OLTP and OLAP workloads
Hands-on experience with Oracle SQL Developer, TOAD, SQL*Plus, or similar tools
Experience 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 integrating Oracle databases with Java, .NET, Python, or REST-based applications
Understanding of database normalization, data modeling, and relational database design
Experience using Git, Azure DevOps, Jenkins, or CI/CD pipelines for database deployment automation
Strong troubleshooting, debugging, and performance tuning skills
Experience working in 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 unavailable
Preferred: Oracle Cloud Infrastructure Database Services or Autonomous Database experience
Preferred: Oracle Exadata, RAC, Data Guard, GoldenGate, OIC, Oracle SOA Suite, or Oracle APEX experience
Preferred: Financial, healthcare, insurance, retail, or government enterprise application experience
Preferred: Shell scripting, Python, or PowerShell for database automation
Preferred: Enterprise data warehousing and dimensional modeling knowledge
Oracle Database Administration or OCP certifications highly desirable
Preferred: Experience supporting regulated environments requiring auditability, compliance, and data governance

Benefits

Comp & perks

Comprehensive benefits
Competitive compensation packages
Supportive work-life balance
Career growth potential
Continuous learning and growth opportunities