Database Administrator

  • Bengaluru
  • Greentree Advisory Services Pvt Ltd

What will your essential responsibilities include? Installing and configuring Microsoft SQL Server instances in stand-alone, clustered, and Always On environments along with database replication and mirroring configuration. Experience in migrating databases to Azure SQL DB, Azure SQL DW, and Azure SQL Managed Instance. Assisting with SQL Server Assessment\Planning\Migration\Upgrades\Automation\Performance Tuning, etc. Troubleshooting, planning migration strategy, and DR planning of SSAS\SSIS\SSRS. SQL DB Automation for DB Deployments working with PowerShell, ARM Templates, etc. using DB Versioning tools like Azure DevOps SSDT, Liquibase, etc. Expertise in database troubleshooting, performance tuning, query tuning of SQL\T-SQL, partitioning, and filegroup. Implementation and design database Indexes for high performance, as part of the migration\upgrade activities. Required Skills and Abilities: Experience as SQL Database Administrator. Experience designing, implementing, and managing High Availability database solutions. Experience working in Azure. Experience in producing technical documentation. Exposure to migrating existing SQL Server (on-premises) data loads to Cloud (Azure). Expert knowledge of SQL scripting \ programming. Prior work experience with performance tuning, query plan analysis, and indexing