SQL Database Administrator, Mid
Resource Management Concepts, Inc.
Dahlgren, virginia
Job Details
Full-time
Full Job Description
Resource Management Concepts, Inc. (RMC) provides high-quality, professional services to government and commercial sectors. Our mission is to deliver exceptional management and technology solutions supporting the protection and preservation of the people and environment of the United States of America.
RMC is hiring for a SQL Database Administrator to support our government customers in Dahlgren, VA. The successful candidate will perform in a fast-paced environment in the capacity of upgrades/migrations; instance/database hardening and supporting system accreditation activities; application and database troubleshooting; code review to include (evaluating the implications of using stored procedures and constraints to implement business rules), database design/development, optimize performance, recommend and implement process improvement technologies.
Requirements
- Five (5) years DBA experience with Microsoft SQL Server (2008R2, 2012, 2014, 2016, 2017, 2019) and Azure SQL Database (PAAS, IAAS, DAAS) in Production, Q/A and Test, and Development environments.
- Two (2) years' experience implementing and supporting highly available SQL Server environments, including experience with Failover Cluster and Always-On.
- Experience with SQL Server troubleshooting, performance tuning, issues monitoring and resolution, to include extended events and perfmon.
- Experience with SQL Server troubleshooting, ability to proactively identify, troubleshoot and resolve live database system issues.
- Experience supporting database on a virtual platform.
- Experience with the following functions: query, index and DB I/O performance tuning, and Stored Procedures and SQL coding.
- Experience with T-SQL and PowerShell scripts.
- Experience with disaster recovery principles and practices, to include planning, testing, backup/restore using disk-based backup solutions. Experience in Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler, extended events, index and fragmentation.
- Ability to detect and troubleshoot SQL Server related CPU, memory, I/O, disk space, and other resource contention.
- Knowledge of multiple IT environments including server and cloud-based platforms. Knowledge of comprehension of secure build techniques, tools, and practices of DISA Security Technical Implementation Guide (STIG).
- Experience with backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, and replication.
- Maintain and patch all database security vulnerabilities and implemented remediation.
- Experience with Azure Cloud and Database Service, to include Windows and Linux environments.
- Strong communication, interpersonal and human relations skills to interact with clients
- Strong analytical and problem-solving skills
- Ability to pay meticulous attention to detail
- Ability to work collaboratively on multi-disciplinary teams
- Certification: DoD 8570 IAT Level 2 (Security+ CE or equivalent) or Level 3 (CASP, CISSP, or equivalent)
- Certification: MS Azure Database Administrator Associate Certification (DP-300).
- Security Clearance: An Interim DoD secret security clearance is required to start. Applicant must be able to obtain a Top-Secret Clearance. Selected applicant may be subject to a security investigation and must meet eligibility requirements for access to classified information.
Benefits
At RMC, we're committed to your career growth! RMC differentiates itself from other firms through its investment in our employees. We invest our resources to train, certify, educate, and build our employees. RMC can offer you a great place to work with a small company feel and give you the experience and certifications that will take your career to the next level. RMC also offers high-quality, low-deductible healthcare plans and a competitive 401K package.