Job Description THE SELECTED CANDIDATE WILL BE OFFERED A SALARY BETWEEN $92,236.00-$106,071.00 The Administration for Children’s Services (ACS) protects and promotes the safety and well-being of children and families through child welfare and juvenile justice services and community supports. ACS manages community-based supports and foster care services, and provides subsidized child care vouchers. ACS child protection staff respond to allegations of child maltreatment. In juvenile justice, ACS oversees detention, placement and programs for youth in the community. The New York City Administration for Children’s Services of Office of Information Technology (OIT) Business Solutions department is responsible for the building the systems that provide operational, analytical and managerial support functions, as well as IT resource management, for the entire agency. Working closely with different business stakeholders within the agency, Business Solutions develops and implements both custom and packaged applications, and maintains the requisite technical infrastructure, using in-house project resources and hired consultants. We encourage innovation, creativity, and a think outside of the box attitude when solving complex problems and implementing new solutions. The Office of Information Technology Business Solutions is recruiting a Certified Applications Developer functioning as a Systems Developer who will under general supervision and with broad scope for independent initiative and judgment lead the effort of complex application development according to requirements, specifications using ASP, .NET, C#, Oracle/SQL Server and associated languages and tools in a variety of systems development life cycle (SDLC) methodologies, including Waterfall, Agile and Hybrid Agile. The selected candidate will be responsible for performing the following duties but not limited to: - Lead the effort of complex application development according to requirements, specifications using ASP, .NET, C#, and Oracle, SQL Server. - Design complex database tables; develop complex packages, functions, and stored procedures using SQL Server and/or PL, SQL, database Job Scheduling. - Create ETL process. - Create and update Data Warehouse Data Mart. - Create and update Technical Design Documents. - Perform unit and integration testing. - Interact with Business Analysts and customers to comprehend product requirements. - Explain technical concepts to users and help them understand the solutions implemented. - Estimates timeframe to implement specifications. - Create reports in SSRS, BI Publisher or other reporting tool. - Works with the business analysts to program the specifications. - Utilize version control systems such as Team Foundation Server (TFS). - Create and schedule tuning jobs. ADDITIONAL INFORMATION THE SELECTED CANDIDATE WILL BE OFFERED A SALARY BETWEEN $92,236.00-$106,071.00 Section 424-A of the New York Social Services Law requires an authorized agency to inquire whether a candidate for employment with child-caring responsibilities has been the subject of a child abuse and maltreatment report. TO APPLY Please go to www.cityjobs.nyc.gov or www.nyc.gov/ess for current NYC employees and search for Job ID#616577. No phone calls, faxes or personal inquiries permitted. Note: Only candidates under consideration will be contacted. Qualifications Professional/vendor certification(s) in computer applications programming that is required for the position to be filled. In addition, all candidates must have the following: 1. A baccalaureate degree from an accredited college, and two years of satisfactory full-time (not classroom based) experience in computer applications development planning, design, configuration, installation, troubleshooting, integration, performance monitoring, maintenance, enhancement, and security management; or 2. A four-year high school diploma or its educational equivalent and six years of satisfactory full-time (not classroom based) information technology experience of which at least 2 years must have been as described in "1" above; or 3. A masters degree in computer science or a related field from an accredited college may substitute for one year of experience. However, all candidates must have at least one year of satisfactory full-time (not classroom based) information technology experience as described in "1" above. Additional Information The City of New York is an inclusive equal opportunity employer committed to recruiting and retaining a diverse workforce and providing a work environment that is free from discrimination and harassment based upon any legally protected status or protected characteristic, including but not limited to an individual's sex, race, color, ethnicity, national origin, age, religion, disability, sexual orientation, veteran status, gender identity, or pregnancy.