Architect- MS SQL & Azure Cloud Database Operations

Roles & Responsibilities :

Job Description

Should have 12-16 years of experience in consulting and administration of SQL Server and SQL server on Azure Cloud.

• Design and implement cloud-based and hybrid SQL Server environments using Azure SQL  for SQL Server, or equivalent.

• Work closely with application developers, cloud architects, and system administrators to design, optimize, and support database solutions.

• Support and execute database migration projects from on-premises to cloud or between cloud providers.  

• Collaborate with application architects, DevOps teams, and business stakeholders to align database solutions with organizational goals.   

• Strong understanding of Windows Server (2016/2019/2022), Active Directory, and Failover Clustering.   

• Proven track record of managing mission-critical clusters in a production environment.

• Act as the primary liaison between Windows, Hardware, Network, and Storage teams.

• Ensure smooth collaboration between different teams for incident resolution, maintenance, and Upgrades

• Drive root cause analysis (RCA) sessions and ensure permanent fixes for recurring infrastructure issues.

• Create and maintain documentation for SQL architecture, processes, configurations, and operational procedures.

• Proficiency in SQL querying ,DAX and T-SQL scripting.

• Understanding of data warehousing concepts and best practices.

• Solid understanding of security, backup, and disaster recovery strategies for BI environments.

• Manage the installation, configuration, and patching of SQL Server.

• Strong command of SQL server tools, Backup tools and Monitoring tools.

• Good Knowledge in High availability concepts (Always ON, DAG, Failover Cluster, Replication).

• Good Knowledge in SQL server Cluster, Always on configurations, and Troubleshooting.

• Advanced knowledge of database security, backup and recovery, performance tuning and monitoring.

• Must have knowledge of migration, upgradation, and SQL Server Patching.

• Hands on experience on PowerShell scripting and Automations.

• Strong analytical and problem-solving skills.

• Familiar with trending technologies and tools.

Educational qualification:

B.Tech/M.Tech/MCA

Experience :

12-16 yrs

Mandatory/requires Skills :
MS SQL Database Operation Expert, Azure Database Administrator,Cloud migration (SQL Server);Azure SQL Managed Instance, Terraform and Ansible.

Preferred Skills :
PowerShell scripting and Automations.

Qualification: B.Tech/M.Tech/MCA