Remote Senior Oracle PL/SQL Developer

Bright Vision Technologies; Frisco (TX); 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 for high-volume transactional systems and regulatory reporting. You will work with developers, DBAs, data architects, QA, and business analysts to build scalable PL/SQL applications with secure data handling.

The ideal candidate has deep Oracle Database experience, advanced PL/SQL programming, and strong query optimization skills.

Qualifications

• Six+ years of professional experience developing enterprise Oracle database solutions.
• Strong expertise in Oracle PL/SQL including packages, procedures, functions, cursors, triggers, collections, exceptions, and dynamic SQL.
• Advanced SQL development skills with complex joins, CTEs, analytical and window functions.
• Extensive experience with Oracle Database 12c, 19c, or newer enterprise environments.

Responsibilities

• Design, develop, and maintain complex PL/SQL packages, procedures, functions, and database objects.
• Develop highly 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 data movement and synchronization.
• Develop batch processing jobs and automated database workflows.
• Analyze execution plans, identify SQL bottlenecks, and optimize performance for high-volume systems.
• Collaborate with application teams to design efficient database access patterns and API integrations.
• Implement database security, auditing, and data encryption standards.
• Develop migration scripts, deployment packages, and release automation processes.
• Perform database code reviews and troubleshoot production issues.

Skills

Oracle PL/SQL

SQL Tuning

Oracle 12c/19c

ETL Development

CI/CD Pipelines

Git

Azure DevOps

Oracle SQL Developer

TOAD

Tools

Oracle SQL Developer

TOAD

Git

Azure DevOps

Job description

Bright Vision Technologies is seeking an experienced Oracle PL/SQL Developer to design, develop, and optimize enterprise database solutions for high-volume transactional systems and regulatory reporting. You will work with developers, DBAs, data architects, QA, and business analysts to build scalable PL/SQL applications with secure data handling.

The ideal candidate has deep Oracle Database experience, advanced PL/SQL programming, and strong query optimization skills.