SQL Database Administrator

V Group Inc.; City of Albany (NY); Hybrid; USD 110,000 - 140,000; Part time

Job summary

V Group Inc. in Albany, NY is seeking an experienced SQL Server Database Administrator for a contract role (40 hours/week). The specialist will install, configure, and manage SQL Server databases, implement HA/DR, perform backups, monitor performance, and ensure security in ITS guidelines.

This role supports government agencies and requires AS/Azure SQL experience. Responsibilities include tuning, capacity planning, documentation, and vendor coordination, with off-hours production support as

Qualifications

• 84 months experience installing, configuring, and troubleshooting SQL Server across versions 2012–2025.
• 84 months experience 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 Clustering environments.
• 84 months experience in SQL Server performance tuning and optimization.
• 84 months working on government agency applications hosted on SQL Server databases (e.g., health, aging, public safety).
• 84 months experience with SSRS/SSIS and Power BI Server, including scaled deployments.
• 84 months experience with scripting using T-SQL or PowerShell.
• 36 months experience with Azure or Azure SQL.
• Bachelor’s degree in computer science or related fields.

Responsibilities

• Install, configure, administer, and manage MS SQL Server databases including high availability and disaster recovery configurations.
• Assist in developing and implementing high availability and disaster recovery solutions.
• Perform regular backups and ensure recovery solutions are in place and updated.
• Monitor performance of database servers, optimize performance, tune resources.
• Ensure security in line with ITS guidelines and apply patches.
• Perform capacity planning and storage management.
• Create and maintain documentation for major installations.
• Support new technology initiatives beyond the database world.
• Lead in analyzing SQL database performance issues.
• Provide production support including off-hour support.
• Interact with database vendors for support and resolution of issues.

Skills

SQL Server mastery

HA/DR design

Performance tuning

Scripting (PowerShell/T-SQL)

Windows server admin

Vendor liaison

Education

Bachelor's degree in computer science

Tools

SSIS

SSRS

PowerBI Server

Azure SQL

SQL Server Management Studio

Job description

Job Title: SQL Server Database Administrator

Start Date: ASAP

Position Type: Contract

Duration: 30 Months

Location: Albany, NY, 12210 (Hybrid)

Number of Hours: 40 hours a week

Interview Type: Webcam

Department: ITS

Description : This position is for a Database Administrator - Expert level who provides 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

Responsibilities:

• 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

Required:

• 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
• 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 PowerBI 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