Database Administrator

Engagement Type

Contract

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

Required/Desired Skills

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

Skills:

SQL,SSIS