Oracle Developer / PL/SQL Developer-10819

Company: Optimal Solutions and Technologies
Location: Albany
Posted on: September 13, 2020

Job Description:

POSITION: Oracle Developer / PL/SQL Developer-10819

LOCATION: Albany, NY

JOB ID: 4744-RCAT-4

# OF OPENINGS: 1

-------------------------

Optimal Solutions & Technologies (OST, Inc.) is focused on excellence. We specialize in providing Management Consulting, Information Technology, and Research Development and Engineering services. OST is one of an elite set of companies worldwide to be externally appraised CMMI Level 5.

The fundamental distinction of the OST team is its business knowledge in both the public and private sectors. We serve the aerospace & transportation, association & nonprofit, defense, education, energy, financial, healthcare, and technology & telecommunications industries. OST is successful because we listen to our clients, we learn from our clients, and we know our clients.

ENGAGEMENT LENGTH IN MONTHS:

24 Months

WHAT ARE THE DAILY WORK HOURS*

07:00am 5:00pm

WHERE IS THE PHYSICAL WORK OFFICE LOCATED*

Harriman Campus Building 12 Albany, NY 12240

DESCRIPTION OF SPECIFIC DUTIES IN A TYPICAL WORKDAY FOR THIS POSITION:
The consultant will guide an agile development team and be responsible for Graphical User Interface (GUI) design and development activities. The activities include, but are not limited to:
Guide an agile development team working on a complex employer account financial system, including designing and developing modules that establish receivables, calculate fees and interest, apply remittances, establish and reverse refunds, and reconcile funds and other account maintenance activities
Guide a team of developers in the analysis, design, and development of integrated solutions for the project.
Assist the project development team to establish and document standards and patterns for best practices of integration technologies.
Mentor state staff developers in advanced programming techniques and skills.
Use Rational Software Architect (RSA) for modeling architecture and application design, components, and services. Analyze, design, review, and document database conceptual and logical data models. Identify services and business process components in functional decomposition.
Create and review sequence and activity diagrams.
Define and validate service WSDLs and XSDs.
Develop business process models.
Analyze, design, and develop services and business processes from business requirements using a SOA approach.
Orchestrate individual system components into end-to-end business processes as part of a comprehensive Case Management/Workflow system.
Construct software applications using J2EE and SOA architectures.
Develop applications using Rational Application Developer (RAD/IID) utilizing Agile methodologies.
Develop composite applications utilizing WebSphere Integration Developer (WID), WebSphere Process Server (WPS), WebSphere Business Integration Workbench and/or WebSphere MQ Workflow.
Perform composite application integration using EJB, SCA, JMS, and Web Services over an Enterprise Service Bus (ESB).
Analyze and develop rule sets for processes utilizing WODM.
Develop and test data access using Object Relation Mapping frameworks (Hibernate).
Develop complex relational database queries using ANSI standard SQL and PLS/SQL to be used with Oracle and DB2 databases giving special consideration to transaction management.
Perform database transaction management analysis, implementation, and troubleshooting.
Perform unit and integration testing and resolve defects.
Create and review technical documents for all aspects of the software development lifecycle.
Provide new technology evaluations resulting from research, proof of concept (POC), and proof of technology (POT) work.

POSITION REQUIREMENTS:
5 years of Experience developing and testing query solutions using Oracle PL/SQL query.
5 years of UNIX Shell Scripting experience
5 years of ETL design/Data Warehouse development experience using SQL and PL/SQL programming/ IBM DataStage
5 years of Experience tuning SQL within an Oracle environment to ensure timely and efficient execution of queries
6 years of ETL development experience in Oracle environment with IBM DataStage
5 years of DataStage Administrator experience on AIX environments that includes implementing and maintaining business and technical rules; automating ETL code migration process and standards for Stop/start services; monitor logs; setting up security; assigning roles; project permissions; Create/Delete projects; create/modify environmental parameters; Platform Issue resolution; troubleshooting and root cause analysis; Configuration and tuning of production and lower-level environments; and capacity planning.
Bachelors' degree in computer science, information science, health science, engineering, or mathematics.

OST is an equal opportunity employer. Applicants are considered for positions without regard to race, religion, gender, native origin, age, disability, or any other category protected by applicable federal, state, or local laws.

Keywords: Optimal Solutions and Technologies, Albany , Oracle Developer / PL/SQL Developer-10819, IT / Software / Systems , Albany, New York