Remote Oracle PL/SQL Developer – High-Volume OLTP/Data

Bright Vision Technologies; Overland Park (KS); Remote; USD 120,000 - 180,000; Full time

Job summary

Bright Vision Technologies is seeking an experienced Oracle PL/SQL Developer to design, develop, and optimize enterprise database solutions supporting high‑volume transactional systems, regulatory reporting, and mission‑critical operations across Oracle environments.

You will work closely with application developers, DBAs, data architects, QA engineers, and business analysts to build scalable PL/SQL applications, optimize queries, and ensure high availability.

Qualifications

• 6+ years of professional Oracle database development.
• Deep expertise in PL/SQL, packages, procedures, and dynamic SQL.
• Strong SQL with complex joins and analytic functions.
• Experience with large Oracle environments (12c/19c+).

Responsibilities

• Design, develop, and maintain PL/SQL packages and database objects.
• Develop optimized SQL queries for large transactional databases.
• Design scalable schemas, indexing, and partitioning strategies.
• Build ETL processes and integration components.
• Develop batch jobs and automated database workflows.
• Analyze execution plans and optimize performance.
• Collaborate with developers to optimize data access patterns.
• Implement security, auditing, and data encryption standards.
• Create migration scripts and release automation.
• Troubleshoot production issues and ensure data integrity.
• Support OCI/AWS/Azure cloud migration initiatives.
• Participate in Agile development and production rotations.

Skills

Oracle PL/SQL

SQL performance tuning

SQL optimization

Database design

Cloud familiarity

Agile/Scrum

REST integration

Tools

Oracle SQL Developer

TOAD

SQL*Plus

Git/Azure DevOps

Job description

Bright Vision Technologies is seeking an experienced Oracle PL/SQL Developer to design, develop, and optimize enterprise database solutions supporting high‑volume transactional systems, regulatory reporting, and mission‑critical operations across Oracle environments.

You will work closely with application developers, DBAs, data architects, QA engineers, and business analysts to build scalable PL/SQL applications, optimize queries, and ensure high availability.