Administer Microsoft SQL Server environments including Replication, Backup/Restore, Capacity Planning, Reporting Services, Analysis Services, and Integration Services.
Migrate databases from SQL Server 2012 to SQL Server 2016.
Provide systems administration support: planning, execution, testing, installations, and configurations of hardware and software.
Recommend and implement SQL performance monitoring and tuning solutions.
Implement, deploy, and support Microsoft technologies (Visual Studio Framework, VB.NET, ASP.NET, Web Services).
Support virtualization platforms (VMware, Microsoft Hyper-V) and create/configure virtual machines.
Perform backups of web, application, and database servers (daily incremental and weekly full backups) according to policies.
Monitor databases, manage space, and provide extended-hours support when required.
Collaborate with teams on projects and document processes and decisions.
Requirements
Minimum 5 years relevant experience related directly to SQL Server Database Administration.
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 systems administration support including planning, execution, testing, installations, and configurations of new hardware and software.
Recommending/implementing solutions for SQL performance monitoring and tuning.
Implementing, deploying, and/or supporting Microsoft technologies such as Visual Studio Framework, VB.NET, ASP.NET and Web Services.
Experience with virtualization technologies such as VMware and Microsoft Hyper-V, creating and configuring virtual machines.
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.
Ability to handle multiple assignments concurrently.
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.
Ideally: Experience implementing and maintaining data warehouses.
Ideally: Experience with AWS RDS for PostgreSQL.
Ideally: Experience working in cloud environments such as Azure and/or AWS.
Ideally: Prior professional services or federal consulting experience.
Benefits
Health, Dental, and Vision
Life Insurance
401k
Flexible Spending Account (Health, Dependent Care, and Commuter)
Paid Time Off and Observance of State/Federal Holidays
Professional growth through various learning opportunities
Applicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard skills
Microsoft SQL ServerReplicationBackup/RestoreCapacity PlanningReporting ServicesAnalysis ServicesIntegration ServicesSQL performance monitoringVB.NETASP.NET
Soft skills
ability to handle confidential materialsability to handle multiple assignmentscollaborationdocumentationpresentation skills