Actively Hiring

Source for IT Talent

Senior Oracle PL/SQL Developer

Houston
|11 years of exp
|Full Time

Posted: 3 weeks ago

Job Location

Houston

Remote Work Policy

In office

Visa Sponsorship

Not Available

RelocationAllowed

Skills

Git

Svn

SCRUM

Jira

Agile

Windows

Data Migration

Unix Shell Scripting

Toad

Oracle PL/SQL

Stored procedures

indexing

Linux shell scripting

Collections

Oracle Database 11g

Production support

Incident Management

Etl Development

Exception Handling

QUERY OPTIMIZATION

SQL Loader

Oracle Data Pump

Oracle Sql Developer

Constraints

Triggers

SQL performance tuning

Packages

Synonyms

Azure DevOps

Dynamic Sql

Views

Oracle Database 19c

Functions

Impdp

Partitioning

SQL Trace

Execution Plans

Oracle Database 12c

Materialized Views

EXPLAIN PLAN

External Tables

Bulk Collect

AWR Reports

FORALL

Expdp

Oracle Scheduler

DBMS Jobs

XML Processing in Oracle

JSON Processing in Oracle

Oracle Tuning Techniques

About the job

Senior Oracle PL/SQL Developer (11+ Years Experience)

Professional Summary

Highly accomplished Senior Oracle PL/SQL Developer with over 11 years of experience in designing, developing, optimizing, and maintaining enterprise-grade database applications using Oracle technologies. Expertise in developing complex PL/SQL packages, procedures, functions, triggers, and performance tuning for mission-critical applications. Strong background in database design, ETL development, data migration, and integration with enterprise systems. Experienced in Agile development, production support, and delivering scalable, high-performance database solutions across Banking, Healthcare, Insurance, Retail, and Financial Services domains.

Key Skills

Oracle Database 11g/12c/19c
Oracle PL/SQL
SQL Performance Tuning
Stored Procedures, Packages, Functions, Triggers
Views, Materialized Views, Synonyms
Query Optimization & Execution Plans
Oracle SQL Developer, TOAD
Oracle Data Pump (EXPDP/IMPDP)
ETL Development & Data Migration
Unix/Linux Shell Scripting
Oracle Scheduler & DBMS Jobs
Indexing, Partitioning, Constraints
Bulk Collect, FORALL, Collections
Dynamic SQL
Exception Handling
XML, JSON Processing in Oracle
SQL Loader, External Tables
Git, SVN
Jira, Azure DevOps
Agile & Scrum
Production Support & Incident Management

Professional Experience

Designed and developed scalable Oracle database solutions for large enterprise applications.
Developed complex PL/SQL Packages, Procedures, Functions, Triggers, and Cursors to automate critical business processes.
Optimized SQL queries and PL/SQL programs, significantly improving application performance and reducing execution time.
Performed database performance tuning using Explain Plan, AWR Reports, SQL Trace, and Oracle tuning techniques.
Developed ETL processes for large-scale data extraction, transformation, and loading from multiple data sources.
Created and maintained database objects including tables, indexes, views, sequences, materialized views, and synonyms.
Implemented Bulk Collect, FORALL, Collections, and Dynamic SQL to enhance processing efficiency.
Worked extensively with Oracle Scheduler, DBMS Jobs, SQL Loader, and Data Pump utilities.
Developed robust exception handling, logging, and auditing mechanisms to improve application reliability.
Collaborated with application developers, architects, and business analysts to translate business requirements into technical solutions.
Supported database deployments, release management, and production issue resolution.
Participated in database migration, schema upgrades, and data validation activities.
Conducted code reviews and mentored junior developers on Oracle development best practices.
Worked in Agile/Scrum environments, participating in sprint planning, daily stand-ups, code reviews, and retrospectives.
Ensured database security, data integrity, and compliance with organizational standards.