Senior Oracle PL/SQL Developer

Senior Oracle PL/SQL Developer

Posted 1 week ago by Raas Infotek LLC

Apply
Negotiable
Undetermined
Hybrid
Remote or Hybrid in Chicago, Illinois
Apply
Agile Methodology Amazon Web Services (AWS) Banking Business Requirements Cloud Computing Cloud Infrastructure Cloud Technology Computer Science Database Design Database Security Data Integrity Data Migration Datamodel Data Modeling Data Processing Design Elements And Principles Exception Handling Extract Transform Load (ETL) General Insurance Generic Programming Git (Version Control System) Indexing Information Technology Management Oracle Cloud Oracle Databases Performance Tuning PL/SQL Query Optimisation Root Cause Analysis Scripting Software Coding Software Development SQL (Programming Language) Stakeholder Management Version Control

Summary: We are seeking a Senior Oracle PL/SQL Developer with over 12 years of experience in designing, developing, and optimizing enterprise-grade database applications. The candidate should have deep expertise in Oracle Database, PL/SQL programming, and performance tuning, with a preference for those experienced in Agile environments. This role involves collaboration with cross-functional teams to deliver high-quality database solutions.

Key Responsibilities:

  • Design, develop, test, and maintain complex Oracle PL/SQL programs, packages, procedures, functions, triggers, and views.
  • Develop and optimize high-performance SQL queries for large-scale transactional and analytical systems.
  • Perform database performance tuning, query optimization, and troubleshooting using Oracle tools and best practices.
  • Analyze business requirements and translate them into efficient database solutions.
  • Design and implement data models and database objects based on application requirements.
  • Support data migration, ETL processes, and integration activities involving Oracle databases.
  • Conduct code reviews, enforce coding standards, and mentor junior developers.
  • Collaborate with application developers, business analysts, QA teams, and DBAs throughout the software development lifecycle.
  • Create and maintain technical design documents, deployment guides, and support documentation.
  • Participate in production support activities, root cause analysis, and issue resolution.
  • Ensure database security, data integrity, and compliance with organizational standards.
  • Contribute to release planning, estimation, and Agile ceremonies.

Key Skills:

  • Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
  • 12+ years of experience in Oracle database development.
  • Strong expertise in Oracle PL/SQL, including packages, procedures, functions, triggers, collections, and exception handling.
  • Extensive experience in writing complex SQL queries, joins, subqueries, and analytical functions.
  • Hands-on experience with performance tuning using execution plans, SQL Trace, TKPROF, AWR, and Oracle tuning techniques.
  • Experience working with Oracle 11g/12c/19c environments.
  • Strong understanding of database design principles, normalization, and indexing strategies.
  • Experience with data migration, bulk data processing, and ETL methodologies.
  • Proficiency in using version control systems such as Git or similar tools.
  • Excellent analytical, troubleshooting, and problem-solving skills.
  • Strong verbal and written communication abilities.

Salary (Rate): £70,000 yearly

City: Chicago

Country: United States

Working Arrangements: hybrid

IR35 Status: undetermined

Seniority Level: Senior

Industry: IT

Detailed Description From Employer:

Job Title: Senior Oracle PL/SQL Developer
Experience: 12+ Years
Location: [Onsite/Hybrid/Remote]

Job Summary

We are seeking an experienced Senior Oracle PL/SQL Developer with 12+ years of hands-on experience in designing, developing, optimizing, and supporting enterprise-grade database applications. The ideal candidate should possess deep expertise in Oracle Database, PL/SQL programming, performance tuning, data migration, and complex SQL development. Experience working in Agile environments and collaborating with cross-functional teams is highly desirable.

Key Responsibilities

  • Design, develop, test, and maintain complex Oracle PL/SQL programs, packages, procedures, functions, triggers, and views.
  • Develop and optimize high-performance SQL queries for large-scale transactional and analytical systems.
  • Perform database performance tuning, query optimization, and troubleshooting using Oracle tools and best practices.
  • Analyze business requirements and translate them into efficient database solutions.
  • Design and implement data models and database objects based on application requirements.
  • Support data migration, ETL processes, and integration activities involving Oracle databases.
  • Conduct code reviews, enforce coding standards, and mentor junior developers.
  • Collaborate with application developers, business analysts, QA teams, and DBAs throughout the software development lifecycle.
  • Create and maintain technical design documents, deployment guides, and support documentation.
  • Participate in production support activities, root cause analysis, and issue resolution.
  • Ensure database security, data integrity, and compliance with organizational standards.
  • Contribute to release planning, estimation, and Agile ceremonies.

Required Qualifications

  • Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field.
  • 12+ years of experience in Oracle database development.
  • Strong expertise in Oracle PL/SQL, including packages, procedures, functions, triggers, collections, and exception handling.
  • Extensive experience in writing complex SQL queries, joins, subqueries, and analytical functions.
  • Hands-on experience with performance tuning using execution plans, SQL Trace, TKPROF, AWR, and Oracle tuning techniques.
  • Experience working with Oracle 11g/12c/19c environments.
  • Strong understanding of database design principles, normalization, and indexing strategies.
  • Experience with data migration, bulk data processing, and ETL methodologies.
  • Proficiency in using version control systems such as Git or similar tools.
  • Excellent analytical, troubleshooting, and problem-solving skills.
  • Strong verbal and written communication abilities.

Preferred Qualifications

  • Experience with Oracle Forms and Reports.
  • Knowledge of Shell Scripting and Linux/Unix environments.
  • Experience with Oracle Data Integrator (ODI) or other ETL tools.
  • Familiarity with Oracle APEX development.
  • Exposure to cloud platforms such as Oracle Cloud Infrastructure (OCI) or AWS.
  • Experience working in Agile/Scrum development environments.
  • Oracle certifications will be an added advantage.

Technical Skills

  • Oracle Database (11g/12c/19c)
  • Oracle PL/SQL
  • Advanced SQL
  • Performance Tuning & Query Optimization
  • Data Modeling
  • Stored Procedures, Packages, Triggers, Functions
  • AWR, TKPROF, Explain Plan
  • SQL Loader / External Tables
  • Shell Scripting (Preferred)
  • Git / Version Control
  • ETL Concepts and Data Migration

Soft Skills

  • Leadership and mentoring capabilities
  • Strong stakeholder management skills
  • Ability to work independently and manage multiple priorities
  • Excellent communication and collaboration skills
  • Detail-oriented with a focus on delivering high-quality solutions

Preferred Experience: Candidates with experience supporting large-scale enterprise applications in banking, healthcare, insurance, government, or retail domains will be highly preferred.

Apply
Similar Jobs
Loading data...