Location: Tallahassee, FL 32301

Work Mode: onsite

RTR

I, candidate name authorize TexcelVision to submit me for below mentioned position

BG Check

Any issues with criminal background? misdemeanors if any, we need details (type/month/year)

Documents required: Form F-Acknowledgment form and Form D-Candidate References form

Job Description

Job Title: Application Development Analyst

Job #: 1250

Scope Variant: B. Intermediate or C. Advanced Oracle PL/SQL Developer

Primary Work: This position involves collaborating with technical and program area staff to assist with analysis, design, communication, facilitation, and code remediation, aimed at integrating in-house applications with the statewide PALM (Planning, Account, and Ledger Management) solution. The primary focus of this support work will be on a specific Division's application portfolio. However, the team member may also be assigned to work on other projects and/or applications in the application portfolio, as specified by management.

Term / Hours: Estimated 1880 hours per year

Education: Bachelor's Degree in Computer Science, Information Systems or other Information Technology major, or equivalent work experience.

Required Tasks to be performed:

• Provide maintenance, enhancement and support for a variety of the agency's business applications.
• Assist in the preparation and documentation of program requirements and specifications.
• Research and document requirements of program users.
• Analyze existing schemas, documenting relationships and dependencies.
• Write scripts for migrating data from old data structures to new ones, which may include transforming data values to fit new standards.
• Leverage DDL and DML to administer Oracle database objects to include schemas, tables, fields, views, packages, and procedures.
• Update and manage scripts and scheduled tasks through operating system utilities such as CRON jobs.
• Write, translate and code software programs and applications per specifications.
• Assist in the development and maintenance of user manuals and guidelines, to include documenting current and future state changes.
• Work with network administrators, systems analysts and software engineers to assist in resolving problems with software products or company software systems.
• Work with the project team to facilitate unit, interface, integration, and user acceptance tests.
• Attend and contribute to all requisite project ceremonies.
• Modify existing Oracle Forms to reflect changes in the underlying database including adding new fields, modifying existing ones, and removing obsolete elements.
• Ensure Oracle Forms UI remains user-friendly and meets agency business requirements.
• Revise existing PHP reports or develop new ones as required by the new system.

Required Knowledge, Skills & Abilities (KSAs):

• 7 years' experience with Oracle databases with the capability to write complex queries and develop complex PL/SQL database objects, including both DML and DDL.
• 3 years' experience with Oracle Forms.
• 3 years' experience with database and/or SQL performance tuning.
• 3 years' experience with financial data, preferably those that deal with accounting processes, procedures, and internal controls.
• Knowledge of relational database designs.
• 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 be creative, to use sound judgment, and to display foresight to identify potential problems and design/specifications and assigned application software systems.
• Ability to establish and maintain effective working relationships with others.
• Ability to work independently.
• Ability to determine work priorities and ensure proper completion of work assignments.
• Ability to work well under pressure and meet deadlines without sacrificing quality.
• Excellent interpersonal, collaborative, oral and written communication skills.

Preferred Knowledge, Skills & Abilities (KSAs):

• Oracle certification(s).
• Experience with standard principles of accounting, such as GAAP or International Financial Reporting Standards.
• Experience developing PHP applications and/or reports.
• Experience in web development leveraging XML and CSS.
• Experience with JQuery (Javascript library) or other Javascript frameworks (such as AngularJS, NodeJS, and React).
• Experience using code repositories, preferably Git.
• Experience using continuous integration tools, preferably Jenkins.
• Experience with environmental regulatory business processes and practices.
• Familiarity with Agile development, specifically Scrum, Extreme Programming (XP) and Kanban.
• Knowledge and understanding of technical environment.