Oracle PL/SQL Developer

Beacon Hill Staffing Group - Annapolis, MD

Full-time

Annapolis, MD

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 programming. The role requires extensive proficiency in modern RDBMS products, particularly Oracle, and familiarity with PostgreSQL is considered a plus. The developer will be responsible for creating complex database objects such as stored procedures, functions, packages, and triggers, utilizing SQL and PL/SQL effectively. In addition to database development, the position requires strong ETL and data modeling experience. The developer will be expected to create mappings and workflows, implementing ETL concepts using Informatica Platform and adhering to best practices for Informatica PowerCenter and Data Transformation. The role also involves performance tuning of SQL and PL/SQL queries, utilizing techniques such as query rewriting and the use of Explain Plan and Hints to optimize performance. The candidate should be comfortable working in a UNIX/Linux environment and have experience with Agile methodologies, particularly Scrum and SDLC practices. Familiarity with Atlassian products like JIRA, Confluence, and BitBucket is also beneficial. The role may involve working with DevOps tools such as UC4, Maven, Jenkins, and CI/CD practices. Knowledge of object-oriented analysis and design principles, as well as programming languages and frameworks like Java, Angular, or React, is advantageous. The developer will also need to have a thorough understanding of software methodologies, distributed networking, and database communications.

Responsibilities

• Develop and maintain complex database objects including stored procedures, functions, packages, and triggers using SQL and PL/SQL.
• Create mappings and workflows, implementing ETL concepts using Informatica Platform.
• 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.
• Work in a UNIX/Linux environment and ensure efficient command execution.
• Collaborate in Agile teams using Scrum and SDLC methodologies.
• Utilize DevOps tools such as UC4, Maven, Jenkins, and CI/CD for deployment processes.
• Apply object-oriented analysis and design principles in development tasks.
• Engage with programming languages and frameworks such as Java, Angular, or React.

Requirements

• Excellent working knowledge and experience of SQL, Oracle PL/SQL, and Unix Shell (or Perl or Python).
• Extensive proficiency in modern RDBMS products, particularly Oracle and PostgreSQL.
• Strong experience with Informatica Platform and best practices for Informatica PowerCenter and Data Transformation.
• Proficient in ETL and data modeling, including creating mappings and workflows.
• Experience in developing complex database objects and using standard Oracle packages.
• Strong skills in SQL and PL/SQL performance tuning and optimization techniques.
• Solid experience with UNIX/Linux platforms and command line tools.
• Agile working experience with Scrum and SDLC methodologies.
• Familiarity with DevOps practices and tools such as UC4, Maven, Jenkins, and CI/CD.
• Good knowledge of programming languages and frameworks such as Java, Angular, or React.

Nice-to-haves

• Experience with API gateway technologies such as Gravitee.
• Knowledge of analytics functions and external tables in Oracle.
• Familiarity with object-oriented programming principles.