Senior SQL Database Administrator (TS/SCI Required) with Security Clearance

Praescient Analytics; Fort Belvoir (VA); Vor Ort; USD 110.000 - 170.000; Vollzeit

Benefits dieser Stelle

Competitive salary

Company-paid healthcare

401(k) with company match

Travel incentives

Paid time off with holidays

Zusammenfassung

Praescient Analytics seeks a Senior SQL Database Administrator to manage multiple RDMS across networks supporting DoD and IC applications. You will lead eighty databases across five networks, ensuring performance, security, and high availability for critical .NET-based systems.

Responsibilities include system maintenance, disaster recovery planning, and security/compliance with DISA STIGs. This role requires TS/SCI clearance, U.S. citizenship, and the ability to work on-site at Fort Belvoir, VA.

Qualifikationen

• 8+ years of experience in SQL database administration supporting production environments.
• 5 years of experience installing and configuring Microsoft SQL Server in High Availability Group configurations.
• 5 years of experience with T-SQL, including writing scripts, stored procedures, triggers, and views to automate maintenance.
• 3 years of experience serving as a team leader, managing task progress, and mentoring junior personnel.
• 3 years of experience implementing security measures per industry best practices and DISA STIGs.
• Active TS/SCI Level Security Clearance (U.S. Citizen).
• Current DoDD 8140.01 IAT II certification and Microsoft SQL Server certifications.

Aufgaben

• Systems Maintenance: perform daily system checks and track findings via the DCD IT Portal.
• High Availability: maintain data replication using Availability Groups.
• Security & Compliance: apply DISA STIGs within 30 days of release and enforce least privileged access.
• Performance Tuning: optimize code and stored procedures for fast query responses.
• Disaster Recovery: develop backup/recovery plans and test 10% of backups monthly.
• Technical Documentation: create ERDs, architecture diagrams, and SOPs.
• Operational Support: respond to outages within 30 minutes; provide after-hours on-site support with 2-hour response.

Kenntnisse

SQL database administration

T-SQL scripting

Team leadership

Security best practices

DISA STIGs compliance

High Availability / Availability Group

Tools

Microsoft SQL Server

Availability Groups

SQL Server 2016

Jobbeschreibung

Location: Ft. Belvoir, VA Clearance Required: TS/SCI minimum (US Citizen) Employment Type: Full-Time About Praescient Analytics: Praescient Analytics is a leader in delivering advanced analytic, data engineering, and technology integration solutions in support of the Department of Defense (DoD), Intelligence Community, and federal law enforcement. Our mission is to empower analysts and decision-makers through data-driven insights, enabling faster and more effective mission outcomes. Position Overview: Praescient Analytics is seeking a Senior SQL Database Administrator to provide comprehensive database management for the Data Capabilities Division (DCD). You will lead the administration of approximately nine Relational Database Management Systems (RDMS) hosting twenty databases across five distinct networks (NIPR, SIPR, JWICS, BICES, and CENTRIXS-K). This role ensures the performance, integrity, and security of databases supporting custom .NET applications within the Army Intelligence enterprise.

Key Responsibilities:

• Systems Maintenance: Perform and record daily system checks (approximately 15 checks) to ensure 100% of findings are tracked via the DCD IT Portal.
• High Availability: Maintain healthy and reliable data replication using technologies such as Availability Groups.
• Security & Compliance: Apply the latest DISA STIGs within 30 calendar days of release and implement "least privileged access" security requirements.
• Performance Tuning: Optimize code and stored procedures to provide fast query responses and assist application developers with database requirements.
• Disaster Recovery: Develop and test backup and recovery plans, performing monthly integrity testing on at least 10% of database backups.
• Technical Documentation: Create and maintain logical architecture diagrams, entity relationship diagrams (ERD), and Standard Operating Procedures (SOPs).
• Operational Support: Respond to unscheduled system outages within 30 minutes and provide after-hours on-site support with a 2-hour response time when notified of malfunctions.

Required Qualifications:

• Experience: Minimum 8 years of experience in SQL database administration supporting production environments.
• Technical Expertise: 5 years of experience installing and configuring Microsoft SQL Server in High Availability Group configurations.
• Scripting: 5 years of experience with T-SQL, including writing scripts, stored procedures, triggers, and views to automate maintenance.
• Leadership: 3 years of experience serving as a team leader, managing task progress, and mentoring junior personnel.
• Security: 3 years of experience implementing security measures in accordance with industry best practices and DISA STIGs.
• Active TS/SCI Level Security Clearance (U.S. Citizen)
• Certifications:
• Current DoDD 8140.01 (formerly DoDD 8570.01-M) certification – IAT Level II (or higher). Examples Include: CompTIA Security+ CE, CompTIA CySA+, CompTIA Cloud+, GIAC Security Essentials Certification (GSEC), GIAC Certified Incident Handler (GCIH), Cisco Certified Network Associate (CCNA), Certified Ethical Hacker (CEH).
• Microsoft Certified Solutions Associate (MSCA) or SQL Server 2016 or SQL Database Administration Certification What you can expect from us:

Benefits:

• Competitive salary based on qualifications and experience
• Comprehensive, Company paid healthcare for you (We pay your premiums and deductibles)
• 401(k) with company match
• Travel & performance incentives
• 3 weeks paid time off (plus Federal Holidays) * $5K annual training allowance * $500 book allowance
• Tuition reimbursement program Praescient Analytics is a Certified Woman-Owned Small Business (WOSB) with over a decade of expertise in advanced analytics, engineering, and DevOps, specializing in transforming complex data into actionable intelligence for informed decision-making. Since 2011, we have supported over 40 organizations across diverse domains, including military intelligence operations, financial and fraud investigations, and insider threat detection. Our team of experts—skilled in cloud computing, artificial intelligence, machine learning, data science, DevOps, and engineering—brings deep experience in solving complex challenges. With a proven track record in federal contracting, we deliver tailored, high-impact solutions designed to enhance operational efficiency, ensure mission success, and address the evolving needs of our clients. Praescient's innovative and adaptive approach makes us a trusted partner in delivering data-driven insights and technological excellence for critical missions. Applicants selected will be subject to a government security investigation and must meet eligibility requirements for access to classified information. US Citizenship Required