Job Title: Senior SQL Database Administrator (DBA)
Location: Remote
Experience Required: 8+ Years
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 ResponsibilitiesDatabase 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).
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.
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).
...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...
...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...
...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...
...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...
...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...