Develop and optimize enterprise Oracle database solutions using PL/SQL and advanced SQL. Responsibilities include building database objects, ETL processes, batch jobs, schemas, integrations, security controls, migration scripts, and deployment automation. The role emphasizes performance tuning, high-volume OLTP and OLAP workloads, troubleshooting, data integrity, cloud modernization, production support, and collaboration with application, architecture, QA, and business teams.
Oracle PL/SQL Developer – Remote
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.
Job Title: Oracle PL/SQL Developer
Location: 100% Remote (U.S.)
Position Type: Full-time, Direct W2
Salary Range: $120,000–$180,000 Annually
Experience Required: 6+ years
Sponsorship: U.S. Citizens, Green Card Holders, EAD Holders, and H-1B transfer candidates are encouraged to apply. We are unable to sponsor new H-1B visa petitions for this position.
Job Summary
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.
You will work closely with application developers, database administrators, data architects, QA engineers, and business analysts to build efficient database solutions that support enterprise applications, cloud modernization initiatives, and data integration platforms. The ideal candidate possesses deep expertise in Oracle Database technologies, advanced PL/SQL programming, query optimization, and performance tuning while maintaining high standards for data integrity, security, and reliability.
Key Responsibilities
Required Skills
Preferred Qualifications
Project Environment
You will be joining an enterprise data engineering and application modernization team responsible for supporting mission-critical Oracle database platforms serving multiple business units. Current initiatives include:
How to Apply
Would you like to know more about this opportunity? For immediate consideration, please send your resume to [email protected] or contact us at (908) 676-4399. Learn more about Bright Vision Technologies at www.bvteck.com.
Bright Vision Technologies is an Equal Opportunity Employer.
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.
Job Title: Oracle PL/SQL Developer
Location: 100% Remote (U.S.)
Position Type: Full-time, Direct W2
Salary Range: $120,000–$180,000 Annually
Experience Required: 6+ years
Sponsorship: U.S. Citizens, Green Card Holders, EAD Holders, and H-1B transfer candidates are encouraged to apply. We are unable to sponsor new H-1B visa petitions for this position.
Job Summary
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.
You will work closely with application developers, database administrators, data architects, QA engineers, and business analysts to build efficient database solutions that support enterprise applications, cloud modernization initiatives, and data integration platforms. The ideal candidate possesses deep expertise in Oracle Database technologies, advanced PL/SQL programming, query optimization, and performance tuning while maintaining high standards for data integrity, security, and reliability.
Key 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.
Required Skills
- 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.
Preferred Qualifications
- Experience working with Oracle Cloud Infrastructure (OCI) Database Services or Autonomous Database.
- Familiarity with Oracle Exadata, RAC (Real Application Clusters), and Data Guard environments.
- Experience with Oracle GoldenGate, Oracle Integration Cloud (OIC), or Oracle SOA Suite.
- Knowledge of Oracle APEX application development.
- Experience developing financial, healthcare, insurance, retail, or government enterprise applications.
- Familiarity with cloud migration strategies from on-premises Oracle databases to OCI, Azure, or AWS.
- Experience with shell scripting, Python, or PowerShell for database automation.
- Knowledge of enterprise data warehousing and dimensional modeling concepts.
- Oracle Database Administration or Oracle Certified Professional (OCP) certifications are highly desirable.
- Experience supporting highly regulated environments requiring auditability, compliance, and data governance.
Project Environment
You will be joining an enterprise data engineering and application modernization team responsible for supporting mission-critical Oracle database platforms serving multiple business units. Current initiatives include:
- Enterprise financial transaction processing systems
- Healthcare claims and patient management platforms
- Insurance policy administration and billing systems
- Large-scale ERP and supply chain applications
- Cloud migration of Oracle databases to Oracle Cloud Infrastructure (OCI)
- Regulatory reporting and compliance data platforms
- Enterprise data integration and batch processing solutions
- High-availability Oracle environments supporting millions of daily transactions
- Performance optimization and modernization of legacy PL/SQL applications
How to Apply
Would you like to know more about this opportunity? For immediate consideration, please send your resume to [email protected] or contact us at (908) 676-4399. Learn more about Bright Vision Technologies at www.bvteck.com.
Bright Vision Technologies is an Equal Opportunity Employer.
Similar Jobs
Information Technology • Software
Develop and optimize Oracle databases for high-volume government applications. Responsibilities include data modeling, database architecture, SQL and PL/SQL development, performance tuning, testing, production support, reusable database object development, technical design, code-quality standards, peer reviews, documentation, and CI/CD integration for database changes. The role may also contribute to Java Spring Boot microservices and Angular/TypeScript front-end applications while collaborating with development, DevSecOps, design, and analytics teams.
Top Skills:
AngularAshAwrAws RdsDockerFlywayGitGithub ActionsGitlab CiJavaJenkinsKubernetesLiquibaseOciOracle RdbmsPl/SqlReactSpring BootSQLTypescriptUtplsqlVue
Automotive • Big Data • Information Technology • Robotics • Software • Transportation • Manufacturing
Designs and leads scalable cloud applications, virtualization platforms, and automation for embedded software development and co-simulation. Responsibilities include architecting multi-region cloud infrastructure, developing deployment and maintenance automation, integrating regression testing workflows into CI/CD, and supporting cybersecurity, scalability, resiliency, and cost optimization. The role serves as a subject matter expert, leads cross-functional integrations, collaborates with suppliers, and presents technical solutions to leadership and external organizations.
Top Skills:
AutovalAWSAzureAzure Event GridAzure Event HubsAzure Service BusBicepCC++CaplCi/CdClaudeCursorDockerDspace SystemdeskEcsGCPGerritGitGithub ActionsGithub CopilotGleanIntrepid Vehicle SpyJavaJenkinsKubernetesMicronautMicrosoft 365 CopilotPythonQuarkusSingularitySpring BootSystemcTerraformVector CanapeVector CanoeVeos
Automotive • Big Data • Information Technology • Robotics • Software • Transportation • Manufacturing
The Senior Fullstack/Frontend Engineer will architect and implement scalable frontend systems for AV mapping applications, collaborating with cross-functional teams to enhance user experience and performance in autonomous driving technologies.
Top Skills:
D3.JsDeck.GlGraphQLJavaScriptMapbox GlNode.jsOpenlayersReactReduxRestful ApisTypescriptWebsocketsZustand
What you need to know about the NYC Tech Scene
As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory
