LOCATION: Harrisburg, PA
POSITION TYPE: 12 month contract
POSITION TERMS: Hybrid Position – Flexible – at most 2 days per week.
Candidates must be local or within a one hour drive
The General Government Delivery Center (GGDC) is seeking a motivated and skilled for all Applications/SQL Servers. This individual will need to work independently as assignments are given as well as in a teams Setting working with Database Administrators, Developers of various skill levels, and with Networking/Server teams. They will be responsible for Database Support as well as SQL Server Administration.
- ·Perform database management activities using Microsoft SQL Server 2016/2019
- ·Install database software
- ·Analyze, design, and review logical and physical data models
- ·Support the application system development life cycle.
- ·Perform data analysis and correction activities
- ·Load data tables and perform data migration from one database structure to another
- ·Review and migrate stored procedures; recommend improvements to enhance performance
- ·Write and Use SSIS (SQL Server Integration Services) and PowerShell Scripts
- ·Follow and help enforce established database standards.
- ·Monitor database performance and space requirements and give recommendations to improve
- ·Analyze and resolve database performance issues
SKILLS:
| Perform database management activities using Microsoft SQL Server 2016/2019 | Required | 2 |
| Write and Use SSIS (SQL Server Integration Services) and PowerShell Scripts | Required | 2 |
| Assist with conversions from older SQL versions to current version | Required | 2 |
| Assist with database server infrastructure and software analysis and recommendations | Required | 2 |
| Help ensure databases are backed up appropriately and can be restored if necessary | Required | 2 |
| Maintain database access security and database integrity | Required | 2 |
| Previous working experience with the Pennsylvania State Department of Education |