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 possess strong technical skills in SQL Server database management and be exceptionally "hands on," able to work independently as well as part of a team, often collaborating with members of other IT units and business users. In This Capacity, The Successful Candidate Will 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 (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 ETL tools Lead by example and provide technical guidance to other IT DATABASE team members when required Perform other duties as assigned Minimum Qualifications A baccalaureate degree from an accredited college or university, and two years of satisfactory full‑time experience in database administration, including database design, configuration, installation, troubleshooting, integration, performance monitoring, maintenance, enhancement, and security management Alternatively, a four‑year high school diploma or equivalent and six years of satisfactory full‑time information technology experience, of which at least two years must be in database administration as described above A satisfactory equivalent of education and/or experience equivalent to the above requirements, including undergraduate education that may substitute for experience on the basis of credit hours, or a master’s degree that may substitute for one year of database administration experience All candidates must have at least one year of satisfactory full‑time database administration experience Professional or vendor certification(s) in database administration that is required for the position Preferred Skills 7+ years of experience in SQL Server database administration Working knowledge of Microsoft SQL Server 2014/2016/2019+ Thorough understanding of relational databases, T‑SQL scripting, database normalization best practices, and database technologies Proficiency in database design, logical to physical transformation, and SQL development Experience troubleshooting and resolving database integrity and performance issues, including performance tuning and query optimization Experience with database automation tools to support CI/CD database activities Experience with SSIS, SSRS, SSAS, and ETL applications Experience with Microsoft Azure SQL Database Strong communication skills and ability to work collaboratively in a team environment Previous experience leading small teams Equal Opportunity 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. Compensation $135,000.00 – $140,000.00 #J-18808-Ljbffr City of New York