Oracle Application Developer

Client: New York City Department of Social Services (DSS)

Position Number: 110

Job Title: Oracle Application Developer

Location: 109 E 16th St, New York, NY 10003
Work Arrangement: On-site in New York City; remote work may be considered for highly qualified candidates.

Required: 2 Professional References

Position Summary

The Oracle Application Developer will support the design, development, implementation, and ongoing maintenance of application software for the Paperless Office System (POS) project, with an emphasis on Oracle database development. This position provides technical contribution across program specification design, stored procedure development, and full lifecycle software implementation.

The position will collaborate with developers, database teams, QA staff, and other stakeholders to build secure, reliable, and maintainable database-driven applications.

Essential Duties and Responsibilities

• Design, develop, test, and implement application software supporting the Paperless Office System (POS) project.
• Lead the design of program specifications and the implementation of software solutions.
• Develop and debug Oracle stored procedures and related database logic.
• Develop and maintain technical and user documentation, including specifications and conversion records.
• Work with data structures, data manipulation, and database design across assigned systems.
• Support software conversions and operate across varied environments, including mainframe, mid-range, personal computers, and laptops.
• Participate across the full Software Development Life Cycle (SDLC), including design, development, testing, deployment, and maintenance.
• Collaborate with database, QA, and cross-functional teams on implementation activities.

Required Qualifications

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

• Oracle 12c/11g, including developing and debugging stored procedures
• Writing application software, including data analysis and data access
• Data structures, data manipulation, databases, design, programming, testing, and implementation
• Technical and user documentation, and software conversions
• Exposure to varied environments, including mainframe, mid-range, personal computers, and laptops
• Leading the design of program specifications and implementation of software solutions

Minimum Experience

Position 110 – Oracle Application Developer: Minimum of four (4) years of relevant experience, with an emphasis on Oracle database development and application software implementation.

Preferred Competencies

• Strong understanding of Oracle database architecture and solution design principles.
• Ability to design secure, reliable, and maintainable database solutions.
• Experience developing technical specifications and implementation plans.
• Ability to evaluate existing systems and recommend optimization opportunities.
• Strong troubleshooting, analytical, and problem-solving abilities.
• Ability to communicate technical concepts to both technical and non-technical stakeholders.
• Strong written and verbal communication skills.
• Ability to collaborate effectively across development, QA, and business teams.

Core Competencies

• Oracle database development
• Application software design and implementation
• Technical documentation
• Problem-solving and root-cause analysis
• Cross-functional collaboration
• Continuous improvement and technology modernization