SQL Database Admin
8 months ago
Employment Information
Agile Defense provides leading-edge Digital Transformation solutions to support and advance our customers' mission. We deliver innovative and high-quality services to our customers worldwide through an empowered and engaged workforce.
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 SQL Environment
JOB DUTIES AND RESPONSIBILITIES
- Manage the TRADOC SQL Azure Cloud environment
- Ensure the SQL environment is in compliance with all DoD requirements
- Recommend and conduct SQL enhancements.
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 SQL Server solutions using highly availability patterns for scalability and stability in on-premises and Microsoft Azure
- Design and deploy Microsoft SQL PaaS 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 SQL agent 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. We believe several attributes are the root of our very best employees and extraordinary culture. We have named these attributes “The 6 H’s” – Happy, Helpful, Honest, Humble, Hungry, and Hustle.
Happy: We exhibit a positive outlook in order to create a positive environment.
Helpful: We assist each other and pull together as teammates to deliver.
Honest: We conduct our business with integrity.
Humble: We recognize that success is not achieved alone, that there is always more to learn, and that no task is below us.
Hungry: We desire to consistently improve.
Hustle: We work hard and get after it.
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 60-1.35(c)
Share this
