Senior Database Administrator II

About the role

The Senior Database Administrator will be responsible for administering all aspects of Microsoft SQL Server, including Replication, Backup/Restore procedures, Capacity Planning, Reporting Services, Analysis Services, and Integration Services. They will also migrate databases from SQL Server 2012 to SQL Server 2016, provide systems administration support, recommend/implement solutions for SQL performance monitoring and tuning, and support visualization technologies such as VMware and Microsoft Hyper-V.

Responsibilities

• Administering Microsoft SQL Server including Replication, Backup/Restore procedures, Capacity Planning, Reporting Services, Analysis Services, and Integration Services.
• Migrating databases from SQL Server 2012 to SQL Server 2016.
• Providing all aspects of basic systems administration support including planning, execution, testing, installations, and configurations of new hardware and software.
• Recommending/implementing solutions for SQL performance monitoring and tuning.
• Implement, deploy, and/or support Microsoft Technologies such as Visual Studio Framework, VB.NET, ASP, NET and Web Services.
• Support visualization technologies such as VMware and Microsoft Hyper-V, creating and configuring virtual machines.
• Performing back ups of the web, application, and database servers according to MPA policies and procedures.
• Performing database activities such as monitoring, space management, and support, as well as extended hours of support for database systems when required.

Qualifications

• Minimum 5 years relevant experience related directly to SQL Server Database Administration.
• Ability to handle multiple assignments concurrently.
• Experience with visualization technologies such as VMware and Microsoft Hyper-V.
• Experience and knowledge related to source/change control, bug tracking, SDLC, and integration of Relational Databases.
• Ability to appropriately handle confidential and/or sensitive materials.
• Comfort with and willingness to work in groups and individually on both large and small projects.
• Ability to document, explain, and present any task related to decisions and processes.

Skills

• Experience implementing and maintaining data warehouses.
• Experience with AWS RDS for PostgreSQL.
• Experience with working in cloud environments such as Azure and/or AWS.
• Prior professional services or federal consulting experience.

Benefits

We offer a comprehensive benefits package including:

• Health, Dental, and Vision
• Life Insurance
• 401k
• Flexible Spending Account (Health, Dependent Care, and Commuter)
• Paid Time Off and Observance of State/Federal Holidays