Cognizant is seeking a SQL Server DBA for a full-time opportunity in Des Moines, IA. The candidate needs to work out of the client’s office 3 days a week. This is a Hybrid role. Qualified applicants must have valid US work authorization. Cognizant will not offer visa sponsorship now or anytime in the future.
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.
Qualifications:
Candidates must have over 7 years of experience with the technical skills below:
- 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
关于高知特 (Cognizant)
高知特(Cognizant)（纳斯达克代码：CTSH）作为一家AI Builder和相关技术服务提供商，致力于通过打造全栈AI解决方案，帮助企业将人工智能投资转化为实际价值。公司凭借深厚的行业经验、流程优化和工程技术专长，将企业独特的业务场景融入科技系统，赋能组织释放人才潜能，推动切实成果，并帮助全球企业在瞬息万变的环境中保持领先。如需了解更多详情，敬请访问 cognizant.ai 或关注@cognizant。
补充雇佣信息
薪酬信息截至本职位发布之日为准。Cognizant 保留在适用法律允许的范围内随时修改该信息的权利。
申请人可能需要通过现场面试或视频会议的方式参加面试。此外，候选人在每次面试时可能需要出示其当前所在州或政府签发的有效身份证件。
Cognizant 是一家提供平等就业机会的雇主。在招聘过程中，您的申请和候选资格不会因种族、肤色、性别、宗教、信仰、性取向、性别认同、国籍、残疾、遗传信息、怀孕、退伍军人身份或任何其他受联邦、州或地方法律保护的特征而受到影响。
