What are the responsibilities and job description for the MS SQL Server DBA position at Bits & Bytes Technology Solutions?
Job Details
MS SQL Server DBA
Duration: 30 months
Location: Albany, NY (2-3 days remote every week)
Client: State of New York
Note: Candidates must share 3 references and a copy of their Visa & Passport for submission
Job Description:
1. | 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. |
2. | 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. |
3. | 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. |
4. | 84 months experience in the design, architecture and build of Microsoft SQL Server on a Microsoft HyperV framework. |
5. | 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. |
6. | 84 months experience in proof of concept and prototyping activities to evaluate whether proposed architecture and database components meet functional and non-functional requirements. |
7. | 60 months experience with the design, implementation and support of Microsoft SQL Server Integration and Reporting services, including scale-out design for Reporting services. |
8. | 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. |
9. | Bachelor's degree in computer science, Computer Information Systems, or Information Technology |