SQL Database Administrator(Secret Clearance) Job at Agelix Consulting, Washington DC

VnNRZnBMSFVkWStSQk1jekx6RDVEV214ZlE9PQ==
  • Agelix Consulting
  • Washington DC

Job Description

Job Title: Senior SQL Database Administrator (DBA)

Location: Remote

Experience Required: 8+ Years

About the Role

We are seeking a highly skilled and experienced Senior SQL Database Administrator to join our client [IT Infrastructure / Database Engineering] team. In this role, you will be the technical authority responsible for the design, implementation, and maintenance of our critical database ecosystems. You will focus primarily on Microsoft SQL Server while also supporting open-source and legacy database technologies.

The ideal candidate is a proactive problem-solver who can architect high-availability solutions, optimize performance at scale, and mentor junior team members.

Key Responsibilities

Database Administration & Architecture (SQL Server)

  • Design & Implement HA/DR: Architect, configure, and maintain high-availability and disaster recovery solutions, specifically SQL Server Clustering (WSFC) and Always On Availability Groups .

  • Performance Tuning: Proactively monitor and optimize database performance using tools like SQL Profiler, Extended Events, and DMVs. Resolve blocking, deadlocking, and I/O contention issues.

  • T-SQL Scripting: Develop and maintain complex T-SQL scripts for automation, data manipulation, and administrative tasks.

  • Standards & Governance: Establish and enforce database standards, policies, and procedures for security, backup/recovery, and change management.

  • Upgrades & Patching: Manage SQL Server version upgrades, Cumulative Updates (CUs), and Service Packs (SPs) with minimal downtime.

Cross-Platform & Legacy Support

  • Open-Source & Other RDBMS: Provide administrative support and migration assistance for MySQL, MariaDB, and PostgreSQL .

  • Legacy Systems: Maintain and support legacy databases including Microsoft Access and Oracle PL/SQL environments.

  • Integration: Ensure seamless data flow and connectivity between disparate database platforms.

Operational Excellence

  • Backup & Recovery: Own the backup and recovery strategy, ensuring RPO/RTO targets are met. Perform regular recovery drills.

  • Security: Implement database security best practices, including encryption (TDE), auditing, and role-based access control (RBAC).

  • Troubleshooting: Act as the escalation point for complex database issues, providing root cause analysis (RCA) and permanent fixes.

  • Cloud Exposure: Assist in the migration or hybrid management of databases to Azure (IaaS/PaaS).

Required Qualifications (Must-Have)
  • Experience: 8+ years of proven experience as a SQL Server DBA in an enterprise environment.

  • SQL Server Mastery:

    • Deep expertise in SQL Server Clustering and Always On Availability Groups .

    • Advanced T-SQL scripting skills (stored procedures, triggers, functions, window functions).

    • Proven track record of HA/DR design and implementation.

    • Strong performance tuning capabilities (Query Store, Execution Plans, Indexing strategies).

  • Secondary Database Exposure: Hands-on experience with MySQL, MariaDB, and PostgreSQL .

  • Legacy Systems: Experience supporting Microsoft Access and writing/debugging PL/SQL (Oracle).

  • Certifications: Microsoft Certified: Azure Database Administrator Associate (DP-300) is required.

Preferred Qualifications (Nice-to-Have)
  • Legacy Certifications: MCSA (Microsoft Certified Solutions Associate) or MCSE (Microsoft Certified Solutions Expert) in SQL Server / Data Management.

  • Experience with Infrastructure as Code (IaC) tools (Terraform, ARM templates).

  • Familiarity with PowerShell for database automation.

  • Experience with third-party monitoring tools (Redgate, SolarWinds, Idera).

Job Tags

Permanent employment, Full time, Part time, Internship, Seasonal work, Remote work

Similar Jobs

Capital One

Sr Business Analyst, Commercial Corporate Bank Job at Capital One

 ...Overview Sr Business Analyst, Commercial Corporate Bank Summary: As a Senior Business Analyst at Capital One, you will apply your strategic and analytical skills to major company challenges. You will team with world-class professionals to develop and test strategies... 

HEALTHCARE RECRUITMENT COUNSELORS

Pain Management Physician Pensacola FL Job at HEALTHCARE RECRUITMENT COUNSELORS

 ...Pain Management Physician Pensacola FL Earning Potential $575,000+ | Full-Time Join a thriving, physician-led pain management practice in Pensacola, FL. We are seeking a Pain Management Physician to join our growing multidisciplinary team. Both fellowship-trained... 

AgeSpan

Accountant I Job at AgeSpan

 ...RN's and Social Workers ~ And MORE! Position Summary: Accountant I is an entry-level professional accounting position responsible...  ..., or a related field. One to two years of accounting experience. Understanding of generally accepted accounting principles... 

Dozortsev & Sons Dozortsev & Sons

Experienced Sales Consultant Job at Dozortsev & Sons Dozortsev & Sons

 ...Job Description: **Job Opening: Sales Consultant** **Company:** Dozortsev and Sons Wine and Spirits Distribution **Location:** Metro NY (Long Island & Manhattan) & NJ **Position Type:** Full-Time **About Us:** Dozortsev and Sons is a leading wine and spirits... 

Visiting Angels Puyallup and Federal Way

CNA or HCA In-Home Caregiver Job at Visiting Angels Puyallup and Federal Way

 ...services for the Client as necessary to maintain the personal care and comfort of the Client. The Caregiver officially reports to...  ...desirable. Active Washington State Certified Nursing Assistance (CNA) or Home Care Aide (HCA) license, or in current training to obtain...