Sr. Microsoft SQL Server (DBA)

Total-TECH Co

The Job Description

1. Database Design implement and Maintenance: DB Design implementation and maintain SQL Server databases to support business applications.
2. Plan and execute database installations, upgrades, and patches for both on-premises and cloud environments.
3. SQL Server Clustering: Implement and manage SQL Server clustering for high availability and fault tolerance.
4. Monitor and troubleshoot SQL Server clusters to ensure consistent performance and reliability.
5. Perform failover testing and ensure cluster configuration adheres to best practices.
6. On-Premises and Cloud SQL Server Management: Manage and maintain on-premises SQL Server databases, ensuring optimal performance and availability.
7. Administer cloud-based SQL Server solutions such as Azure SQL Database, Azure SQL Managed Instance, or Amazon RDS for SQL Server.
8. Plan and execute database migrations between on-premises and cloud environments.
9. Performance Tuning and Optimization: Monitor database and cluster performance in both on-premises and cloud setups and troubleshoot issues.
10. Optimize SQL queries, indexes, and database structures for efficiency and speed.
11. Backup and Recovery: Develop and implement robust backup and recovery strategies for on-premises and cloud databases.
12. Perform regular database backups and recovery testing, ensuring high availability across environments.
13. Security Management :Ensure security compliance for on-premises and cloud databases by implementing access controls, encryption, and monitoring tools.
14. Resolve security vulnerabilities promptly and conduct regular audits.
15. Proactively monitor database systems across environments to ensure high availability and optimal performance.
16. Provide support for critical database environments and alerts, as needed.
17. Work closely with development and operations teams to support database requirements.
18. Document database architectures, configurations, and operational procedures for on-premises and cloud environments.
19. Automate routine DBA tasks, including provisioning, monitoring, and maintenance for both on-premises and cloud databases.
20. Identify and implement process improvements to enhance database performance and reliability.
    Requirements:
    

• Proven experience as a Microsoft SQL Server DBA managing on-premises and cloud-based databases.
• Proficiency with SQL Server 2019/2022 and later versions.
• Strong understanding of T-SQL, query optimization, and database performance tuning.
• Expertise in SQL Server clustering and high availability (HA) solutions, including Always On Availability Groups.
• Experience with Azure SQL Database, Azure SQL Managed Instance, or other cloud database services.
• Knowledge of backup, recovery, and disaster recovery planning for hybrid environments.
• Familiarity with cloud tools such as Azure Monitor, Azure Resource Manager, and PowerShell scripting.

Preferred Qualifications :

• Certifications such as Microsoft Certified: Azure Database Administrator Associate or Microsoft Certified Solutions Expert (MCSE) in Data Management and Analytics.
• Experience with multi-cloud database management (e.g., AWS RDS, Google Cloud SQL).
• Knowledge of containerized databases and orchestration tools (e.g., Docker, Kubernetes).
• Familiarity with DevOps practices and CI/CD pipelines for database management.
  

Tagged as: azure , DB , DBA , powershell , RDS , SQL