Oracle PL/SQL Developer

Beacon Hill Staffing Group - Augusta, ME

Full-time

Augusta, ME

Administrative and Support Services

About the position

The Oracle PL/SQL Developer position at Beacon Hill Staffing Group, LLC involves working with a variety of technical skills and tools to develop and maintain database applications. The ideal candidate will have a strong background in SQL and Oracle PL/SQL, along with experience in Unix Shell scripting or programming languages such as Perl or Python. The role requires extensive proficiency in modern RDBMS products, particularly Oracle's latest version, and familiarity with PostgreSQL is considered a plus. In this role, the developer will be responsible for utilizing the Informatica Platform, applying best practices for Informatica PowerCenter, Data Transformation, and Informatica B2B Data Exchange products. A strong understanding of Informatica design concepts is essential, as well as experience in ETL processes and data modeling. The developer will create mappings, workflows, and implement ETL concepts effectively. The position also requires the development of complex database objects, including Stored Procedures, Functions, Packages, and Triggers using SQL and PL/SQL. Candidates should have experience with Standard Oracle Packages, Dynamic SQL, and performance tuning techniques, including query rewriting and the use of Explain Plan and Hints. Additionally, expertise in Collections, Exception Handling, and Partitioning techniques is necessary. The developer will work in an Agile environment, utilizing Scrum and SDLC methodologies, and will be familiar with Atlassian products such as JIRA, Confluence, and BitBucket. Experience with DevOps practices, UC4, Maven, Jenkins, and CI/CD processes is also required. Knowledge of object-oriented analysis and design principles, as well as programming languages and frameworks like Java, Angular, or React, is beneficial. Familiarity with API gateways, such as Gravitee, is a plus. Overall, this position offers an opportunity to work in a dynamic environment with a focus on delivering quality IT solutions to meet the technical and business needs of clients.

Responsibilities

• Develop and maintain complex database objects including Stored Procedures, Functions, Packages, and Triggers using SQL and PL/SQL.
• Utilize the Informatica Platform and apply best practices for Informatica PowerCenter, Data Transformation, and Informatica B2B Data Exchange products.
• Create mappings, workflows, and implement ETL concepts effectively.
• Perform SQL and PL/SQL performance tuning, including query rewriting and the use of Explain Plan and Hints.
• Work in an Agile environment utilizing Scrum and SDLC methodologies.
• Collaborate with team members using Atlassian products such as JIRA, Confluence, and BitBucket.
• Implement DevOps practices using tools like UC4, Maven, Jenkins, and CI/CD processes.
• Apply object-oriented analysis and design principles in development tasks.
• Develop knowledge in programming languages and frameworks such as Java, Angular, or React.

Requirements

• Excellent working knowledge and experience of SQL, Oracle PL/SQL, Unix Shell (or Perl or Python) programming languages.
• Extensive proficiency in modern RDBMS products, particularly Oracle (latest version), with PostgreSQL as a plus.
• Strong ETL and data modeling experience, proficient in creating mappings and workflows.
• Experience with Informatica Platform and knowledge of Informatica best practices.
• Solid experience with UNIX/Linux platforms and sufficient commands.
• Experience in SQL and PL/SQL Performance Tuning, query rewriting, and use of Explain Plan and Hints.
• Expertise in Collections, Exception Handling, Partitioning techniques, BULK features, and Analytics functions.

Nice-to-haves

• Knowledge and experience with API gateway (such as Gravitee) is a plus.
• Familiarity with programming languages and frameworks such as Java, Angular, or React.