Talent.com
SQL Server DBA

SQL Server DBA

ASRC Federal Holding CompanyARLINGTON, VA
30+ days ago
Job type
  • Full-time
Job description

Job Title

SQL Server DBA

Location

1600 WILSON BLVD, STE 500, ARL-VA043

Job Description

Team ASRC Federal is actively seeking an experienced SQL Server DBA to support our government client in Arlington, VA (Primarily Remote)

  • 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).

Requirements

Requirements :

  • Expertise in database administration on SQL Server
  • Experience with PowerShell and Command Line Commands
  • 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