Description

You will administer and maintain MS SQL Server databases, ensuring optimal performance, security, and reliability across environments.

Responsibilities

• Administer and maintain MS SQL Server databases, including installation, configuration, backup, recovery, and troubleshooting.
• Perform regular database maintenance tasks like index maintenance, optimization, and query tuning.
• Monitor MS SQL Server performance and resource utilization, resolving bottlenecks.
• Implement and maintain database security measures, including access controls and encryption.
• Plan and execute MS SQL Server upgrades, patches, and migrations with minimal downtime.

Required Skills

• 5+ years of experience administering MS SQL Server.
• Proficiency in SQL Server Performance Tuning and Query Optimization.
• Experience with SQL Server AlwaysOn Availability Groups, Database Mirroring, and Log Shipping.
• Familiarity with SSIS, SSRS, and SSAS.
• Knowledge of database backup and recovery strategies (full, differential, transaction log).
• Experience implementing database security auditing and compliance.
• Understanding of database migration tools and techniques.

Key Skills

Education

Any Graduate