Senior Oracle PL/SQL Developer – Remote

Bright Vision Technologies; United States; A distancia; USD 120.000 - 180.000; Jornada completa

Descripción de la vacante

Bright Vision Technologies is seeking an experienced Oracle PL/SQL Developer to design, develop, and optimize enterprise database solutions across high-volume systems. You will build scalable PL/SQL applications, optimize SQL queries, and ensure data integrity and security in Oracle environments.

You will collaborate with DBAs, developers, and analysts to enable cloud modernization and data integration across OCI/AWS/Azure platforms.

Formación

• 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/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, SQL*Plus, or similar Oracle development tools.

Responsabilidades

• 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 for business operations.
• Analyze execution plans and optimize database 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 code reviews, troubleshoot production issues, and resolve data integrity problems.
• Support OCI, Azure, or AWS cloud migrations of Oracle databases.

Conocimientos

Oracle PL/SQL

SQL optimization

Oracle DB 12c/19c

Query tuning

CI/CD pipelines

REST integration

Herramientas

SQL Developer

TOAD

SQL*Plus

Descripción del empleo

Bright Vision Technologies is seeking an experienced Oracle PL/SQL Developer to design, develop, and optimize enterprise database solutions across high-volume systems. You will build scalable PL/SQL applications, optimize SQL queries, and ensure data integrity and security in Oracle environments.

You will collaborate with DBAs, developers, and analysts to enable cloud modernization and data integration across OCI/AWS/Azure platforms.