Database Engineer / Reporting Specialist

Job title: Database Engineer / Reporting Specialist Location: Manhattan, NY Work Location: New York, NY Client/Agency: NYC Office of Administrative Trials and Hearings Department: IT Employment Type: Full-time / Permanent Role About the Role The IT Department is seeking a skilled Database Engineer / Reporting Specialist to support the agency’s main adjudication systems. This role requires strong hands-on experience in database administration, SQL performance tuning, reporting, ETL workflows, and support across multiple database platforms. The ideal candidate will be responsible for ensuring database performance, reliability, scalability, and reporting accuracy across development and production environments. This position will also work closely with development and QA teams to support data validation, test data preparation, and application delivery. Key Responsibilities • Manage, optimize, and support Microsoft SQL Server databases. • Perform SQL query optimization, schema design, indexing, and performance tuning. • Support database environments across development and production systems. • Design and maintain ETL workflows using SQL Server Integration Services. • Develop and maintain reports using SQL Server Reporting Services and other reporting tools. • Support multiple database platforms including Azure SQL Database, MongoDB, MySQL, and PostgreSQL. • Collaborate with application development and QA teams on data validation and test data management. • Identify database bottlenecks and recommend improvements. • Support software quality initiatives and application development needs. Required Skills • Strong experience with Microsoft SQL Server Administration. • Hands-on experience with SQL query optimization, performance tuning, schema design, stored procedures, and indexing strategies. • Experience with SQL Server Integration Services. • Experience with SQL Server Reporting Services or similar reporting technologies. • Experience supporting development and production database environments. • Strong understanding of database performance, reliability, and scalability. • Experience with data validation and working closely with QA/development teams. Preferred Skills • Experience with Azure SQL Database. • Experience with MongoDB, MySQL, and PostgreSQL. • Exposure to CI/CD tools such as Jenkins. • Exposure to QA automation tools such as Selenium, Cypress, or similar tools. • Prior experience supporting government, legal, adjudication, or case management systems. Minimum Qualifications • Bachelor’s degree in computer science or related field with relevant software/database experience; or • High school diploma/equivalent with equivalent full-time software experience; or • A satisfactory combination of education and experience. Candidates must have experience serving as a project leader or major contributor on a complex software/database project.