MSSQL:

Administer and maintain MS SQL Server databases, including installation, configuration, backup, recovery, and troubleshooting.

 Perform regular database maintenance tasks such as index maintenance, database optimization, and query tuning to ensure optimal performance.

 Monitor MS SQL Server performance and resource utilization, identifying and resolving performance bottlenecks.

 Implement and maintain database security measures, including user access controls, encryption, and data masking.

 Plan and execute MS SQL Server upgrades, patches, and migrations, minimizing downtime and disruptions to business operations.

 Collaborate with application developers to design and implement database solutions that meet business requirements.

 Provide technical support and troubleshooting assistance to users and developers, resolving database-related issues in a timely manner.

Technical expertise (MS SQL):

Experience with SQL Server features such as AlwaysOn Availability Groups, Database Mirroring, and Log Shipping.

Proficiency in SQL Server Performance Tuning and Query Optimization techniques.

Familiarity with SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).

Knowledge of database migration tools and techniques for seamless data movement between environments.

Experience with database security auditing and compliance requirements, including GDPR, HIPAA.

Understanding of database backup and recovery strategies, including full, differential, and transaction log backups.