Database Administrator II

Database Administrator II

Bangalore, Karnataka, India

Working as a member of the Database Administrator (DBA) team, the DBA will be responsible for SQL Server Installations, Configurations, High Availabilities, performance tuning, troubleshooting, security management, Migrations and Upgradations of different database platforms in on-prem and cloud systems for all applications under AXA XL.

DISCOVERyour opportunity

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

·Good in TSQL scripting and commands.

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

·Work resilently and in coordination with other application developers to investigate, analyse and resolve issues.

·Work with internal technical resources on project implementations and resolve business and technical issues.

·Developing, managing, testing and implementing database backup, recovery and maintenance plans.

·Performing database capacity management, handling database incidents and finding root cause analysis.

·Recover databases during disaster recovery testing and incidents.

·Liaising with Project Managers, Developers, Application Support, Release, and infrastructure teams to ensure database integrity, security and performance.

You will report to the GT SDC DBA Lead.

SHARE your talent

We’re looking for someone who has these abilities and skills:

Required Skills and Abilities:

• Relevant years of experience as SQL Database Administrator.
  
  

·Experience in designing, implementing and managing High Availability database solutions.

·Hands-on experience working in Azure.

·Expertise in producing technical documentation.

·Exposure in migrating existing SQL Server (on-premises) data loads to Cloud (Azure) & on-prem to on-prem.

• Expert knowledge of SQL scripting \ programming.

·Prior work experience with performance tuning, query plan analysis, and indexing.

• Knowledge of database auditing and performance monitoring solutions.