SQL Server Database Architect

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.

Job Types: Full-time, Contract

Pay: $55.00 - $60.00 per hour

Expected hours: 37.5 per week

Benefits:

• Health insurance

Schedule:

• Monday to Friday

Experience:

• Microsoft SQL Server database environment.: 8 years (Preferred)
• SQL Server infrastructures on a Windows platform: 8 years (Preferred)
• databases, focusing performance and sizing characteristics: 8 years (Preferred)
• HADR Microsoft SQL Server 2016 or higher versions: 8 years (Preferred)
• SQL Server support for government / public sector IT: 6 years (Preferred)

Work Location: On the road

Salary : $55 - $60