Senior Oracle PL/SQL Developer

Raas Infotek; Carolina Beach (NC); On-site; USD 286,541,000 - 371,952,000; Full time

Job summary

Raas Infotek is seeking a Senior Oracle PL/SQL Developer with 10+ years of Oracle database development experience for a Contract W2 engagement in North Carolina. The role focuses on PL/SQL programming, performance tuning, and enterprise data solutions.

You will design and implement complex database components, optimize SQL and PL/SQL, and support ETL processes, while collaborating with business and application teams in an Agile environment.

Qualifications

• 10+ years of Oracle PL/SQL development experience.
• Strong SQL/PLSQL, performance tuning and data modeling.
• Experience with Agile/Scrum environments.
• Experience with data migration and data integration.
• Experience with large-scale Oracle databases and complex PL/SQL programming.

Responsibilities

• Design, develop, and maintain complex Oracle PL/SQL programs, packages, procedures, functions, triggers, and cursors.
• Develop complex SQL queries, views, materialized views, and database objects per business requirements.
• Perform Oracle database performance tuning, including query optimization, indexing, execution plans, and SQL tuning.
• Analyze and resolve database-related performance and production issues.
• Develop and optimize ETL/data integration processes involving Oracle databases.
• Collaborate with application developers, business analysts, QA teams, and other technical teams.
• Mentor junior developers and provide technical guidance to the team.
• Create technical documentation for database processes and solutions.

Skills

Oracle PL/SQL

SQL tuning

Performance tuning

ETL data integration

Agile/Scrum

Unix/Linux

Data modeling

Code reviews

Mentoring

Oracle database design

Education

Bachelor's degree

Tools

Informatica PowerCenter / IICS

Git / Jenkins / CI/CD

Unix/Linux scripting

Cloud DB environments (AWS/Azure/GCP)

Job description

Experience: 10+ Years

Role: Senior Oracle PL/SQL Developer

Employment Type: Contract W2

Role Overview

We are looking for an experienced Senior Oracle PL/SQL Developer with 10+ years of experience in Oracle database development, PL/SQL programming, performance tuning, and enterprise application support. The ideal candidate should have strong experience designing and developing complex database solutions, writing high-performance SQL/PLSQL code, and working closely with application and business teams.

The candidate will be responsible for developing database components, optimizing existing solutions, troubleshooting production issues, and contributing to technical design and architecture discussions.

Key Responsibilities

• Design, develop, and maintain complex Oracle PL/SQL programs, packages, procedures, functions, triggers, and cursors.
• Develop complex SQL queries, views, materialized views, and database objects based on business requirements.
• Perform Oracle database performance tuning, including query optimization, indexing, execution plans, and SQL tuning.
• Analyze and resolve database-related performance and production issues.
• Develop and optimize ETL/data integration processes involving Oracle databases.
• Work with large volumes of transactional and analytical data while ensuring performance and scalability.
• Participate in database design, data modeling, and technical solution discussions.
• Develop reusable PL/SQL components and establish coding standards and best practices.
• Perform data analysis, reconciliation, validation, and migration activities.
• Troubleshoot production issues and provide root-cause analysis and permanent solutions.
• Collaborate with application developers, business analysts, QA teams, and other technical teams.
• Participate in code reviews and ensure development follows established standards.
• Support database deployments across development, QA, UAT, and production environments.
• Create technical documentation for database processes, procedures, and solutions.
• Mentor junior developers and provide technical guidance to the development team.

Required Technical Skills

• 10+ years of Oracle PL/SQL development experience
• Strong expertise in Oracle SQL and PL/SQL
• Oracle Stored Procedures, Functions, Packages, Triggers, Cursors
• Complex SQL queries and query optimization
• Oracle performance tuning and troubleshooting
• Execution Plans, Indexing, Partitioning, and SQL optimization
• Oracle database design and data modeling
• Strong understanding of relational databases and database concepts
• Experience with data migration and data integration
• Strong debugging and problem-solving skills
• Experience working in Agile/Scrum environments
• Strong communication and collaboration skills

Preferred Skills

• Oracle 11g/12c/19c experience
• Experience with Informatica PowerCenter/IICS or other ETL tools
• Experience with Unix/Linux shell scripting
• Experience with database migration and modernization projects
• Knowledge of AWS/Azure/Google Cloud Platform cloud database environments
• Experience with Git, Jenkins, CI/CD, or other DevOps tools
• Experience working with REST APIs and application integration
• Knowledge of Oracle RAC, Data Guard, or high-availability environments
• Experience with financial services, banking, healthcare, or other enterprise applications

Education

Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field is preferred.

Soft Skills

• Strong analytical and problem-solving abilities
• Excellent communication and interpersonal skills
• Ability to work independently and take ownership of technical deliverables
• Strong stakeholder management skills
• Ability to mentor and guide junior developers
• Comfortable working in a fast-paced Agile environment