SQL Server DBA

Cognizant is seeking a SQL Server DBA for a full-time, hybrid opportunity in Des Moines, IA. The candidate must work out of the client’s office 3 days a week and have valid US work authorization. Visa sponsorship is not available.

Responsibilities

• 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.
• 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.
• 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.
• 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.
• 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.
• 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.
• 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

• Over 7 years of experience with Microsoft SQL Server administration.
• 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.

Preferred Qualifications

• Exposure to cloud and modern platforms, including:
  • Azure SQL Database
  • Azure Managed Instance
  • AWS RDS SQL Server
  • Cloud migration tools and methodologies