Impress employers and recruiters.
Choose from hundreds of resume examples.
Impress employers and recruiters.
Choose from hundreds of resume examples.
Tailor your resume to this Oracle PL/SQL Developer role.
Rezi rewrites your resume against Bright Vision Technologies's job description. Free.
Tailor your resume to this Oracle PL/SQL Developer role.
Rezi rewrites your resume against Bright Vision Technologies's job description. Free.
Don't guess if your resume is good enough.
See how it scores against the Oracle PL/SQL Developer posting at Bright Vision Technologies — free, in seconds.
Don't guess if your resume is good enough.
See how it scores against the Oracle PL/SQL Developer posting at Bright Vision Technologies — free, in seconds.
About the Role
We are seeking an experienced Oracle PL/SQL Developer to design, develop, and optimize enterprise database solutions supporting high-volume transactional systems, financial applications, regulatory reporting, and mission-critical business operations. This role focuses on building scalable PL/SQL applications, optimizing complex SQL queries, developing database objects, and ensuring high availability and performance across large Oracle environments.
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.
- Develop database migration scripts, deployment packages, and release automation processes.
- Perform database code reviews, troubleshoot production issues, and resolve complex 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.
Requirements
- 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, Common Table Expressions (CTEs), analytical functions, 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.
- Experience developing ETL processes and integrating Oracle databases with external systems.
- Familiarity with Oracle Data Pump, RMAN, and database migration methodologies.
- Experience working 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.
Skills
- Oracle PL/SQL
- SQL
- ETL
- Database Schema Design
- Indexing
- Partitioning
- Performance Tuning
- Database Security
- Database Migration
- Agile Methodologies
- Oracle Cloud Infrastructure (OCI)
- Azure
- AWS
- Git
- Azure DevOps
- Jenkins
- CI/CD
Location
- 100% Remote (U.S.)
Work Type
- Full-time
- Direct W2
Experience Level
- 6+ years
Salary/Compensations
- $120,000–$180,000 Annually
About the Company
- Bright Vision Technologies is a technology consulting and software development company delivering cloud, AI, data, and enterprise solutions across the United States.
- This is a fantastic opportunity to join an established and well-respected organization offering tremendous career growth potential.
Equal Opportunity
- Bright Vision Technologies is an Equal Opportunity Employer.
- Bright Vision Technologies (BV Teck) is committed to equal employment opportunity (EEO) for all employees and applicants without regard to race, color, religion, sex, sexual orientation, gender identity or expression, national origin, age, genetic information, disability, veteran status, or any other protected status as defined by applicable federal, state, or local laws.
- This commitment extends to all aspects of employment, including recruitment, hiring, training, compensation, promotion, transfer, leaves of absence, termination, layoffs, and recall.
- BV Teck expressly prohibits any form of workplace harassment or discrimination.
- Any improper interference with employees' able to perform their job duties may result in disciplinary action up to and including termination of employment.