PL/SQL Developer

State Center, IA, US • Posted 5 hours ago • Updated 5 hours ago
Contract W2
12 Months
No Travel Required
On-site
Depends on Experience
Fitment

Dice Job Match Score™

🔢 Crunching numbers...

Job Details

Skills

  • SQL Trace
  • Oracle Forms
  • Oracle RAC
  • PL/SQL
  • Performance Tuning
  • Pl/Sql Developer
  • Optimization
  • Oracle Data Integrator
  • Oracle Enterprise Manager
  • Git
  • Health Care
  • Informatica
  • Insurance
  • Database Performance Tuning
  • Extract, Transform, Load
  • Financial Services
  • Database Architecture
  • Database Design
  • Database Migration
  • Data Migration
  • Data Modeling
  • Data Validation
  • SQL
  • Database
  • Linux
  • Oracle
  • Problem Solving
  • Query Optimization
  • SQL Tuning
  • Scripting
  • Shell Scripting
  • Stored Procedures
  • Cloud Computing
  • Conflict Resolution
  • Data Integration
  • Testing
  • ADDM
  • Analytical Skill
  • Apache Subversion
  • Banking
  • Collaboration
  • Toad
  • Unix
  • Version Control

Summary

< data-pm-slice="1 3 []">Job Title: Senior PL/SQL Developer

Experience: 12 Years
Employment Type: Contract (W2)

Job Description

We are seeking an experienced Senior PL/SQL Developer with strong expertise in Oracle Database, PL/SQL programming, SQL development, performance tuning, and database optimization. The ideal candidate should have hands-on experience developing complex stored procedures, packages, functions, triggers, and database solutions for enterprise applications.

Key Responsibilities

  • Design, develop, and maintain complex PL/SQL procedures, packages, functions, and triggers.

  • Write and optimize complex SQL queries for large-scale databases.

  • Perform SQL and PL/SQL performance tuning and query optimization.

  • Develop database objects, views, indexes, and materialized views.

  • Analyze business requirements and translate them into technical database solutions.

  • Troubleshoot database performance issues and production defects.

  • Perform data migration, data validation, and data reconciliation.

  • Work with ETL processes and data integration solutions.

  • Collaborate with application developers, business analysts, and database administrators.

  • Support database deployments, testing, and production releases.

Required Technical Skills

  • Database: Oracle 11g, 12c, 19c, 21c.

  • Programming: PL/SQL, Advanced SQL.

  • PL/SQL Objects: Stored Procedures, Packages, Functions, Triggers, Cursors.

  • Performance Tuning: Explain Plan, AWR, ADDM, SQL Trace, Index Optimization.

  • Database Concepts: Partitioning, Materialized Views, Indexes, Joins.

  • ETL Tools: Informatica, Oracle Data Integrator (ODI).

  • Tools: SQL Developer, TOAD, Oracle Enterprise Manager.

  • Scripting: Unix/Linux Shell Scripting.

  • Version Control: Git, SVN.

Required Qualifications

  • 12+ years of experience in Oracle PL/SQL development.

  • Strong hands-on experience with complex SQL and PL/SQL programming.

  • Expertise in database performance tuning and optimization.

  • Experience working with large-volume transactional databases.

  • Knowledge of database design, data modeling, and troubleshooting.

  • Strong analytical and problem-solving skills.

Preferred Skills

  • Experience with Oracle Forms and Reports.

  • Knowledge of Oracle RAC and database architecture.

  • Experience with banking, financial services, insurance, or healthcare applications.

  • Exposure to cloud databases and database migration projects.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 10477291
  • Position Id: 9142572
  • Posted 5 hours ago
Contact the job poster
Jayesh Tanwar

Jayesh Tanwar

Recruiter @ Raas Infotek LLC

Create job alert
Never miss an opportunity! Create an alert based on the job you applied for.