Database Administrator, Suitland, MD - Top Secret clearance
Employment Type : Full-Time
A new, five-year contract award has created the opportunity for a Database Administrator, to support our government customer based in Suitland, MD. This is an excellent career opportunity with unlimited growth potential.DescriptionThe Database Administrator (DBA) shall support the Information Technology (IT) team to provide high-performance, highly available, and secure Microsoft SQL Server database (DB) services in direct support of the activity's business and mission needs. Specifically, the DBA shall provide implementation, configuration, hardening, availability, resiliency, protection, automation, administration, and monitoring of multiple Microsoft SQL Server DB environments.
The DBA shall work under/with the Senior DBA to explore, investigate, research, analyze, assess, implement, and transition new technologies to an operational state to modernize and improve upon existing Microsoft SQL Server solutions.Qualifications- Shall have 3 or more years of progressive experience with Microsoft SQL Server capturing stakeholder and business requirements, designing, engineering, implementing, securing, and operating and maintaining vendor currently supported enterprise-level Microsoft SQL Server DB solutions (SQL Server 2012 and newer) across an IT multi-platform (Microsoft, *nix, etc.) enterprise information systems (LAN, MAN, WAN, etc.).
- Shall have 3 or more years of experience operating and maintaining solutions in secure processing environments which must adhere to U.S. Government Information Assurance and Security standards such as the Defense Information Systems Agency (DISA) Security Technical Implementation Guides (STIGs).
- Demonstrated experience implementing, maintaining, testing, and validating Microsoft SQL Server High Availability (HA) technologies and concepts, such as Basic and Always-on Availability Groups (BAG/AAGs) to maximize the availability, resiliency, reliability, and fault tolerance of product DB environments.
- Demonstrated experience designing, implementing, maintaining, testing, and validating Microsoft SQL Server Disaster Recovery (DR) solutions built on technologies and concepts such as log shipping and stretched AAGs, to ensure both local and off-site recovery capabilities within established Recovery Time and Point Objectives (RTO/RPOs).
- Demonstrated experience leveraging vendor provided best practices, systems, applications, and services to regularly patch and upgrade deployed Microsoft SQL Server implementations to maintain compliance and configuration requirements, minimizing, and eliminating if possible, production and end-user impact and/or downtime.
- Demonstrated experience authoring, testing, troubleshooting, and implementing scripted technologies, such as Microsoft PowerShell, PowerShell on Linux, Bash, T/SQL, etc., to automate and orchestrate routine, as well as complex, DBA duties and responsibilities, with a focus on maximizing efficiency, consistency, and minimizing the subsequent human error factor of related tasks.
- Shall meet the minimum credential requirements for a Cyber IT/Cybersecurity Workforce (CSWF) position as defined in Section 6, Table 3.
Desired Qualifications:- Strongly desired to be Microsoft Certified Solutions Associate (MCSA): SQL 2016 DB Administration certified.
- Technical certifications in additional enterprise level DB and OS vendor technologies, such as Microsoft, Oracle, and/or VMware, are also a plus.
- Strong understanding of Microsoft SQL Server 2016 architectures, implementation, and configurations within enterprise production environments is a strong plus.
- Strong understanding of common Microsoft SQL Server DBA activities to include DB health checks, Dynamic Management Views (DMVs), index optimization, performance tuning, query optimization, maintenance plans, link servers, etc. A thorough understanding of DMV views and how to utilize them to improve performance and monitoring is a plus.
- Demonstrated experience performing Microsoft SQL Server performance tuning with specific experience with analyzing query plans, tuning stored procedures, troubleshooting deadlocks, blocks, and long running queries, as well as isolating and resolving Input/Output (I/O) and CPU bottlenecks.
- Demonstrated experience implementing, maintaining, testing, and validating Microsoft SQL Server Data-at-Rest Encryption (DARE) and Data-in-Flight Encryption (DIFE) technologies and concepts in line with vendor guidance, best practice, and DISA STIG, and IA/INFOSEC requirements are a plus.
- Demonstrated experience migrating older and legacy, Microsoft SQL Server platforms, such as SQL, Server 2008 and 2008 R2 to SQL Server 2016 is a plus.
- Familiarity and willingness to work with other vendor DB platforms, such as MariaDB, MongoDB, MySQL, NoSQL, and Oracle is a strong plus.
- Familiarity with using third-party vendor backup solutions together with Microsoft SQL Server protection planning is a plus.
Requests for reasonable accommodations will be considered to enable individuals with disabilities to perform the principal (essential) functions of this job.Security Clearance- This position will require U.S. citizenship and an active DoD TS clearance, with a CI Poly preferred. The ability to obtain a CI poly is required