AlbanyNYRecruiter Since 2001
the smart solution for Albany jobs

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


JOB ID: 4744-RCAT-4



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.


24 Months


07:00am 5:00pm


Harriman Campus Building 12 Albany, NY 12240

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.

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

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Other IT / Software / Systems Jobs

Remote Oracle EBS SCM Manufacturing Functional Consultant
Description: A software development company is seeking a Remote
Company: VirtualVocations
Location: Hartford
Posted on: 09/25/2020

Certified Mobile Notary Services
Description: Certified Mobile Notary Service is now seeking Mobile Notaries nationwide. We currently have an exciting opportunity for Notary Publics in all 50 states looking for (more...)
Company: Certified Mobile Notary Service
Location: Hartford
Posted on: 09/25/2020

Technology Leadership Development Program Intern
Description: Company SummaryTaking care of our customers, our communities and each other. Thats the Travelers Promise. By honoring this commitment, we have maintained our reputation as one of the best property casualty (more...)
Company: Travelers
Location: Hartford
Posted on: 09/25/2020

Description: Job Description:Were looking for a Lead RPA Developer to join our growing Automation team in Bridgeport, CT The Lead RPA Developer will focus on developing high-quality RPA solutions to deliver maximum (more...)
Company: People's United Bank
Location: Bridgeport
Posted on: 09/25/2020

Remote Software Development Engineer
Description: A cybersecurity company is filling a position for a Remote Software Development
Company: VirtualVocations
Location: Springfield
Posted on: 09/25/2020

Telecommute Snowflake Database Architect
Description: A staffing agency is in need of a Telecommute Snowflake Database Architect.Must be able to:
Company: VirtualVocations
Location: Springfield
Posted on: 09/25/2020

Work Remotely Mobile Notary
Description: Certified Mobile Notary Service is now seeking Mobile Notaries nationwide and our priority in ensuring your success.
Company: Certified Mobile Notary Service
Location: Hartford
Posted on: 09/25/2020

Sr. Software Engineer (JavaScript, JavaScript Frameworks, HTML/CSS)
Description: Company InformationSolid reputation, passionate people and endless opportunities. Thats Travelers. Our superior financial strength and consistent record of strong operating returns mean security for our (more...)
Company: Travelers
Location: Hartford
Posted on: 09/25/2020

Remote Research and Development Technical Architect
Description: A cloud-based computing software firm is filling a position for a Remote Research and Development
Company: VirtualVocations
Location: Springfield
Posted on: 09/25/2020

Remote Loan System COBOL Developer
Description: A staffing firm specializing in the technology industry is seeking
Company: VirtualVocations
Location: Bridgeport
Posted on: 09/25/2020

Log In or Create An Account

Get the latest New York jobs by following @recnetNY on Twitter!

Albany RSS job feeds