Talent.com
Database Administrator

Database Administrator

City of New YorkMANHATTAN
30+ days ago
Salary
USD100743–USD142460 yearly
Job type
  • Full-time
Job description

THE SELECTED CANDIDATE WILL BE OFFERED A SALARY BETWEEN $,-$,.

  • ONLY PERMANENT EMPLOYEES IN THE CERTIFIED IT ADMINISTRATOR (DATABASE) TITLE ARE ELIGIBLE TO APPLY.

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 :

  • Plan, design, install, configure, secure, maintain, and support all versions of Microsoft SQL Database Servers on Windows OS environment.
  • Analyze, monitor the resource utilization, and tune the performance of the SQL and associated components, monitor thread usage, CPU and memory usage.
  • Analyze the log files, thread dumps, exception stack traces.
  • Implement and maintain security access (Users, logins, schemas)
  • Provision and de-provision user accounts and access privileges and perform periodic validation.
  • Design and implement databases in accordance with user requirements and views.
  • Develop, validate, and implement an overall strategy to patch server environments including security updates on a regular schedule.
  • Ensure that all changes to the environment adheres to established Change Management policies and procedures.
  • Perform regular SQL Server backup and restore / recover when needed.
  • Perform periodic disaster recovery test for the database, application server environments and maintain disaster recovery documentation and procedures in support of these systems.
  • Collaborate with application developers, database administrators and system administrators for configuration and integration of database and application components.
  • Evaluate new systems and applications requirements for resource planning.
  • Setup and monitor the scheduled batch jobs.
  • Setup and monitor system alerts to provide 24x7 support and high availability.
  • Liaise with Microsoft, and other vendors to troubleshoot technical issues.
  • Follow communications protocol for system failures, outages and file incident reports.
  • Respond to Service Desk tickets for technical support ensuring timely follow up and resolution.
  • Prepare system configurations and management support documentation and provide training and knowledge transfer to other team members as needed.
  • Create and maintain infrastructure Architecture diagrams.
  • 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 :

  • 1. A baccalaureate degree from an accredited college or university, and two years of satisfactory fulltime (not classroom based) experience in database administration. Experience must include database design, configuration, installation, troubleshooting, integration, performance monitoring, maintenance, enhancement, and security management;
  • 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