Senior SQL Server DBA: HA, DR & Performance

Valiant Technologies LLC; Harrisburg (Dauphin County); Presencial; USD 90 000 - 130 000; Tempo integral

Resumo da oferta

Valiant Technologies LLC is seeking an experienced SQL Server DBA in Harrisburg, PA. The role requires 4+ years of experience with SQL Server 2022 or later, including installation, upgrades, maintenance, and security auditing.

You will manage backups, disaster recovery, HA configurations, and integrate with AWS storage. Proficiency with SSMS, SQL Server Agent, Profiler, Extended Events, and DMVs is required.

Qualificações

• 4+ years of SQL Server DBA experience with 2022 or later versions.
• Experience installing and upgrading SQL Servers, including service packs and CU
• Perform routine database maintenance and security auditing
• Strong knowledge of backups, recovery, and disaster recovery planning
• Experience with high availability, including WFCS and MSDTC
• Familiarity with cloud storage (AWS) and encryption at rest/transit

Responsabilidades

• Maintain SQL Server performance and health, monitor logs and alerts
• Configure and manage SQL Server Agent jobs and schedules
• Perform backups, restore tests, and point-in-time recoveries
• Establish and enforce DR plans and recovery objectives
• Implement security controls and auditing for databases
• Work with IT to manage storage and WFCS environments

Conhecimentos

SQL Server Administration

T-SQL Coding

Database Performance Monitoring

Backup and Recovery

Security and Auditing

Disaster Recovery Planning

Ferramentas

SQL Server Management Studio (SSMS)

SQL Server Agent

SQL Server Profiler

Extended Events

Dynamic Management Views

AWS Storage

Windows Failover Cluster Service

MSDTC

Descrição da oferta de emprego

Valiant Technologies LLC is seeking an experienced SQL Server DBA in Harrisburg, PA. The role requires 4+ years of experience with SQL Server 2022 or later, including installation, upgrades, maintenance, and security auditing.

You will manage backups, disaster recovery, HA configurations, and integrate with AWS storage. Proficiency with SSMS, SQL Server Agent, Profiler, Extended Events, and DMVs is required.