What are the responsibilities and job description for the Database Administration and Reporting Development Specialist position at PGMTEK Inc.?
Job Description
Job Title : Database Administrator and Reporting development Specialist
The candidate is responsible for Database management, Data Integration and Report Development. The candidate will be able to work independently and collaboratively with the team on the database management, development, testing, integration, maintenance, and support of the Branch on day-to-day operations.
Responsibilities :
- Responsible for all aspects of planning and management of database;
- Responsible for database environment configuration, migration and cutover, storage, fault handling, performance optimization, backup, daily monitoring, etc.;
- Design and develop database and applications with all phases of software development lifecycle.
- Use SSIS, SSRS, and SQL to develop ETL packages and reports.
- Design and develop new features / functionalities of ETL Data Integration using SSIS, SQL, C#, Java, Python, etc.
- Perform hands-on data-related tasks such as data analysis, data integration, data issue remediation, data reconciliation, data warehousing, and reporting automation.
- Develop functions, views and stored procedures, complex SQL queries for reports that meet business requirements.
- Write technical documents and testing reports. Provide support for the internal and external audit and exam.
- Be responsible for demonstrating risk awareness by following all policies, procedures, and internal control in their daily routine.
Education and Experience Requirements :
Skills and Knowledge Requirements :
