Oracle pl/sql database developer

oracle pl/sql database developer.

tallahassee , florida

posted 1 day ago

job detailssummary

$55 - $60 per hour

contract

no requirements

category computer and mathematical occupations

reference1048082

job detailsjob summary: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.

location: Tallahassee, Floridajob type: Contractsalary: $55 - 60 per hourwork hours: 8am to 5pmeducation: No Degree Requiredresponsibilities: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.

qualifications:

Experience level: Experienced

Minimum 8 years of experience

Education: No Degree Required (required)

skills:

Oracle

PL/SQL

ORACLE FORM

PHP

Javascript

nodeJS

Angular

React

JQuery

Git

Bootstrap

Docker

TOAD, SQL Developer, SQL Navig

Unified Modeling Language UML

SQL Performance TuningEqual Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.At Randstad Digital, we welcome people of all abilities and want to ensure that our hiring and interview process meets the needs of all applicants. If you require a reasonable accommodation to make your application or interview experience a great one, please contact HRsupport@randstadusa.com.Pay offered to a successful candidate will be based on several factors including the candidate's education, work experience, work location, specific job duties, certifications, etc. In addition, Randstad Digital offers a comprehensive benefits package, including health, an incentive and recognition program, and 401K contribution (all benefits are based on eligibility).Applications accepted on ongoing basis until filled.