MS SQL Server and Database Administrator

June 30, 2025 / Comments Off on MS SQL Server and Database Administrator

Perform database management activities using Microsoft SQL Server 2016/2019Required2
Write and Use SSIS (SQL Server Integration Services) and PowerShell ScriptsRequired2
Assist with conversions from older SQL versions to current versionRequired2
Assist with database server infrastructure and software analysis and recommendationsRequired2
Help ensure databases are backed up appropriately and can be restored if necessaryRequired2
Maintain database access security and database integrityRequired2
Previous working experience with the Pennsylvania State Department of Education

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/2019Required2Write and Use SSIS (SQL Server Integration Services) and PowerShell ScriptsRequired2Assist with conversions from older SQL versions to current versionRequired2Assist with database server infrastructure and software analysis and recommendationsRequired2Help ensure databases are backed up appropriately and can be restored if necessaryRequired2Maintain database access security and database integrityRequired2Previous working experience with the Pennsylvania State Department of Education
  • This field is for validation purposes and should be left unchanged.
  • Max. file size: 1 GB.