Oracle PL/SQL Developer

Beacon Hill Staffing Group - Phoenix, AZ

Full-time

Phoenix, AZ

Administrative and Support Services

About the position

The Oracle PL/SQL Developer position at Beacon Hill Staffing Group, LLC involves working with advanced SQL and Oracle PL/SQL technologies to develop and maintain complex database systems. The role requires a strong understanding of modern RDBMS products, particularly Oracle, and familiarity with PostgreSQL is considered a plus. The developer will be responsible for creating and optimizing database objects such as stored procedures, functions, packages, and triggers, utilizing SQL and PL/SQL to ensure efficient data handling and processing. In addition to database development, the position demands extensive experience with ETL processes and data modeling. The developer will work with Informatica Platform, applying best practices in Informatica PowerCenter, Data Transformation, and Informatica B2B Data Exchange products. The role also includes creating mappings and workflows, implementing ETL concepts, and ensuring data integrity and performance through effective query tuning and optimization techniques. The ideal candidate will have a solid background in UNIX/Linux environments and experience with Agile methodologies, particularly Scrum. Familiarity with DevOps practices, including tools like UC4, Maven, Jenkins, and CI/CD processes, is essential. The developer should also possess knowledge of programming languages and frameworks such as Java, Angular, or React, as well as experience with API gateways. The position emphasizes the importance of collaboration and communication within a diverse team, aligning with Beacon Hill's commitment to equal opportunity and inclusion in the workplace.

Responsibilities

• Develop and maintain complex database objects using SQL and PL/SQL.
• Create and optimize stored procedures, functions, packages, and triggers.
• Implement ETL processes and data modeling using Informatica Platform.
• Design and create mappings and workflows for data transformation.
• Perform SQL and PL/SQL performance tuning and query optimization.
• Utilize Agile methodologies and participate in Scrum practices.
• Collaborate with cross-functional teams to deliver high-quality software solutions.
• Work with DevOps tools and practices to enhance deployment processes.

Requirements

• Excellent working knowledge of SQL and Oracle PL/SQL.
• Experience with Unix Shell, Perl, or Python programming languages.
• Proficiency in modern RDBMS products, especially Oracle and PostgreSQL.
• Strong ETL and data modeling experience, particularly with Informatica.
• Ability to develop 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 such as Jenkins.

Nice-to-haves

• Knowledge of Java, Angular, or React frameworks.
• Experience with API gateways like Gravitee.
• Familiarity with object-oriented analysis and design principles.