Job Details

ID #53733640
Estado Texas
Ciudad Plano
Full-time
Salario USD TBD TBD
Fuente Cognizant
Showed 2025-03-28
Fecha 2025-03-28
Fecha tope 2025-05-27
Categoría Etcétera
Crear un currículum vítae
Aplica ya

SQL DBA Lead

Texas, Plano, 75023 Plano USA
Aplica ya

This position is open to fully remote in the United States. A qualified applicant must be local to this area or be open to relocation.Please note, this role is not able to offer visa transfer or sponsorship now or in the futurePractice - CIS - Cloud, Infrastructure, and Security ServicesAbout Cloud Infrastructure & Security Services: Cognizant’s Cloud, Infrastructure, and Security Services Practice (CIS), is all about embracing digital transformation by driving core modernization holistically across layers. We help customers transform infrastructure and workplace to meet the rapidly evolving needs of the digital era. Our holistic approach delivers key results for our customers by achieving cloud driven modernization and workplace and operational transformation to run the business in a secure environment.Job SummaryWe are seeking an experienced SQL DBA Lead with 7 to 11 years of experience in MySQL DB Administration and MS SQL Server. The ideal candidate will work in a hybrid model primarily during the day shift. This role does not require travel. The Infra. Architect will be responsible for designing implementing and maintaining our database infrastructure to ensure optimal performance and reliability.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.

Qualifications

Must have strong experience in MySQL DB Administration and MS SQL Server.

Should have a solid understanding of database design and development principles.

Must possess excellent troubleshooting and problem-solving skills.

Should have experience with database performance tuning and optimization.

Must be knowledgeable in database security best practices.

Should have the ability to work collaboratively with cross-functional teams.

Technology Stack:

SQL DBA - Admin core task - must for all level

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

Database Backup & Restore - must for all level

SQL Job creation and fixing any failure - Must for all level

Database encryption - for L2/L3 level

SQL Server Patching - for L2/L3 level

SQL Server upgrade / Migration - for L2/L3 level

Understanding SQL Server performance - L2/L3 level

checking Blocking issues

checking Deadlock issues

Query tunning

Index maintenance

Working knowledge on High Availability - L2/L3 level

Log shipping

Mirroring

Always-on AG

Working knowledge 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

Salary and Other Compensation:Applications will be accepted until 04/26/2025The annual salary for this position is between $73,350- $133,500 depending on experience and other qualifications of the successful candidate.This position is also eligible for Cognizant’s discretionary annual incentive program, 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.#LI-IR1 #CB #Ind123

Aplica ya Suscribir Reportar trabajo