Database Administrator MS SQL Server DBA WSFC clusters IT development and implementation projects

Profile

SC-10373-1
Daily duties / responsibilities:
The MSSQL DBA is responsible for working closely with application development teams, Clemson server administrators and the Clemson Database Administrators to provide Microsoft SQL Server DBA support for application and infrastructure databases.
Duties include: Hands-on MSSQL monitoring and application support in ways that are consistent with MS SQL Server best practices.
Collaboration with Clemson's database administration team to maintain test, staging, production databases and the development of operations procedures for database management.
Enable and tune MSSQL features to optimize the performance of databases in the context of a VMWare environment. Generate and analyze performance data, recommend courses of action and implement best solutions to achieve optimum performance.
Coordinating with outside entities, including vendors for other systems/services, providers, professional associations, and other State agencies.
Advising development and product teams on best approaches for required data model extensions and/or changes.
Participate in a 24x7 on-call support rotation with other DBA team members.
Other duties as assigned.
Database Administrator:
Required skills:
The Senior MSSQL DBA role has four major attributes: software development leadership, project management skills, people skills, and domain knowledge in enterprise class multi-tier web-based application development projects. Candidates must display excellence in all areas. Proven MS SQL Server DBA experience in supporting enterprise applications in Windows environments.
Experience with WSFC clusters and Always On Availability Groups setup and support.
Experience and detailed knowledge of MSSQL backup and recovery.
Demonstrated success in supporting a development team implementing primarily web-based solutions using MSSQL as the database.
Understanding of IT development and implementation projects.
Understanding of database scalability and operations.
Project planning experience, including effort estimation on technical tasks and resource allocation.
Strong written and oral communications skills, including the ability to give presentations to project management. Strong proficiency in English is required.
Impeccable integrity. This project will have very high visibility and will impact significant expenditures of public funds. Candidates must be confident with their abilities to make correct decisions and the courage to speak out when necessary.
Willingness and ability to effectively engage with people and organizations on a continuous basis.
Hands-on experience with managing MSSQL performance and availability 24x7.
Experience with configuring monitoring and alerting for MSSQL databases.
Hands-on experience with MSSQL upgrades and patching.
In-depth knowledge of security best practices including instance/database security, encryption, and service specific account permissions.
In-depth knowledge of high availability and disaster recovery options. Provide strategic SQL Server solutions for critical systems.
Deployment and support of transparent data encryption.
Knowledge of application change management.
Experience managing PHI/PII data.
Oracle database knowledge and support experience is a plus, but not required.
Public sector experience is a plus.
Required education: Bachelor's degree in a technical, business, or related field. Master's degree is desirable. Equivalent work experience will be considered.
****
Local:
518-218-1700
Map
& visit our office
Corporate - Albany NY
435 New Karner Rd, Ste 202
Albany NY 12205
Chicago
63E Lake Street, Ste 201
Chicago, IL 60601
Florida
17258 SE 121st Ave
Summerfield, FL 34491
© 2018 MVP Consulting Plus. All Rights Reserved.

Company info

Sign Up Now - WashingtondcCrossing.com