Sql dba

Job TitleSQL Server DBALocation1600 WILSON BLVD, STE 500, ARL-VA043Job DescriptionTeam 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 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).RequirementsRequirements :• 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 CitizenLast updated : 2024-11-12