MS SQL Server and Database Administrator

• ·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 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

Requirements:

• 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
• Does your candidate have any previous working experience with the Pennsylvania State Department of Education