PL/SQL Developer

PL/SQL Developer

Posted 1 day ago by 1761380740

Apply
Negotiable
Outside
Remote
USA
Apply
Amazon Web Services (AWS) Application Development Automation Business Operations Cloud Computing Cloud Technology Computer Science Cron Database Design Data Cleansing Data Engineering Data Integrity Data Migration Datamodel Data Modeling Data Transformation Debugging Design Elements And Principles Extract Transform Load (ETL) Generic Programming Google Cloud Google Cloud Platform (GCP) Indexing Information Technology Job Scheduling (Batch Processing) Microsoft Azure Mobile Application Development Performance Tuning PL/SQL Query Optimisation Scalability Scheduling Scripting Software Development SQL (Programming Language) Technical Documentation Version Control

Summary: We are looking for a seasoned PL/SQL Developer with over 10 years of experience to enhance our data engineering and application development team. The role involves developing, maintaining, and optimizing complex database solutions critical to business operations, with a strong emphasis on Oracle PL/SQL programming and database design. The ideal candidate will collaborate with application developers and other teams to ensure efficient database solutions and data integrity. Strong analytical and problem-solving skills are essential for troubleshooting and optimizing database performance.

Key Responsibilities:

  • Design, develop, and maintain PL/SQL packages, procedures, functions, triggers, and views.
  • Optimize and tune SQL queries for performance and scalability.
  • Work closely with application developers to design efficient database solutions.
  • Analyze data requirements, develop logical and physical data models, and maintain database integrity.
  • Troubleshoot and resolve database performance issues.
  • Implement data transformation, migration, and integration processes.
  • Develop and maintain technical documentation and best practices.
  • Collaborate with QA, business analysts, and other teams to ensure data accuracy and consistency.

Key Skills:

  • 10+ years of experience as a PL/SQL Developer.
  • Strong expertise in Oracle PL/SQL, SQL, and database design principles.
  • Hands-on experience with stored procedures, functions, triggers, and packages.
  • Strong understanding of query optimization, indexing, and performance tuning.
  • Experience in data migration, ETL development, and data cleansing.
  • Knowledge of Unix/Linux shell scripting for automation.
  • Familiarity with version control systems (Git, SVN) and job scheduling tools (Autosys, Cron).
  • Strong analytical, debugging, and problem-solving skills.
  • Excellent communication and teamwork abilities.

Salary (Rate): undetermined

City: undetermined

Country: USA

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

Job Title: PL/SQL Developer
Experience Level: 10+ years

About the Role
We are seeking an experienced PL/SQL Developer to join our data engineering and application development team. The ideal candidate will have a strong background in Oracle PL/SQL programming, database design, and performance optimization. You will be responsible for developing, maintaining, and optimizing complex database solutions that drive business-critical applications.

Key Responsibilities

  • Design, develop, and maintain PL/SQL packages, procedures, functions, triggers, and views.

  • Optimize and tune SQL queries for performance and scalability.

  • Work closely with application developers to design efficient database solutions.

  • Analyze data requirements, develop logical and physical data models, and maintain database integrity.

  • Troubleshoot and resolve database performance issues.

  • Implement data transformation, migration, and integration processes.

  • Develop and maintain technical documentation and best practices.

  • Collaborate with QA, business analysts, and other teams to ensure data accuracy and consistency.

Required Skills & Qualifications

  • 10+ years of experience as a PL/SQL Developer.

  • Strong expertise in Oracle PL/SQL, SQL, and database design principles.

  • Hands-on experience with stored procedures, functions, triggers, and packages.

  • Strong understanding of query optimization, indexing, and performance tuning.

  • Experience in data migration, ETL development, and data cleansing.

  • Knowledge of Unix/Linux shell scripting for automation.

  • Familiarity with version control systems (Git, SVN) and job scheduling tools (Autosys, Cron).

  • Strong analytical, debugging, and problem-solving skills.

  • Excellent communication and teamwork abilities.

Preferred Qualifications

  • Experience with Oracle 12c/19c or higher.

  • Familiarity with Informatica, Python, or data integration tools.

  • Exposure to cloud databases (AWS RDS, Azure SQL, or Google Cloud Platform Cloud SQL).

  • Experience in Agile/Scrum environments.

Education

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

Apply
Similar Jobs
Loading data...