PL/SQL Developer

Raas Infotek LLC
Texas City, United States of America
yesterday

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Texas City, United States of America

Tech stack

Java
Amazon Web Services (AWS)
Azure
Cloud Database
Code Review
Databases
Data Integration
ETL
Data Migration
Cursor (Graphical User Interface Elements)
Database Development
Database Security
DevOps
Python
Oracle
Oracle Applications
Oracle Forms
Oracle SQL Developer
Performance Tuning
Scrum
Query Optimization
Oracle APEX
Shell Script
PL-SQL
SQL*Plus
SQL Databases
Database Optimization
Database Performance
Information Technology
Toad (Software)

Job description

We are seeking an experienced Senior PL/SQL Developer with 12+ years of hands-on experience in Oracle database development, PL/SQL programming, and performance optimization. The ideal candidate should have strong expertise in designing, developing, and maintaining complex database solutions, ETL processes, and data integration workflows., * Design, develop, and maintain complex PL/SQL packages, procedures, functions, triggers, and views.

  • Develop and optimize Oracle SQL queries for high-performance applications.
  • Analyze and improve database performance through query tuning and indexing strategies.
  • Develop and support ETL processes and data migration activities.
  • Create and maintain database objects, schemas, and data models.
  • Collaborate with business analysts, developers, and stakeholders to gather requirements and deliver solutions.
  • Troubleshoot and resolve database-related issues in development, testing, and production environments.
  • Perform code reviews, implement best practices, and ensure adherence to coding standards.
  • Develop and maintain technical documentation and support release deployments.
  • Work closely with DevOps and application teams during production releases and support activities.

Requirements

  • 12+ years of experience in Oracle PL/SQL Development.
  • Strong expertise in Oracle Database 11g/12c/19c.
  • Extensive experience with PL/SQL Packages, Procedures, Functions, Triggers, Cursors, and Collections.
  • Strong knowledge of SQL Query Optimization and Performance Tuning.
  • Experience with Data Modeling, Data Migration, and ETL processes.
  • Hands-on experience with Oracle SQL Developer, TOAD, and SQL*Plus.
  • Experience with Unix/Linux shell scripting.
  • Strong understanding of Database Security, Backup, and Recovery concepts.
  • Experience working with Agile/Scrum methodologies.
  • Excellent analytical, troubleshooting, and communication skills.

Preferred Skills

  • Experience with Oracle Forms and Reports.
  • Knowledge of Oracle APEX.
  • Experience with Python or Java integration with Oracle databases.
  • Exposure to AWS, Azure, or cloud database environments.
  • Experience in Banking, Financial Services, Healthcare, or Insurance domains.

Education

  • Bachelor''s or Master''s degree in Computer Science, Information Technology, or a related field.

Nice to Have Certifications

  • Oracle Certified Professional (OCP)
  • Oracle Database SQL Certified Associate
  • Oracle PL/SQL Developer Certified Professional

Apply for this position