Sql Database Administrator

Majestic People Infotech; Coimbatore District; On-site; INR 1,200,000 - 2,000,000; Full time

Job summary

Majestic People Infotech in Coimbatore, India seeks an experienced SQL Server Administrator to design, implement and maintain SQL Server environments. You will manage AlwaysOn availability groups and failover clustering, tune performance, and ensure security and data integrity.

You will work with Windows Server and AD, implement HA/DR strategies, and support backups, restores, and data migrations. Excellent communication skills are essential for collaboration with clients and internal teams.

Qualifications

• 4+ years of MS SQL Server Administration experience.
• Proficient in performance tuning using native tools.
• Experience with backups, restores and recovery models.
• Knowledge of HA and DR options for SQL Server.
• Experience with Windows Server and Active Directory.
• Extensive knowledge in database design, implementation and conversion.
• Knowledge of SSAS, SSIS and SSRS.
• Excellent written and verbal communication.

Responsibilities

• Create new MS SQL Server instances and configure them, including AlwaysOn availability groups and failover clustering.
• Facilitate brainstorming meetings with clients to review, analyze, and assess business systems and needs.
• In charge of database backup and recovery methods, database access security and integrity, physical data storage design, and data storage administration.
• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.

Skills

MS SQL Server Administration

Performance Tuning and Optimization

Backups and Recovery

HA/DR knowledge

Windows Server / Active Directory

Database design and conversion

SSAS/SSIS/SSRS

Communication skills

Tools

AlwaysOn Availability Groups

Failover Clustering

Job description

Role & responsibilities

• Create new Microsoft SQL Server instances and configure them, including AlwaysOn availability groups and failover clustering
• Facilitate brainstorming meetings with clients to review, analyze, and assess business systems and needs
• In charge of database backup and recovery methods, database access security and integrity, physical data storage design, and data storage administration
• Configure and maintain database servers and processes, including monitoring of system health and performance, to ensure high levels of performance, availability, and security.

Preferred candidate profile

• 4+ years of MS SQL Server Administration experience required
• Experience with Performance Tuning and Optimization (PTO), using native monitoring and troubleshooting tools
• Experience with backups, restores, and recovery models
• Knowledge of High Availability (HA) and Disaster Recovery (DR) options for SQL Server
• Experience working with Windows Server, including Active Directory
• Extensive knowledge in database design, implementation, and conversion
• Knowledge with SSAS, SSIS, and SSRS
• Excellent written and verbal communication