Sr SQL Database Admin || Washington, DC || Local

[Azad]

Title: Senior SQL Database Admin.Years of Exp.: 13+ years exp.
Work Location: Washington, DC/Local Remote (candidatesmust be local to Washington, DC area)  VISA:  US Citizen or Green Card PermanentResident
 
Skills:sql server dba, ms nt os environment, lan, t-sql, ssms, agent jobs, maintenanceplans, back-up/restore, database recovery models, point-in-time recovery,diaster recovery, always-on-availability groups, sql server failover clustering,log shipping, database mirroring, back-up encryption, off-site retention, sqlmonitoring/tuning; sql profiler extended events, dmv's, dead locks, blocking,slow running queries, tuning indexes, review execution plans, sql monitoringtools; redgate, solarwinds dpa, sentryone, devops for sql; ci/cd, azure devops,gitlab otopus deploy, git+sql source control, (iac) infrastructure-as-code,powershell or arm templates, sql back-end for legacy sharepoint environment(2010/2013/2016), sharepoint sql back-ends, asp.net, .net core, sql calls fromweb applications, cloud; azure sql, aws rds, hybrid cloud/on-prem sql

Preferred:N/A

Certification: Azure Database Admin. Associate or MCSE Data Management/Analysis
Clearance:  Public Trust Clearance or Higher is Preferred
Job DescriptionSummary
Responsible to perform planning, development,implementation, maintenance and support client’ centralized organization fortotal support of the database environment. This includes executing nationalproduction applications on the Client' large, complex and widely distributed Microsoft NT operating systemenvironment and Local Area Network (LAN) infrastructure throughout the UnitedStates.

This position will be responsible to developstandards and procedures, both operational and functional. Interact with otherclient organizations and individuals, such as developers and end users, inorder to understand applications and resolve problems. This individual will be expected towork independently or semi-independently with a minimum of guidance ordirection.
Supports differentshifts to enable 24x7 support; may be required to carry a pager and be on calland be required to work varied schedules required by large, diverse and complexclient production environment. Travel may be required.

Dutiesand Responsibilities
Development and maintenance of project plans inaccordance with Client’s standards will be required. Weekly status reportingwill be required. Perform other duties in support of the organizations missionas directed by FCSC/DSS management.
Excellent communications skills, both oral and writtenare required. Excellent people skills, an enthusiastic can-do attitude,willingness to do what it takes to get the job done, travel and flexibility areall required attributes of successful candidates for this position. Interactionwith other client organizations and individuals, such as developers and endusers, will be necessary in order to understand applications and resolveproblems.

PositionRequirements: SQL Database Administrator
Core SQL Server DBA Responsibilities
• Minimum 8-10 years of experience as a SQLServer DBA in production environments
• Proficiency in SQL Server 2016/2019/2022(T-SQL, SSMS, Agent Jobs, Maintenance Plans)
• Experience with backup and restore strategies,including full, differential, and transaction log backups
• Strong understanding of database recoverymodels and point-in-time recovery
• Ability to create and maintain databasedocumentation and operational runbooks

DisasterRecovery & High Availability:
• Hands-on experience with Always OnAvailability Groups and/or SQL Server Failover Clustering
• Knowledge of Log Shipping and DatabaseMirroring
• Familiarity with backup encryption and offsiteretention strategies
• Participated in and supported DR drills andcontingency planning

SQLMonitoring & Performance Tuning:
• Skilled in performance troubleshooting usingSQL Profiler, Extended Events, and DMVs
• Ability to identify and resolve deadlocks,blocking, and slow-running queries
• Experience tuning indexes, reviewing executionplans, and maintaining stats
• Familiar with SQL monitoring tools (e.g.,Redgate, SolarWinds DPA, Sentry One)

Architecture& Design:
• Understanding of normalized and denormalizedschema design
• Experience with table partitioning,filegroups, and database file I/O planning
• Participated in storage capacity planning anddatabase lifecycle management
• Supports scalability and performance throughsmart database design decisions

DevOpsfor SQL Server:
• Familiar with CI/CD pipelines involving SQLdeployments (e.g., Azure DevOps, GitLab, Octopus Deploy)
• Experience with version control for databaseobjects (e.g., Git + SQL Source Control)
• Support for automated database deployments andschema changes
• Familiarity with Infrastructure as Code (IaC)concepts using PowerShell or ARM templates
Legacy SharePoint DBA Support
• Experience maintaining backend SQL databasesfor legacy SharePoint environments (2010/2013/2016)
• Familiar with SharePoint content databases,service application databases, and search indexing structures
• Able to support site migrations, databaseintegrity checks, and performance tuning for SharePoint SQL backends
• Collaborated with SharePoint Admins onpatching and upgrade activities
.NET Application Support on SQL Server
• Supported ASP.NET and .NET Core webapplications with SQL Server backends
• Familiar with connection pooling,application-level query performance, and ORM frameworks like Entity Framework
• Ability to trace SQL calls from web apps andoptimize database access patterns
• Worked with application developers to improvedata access performance and scalability

GeneralRequirements
• Strong documentation skills and adherence toITSM/ITIL change control practices
• Basic PowerShell scripting experience for SQLand system task automation
• Effective communicator across DB, application,and infrastructure teams
• Willingness to support an on-call rotation andoccasional after-hours work
• Works on high-visibility, or mission criticalaspects of a given program, and performs all functional duties independently;
• Oversees the efforts of direct reportingresources and/or be responsible for the efforts of all staff assigned to aspecific job.

PreferredQualifications:
• Exposure to cloud-based database solutions(e.g., Azure SQL, AWS RDS)
• Experience with hybrid cloud/on-prem SQLarchitecture
• Microsoft certifications such as AzureDatabase Administrator Associate or MCSE: Data Management and Analytics
• Works on high-visibility, or mission criticalaspects of a given program, and performs all functional duties independently.
• Oversees the efforts of direct reportingresources and/or be responsible for the efforts of all staff assigned to aspecific job.

Education:
A minimum of thirteen (13) to twenty (20) years’relevant experience and a minimum of 10 years of DBA experience
• A degree from an accredited College/Universityin the applicable field of services is preferred. four additional years ofrelevant experience in lieu of a college degree is required. If theindividual's degree is not in the applicable field then four additional yearsof related experience is required.