Title: SQL DBA/SQL Server/Database administrator Mandatory skills: MSSQL DBA, MSSQL patching, MSSQL monitoring, MS SQL Server, MSSQL features,WSFC clusters, data encryption, application change management, software development, project management, domain, multi-tier web-based application development projects, Windows environments, MS SQL Server DBA, MSSQL backup, MSSQL recovery, MSSQL, MSSQL performance, MSSQL databases, MSSQL upgrades, database, database scalability, database operations, database security, database encryption, infrastructure databases, Database Management, Healthcare industry, Medicaid Management Information System, MMIS, Medicaid operations, MySQL, MongoDB, SQL Server solutions, DBA,PHI data, PII data, VMWare environment, 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.
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 client 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. The Team lead will provide MS SQL Subject Matter Expertise and assess the current strengths of the team's processes.
DAILY DUTIES/RESPONSIBILITIES: The Team Lead MSSQL DBA is responsible for working closely with application development teams, 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 the client 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. The 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 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.
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. Skills : 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 Note : Remote Work Availability: 75% VIVA USA is an equal opportunity employer and is committed to maintaining a professional working environment that is free from discrimination and unlawful harassment.
The Management, contractors, and staff of VIVA USA shall respect others without regard to race, sex, religion, age, color, creed, national or ethnic origin, physical, mental or sensory disability, marital status, sexual orientation, or status as a Vietnam-era, recently separated veteran, Active war time or campaign badge veteran, Armed forces service medal veteran, or disabled veteran. Please contact us at for any complaints, comments and suggestions. Contact Details : Account co-ordinator: Lakshmikanth S, Phone No: (847) 284-3343, Email id: firstname.lastname@example.org VIVA USA INC.
3601 Algonquin Road, Suite 425 Rolling Meadows, IL 60008 | http://www.viva-it.com.
Web Reference : AJF/425352746-202
Posted Date : Tue, 04 Oct 2022
Please note, to apply for this position you will complete an application form on another website provided by or on behalf of Viva USA Inc.. Any external website and application process is not under the control or responsibility of IT JobServe