Cognizant Technology Solutions logo

SQL DBA administrator

Cognizant Technology Solutions·Salary not specified

Primary stack

Microsoft SQL ServerPowerShellSQL

Nice to have's

Azure SQL DatabaseAzure Managed InstanceAWS RDS SQL Server

Job description

About the Position

SQL DBA Administrator

Location: Des Moines, IA / Hybrid / Onsite

We are seeking a skilled SQL DBA Administrator to manage and optimize SQL Server databases in a hybrid work environment.

Responsibilities

Database Administration & Operations

  • Manage and support SQL Server databases across Development, Test, UAT, and Production environments.
  • Perform database code, schema, and object migrations in compliance with established change management procedures.
  • Execute daily operational health checks, backup verification, job monitoring, database consistency checks, and capacity reviews.
  • Install, configure, upgrade, patch, and maintain SQL Server instances while minimizing business disruption.
  • Manage database storage, growth, capacity planning, and lifecycle management activities.

Performance Management & Optimization

  • Monitor database and server performance, proactively identifying and resolving CPU, memory, I/O, storage, locking, blocking, and resource contention issues.
  • Perform advanced performance tuning using:
    • SQL Profiler
    • Query Store
    • Execution Plans
    • Dynamic Management Views (DMVs)
    • Extended Events
    • Performance Monitor (PerfMon)
  • Optimize SQL queries, stored procedures, indexes, database objects, and execution plans to improve application performance and reduce response times.
  • Establish performance baselines and implement proactive monitoring strategies.

Database Architecture & Engineering

  • Design, architect, and implement scalable, secure, and highly available SQL Server environments.
  • Collaborate with Infrastructure, Server, Storage, Network, and Application teams to develop robust database platforms.
  • Review database deployments and migration requests to ensure compliance with security, performance, scalability, and infrastructure standards.
  • Participate in enterprise database modernization and cloud transformation initiatives.

High Availability & Disaster Recovery

  • Implement and manage SQL Server HA/DR solutions, including:
    • Always On Availability Groups
    • Failover Clustering
    • Log Shipping
    • Replication
    • Disaster Recovery Planning
  • Develop, maintain, and test database backup, recovery, and business continuity procedures.
  • Conduct periodic restore testing and disaster recovery exercises.

Security & Compliance

  • Manage database security through user provisioning, role management, permissions, and access controls.
  • Ensure compliance with organizational security policies, audit requirements, and regulatory standards.
  • Conduct database security reviews and remediate vulnerabilities and risks.

Migration, Upgrades & Automation

  • Lead database migrations, refreshes, cloning activities, platform upgrades, cloud migrations, and consolidation initiatives.
  • Automate routine DBA tasks using:
    • PowerShell
    • T-SQL
    • SQL Server Agent Jobs
    • Automation Frameworks
  • Develop scripts, utilities, and monitoring solutions to improve operational efficiency and reliability.

Incident & Production Support

  • Provide 24x7 support for critical production databases and applications.
  • Troubleshoot database-related incidents and service disruptions.
  • Perform Root Cause Analysis (RCA) and implement preventive measures.
  • Work closely with application, infrastructure, and vendor teams to ensure SLA compliance and service availability.

Requirements

Technical Skills

  • Strong administration experience with:
    • Microsoft SQL Server 2016/2019/2022
    • SQL Server Management Studio (SSMS)
  • Expertise in:
    • T-SQL Development
    • Performance Tuning
    • Index Optimization
    • Query Optimization
    • Database Design
  • Hands-on experience with:
    • Always On Availability Groups
    • Clustering
    • Replication
    • Log Shipping
  • Experience with backup and recovery strategies and tools.
  • Strong understanding of database security, compliance, and auditing.
  • Experience with PowerShell scripting and automation.
  • Knowledge of Windows Server administration and infrastructure concepts.

Cloud & Modern Platform Exposure (Preferred)

  • Azure SQL Database
  • Azure Managed Instance
  • AWS RDS SQL Server
  • Cloud migration tools and methodologies

Soft Skills

  • Strong analytical and troubleshooting abilities.
  • Excellent communication and stakeholder management skills.
  • Ability to manage multiple priorities in a fast-paced production environment.
  • Strong documentation and process discipline.

We Offer

  • Opportunity to work in a hybrid environment.
  • Be part of a leading technology company.
  • Competitive salary and benefits package.
  • Professional growth and development opportunities.

About the Company

Sobre a Cognizant

Cognizant (NASDAQ: CTSH) é uma construtora de IA e fornecedora de serviços de tecnologia, criando a ponte entre o investimento em IA e o valor para as empresas por meio do desenvolvimento de soluções de IA completas para nossos clientes. Nossa profunda experiência em setores, processos e engenharia nos permite incorporar o contexto único de cada organização em sistemas tecnológicos que potencializam a capacidade humana, geram resultados tangíveis e mantêm empresas globais à frente em um mundo em rápida transformação. Saiba mais em cognizant.ai ou @cognizant.

A Cognizant é uma empregadora que investe em equidade. Sua candidatura não será pautada em raça, cor, gênero, sexualidade, credo, origem, deficiência, gravidez ou qualquer outra característica protegida pelas leis brasileiras.

Informações adicionais de emprego

Os candidatos podem ser obrigados a comparecer a entrevistas presenciais ou por videoconferência. Além disso, os candidatos podem ser obrigados a apresentar seu documento de identificação emitido pelo estado ou governo atual durante cada entrevista.

Embora nosso sistema permita a candidatura em todos os idiomas, o(s) idioma(s) e o(s) nível(is) de proficiência exigidos para o trabalho variam. No entanto, é necessário um nível básico de inglês para fins de comunicação em toda a empresa.

A Cognizant é uma empregadora que investe em equidade. Sua candidatura não será pautada em raça, cor, gênero, sexualidade, credo, origem, deficiência, gravidez ou qualquer outra característica protegida pelas leis brasileiras.

Se você tem uma deficiência que requer adaptações razoáveis para procurar uma vaga de emprego ou enviar uma candidatura, envie um e-mail para [email protected] com sua solicitação e informações de contato.

We care about your privacy

Thank you, your preferences have been updated.

By clicking "Accept All", you agree to the storing of cookies on your device to give you the most optimal experience using our website. We may also use cookies to enhance performance, analyse site usage and to personalise your experience.

Gerenciar preferências

© Cognizant Technology Solutions. This job description was sourced from the employer's public career page. TheJob is not the employer — we index the posting and route candidates to the source. All content rights and hiring decisions belong to the employer.

Cognizant (Nasdaq-100: CTSH) is one of the world’s leading professional services companies, transforming clients’ business, operating and technology models for the digital era. Our unique industry-based, consultative approach helps clients envision, build and run more innovative and efficient businesses. Headquartered in the US, Cognizant is ranked 185 on the Fortune 500 and is consistently listed among the most admired companies in the world. Learn how Cognizant helps clients lead with digital atwww.cognizant.comor follow us @Cognizant.

More at Cognizant Technology Solutions

All 1104 roles

Popular searches