Oracle Application Developer

VGroup Inc; New York (NY); On-site; USD 90,000 - 130,000; Full time

Job summary

VGroup Inc. seeks an Oracle Application Developer to design, build, and maintain Oracle-based applications for the NYC agency environment. The role focuses on data integration, reporting, and system documentation with emphasis on reliability and security.

Responsibilities include developing specifications, creating deployment procedures, and delivering routine and ad hoc reports for senior management. Onsite in Brooklyn, 35 hours per week, contract position with potential extension.

Qualifications

• Experience with Oracle databases and store procedures.
• Strong data analysis and design skills.
• Ability to lead technical design and documentation.

Responsibilities

• Develop system design specifications and documentation.
• Create and maintain design and installation procedures.
• Develop, test and implement software solutions in Oracle environments.
• Prepare operational guidelines for databases and networks.
• Generate routine and ad hoc system reports for management.
• Troubleshoot reports and data processing tasks as needed.
• Coordinate with agencies for data exchanges and security compliance.

Skills

Oracle 12c/11g

Data analysis

Leadership in design

OBIEE 12c

SQL/PLSQL

Tools

OBIEE 12c

Oracle Portal

Report Server

Job description

End Client: Department of Social Services

Job Title: Oracle Application Developer

Duration: 36 months and Extension

Location: Brooklyn, NY 11238 Onsite

Hours Per Week: 35 hours

Ceipal ID: NYC_ORACL110_SN

Job Code: 110/020

Department: ITS

Scope of Work

The HRA Eligibility Systems-POS Application Development unit within the Office of Enterprise Solutions Engineering is responsible for developing, maintaining and enhancing web and mobile applications required to support the agency's mission of preventing and addressing hunger, poverty and homelessness. The unit is also dedicated to the testing of administrative systems that either develop or purchases, as well triaging and responding to data and analytics request necessary to monitor and report on key performance indicators such as capacity, census, and critical incidents occurring in the SNAP and CA eligibility systems. Many of the applications from the HRA Eligibility Systems unit, communicate with both internal and external systems and platforms like the NY State Welfare Management System (WMS), New York City Work Accountability and You (NYCWAY) and other diverse data sources.

Tasks & Duties

• Develop system design specifications
• Develops and prepares documents for the general design of solutions that meet system and security requirements, including the selection of alternative approaches.
• Develops specifications for databases, communication systems, hardware, network, security, storage and software configurations.
• Develops structured diagrams for the specifications of databases, communication systems, computer or storage area networks, security or network programs.
• Develops, compiles, maintains and documents configurations of the following: databases, servers, computers, security and network monitor systems, packaged programs, macros, utilities, and communication systems
• Develop system documentation
• Develops operational and installation procedures for communication systems, hardware, network, security, storage and software
• Develops guidelines and upgrade techniques of new operational procedures for the support of databases, hardware systems, operating systems software, network systems software, security and client server systems.
• Develops detailed systems operations designs
• Perform System Design/Development
• Critical scheduled jobs handling data exchanges among State and various city agencies, monitoring, fixing in case of failure or outage.
• Generate routine/ad Hoc reports for senior managers for system overviews and critical decision making
• Daily and monthly standard tasks:
• Monthly Document & application updates.
• Static table updates.
• Troubleshooting for any reports related exceptions.
• Data processing and re-processing
• Cleaning up committal images to free space from 7 E-forms servers.

Required Skills

A minimum of 4 years of experience with the following skill sets:

• Oracle 12C/11g (proficient in developing/debugging store procedures)
• Writing application software, data analysis, data access
• Data structures, data manipulation, databases, design, programming, testing and implementation
• Technical and user documentation, software conversions
• Exposure to environments include but are not limited to mainframe, mid-range, personal computers, laptops
• Lead in the design of program specifications and the implementation of software solutions

A minimum of 4 years of experience with the following skill sets:

• Developing test plans and analyzing and testing large volumes of data
• Using business knowledge to guide a technical team.
• Experience with the NYS Welfare Management System and/or NYS Medicaid Claims Processing System and/or NYCWAY in a technical/analytical capacity
• Excellent analytical and testing skills and the ability to communicate complex technical concepts in clear, non- technical oral and written English
• Leading the design of program specifications and the implementation of software solutions, requirement analysis, design, snowflake data modeling, interactive Dashboard design and complex ad hoc queries and report.
• the OBIEE Analysis, Agent and Dashboards, including RPD Design and Deployment, Catalog Management and security.
• Working in a large three tier data warehouse environment
• Design and extension of data marts, metadata, and data models. Participate in the intake of data from both internal and outside sources.
• Expert knowledge of OBIEE 12c, Oracle Portal, Report server and development.

Website: https://www.vgroupinc.com/publicsector

LinkedIn: https://www.linkedin.com/company/v-group/

Facebook: https://www.facebook.com/VGroupIT

Twitter: https://www.twitter.com/vgroupinc