SQL DBA Lead

SQL DBA Lead

Location: Remote

Experience: 12 years

Responsibilities

• Provides leadership for the DBA team, identifying work priorities and ensuring effective communication within the team and with external partners/stakeholders.
• Creates a healthy interpersonal and team-oriented environment.
• Should be customer service minded and develops and maintains cordial, effective partnerships with business area and other Services employee-partners.
• Ensures business area satisfaction with regular interaction and by managing expectations, understanding service level expectations and delivering solutions in a timely and cost-effective fashion.
• Supervises vendor performance and contractor resources and ensures they are performing competently and that client is receiving services aligned with contractual terms and conditions.
• Ensures that Cognizant's best practices are followed for the delivery, implementation and maintenance of client DBA by team members and contractors.
• Use critical thinking and project management discipline, tools and techniques in the day to day execution of responsibilities and in resource and workload planning.
• Ensure the timely correction of any bugs and vendor supplied patches and new releases related to DBA infrastructure.
• Develop a common understanding of service level expectations with the business areas and regularly review the business areas' measures and impressions of service level delivery; work collaboratively to develop solutions to bridge the gap.
• Ensure appropriate resources are in place to meet delivery expectations. Ensure appropriate training, knowledge-transfer takes place to meet these expectations.
• Monitor, and provide effective supervision of, contractor/consultant service delivery and service billings to ensure they are accurate and that performance continues to align with statements of work.
• Collaborate and work effectively with other IS teams/resources in delivering required solutions. Communicate unambiguously and listen effectively, ensure organizational messages are delivered in a timely way to team members, that issues and concerns are addressed and foster open communication among team members.
• Clarify performance expectations and help team members achieve success through coaching, mentoring and providing effective and timely feedback, recognizing accomplishments and providing discipline when appropriate.
• Ensure team adherence to standard DBA practices/policies.
• Should have around 10 years of related experience, including management and operation of enterprise DBA services and DBA infrastructure.

Technical Skillset Required

1. SQL DBA - Admin Core Tasks:
   • Checking health of SQL Server
   • Checking sessions details
   • Checking error logs
   • Create logins & users and fix any issues
   • Knowledge on databases, Objects and DMV
   • Monitoring & fixing alerts
2. Database Backup & Restore
3. SQL Job Creation and Fixing Failures
4. Database Encryption (L2/L3 level)
5. SQL Server Patching (L2/L3 level)
6. SQL Server Upgrade / Migration (L2/L3 level)
7. Understanding SQL Server Performance (L2/L3 level)
   • Checking Blocking issues
   • Checking Deadlock issues
   • Query tuning
   • Index maintenance
8. Working Knowledge on High Availability (L2/L3 level)
   • Log shipping
   • Mirroring
   • Always-on AG
9. Working Knowledge on SQL Server Replication (L2/L3 level)
10. Linked Server Issues Fixing SPN & Delegation (L2/L3 Level)
11. MS Azure (IaaS) - Working knowledge is a plus
12. Understanding & Writing T-SQL, PowerShell Scripts
13. Azure SQL