Intermediate Database Specialist

PlanIT Group is seeking an Intermediate Database Specialist to support our Federal customer in the Washington, DC area. The ideal candidate will be responsible for developing standards and procedures, both operational and functional. They will interact with other client organizations and individuals, such as developers and end users, to understand applications and resolve problems. This individual will be expected to work independently or semi‑independently with minimal guidance. Job Details Job Title: Intermediate Database Specialist Start Date: 08/11/25 Location: Remote/Washington, DC Summary Responsible for planning, developing, implementing, maintaining, and supporting the client's centralized database environment. This includes executing national production applications for the client’s large, complex, and widely distributed Microsoft NT operating system environment and LAN infrastructure throughout the United States. The role supports different shifts to enable 24x7 support and may require carrying a pager and on‑call availability, with varied schedules. Travel may be required. Duties And Responsibilities Develop and maintain project plans in accordance with the client’s standards. Provide weekly status reporting. Perform other duties as directed by FCSC/DSS management. Communicate effectively both orally and in writing. Demonstrate an enthusiastic, can‑do attitude and willingness to travel and be flexible. Interact with developers and end users to understand applications and resolve problems. Position Requirements: SQL Database Administrator Core SQL Server DBA Responsibilities 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. 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 off‑site retention strategies. Participated in and supported 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 statistics. 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. Participated 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 (IaC) 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. Able 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. 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 Bachelor's Degree in Computer Science or associated discipline preferred and a minimum of 7 years of DBA experience. Additional Provisions 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 (excluding military service). #J-18808-Ljbffr PLANIT Group