On-Site Senior Oracle PL/SQL and Forms Developer (Financial Domain)

Overview

On Site
Depends on Experience
Accepts corp to corp applications
Contract - W2
Contract - Independent
No Travel Required

Skills

"Senior Oracle PL/SQL and Forms Developer"; Oracle
PL/SQL database objects
DML/DDL; "Oracle Forms" ; schemas
tables
fields
views
packages
procedures; SQL performance tuning; AngularJS
NodeJS
React
JQuery; XML
CSS; PHP applications and/or reports; creating/updating packages
procedures
function; relational database designs; CRON jobs; TOAD
SQL Developer
SQL Navigator; UML; OOA&D; GAAP or International Financial Reporting Standards ; Jenkins; PHP; Git; Scrum
Extreme Programming (XP);Kanban; financial data; Documentation
Govt

Job Details

Note : Please reply ONLY if you

1) can report to work on-site from day 1. No remote options allowed
2) have all the Required skill set and have worked as a "Senior Oracle PL/SQL and Forms Developer (Financial Domain)" in a large & Complex enterprise level IT Environment.
3) have Minimum
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).
4) can provide at least 3 verifiable experience from completed and/or substantially completed jobs that closely match this request (Filling the client provided form) + fill out a skill Matrix + Sign Resume certification form
5) Can go through a background check including fingerprinting + Agree to a Face to face interview OR a WEB CAM Interview
6) A Competitive Rate
7) will be available May/June 2024 to start at the project.

s and those authorized to work in the US are encouraged to apply. We are unable to sponsor H1b candidates at this time. NOTE: GIS will utilize the U.S. Department of Homeland Security's E-Verify system to verify the employment eligibility of all persons employed during the term of the Contract Note to Consulting Companies : ANY CONSULTANT S RESUME YOU SEND ME MUST BE ON YOUR COMPANY S PAYROLL, NO H1-VISA TRANSFER, NO PRO-MARKETING, NO SISTER COMPANY RESUMES. The resume should have the DIRECT contact info and email of the candidate otherwise the candidate will NOT be considered. ALL H1 candidates including those onWOULD need to provide I-797 + DL copy (no exceptions).

Each staff member assigned to this project must have a background screening that is equivalent to a Level Two (2) screening standard.

This is a fixed fee/hourly based project which is inclusive of travel, lodging, per diem expenses and all other costs associated with the completion of the associated tasks.

Interviews:
In the event an interview is requested, in-person interviews will be conducted at the Client location. Interviews may be conducted remotely via Microsoft Teams. A phone interview may also be requested as a first step.

Telecommuting: Telecommuting is not Allowed.

Primary Work: This position involves collaborating with Client 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 Client application portfolio, as specified by Client management.

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 Client s technical environment

Resume for One Proposed Consultant - Resume Should have the following information :
- Name
- All work experience related to the CLIENT s request for service
- Sufficient detail for CLIENT to determine dates of the related work experience, how extensive the related work experience is, and the depth of knowledge and skills of the proposed candidate related to the needs of CLIENT
- Candidate Education
- Professional Summary
- Technical Skills
- Work Experience

Candidate References: Three (3) references must be provided and include the following:
- Name of Company:
- Contact Person & Title:
- Contact Telephone Number:
- Contact Email Address:
- Job Period of Service: (MM/YYYY-MM/YYYY)
- Description (Scope of Work):
- Reference should be a company contact not a peer on the project.
- Verify candidate references, if incomplete and CLIENT is unable to email and call their reference, the proposal will be unaccepted.

"When replying please make sure to list your (All Inclusive) Compensation requirements !!!"

Note : This is a Full time ON SITE Contract Position with no REMOTE options allowed !!


Start date : May/June 2024

# OF POSITIONS : 1


No phone calls please.
Local Citizens are encouraged to Apply
No relocation assistance provided.
ONLY Candidates with an exact match will be contacted
Candidates should be authorized to work in the US.