Oracle PL/SQL Developer

Beacon Hill Staffing Group - Santa Fe, NM

Full-time

Santa Fe, NM

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. Performance tuning of SQL and PL/SQL queries, along with the use of tools like Explain Plan and Hints, is a critical aspect of the job. The candidate should have expertise in collections, exception handling, partitioning techniques, and analytics functions. Additionally, the role demands solid experience with UNIX/Linux platforms 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 work with DevOps tools, including UC4, Maven, Jenkins, and CI/CD practices. Knowledge of object-oriented analysis and design principles, as well as programming languages and frameworks like Java, Angular, or React, is preferred. Familiarity with API gateways, such as Gravitee, is a plus. Overall, this position offers an opportunity to work in a dynamic environment where technical skills are applied to solve complex business needs, contributing to the success of Beacon Hill Technologies and its 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 using Explain Plan and Hints.
• Work with collections, exception handling, partitioning techniques, and analytics functions.
• Collaborate in an Agile environment using Scrum and SDLC methodologies.
• Utilize DevOps tools such as UC4, Maven, Jenkins, and CI/CD practices.
• Engage with Atlassian products like JIRA, Confluence, and BitBucket for project management and collaboration.
• 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 experience with Informatica Platform and best practices for Informatica PowerCenter, Data Transformation, and Informatica B2B Data Exchange products.
• Proficient in ETL and data modeling, including creating mappings and workflows.
• Experience in developing complex database objects like Stored Procedures, Functions, Packages, and Triggers using SQL and PL/SQL.
• Knowledge of Standard Oracle Packages (UTL_FILE etc.), Dynamic SQL, Records, Arrays, PL/SQL tables, and file handling.
• Experience in SQL and PL/SQL performance tuning, query rewriting, and using Explain Plan and Hints.
• Expertise in collections, exception handling, partitioning techniques, BULK features, and analytics functions.
• Solid experience with UNIX/Linux platforms and sufficient commands.
• Agile working experience with Scrum and SDLC methodologies.

Nice-to-haves

• Knowledge of programming languages and frameworks such as Java, Angular, or React.
• Experience with API gateways (such as Gravitee).
• Familiarity with object-oriented analysis and design principles.