SQL Database Administrator

Trigyn; 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's direct government client has an immediate need for a SQL Database Administrator in Albany, NY.

Description: This position is for a Database Administrator, who will provide technical and operational support for NYS agencies with job duties such as installing, patching and upgrading SQL Server; providing operational support; implementing backups and recovery; performing resource planning and performance tuning etc.

• Install, configure, administer, and manage MS SQL Server databases including high availability and disaster recovery configurations.
• Assist in Developing and implementing appropriate high availability and disaster recovery solutions.
• Perform regular backups and ensure recovery solutions are in place and regularly kept updated utilizing approved ITS/MSSQL team approved backup tools.
• Monitor performance of database servers, listeners and other related processes, optimize performance of databases, tune applications, server resources - CPU, memory, storage, network, etc.
• Ensure appropriate security protocols in line with ITS guidelines and known best practices are in place, patches are applied on all database environments
• Perform capacity planning and storage space management.
• Create and maintain documentation for all major installation and implementation
• Explore, actively support and work on new technology initiatives, much beyond the database world that may be of interest to the Organization
• Actively participate and contribute in troubleshooting and alleviating any issues that group may have.
• Actively take a lead in analyzing SQL database performance issues.
• Provide production support including off hour support and help application debugging
• Interact with database vendors for Support and resolution of issues.

• Uses specialized software to store and organize data, which may include capacity planning, installation, configuration, database design, migration, performance monitoring, security and troubleshooting, as well as backup and data recovery.
• Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.
• 84 months of experience with SQL Server versions 2012 to 2025 installations, configurations and troubleshooting.
• 84 months experience working in translating business needs into industry standard SQL solutions.
• 84 months of experience in designing/installing and maintaining High Availability and Disaster Recovery Solutions on Windows Clustered Environment supporting Failover clustered SQL Server instances.
• 84 months of experience in SQL Server Performance Tuning and Optimization.
• 84 months working and supporting Critical Disabilities & Aging, Human Services, and Public Safety Applications for Government Agencies hosted on a SQL Server database environment (e.g., Working with Department of Corrections, Department of Labor, Office for People with Developmental Disabilities, Office for Aging, Office of Addiction Services and Supports, or the Justice Center for the Protection of People with Special Needs).
• 84 months experience installing, configuring and maintaining Microsoft SQL Server SQL Server Reporting Service and Power BI Server. Experience should include scaled-out deployment.
• 84 months experience installing, configuring and troubleshooting SQL Server Integration Services 2012 to 2025 packages and connectivity issues.
• 84 months experience in working with scripting tools like T-SQL or PowerShell.
• 36 months experience with Azure or Azure SQL.
• Bachelor's degree in computer science or related fields.

TRIGYN TECHNOLOGIES, INC. is an EQUAL OPPORTUNITY EMPLOYER and has been in business for 35 years. TRIGYN is an ISO 27001:2022 and CMMI Level 5 certified company.