Senior SQL Database Administrator with Security Clearance - Fort Belvoir, United States - Data Systems Analysts, Inc.

Data Systems Analysts, Inc. Fort Belvoir, United States

2 weeks ago

Description

DSA is seeking a highly qualified Senior SQL Database Administrator with an active TS/SCI clearance to join our team at Fort Belvoir, VA.

Required Qualifications * TS/SCI clearance with SBI and ability to attain SI, TK, G, HCS, and NATO Secret clearance * DoD IAT Level II/Intermediate certification * Microsoft Certified Solutions Associate (MSCA) or SQL Server 2016 or SQL Database Administration Certification * 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.

Key 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 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.

* There are currently approximately 15 daily systems checks required however the SQL DBA will be responsible for maintaining, reporting, and updating the daily checklists.

* 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.

Notify Government and TTM of any critical findings that cannot be remediated within 3 days of discovery. * 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 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 schema's 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 monthly 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 IT Portal and complete the Daily System Checks assigned. Ensure 100% completion of all CRITICAL checks completed by 0700hrs daily, all other priority checks completed by 1000 daily. This includes performance, data integrity, and availability checks that are created daily on SIPRNET portal with required actions. Database administrators will complete checks and update lists with status and actions taken to resolve issues.

* The SQL DBA will notify the Government of any unscheduled system outages within 30 minutes of each occurrence and add to the operations log within four (4) hours.

* Provide after-hours on-site support to respond to system/application malfunctions. The SQL DBA will 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 SQL DBA will escalate the issue to the Project Manager who will provide hourly telephonic updates to the COR and TTM until the issue is resolved.

* Makes sure configuration management data will be timely updated within one business day of any modification or update of infrastructure.

* 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.

Many of DSA's positions require the ability to obtain a security clearance. Security clearances may only be granted to U.S. citizens.

In addition, applicants who accept a conditional offer of employment may be subject to government security investigation(s) and must meet eligibility requirements for access to classified information.

DSA is proud to be an Affirmative Action/Equal Opportunity Employer.

DSA is committed to treating all employees and applicants for employment with respect and dignity and maintaining a workplace that is free from unlawful discrimination.

All applicants will be considered for employment without regard to race, color, religion, age, national origin, ancestry, ethnicity, gender (including pregnancy, childbirth, breastfeeding, or other related medical conditions), gender identity, gender expression, sexual orientation, marital status, veteran status, disability, genetic information, citizenship status, characteristic or membership in any other group protected by federal, state, or local laws.

DSA requires background checks, where permitted, by law. DSA is an E-Verify Employer. #LI-AA1 #DSA209

Security Generalist with Security Clearance

2 weeks ago

ADVANTAGE SCI Fort Belvoir, United States

Advantage SCI is seeking TS/SCI Cleared Full-Time Security Generalists to be considered for employment to support a government contract in Fort Belvoir, VA. This is a great opportunity to provide your services in your field and expand your knowledge in the protection of our natio ...
Security Generalist with Security Clearance

3 days ago

ADVANTAGE SCI San Francisco, United States Permanent

Advantage SCI is seeking TS/SCI Cleared Full-Time Security Generalists to be considered for employment to support a government contract in Fort Belvoir, VA. This is a great opportunity to provide your services in your field and expand your knowledge in the protection of our natio ...
Configuration Manager with Security Clearance

2 weeks ago

Parsons Fort Belvoir, United States

In a world of possibilities, pursue one with endless opportunities. Imagine Next When it comes to what you want in your career, if you can imagine it, you can do it at Parsons. Imagine a career working with intelligent, diverse people sharing a common quest. Imagine a workplace w ...
Network Engineer with Security Clearance

1 week ago

Agensys Fort Belvoir, United States

RESPONSIBILITIES · Implement DoD and local SSO security requirements, specifically Security Technical Implementation Guides of network equipment, while maintaining system efficiency, maintainability, and supportability. · Install, configure, and troubleshoot routing and switching ...
BUDGET ANALYST with Security Clearance

2 weeks ago

Department of the Army Fort Belvoir, United States

Duties * Plans and Allocates and oversee Program funds based on an analysis of budget estimates, historical expenditures, projected workload, and approved funding. * Identifies the need for reprogramming between budget accounts and/or organizations. * Coordinates across the comma ...
Enterprise Architect with Security Clearance

2 weeks ago

Booz Allen Hamilton Fort Belvoir, United States

Job Number: R Enterprise Architect · Key Role: Design architectural roadmaps for enterprise architecture ( EA ) , in accordance with enterprise strategies and EA processes, while analyzing client requirements and collaborating with R & D divisions to provide ongoing support. Appl ...
Logistics Manager with Security Clearance

2 weeks ago

Parsons Fort Belvoir, United States

In a world of possibilities, pursue one with endless opportunities. Imagine Next When it comes to what you want in your career, if you can imagine it, you can do it at Parsons. Imagine a career working with intelligent, diverse people sharing a common quest. Imagine a workplace w ...
Cloud Engineer with Security Clearance

1 day ago

Mindbank Consulting Group San Francisco, United States Permanent

Position - Cloud Engineer · Location - Fort Belvoir, VA (4 days working REMOTE and 1 day onsite each week) · Pay Rate - $130,000 $140,000 · Direct Hire Position Must have a Secret Clearance Mindbank Consulting Group has an immediate need for a Cloud Engineer. The Cloud Engineer w ...
Mover/Installer with Security Clearance

2 weeks ago

The Tatitlek Corporation Fort Belvoir, United States

Overview Job specifications are intended to present a descriptive list of the range of duties performed by employees. Specifications are not intended to reflect all duties performed within the job. ESSENTIAL DUTIES AND RESPONSIBILITIES: * Support Professional Movers culture and v ...
Test Manager with Security Clearance

2 weeks ago

Parsons Fort Belvoir, United States

In a world of possibilities, pursue one with endless opportunities. Imagine Next When it comes to what you want in your career, if you can imagine it, you can do it at Parsons. Imagine a career working with intelligent, diverse people sharing a common quest. Imagine a workplace w ...
Information Systems Security Officer with Security Clearance

2 weeks ago

Booz Allen Hamilton Fort Belvoir, United States

Job Number: R Information Systems Security Officer · The Opportunity: Cyber threats are everywhere, and the constantly evolving nature of these threats can make understanding them seem overwhelming to military organizations. In all of this "cyber noise," how can these organizatio ...
Contract Specialist with Security Clearance

2 weeks ago

Department of Defense Fort Belvoir, United States

Duties * Serve as Contracting Specialist responsible for the full range of pre-award and post-award contract functions. * Ensure appropriate funding and required waivers, certifications, approvals, and compliances have been obtained for purchase requests. * Administration of cont ...
PROGRAM ANALYST with Security Clearance

2 weeks ago

Department of the Army Fort Belvoir, United States

Duties * Responsible for formulating, managing, reviewing, interpreting, analyzing, and evaluating operating programs and projects. * Develop detailed strategy and background documentation for presenting the MACOM's programs to higher headquarters and Office of Management and Bud ...
Declassification Analyst with Security Clearance

1 week ago

QualX Corporation San Francisco, United States Permanent

DUTIES AND RESPONSIBILITIES · • Conduct initial declassification reviews in support of Government agency · • Analyze unclassified and classified documents to determine the appropriate action needed in accordance with E.O. 13526 · • Demonstrate understanding of document markings · ...
Training Specialist with Security Clearance

1 week ago

Nationwide IT Services Fort Belvoir, United States

Training Specialist 100% remote with frequent visits to Ft. Belvoir · IT-II or NACLC/Secret clearance Nationwide IT Services (NIS) is seeking an experienced Training Specialist for a potential opportunity supporting our DLA customer. Requirements · Experience in information syste ...
Network Engineer with Security Clearance

1 week ago

DNI (Delaware Nation Industries) Fort Belvoir, United States

Overview Delaware Nation Industries (DNI) is a prime contractor providing manpower and support of IT Operations and Maintenance within a Federal Agency. Our team must ensure every employee has reliable support and access to the network. We are currently interviewing for a Network ...
Master Scheduler with Security Clearance

2 weeks ago

MAG Aero Fort Belvoir, United States

Position Summary MAG Aerospace has a requirement for a Master Scheduler to support the Product Manager Wideband Enterprise Satellite Systems (PdM WESS) Product Officer Satellite Terminal Systems (PO STS). This position is based out of Fort Belvoir, VA and operates on a hybrid sch ...
Software Developer with Security Clearance

2 weeks ago

Radiance Technologies Fort Belvoir, United States

Radiance Technologies is an employee-owned company with benefits that are unmatched by most companies in the National Capital Region. Employee ownership, generous 401K, full health/dental/life/vision insurance benefits, paid time off, educational reimbursement, competitive salari ...
Security Assistant with Security Clearance

2 weeks ago

Department of the Army Fort Belvoir, United States

Duties * Provides safeguards for the protection of US Government physical and historical property to prevent theft and vandalism. * Provides routine information, referring visitors to appropriate staff members for specific action. * Implements procedures designed to safeguard Arm ...
Budget Analyst with Security Clearance

2 weeks ago

Department of Defense Fort Belvoir, United States

Duties * Develop and coordinate supplemental budget instructions for assigned programs/areas. * Examine and assess the funding requirements to ensure compliance with Dept of Defense (DOD)/Dept of Army (DOA) funding guidance and policies. * Identify significant changes in DOD and ...