MS SQL Server database administrator

City of New York
New York, NY
Job Description
The New York City Employees’ Retirement System is seeking an experienced Certified IT Administrator (DATABASE) to join our IT Database unit in the Information Technology division. This position encompasses highly technical and supervisory responsibilities in SQL Server database administration, including monitoring, maintaining, enhancing, conducting security management, data modeling, auditing, and supporting complex on-prem and cloud database systems and related functions.

Requirements

  • Ensure system availability and recovery
  • Execute performance tuning, backup, and restoration of databases
  • Provide daily management of Microsoft SQL Server, infrastructure and service availability
  • Maintain over 60 database servers across multiple environments
  • Work with developers and infrastructure teams to provide world class services to the business community and NYCERS clients
  • Develop and maintain procedures, best practices and standards documentation
  • Enforce policies and procedures to ensure regulatory compliance
  • Keep SQL servers up to date with necessary patches
  • Promote application database changes to higher environments
  • Perform server migration/upgrade activities
  • Manage database storage based on design and determine operating system requirements
  • Research, evaluate, and provide feedback on problematic trends and patterns
  • Diagnose and resolve problems in response to reported incidents
  • Assist in the preparation and support of data conversion, migration and Extract, Transform, Load (ETL) tools
  • Lead by example and provide technical guidance to other IT DATABASE team members
  • Perform other duties as assigned

Benefits

  • Generous Paid Time Off
  • 401k Matching
  • Retirement Plan
]]>