8+ years in SQL database administration in production environments
5 years installing/configuring Microsoft SQL Server in High Availability Group setups
5 years of T-SQL scripting including stored procedures and triggers
3 years in a leadership role overseeing task completion and mentoring
3 years implementing security measures per industry standards and DISA STIGs
Active TS/SCI security clearance (U.S. Citizen)
DoDD 8140.01 certification - IAT Level II or higher, MSCA or SQL Database Administration Certification
Responsibilities
Perform daily system checks and track findings via DCD IT Portal
Maintain data replication to ensure high availability
Implement security updates per DISA STIGs within 30 days
Optimize database performance and support application developers
Develop and test disaster recovery plans, testing 10% monthly
Maintain technical documentation including architecture and SOPs
Provide operational support for unscheduled outages with quick response time
Benefits
Comprehensive, company-paid healthcare with paid premiums and deductibles
401(k) with company match
Travel and performance incentives
3 weeks of paid time off plus Federal Holidays
$5K annual training allowance
$500 book allowance
Tuition reimbursement program
Full Job Description
Location: Ft. Belvoir, VA Clearance Required: TS/SCI minimum (US Citizen) Employment Type: Full-Time
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)
Microsoft Certified Solutions Associate (MSCA) or SQL Server 2016 or SQL Database Administration Certification
What you can expect from us:
Real opportunity for career growth in an environment where your achievements will be celebrated
Constant collaboration with numerous teams to ensure client success
A team that respects and embraces your ideas and expertise
Coworkers that are motivated by pursuing excellence, rather than the prospect of personal gain
A workplace dedicated to supporting and bettering public safety and government agencies
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
Applicants selected will be subject to a government security investigation and must meet eligibility requirements for access to classified information. US Citizenship Required Interested Candidates: Please forward your resume to and please visit our website to apply online at www.praescientanalytics.applicantstack.com/x/openings.
