Oracle PL/SQL Developer

Beacon Hill Staffing Group - Salt Lake City, UT

Full-time

Salt Lake City, UT

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, and familiarity with PostgreSQL is considered a plus. The developer will be expected to work with the Informatica Platform, applying best practices for Informatica PowerCenter, Data Transformation, and Informatica B2B Data Exchange products. A solid understanding of Informatica design concepts is essential for this role. In addition to ETL and data modeling experience, the candidate should be proficient in creating mappings, workflows, and implementing ETL concepts. 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, along with the use of Explain Plan and Hints, is a critical aspect of the job. The developer will also need to demonstrate expertise in collections, exception handling, partitioning techniques, and analytics functions. The position requires a solid understanding of the UNIX/Linux platform and familiarity with Agile methodologies, particularly Scrum and SDLC best practices. Experience with Atlassian products such as JIRA, Confluence, and BitBucket is also beneficial. The developer will be expected to have thorough working experience with DevOps tools, including UC4, Maven, Jenkins, and CI/CD processes. Knowledge of object-oriented analysis and design principles is important, as is familiarity with programming languages and frameworks such as Java, Angular, or React, as well as JPA, Spring Boot, XML, and JSON. Experience with API gateways, such as Gravitee, is a plus. Overall, the Oracle PL/SQL Developer will play a crucial role in delivering quality IT solutions to meet the technical and business needs of Beacon Hill's clients.

Responsibilities

• Develop and maintain complex database objects including stored procedures, functions, packages, and triggers using SQL and PL/SQL.
• Implement ETL concepts and create mappings and workflows using Informatica PowerCenter.
• 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 collections, exception handling, and partitioning techniques in PL/SQL.
• Collaborate in an Agile environment, utilizing Scrum and SDLC methodologies.
• Manage DevOps processes using tools like UC4, Maven, Jenkins, and CI/CD.
• Apply object-oriented analysis and design principles in software development.
• Develop applications using programming languages and frameworks such as Java, Angular, or React.
• Integrate APIs and work with API gateways like Gravitee.

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 as a plus.
• Experience with Informatica Platform and knowledge of best practices for Informatica PowerCenter and Data Transformation.
• Strong ETL and data modeling experience, proficient in creating mappings and workflows.
• Experience in developing complex database objects like stored procedures, functions, packages, and triggers.
• Knowledge of standard Oracle packages, dynamic SQL, and performance tuning techniques.
• Solid experience with UNIX/Linux platforms and Agile methodologies.
• Familiarity with DevOps tools and CI/CD processes.

Nice-to-haves

• Experience with API gateways such as Gravitee.
• Knowledge of additional programming languages and frameworks like Java, Angular, or React.
• Familiarity with Atlassian products such as JIRA, Confluence, and BitBucket.