Hybrid SQL Server DBA with WSFC, backup/recovery, upgrades, patching, HA, security, DR, PHI/PII/healthcare, MongoDB, MMIS, Medicaid experience

Request ID: BL-10583-1 (913891007)

Hybrid SQL Server DBA with WSFC, backup/recovery, upgrades, patching, HA, security, DR, PHI/PII/healthcare, MongoDB, MMIS, Medicaid experience

Location: Clemson SC
Duration: 12 Months Hrs/Wk: 40.00
Remote Work Availability: 75%

Client is seeking a Microsoft SQL Server professional with the knowledge and experience along with comparable communication and interpersonal skills to enable success on several high-visibility projects.

REQUIRED SKILLS (RANK IN ORDER OF IMPORTANCE):

The Senior/Team Lead 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.

• Strong Leadership Skills
• Proven MS SQL Server DBA experience in supporting enterprise applications in Windows environments.
• Experience with WSFC clusters and Always On 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.

PREFERRED SKILLS (RANK IN ORDER OF IMPORTANCE):
• Hands-on experience with managing MSSQL performance and availability 24×7.
• 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.
• Healthcare industry experience and/or experience managing PHI/PII data
• MySQL knowledge and support experience is a plus, but not required.
• MongoDB knowledge and support experience is a plus, but not required.
• Vendor management experience.
• Medicaid Management Information System (MMIS) experience
• Medicaid operations experience.
• 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.

Experience
Administrative Verbal Communication Skills Yes 2 Expert Currently Using 6 + Years
Administrative Written Communication Skills Yes 2 Expert Currently Using 6 + Years
Database Platforms MS SQL Yes 1 Lead Currently Using 6 + Years
Education BA Degree- Technical, Business, or Healthcare field No 1
Miscellaneous Leadership skills Yes 1 Lead Within 6 Months 6 + Years
Program Management Project planning experience, including effort estimation on technical tasks and resource allocation Yes 3 Expert Within 6 Months 6 + Years

Job Description:
The position is new due to the high level subject matter and team lead responsibilities. This position will provide Team Lead Database Management that includes Subject Matter Expertise, delegating task to DBA team, and oversight. The team consist of 4-5 Database Administrators. The Team Lead will support for several large high-profile projects whose team brings significant experience along with an “entrepreneurial” or “startup” attitude and approach. Secondary knowledge of MySQL or MongoDB is desirable. The team is a combination of Client information technology professionals, experienced consultants and Department of Health and Human Services staff, and we are seeking individuals who are highly productive, very flexible, and can work effectively in team environment where ambiguity is common. Team members are expected to contribute with minimal supervision and be self-motivated. The projects demand individuals who are strong collaborators, who want to make a positive contribution to the State of South Carolina and can understand top-level goals and objectives and drive toward them.

The projects use modern technologies and modern strategies and require cooperative effort among distributed team members.

Candidates who enjoy working on complex, change-oriented projects with motivated team members will find this position attractive.

DAILY DUTIES / RESPONSIBILITIES:
The Team Lead MSSQL DBA is responsible for working closely with application development teams, Client server administration and the Client Database Administrators to provide Microsoft SQL Server DBA support for application and infrastructure databases.

Duties include:
• DBA Team Lead expected to quickly assess the current strengths of the team’s processes as well as opportunities for improvement.
• Oversee Team’s day-to-day operations and assign tasks
• Provide advice and help debug process while incident happens
• Hands-on MSSQL monitoring and application support in ways that are consistent with MS SQL Server best practices.
• Collaboration with Client’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 24×7 on-call support rotation with other DBA team members.
• Other duties as assigned.

RTR – SoSC IT Temp Solicitation_Attachment .docx

Leave a Reply