Oracle PL/SQL Developer

Beacon Hill Staffing Group - Montpelier, VT

Full-time

Montpelier, VT

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 should have expertise in collections, exception handling, partitioning techniques, and analytics functions, as well as experience with file handling and standard Oracle packages. The position requires familiarity with Agile methodologies, particularly Scrum, and experience with SDLC best practices. Knowledge of Atlassian products such as JIRA, Confluence, and BitBucket is beneficial. Additionally, the candidate should have experience with DevOps practices, including tools like UC4, Maven, Jenkins, and CI/CD processes. A good understanding of object-oriented analysis and design principles is also necessary. Knowledge of programming languages and frameworks such as Java, Angular, or React, as well as experience with API gateways, will be advantageous. The role demands a thorough understanding of software methodologies, distributed networking, databases, and multiprocessing applications.

Responsibilities

• Develop and maintain database applications using Oracle PL/SQL and SQL.
• Create complex database objects such as Stored Procedures, Functions, Packages, and Triggers.
• Implement ETL processes and data modeling using Informatica tools.
• Perform SQL and PL/SQL performance tuning and query optimization.
• Utilize Agile methodologies and participate in Scrum practices.
• Collaborate with cross-functional teams using Atlassian tools like JIRA and Confluence.
• Manage DevOps processes and CI/CD pipelines using tools like Jenkins and Maven.
• Apply object-oriented analysis and design principles in development tasks.
• Work with various programming languages and frameworks as needed.

Requirements

• Excellent working knowledge of SQL and Oracle PL/SQL.
• Experience with Unix Shell scripting or programming languages like Perl or Python.
• Proficiency in modern RDBMS products, especially Oracle and PostgreSQL.
• Strong experience with Informatica Platform and best practices.
• Solid ETL and data modeling experience.
• Ability to create mappings and workflows in Informatica.
• Experience developing complex database objects using SQL and PL/SQL.
• Knowledge of performance tuning techniques for SQL and PL/SQL.
• Familiarity with Agile methodologies and SDLC best practices.
• Experience with DevOps tools and CI/CD processes.

Nice-to-haves

• Knowledge of programming languages such as Java, Angular, or React.
• Experience with API gateways like Gravitee.
• Familiarity with distributed networking and multiprocessing applications.