SQL Server Architect

Company: Donato Tech
Location: Carteret
Posted on: April 2, 2025

Job Description:

Role: SQL Server Architect

Before applying for this role, please read the following information about this opportunity found below.
Location: Albany, New York
Duration: 30 Months

Description
This position is for a Database Architect, Expert. Individual will play a technical lead role in support of ITS Microsoft SQL Server Enterprise Databases.
Duties
Provide a Technical lead in the architecture and design of applications, databases, and technical infrastructure for SQL Enterprise team.
Work on proof of concept and prototyping activities to evaluate whether proposed architecture and database components meet functional requirements, as well as non-functional requirements such as reliability, scalability, performance and maintainability.
Architect SQL Server Failover Cluster and AlwaysOn Availability Group environments for site critical databases, including configurations, failover testing, tuning and creating standards.
Perform short and long-range planning needs for databases and applications, focusing on performance and sizing characteristics to determine upcoming storage, CPU, memory, and network needs.
Configure, install and support the implementation of Microsoft SQL Server Database, Reporting, Integration, and Analytical Services within NYS Enterprise managed SQL database environments.
Partner with all teams (database management, software development, analysis/design, business users) to provide effective solutions utilizing industry best practices and in conformance with current ITS policies and guidelines.
Configure and install database instances/databases/schemas, allocate storage, setup and monitor database backups, implement maintenance plans, and maintain database security.
Use DBA tools to monitor, diagnose, and fix issues with the enterprise managed database environments.
Interact heavily with other DBA staff to provide on-the-job training and assistance in performing database administrative activities.
Work off-hours occasionally to support Database maintenance, operational procedures and initiatives, and be available for rotational on-call support to maintain 7x24 coverage of the Database environment.

Mandatory Requirements
Experience (14+ Years)
Determines database structural requirements by analyzing client operations, applications, and programming; reviews objectives with clients; evaluates current systems; provides database support by coding utilities, responding to user questions, and resolving problems.

Requirements
This is an 100% Onsite
84 months experience in providing Technical Architecture services supporting a Microsoft SQL Server database environment. Experience must include architecture and design of SQL Server infrastructures on a Windows platform.
84 months experience designing processes and procedures, setting up standards, and creation of scripts for installation of Microsoft SQL Server software and the creation of databases.
84 months experience performing short and long-range planning needs for databases, focusing on performance and sizing characteristics to determine upcoming storage, CPU, memory, and network needs.
84 months experience in the design, architecture and build of Microsoft SQL Server on a Microsoft HyperV framework.
84 months experience in the design, architecture, and build of HADR Microsoft SQL Server 2016 or higher versions, including fail-over cluster instances, Always-on availability groups, and Disaster Recovery processes.
84 months experience in proof of concept and prototyping activities to evaluate whether proposed architecture and database components meet functional and non-functional requirements.
60 months experience with the design, implementation and support of Microsoft SQL Server Integration and Reporting services, including scale-out design for Reporting services.
60 months experience providing Microsoft SQL Server support for government / public sector IT operations utilizing ITIL-compliant methodologies for the development and delivery of government hosted IT services and solutions.
Bachelor's degree in computer science, Computer Information Systems, or Information Technology

Keywords: Donato Tech, Perth Amboy , SQL Server Architect, Professions , Carteret, New Jersey