Junior SQL Database Administrator
Fort Belvoir, VA

Job Description

Charles F. Day & Associates, LLC is accepting resumes for contingent work out of Ft. Belvoir, VA and Metro Park, VA.

Location of Work: HQ INSCOM (Ft. Belvoir, VA), Metro Park (Arlington, VA), and sites of approved telework

Travel: both within the Continental United States (CONUS) and Outside the Continental United States (OCONUS), may be required for training and customer support

Clearance Requirement: Active Top Secret/SCI with Special Background Investigation (SBI) and be able to attain Special Intelligence (SI), Talent-Keyhole (TK), GAMMA (G), HUMINT Control Systems (HCS), and North Atlantic Treaty Organization

Duties:

* 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 SharePoint and various .NET applications
* Maintain quality of service and availability of DAIIS 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 DAIIS IT Portal
* Ensure SQL servers and instances have the latest Defense Information Systems Agency (DISA) STIGs applied within 30 calendar days of release
* 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 database mirroring and availability groups
* 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 DAIIS 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 to include weekly integrity testing of no less than ten (10) percent of DAIIS database backups on the supported networks
* Conduct capacity planning and assist with storage and architecture design
* Review "Database Daily Checks" list on the DAIIS JWICS Portal and complete the Daily System Checks assigned.
* Review "Database Restore Checks" list on the DAIIS JWICS Portal and complete random testing of no less than ten (10) percent of databases, on each of the supported networks, per week and annotate on JWICS no later than 1200hrs on Friday of each week. This includes ensuring the integrity of database backups and abilities to meet Recovery Point Objectives (RPO) by regularly testing backups
* The contractor shall notify the Government of any unscheduled system outages within 30 minutes of each occurrence and add to operations log within four (4) hours
* Provide after-hours on-site support to respond to system/application malfunctions. The contractor shall have 2 hours after notification of an issue to respond to the workplace. If after two hours on site the issue is not resolved, the contractor shall escalate the issue to the Project Manager who shall provide hourly telephonic updates to the COR and TTM until the issue is resolved
* 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 and Description:

* DoD 8570.1-M IAT Level II certification
* Four years of experience in SQL database administration supporting and managing databases in a production environment
* Two years of experience supporting Microsoft SQL in High Availability Group configurations
* Two years of experience with T-SQL and ability to write scripts to automate maintenance functions
* Two years of experience implementing security measures in accordance with industry best practices and DISA STIGs.
* Microsoft Technology Associate (MTA) - Database Fundamentals (MS SQL Server) Certification

Special preference given to candidates who live in a Hub Zoned area.

Our company is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, protected veteran or disability status EOE/M/F/VET/DISABLED