Senior SQL Server DBA - High Availability & Performance (Hybrid)

Seneca Resources Company, LLC; New York (NY); Hybrid; USD 96.000 - 138.000; Vollzeit

Zusammenfassung

Seneca Resources seeks an experienced SQL Server Database Administrator to manage enterprise SQL Server environments, focusing on high availability, performance, and security. The role covers Always On, backups, restores, and DR testing, with hands-on development using T-SQL, PowerShell, and Python.

Collaboration across infra, apps, and business teams is essential for modernization efforts. The position is hybrid in New York, NY, offering a challenging, enterprise-grade environment with

Qualifikationen

• Strong hands-on experience administering Microsoft SQL Server 2016, 2019, and/or 2022 in enterprise production environments.
• Advanced experience with SQL Server performance tuning, indexing, query optimization, and troubleshooting.
• Hands-on experience with SQL Server Always On Availability Groups and Failover Clustering.
• Strong knowledge of backup, restore, recovery, disaster recovery, and high-availability strategies.
• Strong T-SQL development experience, including queries, stored procedures, and database objects.
• Experience with SQL Server Management Studio (SSMS).
• Experience with SQL Server security, permissions, auditing, monitoring, and capacity planning.
• Hands-on experience with PowerShell scripting and Python programming.
• Experience supporting SSIS, SSRS, and Power BI integrations.
• Experience with Azure DevOps.
• Working knowledge of Windows Server administration.
• Experience supporting mission-critical enterprise databases and applications.
• Strong analytical, troubleshooting, documentation, communication, and problem-solving skills.

Aufgaben

• Administer, maintain, monitor, and support enterprise Microsoft SQL Server 2016/2019/2022 environments.
• Monitor database availability, health, capacity, storage utilization, and overall performance.
• Install, configure, patch, upgrade, and maintain SQL Server environments.
• Support mission-critical production databases and enterprise applications.
• Troubleshoot complex database incidents, performance degradation, blocking, deadlocks, and data-related issues.
• Maintain database security, permissions, auditing, and operational standards.
• Administer and support SQL Server Always On Availability Groups and Failover Clustering.
• Develop and maintain database backup, restore, and recovery strategies.
• Perform database restorations and disaster recovery testing.
• Monitor and maintain database replication and high-availability configurations.
• Support business continuity and recovery requirements for critical database platforms.
• Analyze and resolve database performance issues across production environments.
• Perform index optimization, query tuning, execution-plan analysis, and database performance troubleshooting.
• Develop and optimize T-SQL queries, stored procedures, scripts, and other database objects.
• Monitor database growth and capacity trends and proactively address potential performance or availability issues.
• Recommend database configuration and architecture improvements based on application and business requirements.
• Develop database solutions and automation using T-SQL, PowerShell, and Python.
• Support SSIS and SSRS solutions and associated database integrations.
• Support Power BI integrations with SQL Server environments.
• Utilize Azure DevOps to support database development, deployment, change-management, and automation activities.
• Partner with application and development teams on database changes, releases, troubleshooting, and production deployments.
• Participate in database migration, upgrade, and modernization initiatives.
• Support database integrations with Windows Server, storage, infrastructure, and application environments.
• Evaluate and support opportunities involving Azure SQL and other modern database technologies.
• Maintain technical documentation, operational procedures, recovery plans, and database standards.

Kenntnisse

SQL Server Expertise

Performance Tuning

High Availability

T-SQL Development

PowerShell Scripting

Python Programming

Azure DevOps

SQL Server Security

Communication Skills

Documentation

Tools

SSMS

SSIS

SSRS

Power BI

Azure DevOps

Windows Server

Kubernetes

Jobbeschreibung

Seneca Resources seeks an experienced SQL Server Database Administrator to manage enterprise SQL Server environments, focusing on high availability, performance, and security. The role covers Always On, backups, restores, and DR testing, with hands-on development using T-SQL, PowerShell, and Python.

Collaboration across infra, apps, and business teams is essential for modernization efforts. The position is hybrid in New York, NY, offering a challenging, enterprise-grade environment with