Oracle PL/SQL Developer

TechDigital Group; Orlando (FL); On-site; USD 100,000 - 130,000; Full time

Job summary

TechDigital Group is looking for a skilled PL/SQL Developer to join their Orlando team. This role involves designing and maintaining complex PL/SQL solutions and optimizing database performance in cloud environments like AWS and Azure.

The ideal candidate will have 7-12 years of experience in Oracle PL/SQL development, a strong focus on collaboration with architects and business teams, and a commitment to data quality and governance.

Qualifications

• 7-12+ years of strong hands-on Oracle PL/SQL development experience.
• Deep expertise in PL/SQL packages, procedures, functions, triggers.
• Advanced SQL and performance tuning capabilities.

Responsibilities

• Design, develop, and maintain complex PL/SQL packages and procedures.
• Collaborate with architects on data modeling and indexing strategies.
• Optimize database workloads for cloud performance and scalability.

Skills

Oracle PL/SQL

SQL performance tuning

Cloud-based data warehousing

ETL processes

Data analysis

Education

Bachelor's degree in computer science, IT, or related field

Tools

Oracle Database (11g/12c/19c or higher)

Amazon Redshift

Oracle Autonomous Data Warehouse (ADW)

Unix/Linux

Git

Job description

• We are seeking a highly skilled and experienced PL/SQL Developer with exposure to cloud platforms (AWS or Azure) to build, optimize, and maintain high-performance database solutions.
• This is a hands‑on individual contributor role requiring deep expertise in Oracle PL/SQL along with the ability to work in modern cloud‑enabled data environments.

Key Responsibilities

PL/SQL Development

• Design, develop, and maintain complex PL/SQL packages, procedures, functions, and triggers.
• Write efficient, scalable, and reusable database code.
• Develop and optimize complex SQL queries for large‑scale data processing and reporting.
• Troubleshoot and resolve database‑related performance and production issues.

Database Design & Performance Optimization

• Collaborate with architects and DBAs on data modeling, schema design, and indexing strategies.
• Perform advanced query tuning using explain plans and performance tools.
• Optimize database workloads for high‑volume and high‑throughput systems.
• Ensure data consistency, integrity, and performance across systems.

Cloud Integration (AWS / Azure)

• Work with databases deployed on cloud platforms (AWS RDS, Aurora, Azure SQL, Oracle on Cloud).
• Support migration of on‑prem databases to cloud environments.
• Optimize database workloads for cloud performance, scalability, and cost efficiency.
• Integrate PL/SQL‑based systems with cloud services, APIs, and data pipelines.
• Collaborate with cloud engineers on architecture and deployment strategies.
• Data Processing & ETL
• Develop and maintain ETL processes, batch jobs, and data pipelines.
• Handle large datasets efficiently in both on‑premises and cloud environments.
• Support data transformation, ingestion, and reporting needs.

Quality & Standards

• Follow best practices for coding, version control, and documentation.
• Conduct self‑reviews and participate in peer code reviews.
• Ensure compliance with performance, security, and data governance standards.

Collaboration

• Partner with business analysts, application teams, and cloud architects to deliver solutions.
• Participate in technical design discussions and provide database expertise.
• Support testing, deployment, and release cycles.

Production Support

• Provide L2/L3 support for database and data‑related issues.
• Diagnose and resolve performance bottlenecks and failures.
• Monitor systems and proactively improve stability and efficiency.

Required Qualifications

• Bachelor's degree in computer science, IT, or related field.
• 7–12+ years of strong hands‑on Oracle PL/SQL development experience.
• Deep expertise in: PL/SQL (packages, procedures, functions, triggers)
• Advanced SQL and performance tuning
• Oracle Database (11g/12c/19c or higher)

Cloud Requirements (Must Have / Strongly Preferred)

• Hands‑on experience with: Oracle Autonomous Data Warehouse (ADW) on Azure
• Amazon Redshift
• Strong understanding of: Cloud‑based data warehousing architectures
• Performance tuning in ADW and Redshift environments
• Workload management, query optimization, and storage strategies in cloud DW platforms
• Experience in: Managing and optimizing cloud data processing for scalability and cost efficiency
• Familiarity with: Azure ecosystem (e.g., networking, security, integration with ADW)
• AWS ecosystem (e.g., S3, IAM, data ingestion into Redshift)

Preferred Skills

• Experience with data warehousing and large‑scale data processing.
• Knowledge of performance tuning tools (AWR, ASH, SQL Trace).
• Familiarity with Unix/Linux shell scripting.
• Experience with ETL frameworks/tools.
• Exposure to CI/CD pipelines and DevOps practices.
• Experience with version control tools (Git).

Soft Skills

• Strong analytical and problem‑solving skills.
• Ability to work independently in an individual contributor role.
• Excellent communication and collaboration abilities.
• Detail‑oriented with strong focus on performance and quality.