THE SELECTED CANDIDATE WILL BE OFFERED A SALARY BETWEEN $,-$,.
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 ACS Office of Information Technology Infrastructure and Support Group provides, manages, and supports the Agency’s technology infrastructure, software, and services. Infrastructure and Support comprises the Service Desk, IT Technical Support, Infrastructure, Production Support, and Telecom Management.
The Production Support unit is comprised of three operational areas : Production Administration, Systems Administration, and Database Administration. Under supervision, with latitude for independent action and the exercise of independent judgment, the Database Administrator is responsible for managing and maintaining all Microsoft SQL Servers database environments. The candidate specific duties will include :
Note, candidate may be required to work after hours and weekends as needed.
ADDITIONAL INFORMATION
THE SELECTED CANDIDATE WILL BE OFFERED A SALARY BETWEEN $,-$,.
Section -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
APPLICATIONS MUST BE SUBMITTED ELECTRONICALLY USING ONE OF THE OPTIONS BELOW :
For current city employees, go to Employee Self Service (ESS), Recruiting Activities, Careers and search for Job ID#.
For all other applicants go to and search for Job ID#. Click on the "Apply" button.
If you do not have access to a computer, most public libraries have computers available for use.
Only candidates selected for an interview will be contacted.
Minimum Qualifications
Professional / Vendor Certification(s) in database administration that is required for the position to be filled. In addition, you must have one of the following :
2. A four-year high school diploma or its educational equivalent and six years of satisfactory full-time (not classroom based) information technology experience (IT) of which at least two years must have been database administration experience as described in "1" above; OR
3. A satisfactory equivalent of education and / or experience equivalent to “1” or “2” above. Undergraduate education may be substituted for experience on the basis that 30 undergraduate semester credits from
an accredited college or university is equivalent to 6 months of information technology experience, but may not be substituted for the required database administration experience. A masters degree in computer science or a related field from an accredited college or university may substitute for one year of database administration experience. However, all candidates must have at least one year of satisfactory full-time (not classroom based) database administration experience as described in "1" above.
Preferred Skills
The preferred candidate should possess the following : - Preferably 5 years’ proven experience as database administrator managing a large scale of Microsoft SQL databases in windows OS environment.- Certification in MSSQL Server Database Administration preferred.- Experience to install, configure, manage, monitor, and troubleshoot Microsoft SQL Server / database environment, and Third-Party COTS windows products.- Experience with ETL tool Microsoft SQL Server Integration Services (SSIS).- Experience in MS SQL Server Job System.- Network Topology - Transmission Control Protocol (TCP) / Internet protocol suite (IP) - (TCP / IP).- Knowledge of virtual servers and storage area network (SANs) related to capacity planning, security, and performance tuning.- Experience in IIS, SSL / Windows OS Server environment, MS Visio, SQL performance monitoring tool Idera.- Expert level proficiency in TSQL, experience in SQL code deployment using change management process.- Knowledge of Azure SQL database services.- Knowledge of approaches, tools, and techniques for recognizing and resolving technical issues related to database environment.- Strong interpersonal and problem-solving skills.- Ability to multitask and perform in a high-paced / high-pressure environment.- Ability to work independently or within a group to resolve issues.- Ability to communicate with different levels of the organization.- Strong team player with service-oriented attitude and customer focus.
55a Program
This position is also open to qualified persons with a disability who are eligible for the 55-a Program. Please indicate at the top of your resume and cover letter that you would like to be considered for the position through the 55-a Program.
Public Service Loan Forgiveness
As a prospective employee of the City of New York, you may be eligible for federal loan forgiveness programs and state repayment assistance programs. For more information, please visit the U.S. Department of Education’s website at class="jobad-residencyRequirement">
Residency RequirementNew York City Residency is not required for this position