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:SQLDatabase 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. 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)
