Senior SQL Database Administrator - TS/SCI Required

  • Fort Belvoir, VA
  • Posted 4 days ago | Updated 10 hours ago

Overview

On Site
Full Time

Skills

Training
Logistics
Information Technology
Data Management
Knowledge Management
RDMS
Hosting
.NET
QoS
Servers
Information Systems
Replication
Software Development
Conceptual Design
Accessibility
Research
Standard Operating Procedure
Documentation
SAP BASIS
Data-flow Diagrams
Database Normalization
Archiving
Backup
Capacity Management
Storage
Recovery
Web Portals
Random Testing
Configuration Management
Management
Database
High Availability
Transact-SQL
Scripting
Stored Procedures
Mentorship
STIG
Tk
Security Clearance
DoD
Security+
Microsoft
MSCA
Microsoft SQL Server
SQL
Database Administration
Amazon Web Services
Oracle
Agile
Scrum
JIRA
Microsoft IAS

Job Details

Amentum is a leading global provider of technical and engineering services to government and commercial customers. We are dedicated to delivering innovative solutions to complex challenges in the defense, intelligence, and civilian markets. With 50,000 employees worldwide, we leverage our extensive experience, cutting-edge technology, and proven processes to provide exceptional value to our customers.

Your Impact:

INSCOM executes mission command of operational intelligence forces; conducts worldwide multidiscipline and all source intelligence operations; delivers advanced skills training, linguist support, specialized quick reaction capabilities, intelligence related logistics, and communications in support of Army, Joint, and Coalition command and the National Intelligence Community. You will be part of a team that provides comprehensive automation/information technology support to the Data Capabilities Division (DCD) worldwide intelligence dissemination, data management, and knowledge management missions.

Responsibilities:
  • Provide database administration and management support for Relational Database Management Systems (RDMS) in a Microsoft SQL Server-based environment hosting databases across the supported networks for various .NET applications.
  • Maintain quality of service and availability of DCD RDMSs by establishing and enforcing organizational defined standards ensuring the performance, integrity and security of databases through daily system checks with 100% of findings and statuses being recorded to DCD IT Portal.
  • Ensure all SQL servers and instances have the latest Defense Information Systems Agency (DISA) STIGs applied within 30 calendar days of release and uploaded to STIG management portals where available.
  • Manipulate database objects and develop stored procedures, stored functions, and packages when needed based on customer requirements.
  • Ensure healthy and reliable data replication is maintained using technologies such as availability groups, etc.
  • Monitor performance and manage parameters to provide fast query responses to 'front end' users optimizing code and stored procedures while assisting application developers with database requirements.
  • Configure and utilize database connectivity tools and utilities while supporting developers, programmers, and engineers during software development.
  • Map out a conceptual design for database enhancements, considering both 'back end' organization of data and 'front end' accessibility for end user.
  • Research, test, and implement new versions of the Database Management System (DBMS) for inclusion into DCD infrastructure as they become available.
  • Implement security requirements for least privileged access to organizational databases and monitor user access and security.
  • Develop and maintain database documentation to include updating existing and creating new Standard Operating Procedures, TTPs, logical architecture diagrams, entity relationship diagrams, server lists, and other database administration related documentation on monthly basis adhering to organizational templates and policies.
  • Produce entity relationship and data flow diagrams, and database normalization schemas that are logical to physical data maps and data table parameters.
  • Develop, manage, and test backup and recovery plans, ensuring that storage, archiving, backup, and recovery procedures are functioning correctly.
  • Conduct capacity planning and assist with storage and architecture design.
  • Review "Database Daily Checks" list on the DCD IT Portal and complete the Daily System Checks assigned.
  • Review "Database Restore Checks" list on the DCD IT Portal and complete random testing of no less than ten (10) percent of databases.
  • The contractor shall notify the Government of any unscheduled system outages.
  • Provide after-hours on-site support to respond to system/application malfunctions.
  • Makes sure configuration management data shall be timely updated within one business day of any modification or update of infrastructure.
  • The contractor shall provide restoration services sufficient to ensure high availability.
  • Monitor and assume responsibility of trouble tickets assigned to the Database Administration branch, assign specific tickets for resolution, and prioritize tickets in line with organizational goals of maintaining 99% system availability rate.

Requirements:
  • Eight years of experience in SQL database administration supporting and managing databases in a production environment
  • Five years of experience installing, configuring, and supporting Microsoft SQL Server in High Availability Group configurations
  • Five years of experience with T-SQL and ability to write scripts, stored procedures, triggers, and views to automate maintenance functions.
  • Three years of experience serving as a team leader working as both part of a team and independently to assign/review immediate tasks, set priorities, maintain task progress, validate team members work consistent with the organizational goals and deadlines.
  • Three years of experience mentoring junior personnel on proper practices and procedures.
  • Three years of experience planning and implementing security measures to safeguard information against accidental or unauthorized damage, modification or disclosure in accordance with industry best practices and DISA STIGs.

Clearance Required:
  • TS/SCI clearance with SBI and ability to attain SI, TK, G, HCS, and NATO Secret clearance.

Minimum Education:

Minimum Years of Experience: 8 Years

Required Certifications:
  • DoD 8140.03 IAT Level II/Intermediate certification (Security+)
  • Microsoft Certified Solutions Associate (MSCA) or SQL Server 2016 (or later) or SQL Database Administration Certification

Preferred:
  • AWS
  • Oracle
  • Experience with Agile/Scrum development.
  • Experience with JIRA task tracking.
  • Bachelor's degree

#IAS #javelin
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.