Senior Oracle PL/SQL Developer

Raas Infotek LLC
United States
about 2 months ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
10 years minimum
Working hours
Regular working hours
Job source

Tech stack

Amazon Web Services Microsoft Azure Code Review Databases Data Integration Extract Transform Load (ETL) Data Migration Data Warehousing Database Applications Database Design Revision Control Systems Oracle Databases
+16 more
Oracle Forms Oracle SQL Developer Performance Tuning Systems Development Life Cycle Query Optimization Release Management Oracle Apex Shell Script Software Deployment PL-SQL SQL Databases Subversion Database Optimization Database Performance Git Oracle Reports

Job description

We are looking for a Senior Oracle PL/SQL Developer with 10+ years of experience in designing, developing, and maintaining enterprise-level database applications. The candidate should possess strong expertise in Oracle PL/SQL development, database performance tuning, data migration, and production support., * Design, develop, and maintain complex Oracle PL/SQL programs, packages, procedures, functions, and triggers.

  • Optimize SQL queries and improve database performance.
  • Develop and support ETL processes, data integration, and data migration activities.
  • Analyze business requirements and provide scalable database solutions.
  • Troubleshoot and resolve database-related issues in development and production environments.
  • Create and maintain database objects, views, indexes, and materialized views.
  • Collaborate with Business Analysts, Developers, and QA teams throughout the SDLC.
  • Conduct code reviews and ensure adherence to coding standards and best practices.
  • Prepare technical documentation and deployment plans.
  • Support application releases and production deployments.

Requirements

  • 10+ years of hands-on experience in Oracle PL/SQL development.
  • Strong expertise in SQL, PL/SQL, Packages, Procedures, Functions, Triggers, and Views.
  • Experience with Oracle Database 12c/19c or higher.
  • Strong knowledge of query optimization and performance tuning.
  • Experience in data modeling, database design, and data migration.
  • Knowledge of ETL processes and data warehousing concepts.
  • Experience with Unix/Linux shell scripting.
  • Familiarity with Git, SVN, or other version control tools.
  • Strong analytical, troubleshooting, and communication skills.

Preferred Skills

  • Experience with Oracle APEX, Oracle Forms, or Oracle Reports.
  • Exposure to AWS, Azure, or other cloud platforms.
  • Experience working in Agile/Scrum environments.
  • Knowledge of banking, healthcare, insurance, or financial domains.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on dice.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

3:04 min

Database evolution and the funding behind vector databases

Erik Bamberg · LIVE

6:21 min

Investigating push inefficiencies with upstream Git experts

Jonathan Creamer · Coffee With Developers

1:06 min

Developer experience and project variety at scale

Alexandra Petri · WWC 2023

4:01 min

Managing application isolation via pluggable database models

Wei Hu Wei Hu · WWC 2022

56 sec

Favorite git commands and the importance of patch commits

Eileen Uchitelle Eileen Uchitelle +1 · Coffee With Developers

2:40 min

Evolving through early developer roles and technology stacks

Liam Hurrel +1 · WWC 2021

Videos

See all

Related articles

See all