04 Nov
|
Value Creed
|
Hyderabad
04 Nov
Value Creed
Hyderabad
We are looking for a SQL Server Database Administrator with 3–6 years of experience in database administration and hands-on knowledge of Microsoft Azure cloud infrastructure. The role involves managing, maintaining, securing, and optimizing SQL Server environments, supporting production databases, and assisting with Azure infrastructure operations.
Key Responsibilities
• Install, configure, maintain, patch, and upgrade SQL Server instances (2016, 2019, and 2022).
• Manage database backups, restores, recovery procedures, integrity checks, SQL Server Agent jobs, and routine maintenance activities.
• Monitor database performance, capacity, storage, CPU, memory, disk I/O, blocking, deadlocks, and troubleshoot production issues.
• Optimize SQL queries, stored procedures, indexes, and execution plans using Query Store, Extended Events, SQL Server Profiler, and monitoring tools.
• Configure and support SQL Server Always On Availability Groups, high availability, disaster recovery, and failover activities.
• Manage database security, including logins, users, roles, permissions, auditing, and access controls.
• Support SQL Server databases hosted on Azure Virtual Machines and assist with on-premises to Azure database migrations.
• Manage and troubleshoot Azure infrastructure, including virtual machines, managed disks, storage, virtual networks, subnets, NSGs, and VNet peering.
• Monitor Azure infrastructure using Azure Monitor, Log Analytics, alerts, and Azure Backup.
• Support access management and cloud security using Azure RBAC and Microsoft Entra ID.
• Automate routine DBA activities using PowerShell and T-SQL.
• Handle incident management, root cause analysis, change management, documentation, and production troubleshooting.
• Collaborate with application, infrastructure, development, and DevOps teams and participate in production maintenance and on-call support. Key Skills
• 3–6 years of hands-on experience in Microsoft SQL Server Database Administration.
• Robust knowledge of SQL Server 2016, 2019, and 2022 installation, configuration, maintenance, and troubleshooting.
• Expertise in database backup, recovery, performance tuning, indexing, and query optimization.
• Experience with SQL Server Always On Availability Groups, High Availability, and Disaster Recovery.
• Practical knowledge of Microsoft Azure cloud infrastructure, particularly Azure Virtual Machines and networking.
• Experience with Azure Monitor, Log Analytics, Azure Backup, Azure RBAC, and Microsoft Entra ID.
• Proficiency in T-SQL and PowerShell scripting.
• Familiarity with SQL Sentry or similar database monitoring tools.
• Knowledge of Terraform, Azure DevOps, CI/CD pipelines, and infrastructure automation is an added advantage.
• Bachelor’s degree in Computer Science, Information Technology, or a related field, or equivalent practical experience.
• Azure certifications such as AZ-104 or DP-300 are preferred.
📌 Senior Database Administrator (Hyderabad)
🏢 Value Creed
📍 Hyderabad