Oracle PL/SQL Developer

Beacon Hill Staffing Group - Columbia, SC

Full-time

Columbia, SC

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. Candidates should have experience with standard Oracle packages, dynamic SQL, and performance tuning techniques, including query rewriting and the use of Explain Plan and Hints. Additionally, expertise in collections, exception handling, partitioning techniques, and analytics functions is necessary. The developer will work in an Agile environment, utilizing Scrum and SDLC methodologies, and should be comfortable with tools such as JIRA, Confluence, and BitBucket. Familiarity with DevOps practices, UC4, Maven, Jenkins, and CI/CD processes is also required. Knowledge of object-oriented analysis and design principles, as well as programming languages and frameworks like Java, Angular, or React, is beneficial. Understanding API gateways, such as Gravitee, is a plus. Overall, this position offers an opportunity to work in a dynamic environment with a focus on delivering quality IT solutions to meet business needs.

Responsibilities

• Develop and maintain database applications using Oracle PL/SQL and SQL.
• Create complex database objects such as Stored Procedures, Functions, Packages, and Triggers.
• Utilize Informatica Platform for ETL processes and data transformation.
• Implement best practices for Informatica PowerCenter and B2B Data Exchange products.
• Design and create mappings and workflows for data integration.
• Perform SQL and PL/SQL performance tuning and query optimization.
• Work in an Agile environment, participating in Scrum and SDLC methodologies.
• Collaborate with team members using Atlassian products like JIRA and Confluence.
• Utilize DevOps tools such as Maven, Jenkins, and CI/CD for deployment processes.
• Apply object-oriented analysis and design principles in development.

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 ETL processes.
• Ability to create complex database objects and perform performance tuning.
• Familiarity with Agile methodologies and tools like JIRA and Confluence.
• Experience with DevOps practices and CI/CD tools.

Nice-to-haves

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