Oracle PL/SQL Developer

Beacon Hill Staffing Group - Austin, TX

Full-time

Austin, TX

Administrative and Support Services

About the position

Beacon Hill Technologies is seeking a highly skilled technical professional with extensive experience in SQL, Oracle PL/SQL, and Unix Shell programming. The ideal candidate will have a strong background in modern RDBMS products, particularly Oracle (latest version), and familiarity with PostgreSQL is considered a plus. This role requires proficiency in the Informatica Platform, including best practices for Informatica PowerCenter, Data Transformation, and Informatica B2B Data Exchange products. The candidate should demonstrate strong ETL and data modeling experience, with the ability to create mappings, workflows, and implement ETL concepts effectively. In addition to the above, the successful candidate will have developed complex database objects such as Stored Procedures, Functions, Packages, and Triggers using SQL and PL/SQL. Experience with standard Oracle packages, dynamic SQL, records, arrays, PL/SQL tables, and file handling is essential. The role also demands expertise in SQL and PL/SQL performance tuning, query rewriting, and the use of Explain Plan and Hints. Familiarity with collections, exception handling, partitioning techniques, BULK features, analytics functions, and external tables is also required. The candidate should be comfortable working in a UNIX/Linux environment and possess sufficient command knowledge. Agile working experience with Scrum and SDLC methodologies is necessary, along with experience using Atlassian products such as JIRA, Confluence, and BitBucket. A thorough understanding of DevOps practices, UC4, Maven, Jenkins, and CI/CD processes is also expected. The role requires a solid grasp 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. Familiarity with API gateways, such as Gravitee, is a plus. Overall, the candidate should have a comprehensive understanding of software methodologies, distributed networking, databases, communications, and multiprocessing applications.

Responsibilities

• Develop and maintain complex database objects including Stored Procedures, Functions, Packages, and Triggers using SQL and PL/SQL.
• Create mappings, workflows, and implement ETL concepts using Informatica products.
• Perform SQL and PL/SQL performance tuning and query rewriting.
• Utilize standard Oracle packages and dynamic SQL for efficient data handling.
• Work with collections, exception handling, and partitioning techniques in PL/SQL.
• Collaborate in an Agile environment using Scrum and SDLC methodologies.
• Manage DevOps practices and CI/CD processes using tools like Jenkins and Maven.
• Participate in the design and development of software applications using Java, Angular, or React.

Requirements

• Excellent working knowledge and experience of SQL and Oracle PL/SQL.
• Proficiency in Unix Shell programming (or Perl or Python).
• Extensive experience with modern RDBMS products, especially Oracle and PostgreSQL.
• Strong knowledge of Informatica Platform and best practices for Informatica PowerCenter and Data Transformation.
• Solid ETL and data modeling experience.
• Experience in creating mappings and workflows in Informatica.
• Proficient in developing complex database objects and performance tuning.
• Comfortable working in UNIX/Linux environments.

Nice-to-haves

• Experience with API gateways such as Gravitee.
• Familiarity with programming languages and frameworks like Java, Angular, or React.
• Knowledge of Atlassian products such as JIRA, Confluence, and BitBucket.

Benefits

• Equal Opportunity Employer
• Encouragement for individuals with disabilities and protected veterans to apply.