Senior SQL Database Administrator - HA/DR & Performance

Trigyn Technologies Limited; City of Albany (NY); On-site; USD 110,000 - 140,000; Full time

Job summary

Trigyn Technologies, Inc. in Albany, NY is seeking a SQL Database Administrator to install, patch, upgrade SQL Server, and provide operational support with backups and recovery.

The role includes monitoring performance, applying security patches, planning capacity, and collaborating with ITS teams on new tech initiatives. 8+ years of SQL Server experience and government-agency exposure are preferred.

Qualifications

• 84 months of SQL Server installations, configurations and troubleshooting.
• Experience in designing/maintaining High Availability and Disaster Recovery Solutions.
• Experience with SQL Server Performance Tuning and Optimization.
• Experience with government/critical systems environments and related applications.

Responsibilities

• Install, configure, administer, and manage MS SQL Server databases including HA and DR configurations.
• Assist in developing and implementing high availability and disaster recovery solutions.
• Perform backups and ensure recovery procedures are in place and tested.
• Monitor database performance, tune queries, and optimize resources (CPU, memory, storage).
• Ensure security protocols per ITS guidelines and apply patches.
• Plan capacity and manage storage space.
• Create and maintain installation/implementation documentation.

Skills

SQL Server

PowerShell

T-SQL

Performance tuning

Backup and recovery

High availability

Education

Bachelor's degree in computer science or related fields

Tools

Microsoft SQL Server

Power BI Server

SQL Server Reporting Services (SSRS)

SQL Server Integration Services (SSIS)

Azure SQL

Windows Server

Job description

Trigyn Technologies, Inc. in Albany, NY is seeking a SQL Database Administrator to install, patch, upgrade SQL Server, and provide operational support with backups and recovery.

The role includes monitoring performance, applying security patches, planning capacity, and collaborating with ITS teams on new tech initiatives. 8+ years of SQL Server experience and government-agency exposure are preferred.