Primary Responsibilities: Provide database administration services in support of web and client server applications. Must be able to provide both production and development DBA support tasks. Creating and maintaining database documentation, such as data dictionaries, entity relationship diagrams, data models, and stored procedures. Install, configure, upgrade and maintain databases on Windows (preferred) or other platforms. Administer database users, manage database objects, and configure client network. Perform logical and physical database design. Implement and enforce security for all the databases. Perform database monitoring and tuning using DMVs, Perfmon, profiler and other tools. Perform database refreshes of Development and QA databases. Work with the application development team on production release deployments. Provide support and consultation to the application development team in all database related areas including table and index design and creation and SQL tuning. Install and configure DBA management tools. Troubleshoot and correct database issues in an efficient and timely manner. Perform backup and recovery of databases. Support all nightly database maintenance and administration jobs. Maintain all production job scripts assigned to the database team. Proactively monitor databases and identify potential problems. Enforce all database architecture and relevant procedures according to established policies. Create, troubleshoot and deploy SSIS/SSRS solutions for data exports/imports and reporting needs. Must have worked in Microsoft clustering of SQL databases, Always ON high availability solutions. Position will report to the Senior Database Administrator. The selected candidate must be able to manage database related services from the planning phase through the implementation and management phases. He or she will interface with other team members, management, and end-users on a regular basis. After hours, availability is required in order to respond to emergencies, production releases, and to perform database maintenance that cannot be completed during normal business hours. Qualifications/ Skills: 5+ years Database Administration experience; should have experience in test, development and production instances. In-depth knowledge of SQL server versions 2012/2016 and above, with SSIS/SSRS Experience with databases migrations of SQL Servers from older to newer versions Experience in configuring and maintaining SQL Always ON is required. Ability to execute performance monitoring and necessary adjustments. Excellent knowledge of backup and recovery scenarios and backup tools. Highly self-motivated individual who has the ability to work independently as well as in a team environment. Excellent verbal and written communication skills; ability to think st***gically with technical vision; proven project management and leadership skills; attention to detail and strong organizational skills. Oracle experience a plus.

Comments for Suppliers:

This position will be part of the team that provides ellection support and time off wis restricted for the dates elow. State Primary Election 9/6/2022 (last day to register 8/17/2022) Time off requests will be limited and attendance for the team will be mandatory between the dates of 8/15 to 9/9. State Election 11/8/2022 (last day to register 10/19/2022) Time off requests will be limited and attendance for the team will be mandatory between the dates of 10/17 to 11/10.

Required Skills : 5+ years Database Administration experience; should have experience in test, development and production instances. In-depth knowledge of SQL server versions 2012/2016 and above, with SSIS/SSRS Experience with databases migrations of SQL Servers from older to newer versions Experience in configuring and maintaining SQL Always ON is required. Ability to execute performance monitoring and necessary adjustments. Excellent knowledge of backup and recovery scenarios and backup tools.