Senior SQL Database Administrator IV

Senior SQL Database Administrator IV Location: Washington, DC - Hybrid Summary Responsible to perform planning, development, implementation, maintenance and support client centralized organization for total support of the database environment. This includes executing national production applications on the client’s large, complex and widely distributed Microsoft NT operating system environment and Local Area Network (LAN) infrastructure throughout the United States. This position will develop and enforce standards and procedures, both operational and functional. It will interact with other client organizations and individuals, such as developers and end users, to understand applications and resolve problems. The role works independently or semi‑independently with minimal guidance. Supports different shifts to enable 24×7 support; may be required to carry a pager, be on call, and work varied schedules required by the large, diverse and complex client production environment. Travel may be required. Duties and Responsibilities Develop and maintain project plans in accordance with client standards. Produce weekly status reports. Perform other duties in support of the organization’s mission as directed by FCSC/DSS management. Maintain excellent oral and written communications skills, people skills, a can‑do attitude, willingness to do what it takes to get the job done, flexibility and travel. Interact with developers and end users to understand applications and resolve problems. Position Requirements Minimum 8‑10 years of experience as a SQL Server 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 recovery models and point‑in‑time recovery. Ability to create and maintain database documentation and operational runbooks. Disaster Recovery & High Availability Hands‑on experience with Always On Availability Groups and/or SQL Server Failover Clustering. Knowledge of Log Shipping and Database Mirroring. Familiarity with backup encryption and offsite retention strategies. Participation in and support of DR drills and contingency planning. SQL Monitoring & Performance Tuning Skilled in performance troubleshooting using SQL Profiler, Extended Events, and DMVs. Ability to identify and resolve deadlocks, blocking, and slow‑running queries. Experience tuning indexes, reviewing execution plans, and maintaining stats. Familiar with SQL monitoring tools (e.g., Redgate, SolarWinds DPA, Sentry One). Architecture & Design Understanding of normalized and denormalized schema design. Experience with table partitioning, filegroups, and database file I/O planning. Participation in storage capacity planning and database lifecycle management. Supports scalability and performance through smart database design decisions. DevOps for SQL Server Familiar with CI/CD pipelines involving SQL deployments (e.g., Azure DevOps, GitLab, Octopus Deploy). Experience with version control for database objects (e.g., Git + SQL Source Control). Support for automated database deployments and schema changes. Familiarity with Infrastructure as Code concepts using PowerShell or ARM templates. Legacy SharePoint DBA Support Experience maintaining backend SQL databases for legacy SharePoint environments (2010/2013/2016). Familiar with SharePoint content databases, service application databases, and search indexing structures. Ability to support site migrations, database integrity checks, and performance tuning for SharePoint SQL backends. Collaborated with SharePoint Admins on patching and upgrade activities. .NET Application Support on SQL Server Supported ASP.NET and .NET Core web applications 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 and optimize database access patterns. Worked with application developers to improve data access performance and scalability. General Requirements Strong documentation skills and adherence to ITSM/ITIL change control practices. Basic PowerShell scripting experience for SQL and system task automation. Effective communicator across DB, application, and infrastructure teams. Willingness to support an on‑call rotation and occasional after‑hours work. Works on high‑visibility, or mission‑critical aspects of a given program, performing all functional duties independently. Oversees the efforts of direct reporting resources and/or is responsible for the efforts of all staff assigned to a specific job. Preferred Qualifications Exposure to cloud‑based database solutions (e.g., Azure SQL, AWS RDS). Experience with hybrid cloud/on‑prem SQL architecture. Microsoft certifications such as Azure Database Administrator Associate or MCSE: Data Management and Analytics. 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/University in the applicable field is preferred. Four additional years of relevant experience in lieu of a college degree is required. If the individual’s degree is not in the applicable field, four additional years of related experience is required. Additional Provisions Must pass a client‑mandated clearance process including drug screening, criminal history check, and credit check. Candidate’s resume must be approved and interview passed for the agency to provide drug screening. Failure to submit the drug screening results will delay the security clearance process. For candidates with interim clearance, continuation of employment is based on receiving a sensitive clearance. Candidate must have lived in the U.S. for the past five years. Cannot have more than six months travel outside the U.S. within the last five years (military service excluded). All overtime must be pre‑approved in writing by the client manager or their designated representative. Agency will not be reimbursed for overtime charges without previous written authorization; authorized overtime will be reimbursed at straight time. #J-18808-Ljbffr Jobs via Dice