Senior PL/SQL Developer

Raas Infotek LTD; Texas City (TX); On-site; USD 120,000 - 160,000; Full time

Job summary

Raas Infotek LTD is seeking a Senior PL/SQL Developer with 12+ years of hands-on experience in Oracle database development, PL/SQL programming, performance tuning, and enterprise application development. The role focuses on complex database solutions, stored procedures, and scalable data processing.

The candidate will design, optimize, and deploy PL/SQL components, work with large-scale data environments, and mentor junior developers across multiple environments.

Qualifications

• 12+ years of hands-on PL/SQL development experience.
• Extensive Oracle DB knowledge (11g/12c/18c/19c/21c).
• Experience with performance tuning & optimization.
• Experience with ETL/ODI or Informatica.
• Strong SQL query optimization and indexing strategies.

Responsibilities

• Design, develop, test, and maintain complex Oracle PL/SQL applications.
• Develop stored procedures, packages, triggers, and complex SQL queries.
• Analyze requirements and translate into scalable database solutions.
• Perform SQL/PL/SQL performance tuning and query optimization.
• Collaborate with DBAs, developers, and data engineers.

Skills

PL/SQL development

Oracle Database

Performance tuning

ETL/ODI/Informatica

SQL optimization

Data modeling

Tools

Oracle SQL*Loader

AWR/ADDM

Jenkins/Azure DevOps

Job description

Senior PL/SQL Developer – 12+ Years

Job Title: Senior PL/SQL Developer / Lead Oracle Developer

Experience: 12+ Years

Job Type: W2Contract / Full-Time

Job Summary

We are seeking a highly experienced Senior PL/SQL Developer with 12+ years of hands-on experience in Oracle database development, PL/SQL programming, performance tuning, and enterprise application development. The ideal candidate will have strong expertise in designing complex database solutions, developing stored procedures and packages, optimizing SQL queries, and working with large-scale data environments.

Key Responsibilities

• Design, develop, test, and maintain complex Oracle PL/SQL applications.
• Develop stored procedures, functions, packages, triggers, views, cursors, and complex SQL queries.
• Analyze business requirements and translate them into scalable database solutions.
• Perform SQL and PL/SQL performance tuning and optimization.
• Analyze execution plans and optimize queries, indexes, partitions, and database objects.
• Develop and maintain ETL/data integration processes using Oracle technologies.
• Work with large-volume transactional and analytical databases.
• Develop data migration and conversion scripts.
• Implement database solutions following coding, security, and performance best practices.
• Troubleshoot production issues and perform root-cause analysis.
• Participate in database design, data modeling, and technical architecture discussions.
• Perform code reviews and ensure development standards are followed.
• Collaborate with application developers, DBAs, data engineers, QA teams, and business stakeholders.
• Mentor junior developers and provide technical guidance.
• Support deployment activities across development, QA, UAT, and production environments.

Required Technical Skills

Oracle / PL/SQL

• 12+ years of strong PL/SQL development experience
• Oracle Database 11g/12c/18c/19c/21c
• Advanced SQL
• Stored Procedures
• Functions
• Packages
• Triggers
• Cursors
• Views
• Materialized Views
• Collections
• Exception Handling
• Dynamic SQL
• Database Jobs / Scheduler
• Database Links

Performance Tuning

• SQL Query Optimization
• Explain Plans
• Execution Plans
• Indexing Strategies
• Partitioning
• Optimizer Statistics
• AWR / ADDM
• Performance Troubleshooting
• High-volume data processing

Data & ETL

• ETL/ELT processes
• Data Migration
• Data Transformation
• Data Validation
• Oracle Data Integrator (ODI)
• Informatica
• SQL*Loader
• External Tables
• Bulk Collect / FORALL

Development & Integration

• REST/SOAP API integration
• XML / JSON
• Java or Java-based application integration
• Unix/Linux shell scripting
• Git
• CI/CD
• Jenkins / Azure DevOps

Database & Data Modeling

• Relational Database Design
• Data Modeling
• Normalization / Denormalization
• ER Diagrams
• Logical and Physical Data Models
• Data Integrity
• Referential Integrity
• Database Security
• Transaction Management

Cloud & Modern Technologies — Preferred

• Oracle Cloud Infrastructure (OCI)
• AWS / Azure
• Autonomous Database
• Oracle Database Cloud Services
• Cloud database migration
• Modernization of legacy Oracle applications

Domain Experience

Experience in one or more of the following domains is preferred:

• Banking & Financial Services
• Healthcare
• Insurance
• Retail
• Telecom
• Government
• Manufacturing