What are the responsibilities and job description for the Database Architect position at RightTalents?
Job Details
Title: Database Architect
Location: Albany, NY (Hybrid)
Duration: 30 Months
Work Hours: 40 Hours per week
Job Description:
- 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 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.
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
