City of New York · 2 days ago
MS SQL Server database administrator
Brooklyn, NY
Full-time
Onsite
Senior Level
$135K/yr - $140K/yr
7+ years expThe City of New York is seeking an experienced Certified IT Administrator (DATABASE) to join their IT Database unit in the Information Technology division. The successful candidate will handle technical and supervisory responsibilities in SQL Server database administration, ensuring system availability and managing database servers.
GovernmentLegalPublic Relations
Responsibilities
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
Qualification
Required
Professional/Vendor Certification(s) in database administration that is required for the position to be filled
A baccalaureate degree from an accredited college or university, and two years of satisfactory full-time (not classroom based) experience in database administration. Experience must include database design, configuration, installation, troubleshooting, integration, performance monitoring, maintenance, enhancement, and security management
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
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
Preferred
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
Benefits
Public Service Loan Forgiveness
Company
City of New York
City of New York, often called as New York City, is the most populous city in United States.
10001+ employees
Funding
Current Stage
Late StageLeadership Team
Carl G Esposito
Chief Information Security Officer
Dawn Miller
Senior Advisor to the Chief Climate Officer
Recent News
The Real Deal
2026-01-02
bloomberglaw.com
2026-01-02
2025-12-26
Company data provided by crunchbase