MS SQL Server database administrator

The New York City Employees’ Retirement System (NYCERS) 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. The successful candidate will not only possess strong technical skills in the areas of SQL Server database management but will also be exceptionally "hands on" and able to effectively perform work independently as well as part of a team, that may often require collaboration with members of other IT units and business users.

In this capacity, the successful candidate will:
- Ensure system availability, 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 (Development, Integration, QA, UAT and Production)
- 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. Estimate file sizes and growth
- 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 when it’s required
- Perform other duties as assigned

CERT IT ADMINISTRATOR (DB) - 13644