Oracle PL/SQL Developer

Beacon Hill Staffing Group - Bismarck, ND

Full-time

Bismarck, ND

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 experience in SQL and PL/SQL performance tuning, query rewriting, and the use of Explain Plan and Hints. The candidate should also have solid experience with UNIX/Linux platforms and be comfortable with Agile methodologies, particularly Scrum and SDLC practices. Familiarity with Atlassian products such as JIRA, Confluence, and BitBucket is also beneficial. Moreover, the position demands thorough knowledge of DevOps practices, including tools like UC4, Maven, Jenkins, and CI/CD processes. The developer should possess 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, such as Gravitee, is a plus. The role is designed for individuals who can navigate complex software methodologies, distributed networking, databases, and multiprocessing applications effectively.

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 dynamic SQL for effective database management.
• Work with UNIX/Linux platforms and demonstrate proficiency in shell scripting.
• Collaborate in Agile environments, utilizing Scrum and SDLC methodologies.
• Implement DevOps practices using tools like UC4, Maven, Jenkins, and CI/CD.
• Apply object-oriented analysis and design principles in software development.
• 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).
• Experience with Informatica Platform and best practices for Informatica PowerCenter and Data Transformation.
• Strong ETL and data modeling experience, including creating mappings and workflows.
• Experience in SQL and PL/SQL performance tuning and query optimization.
• Solid experience with UNIX/Linux platforms and shell scripting.
• Agile working experience with Scrum and SDLC methodologies.
• Thorough knowledge of DevOps practices and tools such as Jenkins and CI/CD.
• Good knowledge of programming languages and frameworks such as Java, Angular, or React.

Nice-to-haves

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