SQL Database Admin with Security Clearance - Newport News, VA, United States - Agile Defense, Inc.

Description

At Agile Defense we know that action defines the outcome and new challenges require new solutions
That's why we always look to the future and embrace change with an unmovable spirit and the courage to build for what comes next
Our vision is to bring adaptive innovation to support our nation's most important missions through the seamless integration of advanced technologies, elite minds, and unparalleled agility-leveraging a foundation of speed, flexibility, and ingenuity to strengthen and protect our nation's vital interests
Requisition #: 258 / 262

Job Title:

SQL

Database Admin Location:
Fort Eustis, VA (Remote)

Clearance Level:
Active DoD - Secret Salary Range: $109,900 - $164,850 Required Certification(s):

• Must hold current or obtain within 90 days of start date IAT Level II (Security+ or higher)
• Applicable Computing Environment (CE) Certification

SUMMARY The United States Army Training and Doctrine Command (TRADOC) is a major command of the United States Army headquartered at Fort Eustis, Virginia
It is charged with overseeing the training of Army forces and the development of operational doctrine
TRADOC recruits, trains, educates, develops, and builds the Army, establishes standards, drives improvement, and leads change to ensure the Army can deter, fight, and win on any battlefield now and into the future
The objective of the TRADOC Cloud & Ancillary Support Services (TCASS) contract is to support cloud migration planning services including Inventory (Users, Applications, Infrastructure, Security & Privacy, Services Management); Application Mapping and Assessment; Migration Planning, Migration Services, and Cloud Support Services, Ope Be the primary point person for the oversight and management of the TRADOC Azure Cloud
SQLEnvironment JOB DUTIES AND RESPONSIBILITIES

• Manage the TRADOC
  SQLAzure Cloud environment
• Ensure the
  SQLenvironment is in compliance with all DoD requirements
• Recommend and conduct
  SQLenhancements

SUPERVISORY DUTIES

• Will be the senior person on the team and will help drive the workload across the team and help in training other team members

QUALIFICATIONS Required Certifications

• Must hold current or obtain within 90 days of start date IAT Level II (Security+ or higher)
• Applicable Computing Environment (CE) Certification

Education, Background, and Years of Experience

• BA/BS or higher
• 10+ years of relevant experience (with a MA/MS)
• 12+ years of relevant experience (with a BA/BS) ADDITIONAL SKILLS & QUALIFICATIONS Required Skills
• Proficient in management, availability, security, and performance monitoring and optimization of database solutions
• Design and implement fault-tolerant
  SQLServer solutions using highly availability patterns for scalability and stability in on-premises and Microsoft Azure

Design and deploy Microsoft
SQLPaaS solutions in Microsoft Azure Government (MAG)

Implements Azure infrastructure solutions and may provide oversight and leadership on workstreams across domains

Manages escalations, analyzes situations, and coordinates appropriate resources to resolve issues by following delivery practices, considering cost implications, and engaging in conversations with internal and external stakeholders

Manages escalations, analyzes situations, and coordinates appropriate resources to resolve issues by following delivery practices, considering cost implications, and engaging in conversations with internal and external stakeholders

Responsible for setting up High-Availability and Disaster Recovery

Plan and test high availability and disaster recovery

Create Users and assign/manage permissions based on the level of access the user would need; ensure robust and full proof security of assets

Resolve database integrity, performance, blocking, connectivity, and replication issues

Detect and resolve database-related CPU, memory, I/O, disk space and other contention issues

Perform and manage Database backup/recovery/restore and capacity monitoring

Synapse workload management and optimization

Setup
SQLagent jobs, elastic jobs and runbook automation

Identify and setup alerts and logging in Azure

Maintain databases - Statistics, Indexes, fragmentation

Conduct Performance tuning and optimization (Stored procedures, Views, Functions, Queries, database)

Implement operational automation using scripts

Coordinate removal and/or archiving of data that is no longer required to be available in the production databases

Design and create databases to support development initiatives

Synapse workload management and optimization

Support release/code deployment activities

Manages escalations, analyzes situations, and coordinates appropriate resources to resolve issues by following delivery practices, considering cost implications, and engaging in conversations with internal and external stakeholders

Non-Technical Skills:

Strong self-starter attitude, team oriented and good communication skills are a must

Willingness to commit to maintaining the highest standard of customer service with outstanding written and oral communication

Excellent writing, interpersonal, and communication skills

Ability to communicate effectively with the team on assigned tasks, expectations, and schedules

Sharp attention to detail

Organized; time management skills to forecast and stay ahead of deliverable/reporting requirements

Must be well-organized and detail-oriented with the ability to coordinate, prioritize multiple tasks, and be adaptable to change to accomplish assignments

Excellent customer focus/satisfaction skills WORKING CONDITIONS Environmental Conditions

Remote Strength Demands

Sedentary - 10 lbs
Maximum lifting, occasional lift/carry of small articles
Some occasional walking or standing may be required
Jobs are sedentary if walking and standing are required only occasionally, and all other sedentary criteria are met
Employees of Agile Defense are our number one priority, and the importance we place on our culture here is fundamental
Our culture is alive and evolving, but it always stays true to its roots
Here, you are valued as a family member, and we believe that we can accomplish great things together
Agile Defense has been highly successful in the past few years due to our employees and the culture we create together
What makes us Agile? We call it the 6Hs, the values that define our culture and guide everything we do
Together, these values infuse vibrancy, integrity, and a tireless work ethic into advancing the most important national security and critical civilian missions
It's how we show up every day
It's who we are
Happy - Be Infectious
Happiness multiplies and creates a positive and connected environment where motivation and satisfaction have an outsized effect on everything we do
Helpful - Be Supportive
Being helpful is the foundation of teamwork, resulting in a supportive atmosphere where collaboration flourishes, and collective success is celebrated
Honest - Be Trustworthy
Honesty serves as our compass, ensuring transparent communication and ethical conduct, essential to who we are and the complex domains we support
Humble - Be Grounded
Success is not achieved alone, humility ensures a culture of mutual respect, encouraging open communication, and a willingness to learn from one another and take on any task
Hungry - Be Eager
Our hunger for excellence drives an insatiable appetite for innovation and continuous improvement, propelling us forward in the face of new and unprecedented challenges
Hustle - Be Driven
Hustle is reflected in our relentless work ethic, where we are each committed to going above and beyond to advance the mission and achieve success
These Core Values are present in all our employees and our organization's aspects
Learn more about us and our culture by visiting us here
COVID-19 Vaccination Requirements Agile Defense is subject to federal vaccine mandates or other customer/facility vaccination requirements as a federal contractor
As such, to protect its employees' health and safety and comply with customer requirements, Agile Defense may require employees in certain positions to be fully vaccinated against COVID-19
Vaccination requirements will depend on the status of the federal contractor mandate and customer site requirements
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant
However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information
41 CFR c)