SQL Server DBA - ASRC Federal Holding Company

* 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

Equal Opportunity Employer Minorities/Women/Protected Veterans/Disabled