Lead MSSQL DBA

We are looking for

• This position will provide Team Lead Database Management that includes Subject Matter Expertise, delegating tasks to the DBA team, and oversight.
• The team consists of 4-5 Database Administrators.
• The Team Lead will support 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 information technology professionals, experienced consultants and staff, and we are seeking individuals who are highly productive, very flexible, and can work effectively in a 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 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 MSSQL DBA is responsible for working closely with application development teams, server administration and the 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 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 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.
• 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.

• 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 communication 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.

• Experience with WSFC clusters and Always On Groups setup and support.
• 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.

• Bachelor’s degree in a technical, business, or related field.
• Master’s degree is desirable.
• Equivalent work experience will be considered.