Database Administrator

Vensure Employer Solutions; Thiruvananthapuram; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Vensure Employer Solutions in Kerala seeks a seasoned Database Administrator to own SQL Server environments, ensuring peak performance, robust security, and high availability for critical client applications.

You will design backup and disaster recovery plans, automate tasks with PowerShell, tune queries, and mentor junior DBAs while collaborating with developers, DevOps, and system administrators to keep the platform reliable.

Qualifications

• 5+ years of experience as a database administrator.
• Deep knowledge of SQL Server, T-SQL, and performance optimization.
• Experience with high availability and disaster recovery technologies (e.g., clustering, replication).
• Proficiency in security, encryption, access control, and auditing.
• Hands-on PowerShell scripting and automation of database tasks.
• Ability to collaborate with developers, DevOps, and system administrators.
• Excellent communication and interpersonal skills.

Responsibilities

• Ensure high performance and uptime of all database systems.
• Install, configure, and maintain SQL Server databases to support business applications.
• Optimize performance through query tuning, indexing, and configuration adjustments.
• Design and implement backup, recovery, and disaster recovery strategies.
• Manage database security: encryption, access control, and auditing.
• Write and optimize T-SQL queries, stored procedures, and triggers.
• Oversee migration of databases across servers or to Azure SQL Database.
• Set up and manage database monitoring tools for proactive performance tracking and security.
• Collaborate with cross-functional teams to align changes with architecture and business needs.
• Automate database tasks using PowerShell.
• Review and update database-related documentation and incident response plans.
• Provide technical guidance and mentorship to junior DBAs and IT staff.
• Respond to database issues during off-hours as required.

Skills

SQL Server

T-SQL

HA/DR

PowerShell

Security & Audit

Cross-functional collaboration

Communication skills

Job description

Summary:

The Database Administrator is responsible for supporting and maintaining all aspects of database systems within the ClientSpace platform. 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. This role reports to the Database Administration Manager.

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.

Physical/Travel Requirements:

• Ability to sit or stand for extended periods of time in an office environment.
• Availability to work nights and weekends as required for system maintenance or issue resolution.
• Ability to work under pressure during high-stakes recovery or optimization situations.