Oracle PL/SQL Developer

Bright Vision Technologies

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

Posted 11/11/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 optimization and database performance tuning. Proficient in designing scalable database architectures and implementing ETL processes while ensuring data security and integrity.

Highest-signal resume keywords

Oracle PL/SQL DevelopmentSQL OptimizationETL Process DevelopmentDatabase Performance TuningAgile Scrum Experience

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 DesignIndexing StrategiesPartitioning ModelsDatabase SecurityData MigrationPerformance OptimizationData Modeling

Soft Skills

TroubleshootingDebuggingCollaboration

Tools & Technologies

Oracle Database 12cOracle Database 19cOracle SQL DeveloperTOADSQL*PlusGitAzure DevOpsJenkins

Industry Keywords

OLTPOLAPAgile DevelopmentDatabase ModernizationCloud Migration

Tech Stack

Tools & technologies

AWSAzureCloudETLJavaJenkinsOraclePythonSQL.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 development teams on database access patterns and API integrations
Implement database security, auditing, role-based access controls, and data encryption
Develop 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 development, architecture reviews, and production support rotations
Contribute to database architecture, PL/SQL development, SQL optimization, 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
Strong 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 eligible H-1B transfer candidate; new H-1B sponsorship unavailable

Benefits

Comp & perks

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