Note: The job is a remote job and is open to candidates in USA. Peraton is a national security and enterprise IT company delivering mission-focused solutions and technologies. The Mid-Level Microsoft SQL Server Database Administrator will support production databases across Microsoft SQL Server and AWS environments, ensuring performance, availability, backups, security, compliance, and timely incident resolution.
Responsibilities
- Install Microsoft SQL Server instances in various configurations:
- Standalone, Windows Failover Cluster, and Availability Groups
- Cloud hosting (AWS) including SQL Server RDS
- Develop, test, deploy and maintain security and audit solutions
- Implement Center for Internet Security (CIS) and Safeguard Computer Security Evaluation Matrix (SCSEM) hardening standards
- Review NESSUS scans to remediate vulnerabilities and database compliance findings
- Schedule, monitor, and validate database backups and restores
- Responsible for monitoring metrics collection jobs for performance, availability, and capacity planning though through Datadog
- Schedule and apply DB upgrades, patches, and certificates
- Follow best practices, work plans, checklists, and defined processes
- Proactively support application teams as needed
- Participate in project technical reviews. Lead work product reviews
- Develop and maintain database support documentation
- Responsible of complex database incidents and problems, providing resolutions in a timely manner
- Engage SMEs or vendors to resolve more complex incidents as required
- Implement customer database change requests
Skills
- Must be a U.S. Citizen with the ability to obtain and maintain the required Public Trust level clearance
- Bachelors Degree and 5 years of experience, an Associates Degree and 7 years of experience, or a High School Diploma or equivalent and 9 years of experience
- Minimum 5 years Microsoft SQL Server DBA experience including extensive production support required
- Experienced in virtualizing Microsoft SQL Server 2019/2022 and Microsoft SQL Server High Availability options (replication - transactional or log shipping and Always On)
- Experience with SQL Maintenance Plans, SQL Agent jobs, and Ola Hallengren's Maintenance Solutions
- Experience with MS Windows Security Domains, Networking, and Group Managed Service Accounts
- Experienced in AWS cloud operations supporting databases on EC2 and RDS instances
- Experience deploying and maintaining Cloud Native Databases leveraging Infrastructure as Code (Terraform) and CI/CD automation (GitLab and Liquibase)
- Excellent written and verbal communications skills
- Ability to independently work remote and collaborate effectively with team members
- Experience with transact/SQL language and programming experience/knowledge is a plus
Benefits
- Remote work allowed 100%
- Depending on the position, employees may be eligible for overtime, shift differential, and a discretionary bonus in addition to base pay.
Company Overview