Sr. SQL Server DBA Platform Administrator

Senior SQL Server DBA/Data Platform Engineer We are seeking a highly skilled Senior SQL Server DBA / Data Platform Engineer to support and optimize our enterprise-grade on-premises SQL Server 2022 Always On Availability Group (AG) environment within a highly regulated and compliance-driven organization. This role requires deep expertise in core SQL Server administration, database security, performance optimization, high availability, and operational support for mission-critical systems. The ideal candidate will also have experience supporting hybrid data platforms that extend into Azure SQL, Azure Data Factory (ADF), and Azure Data Lake environments. In addition to traditional DBA responsibilities, this individual will collaborate closely with engineering and analytics teams to support database migrations, data transformations, BI reporting initiatives, and real-time data streaming pipelines. Job Details SQL Server Administration & Operations Administer and support enterprise SQL Server 2022 environments with a focus on Always On Availability Groups (AG), high availability, and disaster recovery. Perform SQL Server installations, configurations, upgrades, patching, and lifecycle management. Monitor database health, storage utilization, performance metrics, and system availability. Manage backup, restore, recovery, and maintenance strategies for mission-critical databases. Troubleshoot database issues including blocking, deadlocks, replication, connectivity, and performance degradation. Security & Compliance Implement and maintain database security standards in a highly regulated environment. Manage role-based access controls, encryption, auditing, and compliance requirements. Ensure adherence to organizational security policies, governance frameworks, and data retention standards. Support audit activities and remediation efforts. Performance Optimization Optimize SQL Server performance through indexing strategies, query tuning, execution plan analysis, and resource optimization. Analyze and optimize stored procedures, views, functions, and ETL workloads. Improve database scalability and operational efficiency for high-volume transactional systems. Data Engineering & Cloud Integration Support engineering teams with: Database migrations Data transformations Schema changes Performance tuning initiatives Assist with Microsoft BI and dashboard development initiatives. Optimize and support Azure Data Factory (ADF) pipelines, including streaming and near real‑time data integrations. Support data delivery workflows into Azure Data Lake environments. Administer and support Azure SQL databases and hybrid cloud data architecture. Collaboration & Support Work closely with application developers, data engineers, BI teams, and infrastructure teams. Provide operational guidance and best practices for database development and deployment. Participate in on‑call support rotations and production incident management as needed. Job Requirements Required 7+ years of hands‑on SQL Server DBA experience in enterprise environments. Strong experience with: SQL Server 2019/2022 Always On Availability Groups (AG) High Availability / Disaster Recovery (HA/DR) SQL Server installations and upgrades Performance tuning and optimization Database security and compliance Experience working in highly regulated or compliance‑driven environments. Advanced T‑SQL skills including: Stored procedure optimization Query tuning Execution plan analysis Index management Experience supporting hybrid environments involving: Azure SQL Azure Data Factory (ADF) Azure Data Lake Familiarity with Microsoft BI technologies and dashboard support. Strong troubleshooting and root cause analysis skills. Excellent communication and collaboration abilities. Desired Experience with Python scripting for automation, ETL, or pipeline development. Experience supporting real‑time or streaming data pipelines. Familiarity with DevOps, CI/CD, and Infrastructure‑as‑Code practices. Knowledge of Power BI, SSIS, SSRS, or other Microsoft data platform technologies. Experience with cloud migration initiatives from on‑premises SQL Server to Azure. Relevant Microsoft certifications preferred. Technical Environment SQL Server 2022 Enterprise Always On Availability Groups (AG) Azure SQL Azure Data Factory (ADF) Azure Data Lake Microsoft BI / Power BI Python (preferred) Hybrid On‑Prem / Azure Cloud Data Platform #J-18808-Ljbffr