Database Engineer / Reporting Specialist

Peer Consulting Resources Inc.

Manhattan, NY

JOB DETAILS
SALARY
$107,137–$123,208
SKILLS
Adjudication, Adjudication Systems, Case Management, Computer Science, Continuous Deployment/Delivery, Continuous Integration, Data Management, Data Quality, Database Administration, Database Design, Database Extract Transform and Load (ETL), Database Programming, Database Technology, Government Regulations, Jenkins, Microsoft SQL Server, Microsoft SQL Server DBA (Database Administration), Microsoft Windows Azure, MongoDB, Multiplatform/Cross-Platform, MySQL, Performance Analysis, Performance Tuning/Optimization, PostgreSQL, Production Support, Production Systems, Quality Assurance, Query Optimization, SQL (Structured Query Language), SQL Databases, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Selenium, Server Support, Software Administration, Software Development, Software Testing, Stored Procedures, Test Automation, Test Data, Validation Testing
LOCATION
Manhattan, NY
POSTED
6 days ago
Contact Details:

Harika M

harika.mamidala@peer-consulting.com

(732) 242-4175

Job Title: Database Engineer / Reporting Specialist
Location: Manhattan, NY
Work Location: 66 John Street, New York, NY
Duration: Full Time
Years of Experience: 10+ Years
Required Hours/Week: 35Hours/Week
Job Overview:
  • 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

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.

About the Company

P

Peer Consulting Resources Inc.