Oracle Developer / PL/SQL Developer-10819
Company: Optimal Solutions and Technologies
Posted on: September 13, 2020
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
ENGAGEMENT LENGTH IN MONTHS:
WHAT ARE THE DAILY WORK HOURS*
WHERE IS THE PHYSICAL WORK OFFICE LOCATED*
Harriman Campus Building 12 Albany, NY 12240
DESCRIPTION OF SPECIFIC DUTIES IN A TYPICAL WORKDAY FOR THIS
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
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
Mentor state staff developers in advanced programming techniques
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
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
Construct software applications using J2EE and SOA
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
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,
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.
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
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
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
Didn't find what you're looking for? Search again!