SQL Server Architect

Donato Technologies Inc

SQL Server Architect

Albany, NY
Full Time
Paid
  • Responsibilities

    Greetings from Donato Technologies Inc.

    We have an immediate opening with my client. If you are looking for a new project, please send me a copy of your updated resume

    Role: SQL Server Architect

    Location: Albany, New York

    Duration: 30 Months

    Client: NY State

    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

    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.

    Jennifer Sampson

    Technical Recruiter

    .......................................................

    DONATO TECHNOLOGIES, INC

    12100 Ford Rd, #306, Dallas, TX 75234

    Direct : (214) 738-0410

    Email: jenny@donatotech.net

    Web: www.donatotech.net