MSSQL DBA

• Should have 10-15 years of experience in consulting and administration of SQL Server BI Components and SQL server.
• Strong understanding of Windows Server (2016/2019/2022) Active Directory and Failover Clustering.

• Basic knowledge of networking and Storage concepts.
• 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 SQLBI architecture processes configurations and operational procedures.
• Strong experience with Microsoft SQL Server and BI tools (SSRS SSIS SSAS Power BI).
• Proficiency in SQL querying DAX and T-SQL scripting.
• Experience with ETL processes and tools (especially SSIS).
• Understanding of data warehousing concepts and best practices.
• Familiarity with Power BI and Power BI Report Server administration.
• Solid understanding of security backup and disaster recovery strategies for BI environments.
• Manage the installation configuration and patching of SQL Server BI tools (SSRS SSIS SSAS Power BI).
• 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.
• Proven experience in migration of SQL databases to Higher versions and to cloud (Azure GCP and AWS).
• Hands on experience on PowerShell scripting and Automations.
• Strong analytical and problem-solving skills.
• Familiar with trending technologies and tools.
• Good written and verbal communication.

Qualifications :

Qualification: B.E / Work :

No

Employment Type :

Full-time