The Department of Social Services (DSS) needs to manage the design, development, and maintenance of object-oriented, Relational database DataStage systems using IBM WebSphere DataStage platforms for agency applications. This includes creating and maintaining multitier database application software solution's software architecture conceptualization, design, and implementation, analyzing data from various systems, gathering report requirements, and responding to ad hoc requests.
Requirements
- Coding experience with Datastage ETL tools and scheduling Datastage jobs.
- Experience with RDBMS, SQL specifically with MS SQL server.
- Coding experience with API’s and familiarity with Cloud concepts.
- Experience in DevOps tools and technologies.
- Track record of accomplishments in Design, Deployment, and debugging.
- Experience in creating stored procedures.
- Experience in preparing project plans including needed tasks and gathering user requirements.
Responsibilities
- Manage the design, development, and maintenance of object-oriented, Relational database DataStage systems using IBM WebSphere DataStage platforms for the agency applications.
- Create and maintain the multitier database application software solution’s software architecture conceptualization, design, and implementation.
- Work extensively on analyzing data from various systems to help create mapping documents; gather report requirements from the User meetings, respond to the ad hoc requests and answer the questionnaire from the client side.
- Create database stored procedures, functions, packages, and triggers application in MS SQL or Oracle relational databases; utilize secured software methodologies to develop and maintain software security compliance and prepare project plans detailing the necessary tasks and schedules, provide the status of assigned projects on written reports or at meetings and develop technical reports for users that provide an overview description of the proposed computer system.
Other
- A baccalaureate degree from an accredited college in computer science, engineering, human computer interaction, interactive media, digital and graphics design, data visualization, communication or a related field, and four years of satisfactory full-time experience related to the area(s) required by the particular position and a specialization in a relevant technology, process, methodology and/or domain; or
- An associate degree from an accredited college in computer science, engineering, human computer interaction, interactive media, digital and graphics design, data visualization, communication or a related field, and six years of satisfactory full-time experience related to the area(s) required by the particular position and a specialization in a relevant technology, process, methodology and/or domain; or
- A baccalaureate degree from an accredited college, and eight years of satisfactory full-time experience related to the area(s) required by the particular position and a specialization in a relevant technology, process, methodology and/or domain; or
- Education and/or experience which is equivalent to "1", "2", or "3" above.
- New York City Residency is not required for this position
