Beacon Hill Staffing Group - Providence, RI
posted 3 months ago
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 expertise in SQL and PL/SQL performance tuning, query rewriting, and the use of Explain Plan and Hints. The candidate should also be comfortable with UNIX/Linux platforms and possess solid command over necessary commands. Agile working experience with Scrum and SDLC methodologies is expected, along with familiarity with Atlassian products such as JIRA, Confluence, and BitBucket. Moreover, the position demands thorough knowledge of DevOps practices, including tools like UC4, Maven, Jenkins, and CI/CD processes. The developer should also have 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, particularly Gravitee, is a plus. The role is designed for individuals who are adept at working in a collaborative environment and are committed to delivering high-quality solutions to meet the technical and business needs of the organization.