Beacon Hill Staffing Group - Nashville, TN

posted 4 months ago

Full-time
Nashville, TN
Administrative and Support Services

About the position

The Oracle PL/SQL Developer position at Beacon Hill Staffing Group, LLC is a critical role that requires a deep understanding of 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 foundation in 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 have experience with Agile methodologies, particularly Scrum and SDLC practices. Familiarity with Atlassian products such as JIRA, Confluence, and BitBucket is beneficial. Moreover, the position demands thorough knowledge of DevOps practices, including tools like UC4, Maven, Jenkins, and CI/CD processes. The developer should also possess a good understanding of object-oriented analysis and design principles, as well as programming languages and frameworks such as Java, Angular, or React, JPA, Spring Boot, XML, and JSON. Knowledge of API gateways, such as Gravitee, is a plus. The role is integral to the success of Beacon Hill Technologies, which prides itself on delivering quality IT professionals to meet the technical and business needs of its clients.

Responsibilities

  • Develop complex database objects such as Stored Procedures, Functions, Packages, and Triggers using SQL and PL/SQL.
  • Create mappings, workflows, and implement ETL concepts using Informatica.
  • 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.
  • Implement Agile methodologies and best practices in software development.
  • Collaborate with teams using Atlassian products like JIRA, Confluence, and BitBucket.
  • Engage in DevOps practices, including CI/CD using tools like Jenkins and Maven.
  • Apply object-oriented analysis and design principles in software development.

Requirements

  • Excellent working knowledge and experience of SQL, Oracle PL/SQL, Unix Shell (or Perl or Python).
  • Extensive proficiency in modern RDBMS products, particularly Oracle (latest version).
  • Experience with Informatica Platform and best practices for Informatica PowerCenter and Data Transformation.
  • Strong ETL and data modeling experience.
  • Proficient in creating mappings, workflows, and implementing ETL concepts.
  • Experience in SQL and PL/SQL performance tuning and query optimization.
  • Solid experience with UNIX/Linux platforms.

Nice-to-haves

  • Familiarity with PostgreSQL.
  • Knowledge of API gateways such as Gravitee.
  • Experience with programming languages and frameworks like Java, Angular, or React, JPA, Spring Boot, XML, and JSON.
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service