Database Engineer Reporting Specialist

Peer Consulting Resources Inc.

Job Location:

Manhattan, IL - USA

Monthly Salary: Not Disclosed

Posted on: 12 days ago

Vacancies: 1 Vacancy

Job Summary

Contact Details:

Harika M

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 agencys 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:

Bachelors 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.

Contact Details: Harika M 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 s...