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 Minimum Qualifications Professional/Vendor Certification(s) in database administration (required). A baccalaureate degree from an accredited college or university plus two years of satisfactory full‑time experience in database administration, including database design, configuration, installation, troubleshooting, integration, performance monitoring, maintenance, enhancement, and security management. A four‑year high school diploma or its educational equivalent plus six years of satisfactory full‑time information technology experience, of which at least two years must have been database administration experience. A satisfactory equivalent of education and/or experience, with a minimum one year of full‑time database administration experience. 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 substitute for the required database administration experience. A master’s degree in computer science or a related field may substitute for one year of database administration experience. Preferred Skills 7+ years’ experience in database administration of SQL Server database environments. Working knowledge of Microsoft SQL Server 2014/2016/2019+. Thorough understanding of Relational Databases, T‑SQL Scripting, Database Normalization best practices, database technologies, and concepts. Proficient in Database Design with ability to perform logical to physical database transformation. Proficient with SQL Development – ability to write and troubleshoot SQL Code as well as design and code stored procedures, functions, tables, views, triggers, indexes, constraints. Experience troubleshooting and resolving database integrity and performance issues. Proficient with Performance Tuning and Query Optimization. Experience working with database automation tools to support CI/CD database activities. Experience working on small, medium and large‑scale projects. Experience with SSIS, SSRS and SSAS. Experience in support of ETL applications. Experience in data modeling principles/methods including conceptual, logical & physical data models. Experience with Microsoft Azure SQL Database. Demonstrated ability to work collaboratively and effectively in a team environment as well as independently. Ability to work with minimum supervision where required as well as ability to effectively perform work under specific direction. Prior experience leading small teams. Excellent written and verbal communication skills.

CERT IT ADMINISTRATOR (DB) - 13644

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 Residency Requirement New York City residency is not required for this position. Additional Information 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 on any legally protected status or 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. #J-18808-Ljbffr Nyc-Employees-Retirement-Sys