Database Architect - Hybrid - Albany, NY

We have a Contract assignment available with our client in Albany, NY

Job 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.

Roles & Responsibilities:

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

Required Skills:

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

While every effort was made to ensure this email was sent to its intended recipient, if you ve received it in error, please keep it confidential, let the sender know and delete the original and any copies. Disclosing, copying or sharing its contents is prohibited and may be unlawful. Thank you.