SQL DBA Lead /Manager

Net 2 Source Inc. is an award-winning total workforce solutions company recognized by Staffing Industry Analysts for our accelerated growth of 300% in the last 3 years with over 5500+ employees globally, with over 30+ locations in the US and global operations in 32 countries. We believe in providing staffing solutions to address the current talent gap - Right Talent - Right Time - Right Place - Right Price and acting as a Career Coach to our consultants.

Role : SQL DBA Lead /Manager (Techno Functional) Remote JD: • 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 task - must for all level a.

checking health of sql server a . checking sessions details b . checking error logs c.

create logins & users and fix any issues d . knowledge on databases, Objects and DMV e Monitoring & fixing alerts 2. Database Backup & Restore - must for all level 3.

SQL Job creation and fixing any failure - Must for all level 4. Database encryption - for L2/L3 level 5. SQL Server Patching - for L2/L3 level 6.

SQL Server upgrade / Migration - for L2/L3 level 7.Understanding SQL Server performance - L2/L3 level a. checking Blocking issues a . checking Deadlock issues b.

Query tunning c. Index maintenance 8.Working knowledge on High Availability - L2/L3 level a. Log shipping a.

Mirroring b. 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 Regards Damini Rawat Account Manager 201-479-3769