Oracle PL/SQL Developer

Beacon Hill Staffing Group - Pierre, SD

Full-time

Pierre, SD

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, with PostgreSQL knowledge considered a plus. In this position, 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 ETL processes and data modeling is essential, as the developer will create mappings, workflows, and implement ETL concepts effectively. The role also involves developing complex database objects, including stored procedures, functions, packages, and triggers using SQL and PL/SQL. Performance tuning of SQL and PL/SQL queries is a critical aspect of this role, requiring expertise in query rewriting, the use of Explain Plan, and hints. The developer will also need to be comfortable with UNIX/Linux platforms and have experience with Agile methodologies, particularly Scrum and SDLC best practices. Familiarity with Atlassian products such as JIRA, Confluence, and BitBucket is beneficial. Additionally, knowledge of DevOps practices, including tools like UC4, Maven, Jenkins, and CI/CD processes, is required. The position may also involve working with object-oriented programming principles and frameworks such as Java, Angular, or React, as well as JPA and Spring Boot. Understanding XML and JSON, along with experience with API gateways like Gravitee, is a plus. The Oracle PL/SQL Developer will be part of a diverse team at Beacon Hill, which values the strength that diversity brings to the workplace, and is committed to equal opportunity employment.

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 with UNIX/Linux platforms and demonstrate proficiency in shell scripting or programming languages such as Perl or Python.
• Collaborate in an Agile environment using Scrum and SDLC methodologies, and utilize Atlassian products like JIRA and Confluence.
• Implement DevOps practices using tools such as UC4, Maven, Jenkins, and CI/CD processes.
• Apply object-oriented analysis and design principles in development tasks.
• Work with programming languages and frameworks such as Java, Angular, or React, and understand XML and JSON.

Requirements

• Excellent working knowledge and experience of SQL, Oracle PL/SQL, and Unix Shell (or Perl or Python) programming languages.
• Extensive proficiency in modern RDBMS products, particularly Oracle (latest version), with PostgreSQL knowledge as a plus.
• Strong experience with the Informatica Platform and best practices for Informatica PowerCenter and Data Transformation.
• Proficient in ETL and data modeling, including creating mappings and workflows.
• Experience in developing complex database objects like stored procedures, functions, packages, and triggers.
• Knowledge of SQL and PL/SQL performance tuning techniques.
• Solid experience with UNIX/Linux platforms and shell scripting.
• Agile working experience with Scrum and SDLC methodologies.
• Familiarity with 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.

Nice-to-haves

• Experience with API gateways such as Gravitee.
• Knowledge of analytics functions, external tables, and partitioning techniques.
• Familiarity with object-oriented programming principles.