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, installation, and configuration 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).
Create and configure virtual machines and support virtualization technologies (VMware, Microsoft Hyper-V).
Perform daily incremental and weekly full backups of web, application, and database servers per policy.
Monitor databases, manage space, provide support and extended-hours coverage as required.
Collaborate with teams on projects and document processes and decisions.
Requirements
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.
Experience with visualization technologies such as VMware and Microsoft Hyper-V, creating and configuring virtual machines.
Performing backups of the web, application, and database servers according to MPA policies and procedures (daily incremental and full weekly backups).
Performing database activities such as monitoring, space management, and extended hours of support when required.
Minimum 5 years relevant experience related directly to SQL Server Database Administration.
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.
(Ideally) Experience implementing and maintaining data warehouses.
(Ideally) Experience with AWS RDS for PostgreSQL.
(Ideally) Experience with working in cloud environments such as Azure and/or AWS.
(Ideally) Prior professional services or federal consulting experience.
Benefits
Comprehensive benefits package
Health, Dental, and Vision
Life Insurance
401k
Flexible Spending Account (Health, Dependent Care, and Commuter)
Paid Time Off and Observance of State/Federal Holidays
ATS 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.NETSQL performance monitoring
Soft skills
collaborationdocumentationcommunicationplanningexecutiontestingconfigurationconfidentialityindividual workgroup work