Job ID: JOB_ID_6395
Job Summary
We are looking for an experienced SQL Database Administrator (DBA) for a long-term contract role (12+ months) located in Albany, NY. This position requires an onsite presence from day one. The ideal candidate will have extensive experience managing MS SQL Server instances, ensuring high availability, disaster recovery, performance optimization, and security, with a strong background in public sector applications.
Key Responsibilities
- Install, configure, administer, and manage MS SQL Server Instances and databases (SQL version 2012 and up), including high availability and disaster recovery configurations.
- Develop and implement 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 database performance and monitor server resources (CPU, memory, storage, network, etc.).
- Ensure appropriate security protocols are in place in line with ITS guidelines and known best practices; ensure patches are applied to all SQL instances timely.
- Perform capacity planning and monitor storage utilization, taking corrective actions when necessary.
- Create and maintain documentation for all major installations, configurations, implementations, and troubleshooting.
- Actively support and work on new technology initiatives that may be of interest to the Organization.
Required Skills and Experience
- 84 months of experience with SQL Server versions 2012 to 2025 installations, configurations, and troubleshooting.
- 84 months of 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 a 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 Public Safety Applications for Government Agencies hosted on a SQL Server database environment (e.g., Working with Dept of Corrections, Division of Criminal Justice, or Homeland Security, or Police Depts).
- 84 months of experience installing, configuring, and maintaining Microsoft SQL Server Reporting Service and PowerBI Server. Experience should include scaled-out deployment.
- 84 months of experience installing, configuring, and troubleshooting SQL Server Integration Services 2012 to 2025 packages and connectivity issues.
- 84 months of experience in working with scripting tools like T-SQL or PowerShell.
- 36 months of experience with Azure or Azure SQL.
- Bachelors degree in computer science or related fields.
Additional Information
- Employment Type: Contract (12+ months)
- Location: Albany, NY (Onsite from day 1)
- Interview Process: Phone/Skype Hire
- Verification: Candidates must be able to provide a completed I9 form for verification at the time of resume submission.
Special Requirements
Screening: Candidates with fake experience are advised not to apply. All candidates will be required to provide completed I9 form for verification at the time of resume submission. Interview Mode: Phone/Skype Hire. Domain: Public sector applications for Government Agencies (e.g., Dept of Corrections, Division of Criminal Justice, Homeland Security, Police Depts).
Compensation & Location
Salary: $80,000 – $130,000 per year (Estimated)
Location: Albany, NY
Recruiter / Company – Contact Information
Email: raj.singh@softwarepeopleinc.com
Recruiter Notice:
To remove this job posting, please send an email from
raj.singh@softwarepeopleinc.com with the subject:
DELETE_JOB_ID_6395