Database Engineer
Core
Manage, optimize, and support diverse database environments (SQL Server, Azure SQL, MongoDB, MySQL, PostgreSQL) and reporting systems for the City of New York's administrative tribunal adjudications.
Role type
Mid-to-senior Database Engineer/Reporting Specialist
Builds
Adjudications systems, ETL workflows, and data-driven application support
Domain
Public sector / Administrative law / Data infrastructure
Deliverable
production ML models | product features | dashboards & analysis | infrastructure
Required skills
Microsoft SQL Server performance tuning, Azure SQL Database, MongoDB, MySQL, PostgreSQL, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), ETL workflow design, query optimization, data validation, QA process support, automation testing tools (Selenium, Cypress)
Preferred skills
Experience with QA processes, automation testing tools
Technologies
Microsoft SQL Server, Azure SQL Database, MongoDB, MySQL, PostgreSQL, SSIS, SSRS, Selenium, Cypress
Responsibilities
Proactively identify and resolve database performance bottlenecks, optimize queries for scalability and reliability, design and maintain ETL workflows, develop reports, collaborate with development and QA teams on data validation and test data preparation
Seniority
Mid-to-senior level, hands-on IC
