HBITS #06-13919 Database Architect - Expert
Apply NowCompany: Knowledge Builders, Inc.
Location: Albany, NY 12203
Description:
Job Description
Database Architect - Expert
This position is for a Database Architect, Expert. Individual will play a technical lead role in support of ITS Microsoft SQL Server Enterprise Databases.
Day to Day Tasks:
1. Provide a Technical lead in the architecture and design of applications, databases, and technical infrastructure for SQL Enterprise team.
2. 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.
3. Architect SQL Server Failover Cluster and AlwaysOn Availability Group environments for site critical databases, including configurations, failover testing, tuning and creating standards.
4. 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.
5. Configure, install and support the implementation of Microsoft SQL Server Database, Reporting, Integration, and Analytical Services within NYS Enterprise managed SQL database environments.
6. 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.
7. Configure and install database instances/databases/schemas, allocate storage, setup and monitor database backups, implement maintenance plans, and maintain database security.
8. Use DBA tools to monitor, diagnose, and fix issues with the enterprise managed database environments.
9. Interact heavily with other DBA staff to provide on-the-job training and assistance in performing database administrative activities.
10. 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 Qualifications:
Database Architect - 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.
Expert - 84+ Months: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.
Requested Qualifications:
- 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 failover 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.
Database Architect - Expert
This position is for a Database Architect, Expert. Individual will play a technical lead role in support of ITS Microsoft SQL Server Enterprise Databases.
Day to Day Tasks:
1. Provide a Technical lead in the architecture and design of applications, databases, and technical infrastructure for SQL Enterprise team.
2. 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.
3. Architect SQL Server Failover Cluster and AlwaysOn Availability Group environments for site critical databases, including configurations, failover testing, tuning and creating standards.
4. 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.
5. Configure, install and support the implementation of Microsoft SQL Server Database, Reporting, Integration, and Analytical Services within NYS Enterprise managed SQL database environments.
6. 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.
7. Configure and install database instances/databases/schemas, allocate storage, setup and monitor database backups, implement maintenance plans, and maintain database security.
8. Use DBA tools to monitor, diagnose, and fix issues with the enterprise managed database environments.
9. Interact heavily with other DBA staff to provide on-the-job training and assistance in performing database administrative activities.
10. 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 Qualifications:
Database Architect - 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.
Expert - 84+ Months: Candidate is able to provide guidance to large teams and/or has extensive industry experience and is considered at the top of his/her field.
Requested Qualifications:
- 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 failover 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.