Architect

Roles & Responsibilities :

• 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.