The Role
Maintains and optimizes Microsoft SQL Server environments, ensuring performance, uptime, security, and compliance. Designs backup, recovery, high-availability, and disaster-recovery strategies; manages migrations to platforms such as Azure SQL Database; writes T-SQL; automates maintenance and monitoring with PowerShell; documents procedures; collaborates with technical teams; mentors junior administrators; and provides off-hours incident support.
Summary Generated by Built In
The Database Administrator is responsible for supporting and maintaining all aspects of database systems. The role requires deep technical expertise in SQL Server, database performance optimization, and high availability solutions. This role will collaborate with cross-functional teams, including developers and system administrators, to ensure seamless database operations, security, and compliance. The position will also focus on disaster recovery planning and automation for efficient and secure database environments.
Job Responsibilities: • Ensure high performance and uptime of all database systems. • Install, configure, and maintain Microsoft SQL Server databases to support business applications. • Optimize database performance through query tuning, indexing, and system configuration adjustments. • Design and implement database backup, recovery, and disaster recovery strategies. • Manage database security protocols, including data encryption, authentication, and role-based access control (RBAC). • Write and optimize complex T-SQL queries, stored procedures, and triggers to improve performance. • Oversee the migration of databases across servers or platforms, such as SQL Server to Azure SQL Database. • Set up and manage database monitoring tools (e.g., SQL Server Management Studio, SQL Server Agent) for proactive performance tracking and security. • Collaborate with cross-functional teams to ensure database changes align with overall system architecture and business needs. • Automate database tasks using PowerShell, such as automated backups, maintenance scripts, and performance monitoring. • Regularly review and update database-related documentation, including operational procedures and incident response plans. • Provide technical guidance and mentorship to junior database administrators and other IT staff. • Respond to database issues during off-hours, including nights and weekends, as required.
Knowledge, Skills & Ability: • 5+ years of experience as a database administrator. • In-depth knowledge of SQL Server, T-SQL, and database performance optimization techniques. • Strong experience with high availability (HA) and disaster recovery (DR) technologies (e.g., clustering, replication). • Proficiency in database security, including encryption, access control, and auditing. • Hands-on experience with PowerShell scripting and automation of database tasks. • Ability to work cross-functionally, collaborating with developers, DevOps, and system administrators. • Excellent communication and interpersonal skills, with a customer-service-oriented mindset.
#VensureHRIndia
#LI-PROMOTED
#LI-Onsite
Skills Required
- 5+ years of experience as a database administrator
- In-depth knowledge of SQL Server, T-SQL, and database performance optimization techniques
- Strong experience with high availability and disaster recovery technologies, including clustering and replication
- Proficiency in database security, including encryption, access control, and auditing
- Hands-on experience with PowerShell scripting and database task automation
- Ability to collaborate cross-functionally with developers, DevOps, and system administrators
- Excellent communication and interpersonal skills with a customer-service-oriented mindset
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Distro is an AI-powered platform designed to enhance the efficiency and productivity of distributor sales teams. By automating manual recruiting and sales tasks, the company helps teams move faster, reduce costs, and improve hiring outcomes. Their technology focuses on optimizing counter and inside sales operations, providing tools that assist recruitment and sales processes while maintaining human oversight in final decision-making.
