Apply on Employer Site

PlanIT Group, LLC · 5 months ago

Intermediate Database Specialist

Washington, DC

Contract

Hybrid

Mid, Senior Level

5+ years exp

PlanIT Group is seeking an Intermediate Database Specialist to support their Federal customer in the Washington, DC area. The role involves developing standards and procedures for database management, interacting with client organizations, and providing support for a complex database environment.

ConsultingInformation TechnologyManagement Consulting

Growth Opportunities

No H1B

U.S. Citizen Only

Responsibilities

Development and maintenance of project plans in accordance with Client's standards will be required

Weekly status reporting will be required

Perform other duties in support of the organizations mission as directed by FCSC/DSS management

Excellent communications skills, both oral and written are required

Excellent people skills, an enthusiastic can-do attitude, willingness to do what it takes to get the job done, travel and flexibility are all required attributes of successful candidates for this position

Interaction with other client organizations and individuals, such as developers and end users, will be necessary in order to understand applications and resolve problems

Qualification

SQL Server DBAT-SQLPerformance TuningDisaster RecoveryDatabase DocumentationCI/CD PipelinesPowerShell ScriptingCommunication SkillsTeam CollaborationProblem Solving

Required

Minimum 5-7 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

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

Participated in and supported DR drills and contingency planning

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)

Understanding of normalized and denormalized schema design

Experience with table partitioning, filegroups, and database file I/O planning

Participated in storage capacity planning and database lifecycle management

Supports scalability and performance through smart database design decisions

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 (IaC) concepts using PowerShell or ARM templates

Experience maintaining backend SQL databases for legacy SharePoint environments (2010/2013/2016)

Familiar with SharePoint content databases, service application databases, and search indexing structures

Able to support site migrations, database integrity checks, and performance tuning for SharePoint SQL backends

Collaborated with SharePoint Admins on patching and upgrade activities

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

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

Bachelor's Degree in Computer Science or associated discipline preferred and a minimum of 7 years of DBA experience

Must be able to obtain a Public Trust Clearance

Pass both a client mandated clearance process to include drug screening, criminal history check and credit check

All candidates must be a US Citizen or US Permanent Resident

Candidate must have lived in the United States for the past 5 years

Cannot have more than 6 months travel outside the United States within the last five years. Military Service excluded. (Exception does not include military family members.)