Oracle PL/SQL Developer

Bright Vision Technologies•Overland Park, KS

2d•$120,000 - $180,000•Remote

About The Position

Bright Vision Technologies is seeking an experienced Oracle PL/SQL Developer to design, develop, and optimize enterprise database solutions for high-volume transactional systems, financial applications, regulatory reporting, and other mission-critical operations. The role focuses on scalable PL/SQL applications, complex SQL query optimization, database objects, and availability and performance across large Oracle environments. The developer will collaborate with application developers, database administrators, data architects, QA engineers, and business analysts on database solutions for enterprise applications, cloud modernization, and data integration. The role contributes to database architecture, development, SQL optimization, cloud migration, production support, and continuous improvement across enterprise Oracle platforms. This is a full-time, direct W2 position based remotely in the United States. The salary range is $120,000–$180,000 annually. The employer cannot sponsor new H-1B visa petitions, but encourages applications from U.S. citizens, Green Card holders, EAD holders, and H-1B transfer candidates.

Requirements

At least 6 years of professional experience developing enterprise Oracle database solutions.
Strong Oracle PL/SQL expertise, including packages, stored procedures, functions, cursors, triggers, collections, exceptions, and dynamic SQL.
Advanced SQL development skills, including complex joins, Common Table Expressions (CTEs), analytical and window functions, and query optimization.
Extensive experience with Oracle Database 12c, 19c, or newer enterprise environments.
Strong understanding of Oracle indexing, partitioning, materialized views, execution plans, and optimizer statistics.
Experience optimizing high-volume OLTP and OLAP database workloads.
Hands-on experience with Oracle SQL Developer, TOAD, SQLPlus, or similar Oracle development 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 (AQ), Scheduler, and database jobs.
Experience integrating Oracle databases with Java, .NET, Python, or REST-based enterprise applications.
Strong understanding of database normalization, data modeling, and relational database design principles.
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 development environments.

Nice To Haves

Experience with Oracle Cloud Infrastructure (OCI) Database Services or Autonomous Database.
Familiarity with Oracle Exadata, RAC (Real Application Clusters), and Data Guard environments.
Experience with Oracle GoldenGate, Oracle Integration Cloud (OIC), or Oracle SOA Suite.
Knowledge of Oracle APEX application development.
Experience developing financial, healthcare, insurance, retail, or government enterprise applications.
Familiarity with cloud migration strategies for moving on-premises Oracle databases to OCI, Azure, or AWS.
Experience with shell scripting, Python, or PowerShell for database automation.
Knowledge of enterprise data warehousing and dimensional modeling concepts.
Oracle Database Administration or Oracle Certified Professional (OCP) certifications.
Experience supporting highly regulated environments requiring auditability, compliance, and data governance.

Responsibilities

Design, develop, and maintain complex PL/SQL packages, stored procedures, functions, triggers, and other database objects.
Develop optimized SQL queries for large transactional and analytical databases.
Design scalable database schemas, indexing strategies, partitioning models, and performance optimization techniques.
Build ETL processes and database integration components for enterprise data movement and synchronization.
Develop batch processing jobs and automated database workflows for business-critical operations.
Analyze execution plans, identify SQL bottlenecks, and optimize performance for high-volume systems.
Collaborate with application development teams to design efficient database access patterns and API integrations.
Implement database security, auditing, role-based access controls, and data encryption standards.
Develop database migration scripts, deployment packages, and release automation processes.
Conduct database code reviews, troubleshoot production issues, and resolve data integrity problems.
Support database modernization initiatives involving Oracle Cloud Infrastructure (OCI), Azure, or AWS.
Participate in Agile development activities, architecture reviews, and production support rotations.