Database Analyst, Bureau of IT Application and Platform Engineering

The Division of Information Technology's mission and vision is to promote and protect the health of all New Yorkers through the use of innovative technology and health information that is useful and available.

We are seeking a seeking a Database Analyst professional to join the Database Administration team and support data-driven public health IT initiatives. This role serves as a critical support and coordination lead for the Director of Database Administration, overseeing the operational stability of a large-scale SQL Server environment. The position acts as a central liaison between technical teams and divisional IT units to ensure the seamless delivery of database initiatives.

Job Duties and Responsibilities:
- Support the Director of Database Administration by assisting with planning, coordination, tracking, and reporting of database administration activities across production and non-production SQL Server environments (SQL Server 2016–2022).
- Assist in the day-to-day oversight and monitoring of a large-scale enterprise database environment consisting of 60+ servers and 1,500+ databases, ensuring operational stability and service continuity.
- Act as a liaison between DBA teams, application development, infrastructure, network operations, and divisional IT units to facilitate communication, gather requirements, and support timely delivery of database-related initiatives.
- Coordinate and track database change requests and deployments, ensuring proper approvals, documentation, scheduling, and adherence to change management processes.
- Assist with coordination of backup, recovery, high availability, and disaster recovery activities, including documentation, validation, and status reporting.
- Assist in the development and documentation of standard operating procedures, workflows, and best practices for database administration activities.
- Monitor dashboards, alerts, and incident reports; track production issues, outages, and remediation activities, escalating as needed and ensuring follow-up actions are completed.
- Coordinate after-hours and weekend support coverage, including scheduled maintenance and emergency response activities.
- Support process improvement initiatives by helping identify opportunities for automation, efficiency gains, and risk reduction in DBA operations.

Preferred Skills:
- 5+ years of experience in IT operations, Project Management, or technical analyst role, preferably supporting database or infrastructure teams.
- Strong experience developing and maintaining metrics, dashboards, scorecards, and management reports using Excel, Power BI, Tableau, or similar tools.
- Demonstrated ability to manage RAID logs, schedules, milestones, and deliverables in alignment with PMO methodologies.
- Working knowledge of SQL Server environments sufficient to understand operational impacts, dependencies, and risks (no hands-on administration required).
- Experience analyzing incidents, changes, and service request data to identify trends and support continuous improvement initiatives.
- Ability to synthesize technical information into clear, concise executive-level summaries and visual reporting.
- Strong organizational and documentation skills, with the ability to manage multiple workstreams and competing priorities.
- Proven ability to collaborate across DBA, application development, QA, infrastructure, security, audit, and PM teams.
- Ability to translate business objectives into measurable operational outcomes and KPIs.
- Excellent written and verbal communication skills.
- Detail-oriented, process-focused professional with a strong interest in operational excellence, data-driven decision-making, and continuous improvement.

Why you should work for us:

- Loan Forgiveness: As a prospective employee of the City of New York, you may be eligible for federal/state loan forgiveness and repayment assistance programs that lessen your payments or even fully forgive your full balance. For more information, please visit the U.S. Department of Education’s website (https://studentaid.gov/pslf/)
- Benefits: City employees are entitled to unmatched benefits such as:
o a premium-free health insurance plan that saves employees over $10K annually, per a 2024 assessment.
o additional health, fitness, and financial benefits may be available based on the position’s associated union/benefit fund.
o a public sector defined benefit pension plan with steady monthly payments in retirement.
o a tax-deferred savings program and
o a robust Worksite Wellness Program that offers resources and opportunities to keep you healthy while serving New Yorkers.
- Work From Home Policy: Depending on your position, you may be able to work up to two days during the week from home.
- Job Security - you could enjoy more job security compared to private sector employment and be able to contribute to making NYC a healthy place to live and work.

Established in 1805, the New York City Department of Health and Mental Hygiene (NYC Health Department) is the oldest and largest health department in the U.S., dedicated to protecting and improving the health of NYC. Our mission is to safeguard the health of every resident and cultivate a city where everyone, regardless of age, background, or location, can achieve their optimal health. We provide a wide array of programs and services focused on food and nutrition, anti-tobacco support, chronic disease prevention, HIV/AIDS treatment, family and child health, environmental health, mental health, and social justice initiatives. As the primary population health strategist and policy authority for NYC, with a rich history of public health initiatives and scientific advancements, from addressing the 1822 yellow fever outbreak to the COVID-19 pandemic, we serve as a global leader in public health innovation and expertise.

Come join us and help to continue our efforts in making a difference in the lives of all New Yorkers!

The NYC Health Department is an inclusive equal opportunity employer committed to providing access and reasonable accommodation to all individuals. To request reasonable accommodation to participate in the job application or interview process, contact Sye-Eun Ahn, Director of the Office of Equal Employment Opportunity, at [email protected] or 347-396-6549.

CERT IT ADMINISTRATOR (DB) - 13644

Professional/Vendor Certification(s) in database administration that is required for the position to be filled. In addition, you must have one of the following:
1. A baccalaureate degree from an accredited college or university, and two years of satisfactory fulltime (not classroom based) experience in database administration. Experience must include database design, configuration, installation, troubleshooting, integration, performance monitoring, maintenance, enhancement, and security management;

2. 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 as described in "1" above; OR

3. 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 as described in "1" above.

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.