Database Administrator

Database Administrator

Bangalore, Karnataka, India

Working as a member of the Database Administrator (DBA) team, the DBA will be responsible for the availability, performance tuning, troubleshooting, security, migration, and upgrade of different database platforms/systems across AXA XL.

DISCOVER your opportunityWhat 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.

·Work self-directly and in coordination with other application, developers to investigate, analyze 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.

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

This position reports to Application Manager - GT Application Solutions – Corporate.

SHARE your talentWe’re looking for someone who has these abilities and skills:

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.

• Knowledge of database auditing and performance monitoring solutions.
  
  

·Understanding of Databricks, Azure Synapse, ADLS, CI\CD Pipelines, and SSIS ETL packages.