SQL Server DBA, ASRC Federal Holding Company, Arlington, VA
ASRC Federal Holding Company -
Arlington, VA,
US
SQL Server DBA
Date Posted: 2024-05-05
Job description
* Manage SQL Server databases and other RDBMS through different product lifecycles from development to mission-critical production systems.* Install, Configure, and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.* Migrate/convert databases from current MS SQL server versions to higher versions (upgrade)* Execute & maintain SQL scripts and utility jobs for MS SQL database maintenance.* Implement & manage MS SQL database backups and restore, clustering, always on, failover and load balancing technologies.* Perform DB refreshes in various Test/Dev environments.* Monitor database status, logs, space utilization, extents, locks, blockings and deadlocks and clear them accordingly.* Implement and support MS SQL (Active/Passive & Active/Active), Multi Node Clustering for multiple node clusters* Independently analyze, solve, and correct issues in real time, providing end-to-end problem resolution.* Refine and automate regular processes, track issues, and document changes.* Share domain and technical expertise, providing technical mentorship and cross-training to other peers and team members.* Perform all other DB related tasks and activities as assigned.* Perform health check for Windows servers and SQL DBs, and troubleshoot abnormalities.* Configure and maintain DB maintenance plans for DB backup and recovery.* Configure and maintain DB Transactional Replications.* Configure and maintain Always On Availability Group (AAG).* Experience with PowerShell and Command Line Commands* Expertise in database administration on SQL Server* Expert ability to analyze and define database and security requirements* Minimum 8 years' experience in SQL Server 2008/17* Experience with IIS and Service Accounts* Experience with Windows Server* Experience working with and supporting Agile processing* Ability to work in a team environment supporting various groups and user types* Ability to communicate complex ideas verbally and in a written format* Successful candidate is subject to a background investigation by the government and must be able to meet the requirements to hold a Government Clearance.* Must be a US Citizen