Oracle PL/SQL Developer

🔥 12 hours ago

🇺🇸 United States – Remote

💵 $120k - $180k / year

⏰ Full Time

🟡 Mid-level

🟠 Senior

🖥 Software Engineer

🦅 H1B Visa Sponsor

This company has sponsored H1B visas in the past.

👻 Ghost score 20%

What it means: the chance that no one is really hiring for this job.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Bright Vision Technologies

WebsiteLinkedInAll Job Openings

51 - 200 employees

Founded 2020

💼 Consulting

🏥 Healthcare

🔒 Cybersecurity

Consulting • Healthcare • Cybersecurity

Bright Vision Technologies is a minority-owned organization, founded in July 2020, based in New Jersey, USA. The company specializes in delivering top-tier staffing and IT consulting services, particularly in the fields of Information Technology and Cybersecurity. Their mission emphasizes the importance of understanding client needs and providing quality solutions. Additionally, they focus on industrial engineering, hospital care services, and support for the United States Armed Services, demonstrating a commitment to empowering organizations through strategic staffing and application management.

📋 Description

• Design, develop, and maintain complex PL/SQL packages, stored procedures, functions, triggers, and database objects • Develop optimized SQL queries for large transactional and analytical databases • Design scalable schemas, indexing strategies, partitioning models, and performance optimization techniques • Build ETL processes and database integration components • Develop batch processing jobs and automated database workflows • Analyze execution plans, identify SQL bottlenecks, and optimize database performance • Collaborate with application developers on database access patterns and API integrations • Implement database security, auditing, role-based access controls, and data encryption • Develop database migration scripts, deployment packages, and release automation processes • Perform code reviews, troubleshoot production issues, and resolve data integrity problems • Support database modernization initiatives involving OCI, Azure, or AWS • Participate in Agile activities, architecture reviews, and production support rotations • Contribute to database architecture, cloud migration, production support, and continuous improvement of enterprise Oracle platforms

🎯 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, CTEs, analytical functions, window functions, and query optimization • Extensive experience with Oracle Database 12c, 19c, or newer • Strong understanding of Oracle indexing, partitioning, materialized views, execution plans, and optimizer statistics • Experience optimizing high-volume OLTP and OLAP workloads • Hands-on experience with Oracle SQL Developer, TOAD, SQL*Plus, or similar tools • Experience developing ETL processes and integrating Oracle databases with external systems • Familiarity with Oracle Data Pump, RMAN, and database migration methodologies • Experience with Oracle Advanced Queuing, Scheduler, and database jobs • Experience integrating Oracle databases with Java, .NET, Python, or REST-based applications • Understanding of database normalization, data modeling, and relational database design • 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 environments • U.S. work authorization as a U.S. Citizen, Green Card Holder, EAD Holder, or H-1B transfer candidate; new H-1B sponsorship unavailable • Preferred: Oracle Cloud Infrastructure Database Services or Autonomous Database experience • Preferred: Oracle Exadata, RAC, Data Guard, GoldenGate, OIC, Oracle SOA Suite, or Oracle APEX experience • Preferred: Financial, healthcare, insurance, retail, or government enterprise application experience • Preferred: Shell scripting, Python, or PowerShell for database automation • Preferred: Enterprise data warehousing and dimensional modeling knowledge • Oracle Database Administration or OCP certifications highly desirable • Preferred: Experience supporting regulated environments requiring auditability, compliance, and data governance

🏖️ Benefits

• Comprehensive benefits • Competitive compensation packages • Supportive work-life balance • Career growth potential • Continuous learning and growth opportunities

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume