Job Title: SQL Server and Database Administrator
Location: Harrisburg, PA (Hybrid)
Duration: 12 Months (Possible Extension)
Job Description:
We are seeking an experienced SQL Server and Database Administrator to support database management and development efforts. The ideal candidate will have hands-on experience with SQL Server 2016/2019, database infrastructure, and automation scripting using SSIS and PowerShell.
Key Responsibilities:
Manage and maintain SQL Server databases (2016/2019)
Install and configure database software
Design, analyze, and review data models
Perform data analysis, corrections, and migrations
Develop and maintain SSIS packages and PowerShell scripts
Monitor and optimize database performance
Support database backup, restore, and disaster recovery planning
Manage database access security and integrity
Collaborate with development teams throughout the application lifecycle
Use Azure DevOps for version control and task tracking
Stay current with database technologies and recommend best practices
Represent the DBA team in project meetings as needed
Required Skills & Experience:
2+ years of experience with SQL Server 2016/2019
2+ years of SSIS and PowerShell scripting
Experience with database upgrades and migrations
Strong background in database infrastructure and performance tuning
Knowledge of backup, restore, and DR procedures
Experience with database access control and data security