Remote Oracle PL/SQL Developer – Enterprise DB Optimization

Bright Vision Technologies; Round Rock (TX); On-site; USD 120,000 - 180,000; Full time

Job summary

Bright Vision Technologies is seeking an experienced Oracle PL/SQL Developer for a 100% remote, U.S.-based role. You will design, develop, and optimize database solutions supporting high-volume transactional systems and regulatory reporting, while collaborating across DBA, QA, and analytics teams.

Strong PL/SQL, SQL optimization, and cloud integration experience are essential. The position emphasizes scalable database design, performance tuning, and secure data management within OCI/AWS/Azure

Qualifications

• 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.

Responsibilities

• Design, develop, and maintain complex PL/SQL packages, stored procedures, functions, triggers, and database objects supporting enterprise applications.
• 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 enterprise data movement and synchronization.
• Develop batch processing jobs and automated database workflows supporting business-critical operations.
• Analyze execution plans, identify SQL bottlenecks, and optimize database 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.

Skills

Oracle PL/SQL

SQL optimization

Performance tuning

Agile Scrum

Database design

Tools

Oracle SQL Developer

TOAD

SQL*Plus

Git

Azure DevOps

Jenkins

Job description

Bright Vision Technologies is seeking an experienced Oracle PL/SQL Developer for a 100% remote, U.S.-based role. You will design, develop, and optimize database solutions supporting high-volume transactional systems and regulatory reporting, while collaborating across DBA, QA, and analytics teams.

Strong PL/SQL, SQL optimization, and cloud integration experience are essential. The position emphasizes scalable database design, performance tuning, and secure data management within OCI/AWS/Azure