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.

Education

Any Graduate