Oracle PL/SQL Developer

Lifescale Analytics - Tallahassee, FL

Full-time - Senior

Tallahassee, FL

Professional, Scientific, and Technical Services

About the position

The Oracle PL/SQL Developer at LifeScale Analytics is responsible for developing and maintaining applications using Oracle technologies, including PL/SQL, Oracle Forms, and PHP. This role focuses on ensuring the stability and enhancement of the agency's business applications while providing support and mentoring to junior programmers. The position requires onsite presence in Tallahassee, FL, and involves collaboration with various stakeholders to meet program requirements and specifications.

Responsibilities

• Serve as an Application Developer focusing on Oracle Forms, Oracle PL/SQL, PHP, and Classic Microsoft ASP (3.0).
• Support ongoing maintenance to ensure the stability of applications in the Client portfolio.
• Provide maintenance, enhancement, and support for various agency business applications.
• Assist in the preparation and documentation of program requirements and specifications.
• Research and document requirements of program users.
• Write, translate, and code software programs and applications per specifications.
• Assist in the development and maintenance of user manuals and guidelines.
• Work with network administrators, systems analysts, and software engineers to resolve software issues.
• Provide mentoring and guidance to junior programmers.

Requirements

• 7+ years' experience with Oracle databases, capable of writing complex queries and developing PL/SQL database objects.
• 5+ years' experience developing Oracle Forms.
• 3+ years' experience with database and/or SQL performance tuning.
• 3+ years' experience as a full-stack developer.
• Experience developing application reporting, preferably with PHP and/or Classic ASP 3.0.
• Experience using code repositories, preferably Git.
• Experience using continuous integration tools, preferably Jenkins.
• Knowledge of relational database designs.
• Knowledge of Information Systems Development Methodology (ISDM).
• Experience with database query tools (i.e., TOAD, SQL Developer, SQL Navigator).
• Knowledge of database security, including role-based security.
• Knowledge and experience with Unified Modeling Language (UML).
• Ability to work independently and determine work priorities.

Nice-to-haves

• Oracle certification(s).
• Familiarity with Agile development, specifically Scrum, Extreme Programming (XP), and Kanban.
• Experience in web development leveraging XML and CSS.
• Experience with JQuery or other JavaScript frameworks (such as AngularJS, NodeJS, and React).
• Experience with environmental regulatory business processes and practices.