Oracle PL/SQL Developer

Beacon Hill Staffing Group - Providence, RI

Full-time

Providence, RI

Administrative and Support Services

About the position

The Oracle PL/SQL Developer position at Beacon Hill Staffing Group, LLC is a critical role that requires a strong technical background in SQL and Oracle PL/SQL, along with experience in various programming languages such as Unix Shell, Perl, or Python. The ideal candidate will have extensive proficiency in modern RDBMS products, particularly Oracle's latest version, and familiarity with PostgreSQL is considered a plus. This role involves working with the Informatica Platform, where the developer will apply best practices for Informatica PowerCenter, Data Transformation, and Informatica B2B Data Exchange products. A strong understanding of Informatica design concepts is essential for success in this position. The developer will be responsible for creating complex database objects, including Stored Procedures, Functions, Packages, and Triggers using SQL and PL/SQL. Additionally, the role requires expertise in SQL and PL/SQL performance tuning, query rewriting, and the use of Explain Plan and Hints. The candidate should also be comfortable with UNIX/Linux platforms and possess solid command over necessary commands. Agile working experience with Scrum and SDLC methodologies is expected, along with familiarity with Atlassian products such as JIRA, Confluence, and BitBucket. Moreover, the position demands thorough knowledge of DevOps practices, including tools like UC4, Maven, Jenkins, and CI/CD processes. The developer should also have a good understanding of object-oriented analysis and design principles, as well as knowledge of programming languages and frameworks such as Java, Angular, or React, JPA, Spring Boot, XML, and JSON. Experience with API gateways, particularly Gravitee, is a plus. The role is designed for individuals who are adept at working in a collaborative environment and are committed to delivering high-quality solutions to meet the technical and business needs of the organization.

Responsibilities

• Develop complex database objects such as Stored Procedures, Functions, Packages, and Triggers using SQL and PL/SQL.
• Create mappings, workflows, and implement ETL concepts using Informatica.
• Perform SQL and PL/SQL performance tuning, including query rewriting and using Explain Plan and Hints.
• Utilize standard Oracle packages and handle file operations effectively.
• Work with Agile methodologies, including Scrum and SDLC best practices.
• Collaborate with team members using Atlassian products like JIRA, Confluence, and BitBucket.
• Implement DevOps practices using tools such as UC4, Maven, Jenkins, and CI/CD.
• Apply object-oriented analysis and design principles in development tasks.
• Develop and maintain applications using programming languages and frameworks such as Java, Angular, or React.

Requirements

• Excellent working knowledge and experience of SQL, Oracle PL/SQL, and Unix Shell (or Perl or Python).
• Extensive proficiency in modern RDBMS products, particularly Oracle (latest version) and PostgreSQL.
• Experience with Informatica Platform and best practices for Informatica PowerCenter and Data Transformation.
• Strong ETL and data modeling experience, including creating mappings and workflows.
• Proficient in SQL and PL/SQL performance tuning and query optimization techniques.
• Solid experience with UNIX/Linux platforms and command usage.
• Agile working experience with Scrum and SDLC methodologies.
• Thorough knowledge of DevOps practices and tools such as UC4, Maven, Jenkins, and CI/CD.
• Good knowledge of programming languages and frameworks such as Java, Angular, or React, JPA, Spring Boot, XML, and JSON.

Nice-to-haves

• Experience with API gateways such as Gravitee.
• Familiarity with Informatica B2B Data Exchange products.
• Knowledge of analytics functions and external tables in Oracle.