SQL Ops DBA Lead (Remote)

Cognizant's Cloud, Infrastructure, and Security Services Practice (CIS) is all about accepting digital transformation by driving core modernization holistically across layers. We help customers transform infrastructure and workplace to meet the constantly evolving needs of the digital era. Our broad approach delivers key results for our customers by achieving cloud driven modernization and workplace and operational transformation to own the business in a secure environment.

* You must be legally authorized to work in United States without the need of employer sponsorship, now or at any time in the future *

Job Title: SQL Ops DBA Lead (Remote)

• Provides leadership for the DBA team, identifying work priorities and ensuring effective communication within the team and with external partners/collaborators.
• Creates a balanced interpersonal and team-oriented environment.
• 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 handling 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 standard methodologies are followed for the delivery, implementation, and maintenance of client DBA by team members and contractors.
• Apply critical thinking and project management in your day-to-day tasks and when planning resources and workload, using various tools and techniques. d to DBA infrastructure.
• Work with the business areas to establish and consistently assess their perception of service level delivery, finding solutions for any gaps.
• 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 optimally 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.
• Support team members in their professional growth by providing mentorship and feedback, acknowledging achievements, and addressing areas for improvement when necessary.
• Ensure team alignment with standard DBA practices/policies.

Required Qualifications:

• 10+ years of related experience, including management and operation of enterprise DBA services and DBA infrastructure.
• SQL DBA - Admin core task - must for all level

1. 1. Checking health of SQL server a. checking sessions details
   2. Checking error logs
   3. Build logins & users and fix any issues
   4. Knowledge on databases, Objects and DMV.
   5. Supervising & fixing alerts

• Database Backup & Restore - must for all level
• SQL Job creation and fixing any failure - Must for all level.
• For L2/L3 level: Database encryption, SQL Server Patching, SQL Server upgrade / Migration, Understanding SQL Server performance (Checking Blocking issues, Checking Deadlock issues, Query tunning, Index maintenance).
• Strong knowledge on High Availability - L2/L3 level

1. 1. Log shipping
   2. Mirroring
   3. Always-on AG

• Solid understanding on SQL Server Replication - L2/L3 level.
• Linked server issues fixing SPN & Delegation - L2/L3 Level.
• MS Azure (Iaas) working knowledge is a plus.
• Understanding & writing T-SQL, PowerShell scripts, Azure SQL.

Salary and Other Compensation:

Applications will be accepted until December 01, 2024.

The annual salary for this position is between $ 99,000.00 - $ 116,000.00 depending on experience and other qualifications of the successful candidate.

This position is also eligible for Cognizant's discretionary annual incentive program and stock awards, based on performance and subject to the terms of Cognizant's applicable plans.

Benefits: Cognizant offers the following benefits for this position, subject to applicable eligibility requirements:

• Medical/Dental/Vision/Life Insurance
• Paid holidays plus Paid Time Off
• 401(k) plan and contributions
• Long-term/Short-term Disability
• Paid Parental Leave
• Employee Stock Purchase Plan

Disclaimer: The salary, other compensation, and benefits information is accurate as of the date of this posting. Cognizant reserves the right to modify this information at any time, subject to applicable law.

Cognizant is an Equal Opportunity Employer M/F/D/V. Cognizant is committed to ensuring that all current and prospective associates are afforded equal opportunities and treatment and a work environment free of harassment.

Cognizant is recognized as a Military Friendly Employer and is a coalition member of the Veteran Jobs Mission. Our Cognizant Veterans Network Assists Veterans in building and growing a career at Cognizant that allows them to demonstrate the leadership, loyalty, integrity, and commitment to excellence instilled in them through participation in military service.