SQL Server DBA - ASRC Federal Holding Company
ARLINGTON, VA 22209
About the Job
- 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).
Source : ASRC Federal Holding Company