SQL Server Database Administrator

Guidehouse•Ashburn, VA

2d•$85,000 - $141,000

About The Position

Install, configure, upgrade, patch, and maintain Microsoft SQL Server environments (2005–2016) across Production, Test, and Development. Administer and support Oracle databases (10g, 11g, 12c, 19c) on Linux/Unix and Windows platforms. Proactively monitor database health, troubleshoot issues, and perform performance tuning to ensure availability, security, and optimal system performance. Analyze and resolve performance bottlenecks, including locking, blocking, deadlocks, index fragmentation, and slow-running queries. Perform T‑SQL performance tuning, code reviews, and optimization; collaborate closely with application and development teams. Manage and test backup, restore, and Point‑in‑Time Recovery processes aligned with RTO and RPO requirements. Lead and support SQL Server upgrades and migrations from legacy versions. Administer TempDB configuration, database compression, and overall database optimization. Implement and enforce database security best practices, including user access, encryption, TDE, auditing, data masking, and compliance monitoring. Design, develop, deploy, and maintain SSIS/ETL solutions using SSDT/BIDS, SSIS, BCP, and Import/Export tools. Configure and maintain SQL Server Agent jobs, alerts, maintenance plans, and Database Mail. Support and administer SSRS environments as needed. Collaborate with data modelers and architects on logical and physical database design and implementation. Maintain accurate database documentation, including data standards, procedures, data dictionaries, and models. Utilize monitoring and ticketing tools to manage incidents, changes, and service requests in accordance with SLAs.

Requirements

Bachelor’s degree or additional four (4) years of exp in lieu of degree.
Minimum Four (4) years of experience with Database Administration.
Strong hands-on experience as a Database Administrator supporting enterprise SQL Server environments.
Proven expertise in T‑SQL development and optimization, including stored procedures, indexes, UDFs, CTEs, triggers, and complex queries.
Solid experience administering Oracle databases, including RMAN, Data Guard, RAC, ASM, and OEM.
Demonstrated experience in database performance tuning using tools such as AWR, ADDM, Statspack, and SQL Server native utilities.
In-depth knowledge of RDBMS concepts, data modeling, and database architecture.
Strong experience with HA/DR architectures and business continuity planning.
Hands-on experience with backup/recovery strategies, capacity planning, and disaster recovery testing.
Experience applying service packs, cumulative updates, patches, and hotfixes.
Familiarity with SDLC processes and working in Agile or traditional development environments.
Experience using enterprise monitoring and management tools (e.g., Redgate, SolarWinds, Erwin, Toad).
Experience working with ticketing systems such as Remedy or Jira.
Strong problem-solving, communication, and collaboration skills with the ability to work independently and manage multiple priorities.
Must be a US Citizen or a Green Card holder.
No visa sponsorship available for this position.
Must be able to OBTAIN and MAINTAIN a Federal or DoD "PUBLIC TRUST"; candidates must obtain approved adjudication of their PUBLIC TRUST prior to onboarding with Guidehouse.
Candidates with an ACTIVE PUBLIC TRUST or SUITABILITY are preferred.

Nice To Haves

Experience with Azure SQL Database or cloud-based database platforms.
Exposure to DevOps or CI/CD practices for database deployments.
Experience supporting large-scale, mission-critical systems in regulated or highly available environments.
Prior experience mentoring junior DBAs or leading database initiatives.
Familiarity with data governance, compliance, and auditing standards.
Relevant certifications (e.g., Microsoft SQL Server, Oracle DBA) are a plus.

Responsibilities

Install, configure, upgrade, patch, and maintain Microsoft SQL Server environments (2005–2016) across Production, Test, and Development.
Administer and support Oracle databases (10g, 11g, 12c, 19c) on Linux/Unix and Windows platforms.
Proactively monitor database health, troubleshoot issues, and perform performance tuning to ensure availability, security, and optimal system performance.
Analyze and resolve performance bottlenecks, including locking, blocking, deadlocks, index fragmentation, and slow-running queries.
Perform T‑SQL performance tuning, code reviews, and optimization; collaborate closely with application and development teams.
Manage and test backup, restore, and Point‑in‑Time Recovery processes aligned with RTO and RPO requirements.
Lead and support SQL Server upgrades and migrations from legacy versions.
Administer TempDB configuration, database compression, and overall database optimization.
Implement and enforce database security best practices, including user access, encryption, TDE, auditing, data masking, and compliance monitoring.
Design, develop, deploy, and maintain SSIS/ETL solutions using SSDT/BIDS, SSIS, BCP, and Import/Export tools.
Configure and maintain SQL Server Agent jobs, alerts, maintenance plans, and Database Mail.
Support and administer SSRS environments as needed.
Collaborate with data modelers and architects on logical and physical database design and implementation.
Maintain accurate database documentation, including data standards, procedures, data dictionaries, and models.
Utilize monitoring and ticketing tools to manage incidents, changes, and service requests in accordance with SLAs.

Benefits

Medical, Rx, Dental & Vision Insurance
Personal and Family Sick Time & Company Paid Holidays
Parental Leave
401(k) Retirement Plan
Group Term Life and Travel Assistance
Voluntary Life and AD&D Insurance
Health Savings Account, Health Care & Dependent Care Flexible Spending Accounts
Transit and Parking Commuter Benefits
Short-Term & Long-Term Disability
Tuition Reimbursement, Personal Development, Certifications & Learning Opportunities
Employee Referral Program
Corporate Sponsored Events & Community Outreach
Care.com annual membership
Employee Assistance Program
Supplemental Benefits via Corestream (Critical Care, Hospital Indemnity, Accident Insurance, Legal Assistance and ID theft protection, etc.)
Position may be eligible for a discretionary variable incentive bonus