Database Administrator and Reporting development Specialist

Database Administrator and Reporting development SpecialistNew York, United States | Posted on 03/18/2026Welcome to PGMTEK, Inc where we help candidates find the opportunities that best match with their career goals.Job DescriptionReports to: Teamleader/Deputy Head of ITSummary This position is theBranch's Database Administrator and Reporting Specialist. The role is responsible for Databasemanagement, Data Integration and Report Development including the database management, development, testing,integration, maintenance, and support of the Branch on day-to-day operations.Responsibilities:Responsible for the planning and management of databaseand related database application.Responsible for database environment configuration,migration and cutover, storage, fault handling, performance optimization,backup, daily monitoring, etc.;Analysis business need and provide technicalsolutions to meet end-users' need.Design and develop database and applications withall phases of software development lifecycle.Conducts system integration testing (SIT) and useracceptance testing (UAT), creates SIT testing cases, and drafts reports.Provide support for the business the user acceptance testing (UAT).Use SSIS, SSRS, and SQL to develop ETL packages andreports.Design and develop new features/functionalities ofETL Data Integration using SSIS, SQL, Java, Python, etc.Perform hands-on data-related tasks such as dataanalysis, data integration, data issue remediation, data reconciliation, datawarehousing, and reporting automation.Develop functions, views and stored procedures,complex SQL queries forreports that meet business requirements.Collaborate with IS team and HO in vulnerability andbatch installed and remediated on time.Be responsible for demonstrating risk awareness byfollowing all policies,procedures, and internal control in their dailyroutine.Educationand Experience Requirements:Bachelor's degree in Computer Science or equivalent relatedfield.2+ years of experience in Microsoft SQL Server orother database applications in an enterprise environment.Skillsand Knowledge Requirements:Have experience in database project, large-scaledatabase operation and maintenance management.Familiar with data backup, restoration, import,export, synchronization, format conversion and other operations of MicrosoftSQL Server or other database.Extensive experience developing, writing advancedSQL queries and stored procedures andtroubleshooting their performance.Experience in develop test plans, test scripts,validation procedures, and perform systemtesting.Familiarity with Business Intelligence toolsincluding SSIS and SSRS, integration with SQL.Ability to develop reports development andmaintenance policies, and draft the newproduct or report requirements.J-18808-Ljbffr