Note: The job is a remote job and is open to candidates in USA. CGS Federal is seeking a Senior Database Administrator to assist with administering all aspects of Microsoft SQL Server. The role involves managing SQL Server databases, providing systems administration support, and implementing solutions for performance monitoring and tuning.
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. This hall includes daily incremental backups and full weekly backups of all volumes of servers
- Performing database activities such as monitoring, space management, and support, as well as extended hours of support for database systems when required
Skills
- 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
- 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
- Health, Dental, and Vision
- Life Insurance
- 401k
- Flexible Spending Account (Health, Dependent Care, and Commuter)
- Paid Time Off and Observance of State/Federal Holidays
Company Overview