17 Nov
|
Cognizant
|
Hyderabad
17 Nov
Cognizant
Hyderabad
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, energetic 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
📌 Manager (Hyderabad)
🏢 Cognizant
📍 Hyderabad