Manager

Cognizant; Hyderabad, Chennai, Bengaluru; On-site; INR 900,000 - 1,500,000; Full time

Job summary

Cognizant is seeking a Senior Database Admin (SQL) to manage SQL Server 2019/2022, develop complex T-SQL, and optimize queries. You will design schemas, implement CDC/Always On features, and build robust maintenance plans and backup strategies.

You will collaborate with the Java team on ORM mappings, integrate Flyway/Liquibase in GitHub CI/CD, and implement secure data handling with encryption and masking. Proactive monitoring with DMVs and Grafana is expected.

Qualifications

• Strong experience with SQL Server 2019/2022, advanced T-SQL, and complex stored procedures.
• Expertise in query optimization and index design (clustered, non-clustered, covering, filtered).
• Design of schemas with normalization, partitioning, temporal tables, and column store indexes.
• Experience with SQL Server Agent, maintenance plans, and backup/restore strategies.
• Familiarity with CDC, replication, or Always On Availability Groups.
• Performance tuning focusing on wait stats, blocking, and deadlock resolution.

Responsibilities

• Collaborate with the Java team on ORM mapping review and optimization.
• Manage database version control using Flyway or Liquibase in GitHub CI/CD pipelines.
• Review application-layer SQL and data access patterns.
• Develop data migration scripts and ETL patterns (SSIS or custom pipelines).
• Ensure sensitive data handling via encryption, row-level security, and masking.
• Monitor health using SQL Server DMVs and integrate metrics with Grafana/Prometheus.
• Set up alerts for long-running queries, blocking chains, and disk growth.

Skills

SQL Server

T-SQL

Performance Tuning

Backup & Restore

CDC / Always On

ETL / SSIS

Tools

Flyway

Liquibase

GitHub CI/CD

SSIS

Grafana/Prometheus

Job description

JD: Database Admin L3(SQL)

Level: Senior

SQL Server Development

• SQL Server 2019 / 2022: advanced T-SQL, complex stored procedures, functions, triggers
• Query optimization: execution plans, index design (clustered, non-clustered, covering, filtered)
• Schema design: normalization, partitioning, temporal tables, column store indexes
• SQL Server Agent, maintenance plans, backup/restore strategies
• Change Data Capture (CDC), replication, or Always On Availability Groups awareness
• Performance tuning: wait stats analysis, blocking / deadlock detection and resolution

Developer Collaboration

• ORM integration support: Hibernate / JPA mapping review and optimization with Java team
• Database version control using Flyway or Liquibase within GitHub CI/CD pipeline
• Code review of application-layer SQL and data access layers
• Data migration scripting and ETL patterns (SSIS or custom pipelines)
• Sensitive data handling: column encryption, row-level security, dynamic data masking

Observability & Monitoring

• SQL Server DMVs for proactive health monitoring
• Integration of SQL Server metrics with Grafana (via Telegraf or Prometheus SQL Exporter)
• Alerting on long-running queries, blocking chains, disk growth

Nice to Have

• Azure SQL or SQL Server on Linux experience
• PowerShell DBA automation (dbatools)
• Basic knowledge of SigNoz trace correlation to database calls
• SSRS / SSAS reporting layer experience