Oracle PLSQL Developer
Share
Job Location:
Orlando, FL - USA
Monthly Salary:
Not Disclosed
Posted on:
13 hours ago
Vacancies:
1 Vacancy
Job Summary
- 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
- Bachelors 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.
