21 Nov
|
Tetrahed
|
Hyderabad
21 Nov
Tetrahed
Hyderabad
Job Description - Database Administrator (MS SQL)Role:Database Administrator - MS SQLJob Summary:We are looking for an experienced MS SQL Database Administrator responsible for managing, maintaining, securing, and optimizing SQL Server databases across on-premises and hybrid environments. The role involves ensuring database availability, performance, security, backup and recovery, and supporting database-related deployments in collaboration with application and DevOps teams.Key Responsibilities:- Administer, maintain, and optimize MS SQL Server instances across on-premises and hybrid environments, ensuring high availability and database reliability.- Design, implement, and manage database backup, recovery, replication, and disaster recovery strategies in line with business requirements and SLAs.- Monitor database performance using Dynamic Management Views (DMVs), SQL Profiler, and custom scripts to identify and resolve performance bottlenecks.- Perform query optimization, indexing, and performance tuning to improve database efficiency and reduce latency.- Manage database security, including user access, permissions, roles, and auditing, in accordance with organizational security policies.- Automate routine database administration tasks, including scheduled jobs, alerts, and maintenance activities using T-SQL, PowerShell,
and SQL Server Agent.- Collaborate with DevOps and application teams to support database deployments, schema changes, database migrations, and CI/CD processes.- Monitor database health and proactively troubleshoot database-related issues to maintain optimal performance and availability.Mandatory Skills & Qualifications:- Strong hands-on experience with Microsoft SQL Server database administration.- Proficiency in T-SQL, including writing and optimizing SQL queries and scripts.- Experience with SQL Server Agent for job scheduling and automation.- Hands-on knowledge of database backup, restoration, and recovery processes.- Strong understanding of database performance monitoring and tuning.- Experience with PowerShell scripting for database administration and automation.- Practical experience using DMVs and SQL Profiler for troubleshooting and performance analysis.- Valuable understanding of database security, access management, and maintenance activities.Good to Have:- Experience with Always On Availability Groups.- Exposure to Azure SQL Database and cloud-based database environments.- Understanding of CI/CD practices for database deployments.- Experience working in hybrid database environments.Screening Questions:1. 2. 3. 4. (ref:hirist.tech)
📌 Database Administrator - MS SQL (Hyderabad)
🏢 Tetrahed
📍 Hyderabad