Administer Microsoft SQL Server (replication, backup/restore, capacity planning, Reporting Services, Analysis Services, Integration Services)
Migrate databases from SQL Server 2012 to SQL Server 2016
Provide systems administration support: planning, execution, testing, installations, and configurations of new hardware and software
Recommend and implement solutions for SQL performance monitoring and tuning
Implement, deploy, and support Microsoft technologies (Visual Studio Framework, VB.NET, ASP.NET, Web Services)
Support virtualization technologies (VMware, Microsoft Hyper-V) including creating and configuring virtual machines
Perform backups of web, application, and database servers according to policies (daily incremental, weekly full backups)
Perform database activities such as monitoring, space management, and extended hours support when required
Collaborate with teams to support government IT projects and maintain system reliability
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
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
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; Experience with AWS RDS for PostgreSQL; Experience with cloud environments such as Azure and/or AWS; 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
Comprehensive benefits package
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 ServicesVB.NETASP.NETSDLC
Soft skills
ability to handle confidential materialsability to handle multiple assignmentscollaborationdocumentationpresentation skills