Oracle Application Developer 110

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

Job summary

Ariel Partners is seeking professionals to advance HRA Eligibility Systems and related POS application development in our New York office. The role focuses on system design, database development, and maintenance for complex public-sector applications used to support hunger, poverty and homelessness programs.

Responsibilities include data analysis, software development, testing, and documentation, with exposure to mainframe and diverse environments.

Qualifications

• 4+ years of experience in Oracle databases and application development.
• Experience writing and debugging store procedures in Oracle 12C/11g.
• Proficiency in data analysis, data access, and database design.
• Strong programming, testing, and implementation skills.
• Experience preparing technical/user documentation and software conversions.
• Exposure to mainframe, mid-range, and PC environments.
• Leads in design of program specifications and software solutions.

Responsibilities

• Develop system design specifications and documents for solutions meeting system and security requirements.
• Create specifications for databases, communications, hardware, network, security, storage, and software configurations.
• Produce diagrams for databases, networks, and storage, and document configurations.
• Develop system operations designs and procedures for systems, hardware, and software.
• Handle production incidents: analysis, triage, root cause, and bug fixes.
• Create unit test scenarios and data element requirements; maintain application versions.

Skills

Oracle 12C/11g

Data analysis

Databases design

Programming

Testing & implementation

Technical documentation

Software conversions

Lead in design

Mainframe exposure

Data structures

Job description

PROJECT DESCRIPTION

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.
• State: Initial and Final file processing.
• Perform Testing/Evaluation/Maintenance
• Key production database data cleanup maintenance for allowance/storage fee payment processing.
• Handle production incidents: analysis, triaging, finding root cause and bug fixing
• Create unit test scenarios and date elements requirement
• Maintain application versions based on implementation phases, and Quality Control progressing

MANDATORY SKILLS/EXPERIENCE

Note: Candidates who do not have the mandatory skills will not be considered

• 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

At Ariel Partners, we solve the most difficult problems that inhibit technology from enabling our customers to achieve their goals. Our vision is to be recognized by our stakeholders as an elite provider of IT solutions, so when they have their biggest challenges, we are on their short list. We are looking for team members who share our values of: Integrity to do the right thing even when it hurts; Commitment to the long-term success and happiness of our customers, our people, and our partners; Courage to take on difficult challenges, accept new ideas, and accept incremental failure; and the constant pursuit of Excellence. Ariel Partners is an Equal Opportunity Employer in accordance with federal, state, and local laws.