Senior Database Architect & Lead DBA (Azure SQL)

City of New York; New York (NY); On-site; USD 115,000 - 159,000; Full time

Benefits offered by this job

Public Service Loan Forgiveness

55-a Program eligibility

Job summary

City of New York seeks a highly experienced Computer Specialist (Software) IV to perform expert database administration, design data models for cloud and hybrid environments, and lead end-to-end data integration with Azure SQL, SSIS, and Power BI. The role emphasizes security, performance tuning, and outage response, with supervisory responsibilities noted from prior positions.

The position involves maintaining SQL Server clusters, implementing backups/recovery, and coordinating with development

Qualifications

• 7+ years proficiency with Microsoft Azure SQL development, SQL server DBA roles, Microsoft SQL server Management Studio, Microsoft Power BI, Reporting services and SQL server Database Administration 2016, 2019, and
• 7+ years proficiency in development and maintenance of Stored Procedures, Functions, Triggers, SQL statements., database connections, coding and design
• 6+ years proficiency in database administrator role.
• Performance Tuning including tuning/optimizing SQL, backup,
• A plus: knowledge of AI tools, Copilot, Windows environments, and cloud services (AWS, Microsoft Azure, related Microsoft certification)
• 4+ years supervisory experience required

Responsibilities

• Supervisory role in past job experiences
• Database Architecture, designing conceptual, logical, and physical data models for cloud and hybrid environments.
• Design, develop, automate, implement, and maintain database best practice standards, policies and procedures for ensuring the security and preserving data integrity.
• Data Integration & ETL, building modern data pipelines using ADF, or legacy SSIS environments. Create and optimize highly transactional queries, writing complex stored procedures, SQL Jobs, Power BI, SSRS, SSIS packages interface with multiple data sources.
• Install, maintain and configure SQL Server and Windows/SQL server failover cluster and Always On for various SQL environments (dev, staging and Prod).
• Implement data models and database designs, table maintenance and data access at REST and encryption.
• Monitor and respond to production issues, outages and identify enhancements needed to fix bugs (including off-hours).
• Security and compliance, perform regular security patch updates to ensure cyber security measures are intact and manage user permissions on database level. Implementing data masking, row-level security, encryption, and controlling role-based network access
• Performance Tuning and troubleshooting SQL databases, monitoring database metrics to eliminate execution bottlenecks by optimizing indexes, execution plans, and memory distribution.
• Create, manage and modify database SSRS reporting services and data mining
• Document database processes and solutions and develop all technical aspects needed to implement SQL.
• Work with the development and management teams to ensure successful development of business, functional, and technical specifications.
• Design and implement maintenance plan, backup & recovery system.

Skills

Azure SQL development

SQL Server DBA

Power BI

SSRS

SSIS

ASP.NET

C#.NET

Tools

SQL Server

Azure

SSRS/SSIS

Job description

City of New York seeks a highly experienced Computer Specialist (Software) IV to perform expert database administration, design data models for cloud and hybrid environments, and lead end-to-end data integration with Azure SQL, SSIS, and Power BI. The role emphasizes security, performance tuning, and outage response, with supervisory responsibilities noted from prior positions.

The position involves maintaining SQL Server clusters, implementing backups/recovery, and coordinating with development