> Markdown version of [/jobs/ext/1219333-sr-sql-server-administrator](https://www.wearedevelopers.com/jobs/ext/1219333-sr-sql-server-administrator). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Sr. SQL Server Administrator - **Company:** Sligo Software Solutions Inc. - **Location:** Albany, NY, United States - **Experience:** Expert - **Contract:** Temporary to permanent - **Skills:** Databases, Data Architecture, Data Conversion, Data Manipulation Languages, Data Mapping, Data Recovery, IBM DB2, Database Design, Job Scheduling, Microsoft SQL Server, Performance Tuning, Software Engineering, SQL Stored Procedures, PL-SQL, SQL Databases, SQL Server Reporting Services, SQL Server Integration Services, Freeform SQL, Usage Tracking, Information Technology, Performance Monitor, Physical Data Models, Redgate, SQL Server Management Studio (SSMS), Programming Languages - **Published:** July 9, 2026 - **Apply:** https://www.careerjet.com/jobad/us41a0b79cd8c53912ffe689391c964084 ## About the Role * This is an 100% Onsite. * 84 months of experience designing and developing logical and physical data models, and creating DDL scripts for tables, views, indexes, triggers, stored procedures. * 84 months of experience designing and developing Data Conversion Strategy Plan, Data Mapping Documents, Gap Analysis. * 84 months of experience writing complex DML SQL against enterprise SQL Server and DB2 databases. * 84 months of experience working with tools like SQL Server Management Studio, SSMS Job Scheduler, SSIS, SSRS, Export/Import, ER Studio Data Architect, QMF for Workstation, Redgate SQL Compare, TSO. * 84 months of experience using programming languages such as SQL, PL/SQL. * 60 months of experience performance tuning complex SQL against enterprise SQL Server and DB2 databases. * R sum * Copy of Candidate Identification (i.e., Driver's License/Green Card/Visa and Passport if applicable) * Any documents referenced in the above Requested Qualifications (i.e., professional certifications, degrees, etc.) ## Description Based on Governor's Office priorities, there are crucial initiatives that benefit New York State Higher Education Services (HESC) and are part of the ITS/HESC project portfolio. This position will supplement the GLP DB staff for governor initiatives resulting from the 2024 NYS Budget and that effect HESC's Grants and Scholarship programs. Duties * Build and maintain a data architecture based on the requirements. * Design and develop Logical and Physical Data Model using ER Studio Data Architect. Create DDL scripts to establish and maintain necessary databases. * Write complex SQL queries against SQL Server and DB2 databases. Create DML scripts to manipulate data. * Work with project managers, solution architects, business analysts, application development teams and QA to ensure the quality of DDL and DML scripts. * Performance tuning SQL to improve efficiency. * Working with NYS Agency representatives to develop gap analysis specifications and understand Agency business rules. * Provide guidance and hands-on development for developing and maintaining queries in QMF for Workstation. * Create clear and accurate documentation on data models, and description of data usage in the application process flow. Mandatory Requirements * Experience (14+Years) * 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., Title : Database Administrator - Senior Location : Albany, NY, 12255. Duration : 24 Months Client : Information Technology Services (ITS) Requirements : 60 months of Expe… + 11 hours ago + Apply easily ## Related Videos - [Data Fabric in Action - How to enhance a Stock Trading App with ML and Data Virtualization](https://www.wearedevelopers.com/videos/253-data-fabric-in-action-how-to-enhance-a-stock-trading-app-with-ml-and-data-virtualization) - [Hacking MSSQL on Cloud. All of them. How I became sysadmin on Azure, AWS, GCP and Alibaba.](https://www.wearedevelopers.com/videos/100339-hacking-mssql-on-cloud-all-of-them-how-i-became-sysadmin-on-azure-aws-gcp-and-alibaba) - [Database DevOps with Containers](https://www.wearedevelopers.com/videos/145-database-devops-with-containers) - [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Fully Remote Software Engineer Jobs](https://www.wearedevelopers.com/magazine/447-fully-remote-software-engineer-jobs) - [SQL Murder Mystery: A game for hobby detectives who want to learn SQL](https://www.wearedevelopers.com/magazine/38-sql-murder-mystery-a-game-for-hobby-detectives-who-want-to-learn-sql) - [What’s the Difference between a Junior, Mid, and Senior Developer?](https://www.wearedevelopers.com/magazine/238-what-s-the-difference-between-a-junior-mid-and-senior-developer) - [Software Engineer Salary London](https://www.wearedevelopers.com/magazine/252-software-engineer-salary-london)