Overview
Skills
Job Details
Role : Database Support / SQL Server
Hybrid (333 Market St, Harrisburg, PA 17101; seeking clarification on schedule)
2 days a week to office, Locals
Responsibilities:
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 sfrom 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 PDE database standards.
Monitor database performance and space requirements and give recommendations to improve
Analyze and resolve database performance issues
Assist with conversions from older SQL versions to current version
Maintain database access security and database integrity
Help ensure databases are backed up appropriately and can be restored if necessary
Assist with database server infrastructure and software analysis and recommendations
Conduct work in a team environment
Use strong communication skills; both written and spoken
Determine time estimates and schedule for own work
Use Azure DevOps for source control, manage work items, for documentation versioning, and to report time spent on all assigned work item activities
Complete assigned work activities; Anticipate and resolve issues in a timely manner
Communicate accurate and useful status updates to the Database Administration Section Chief, and to each Application Lead analysts/project managers
Execute all assigned responsibilities with little direct supervision from the Database Administration Section Chief
Represent DBA staff at status meetings and other meetings as requested
Keep current with the features of new database releases and related database products and make recommendations as to their use
Make recommendations on best practices and improvements surrounding database administration practices
Skill
Required / Desired
Amount
of Experience
Perform database management activities using Microsoft SQL Server 2016/2019
Required
2
Years
Write and Use SSIS (SQL Server Integration Services) and PowerShell Scripts
Required
2
Years
Assist with conversions from older SQL versions to current version
Required
2
Years
Assist with database server infrastructure and software analysis and recommendations
Required
2
Years
Help ensure databases are backed up appropriately and can be restored if necessary
Required
2
Years
Maintain database access security and database integrity
Required
2
Years
Question 3
Does your candidate have any previous working experience with the Pennsylvania State Department of Education?