09 Sep
|
Xencia Technology Solutions
|
Bengaluru
09 Sep
Xencia Technology Solutions
Bengaluru
Summary
We are seeking a skilled and proactive SQL Server Database Administrator (DBA) to join our team. The ideal candidate will be responsible for managing, maintaining, optimizing, and securing SQL Server environments across on-premises and Azure platforms. The candidate should possess solid expertise in SQL Server administration, performance tuning, query optimization, high availability, disaster recovery, and production troubleshooting while ensuring optimal database performance, reliability, and security.
Key Responsibilities
- Install, configure, upgrade, patch, and maintain Microsoft SQL Server environments.
- Manage SQL Server instances across development, testing, staging, and production environments.
- Perform database migrations, upgrades, backup and recovery activities, and capacity planning.
- Analyse and optimize slow-running queries, stored procedures, functions, and database workloads.
- Review execution plans and implement indexing, partitioning, and performance tuning strategies.
- Troubleshoot deadlocks, blocking issues, locking conflicts,
and resource contention.
- Monitor and optimize database performance including CPU, memory, TempDB, storage, and I/O utilization.
- Design, implement, and support High Availability and Disaster Recovery solutions including Always on Availability Groups, Failover Clustering, Replication, and Log Shipping.
- Manage database security, user access, permissions, auditing, and compliance requirements.
- Administer Azure SQL Database, Azure SQL Managed Instance, and SQL Server workloads running on Azure Virtual Machines.
- Collaborate with application, infrastructure, and cloud teams to resolve database-related issues and support modernization initiatives.
- Plan and execute database migration projects across on-premises, cloud, and hybrid environments.
- Perform SQL Server migrations to Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure Virtual Machines.
- Assess source databases, identify migr
📌 SQL Server Database Administrator (Bengaluru)
🏢 Xencia Technology Solutions
📍 Bengaluru