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

.