Database Administrator

**Job Description**:
**Database Administrator**
Bangalore, Karnataka, India

Working as a member of 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.

**What you’ll be doing**

What will your essential responsibilities include?

Installing and configuring Microsoft SQL Server instances in a stand-alone, clustered and Always On environments along with database replication and mirroring.

Experience working in Azure SQL DB, Azure SQL DW and other Azure DB Platforms.Assisting with SQL Server Assessment/Planning/Migration/Upgrades/Automation/Performance Tuning, etc.Plan and Execute the On-Prem Database/Analysis Services/Reporting Services/Integration Services Migration to Azure SQL DB / Azure PostgreSQL / Azure MySQL / SQL Server 2016 / 2019.SQL DB Automation for DB Deployments working with PowerShell, ARM Templates, etc. using DB Versioning tools like Azure DevOps SSDT, Liquibase, etc.
- Work with internal technical resources on project implementations and to resolve business and technical issues.
- Good verbal and written communication skills with the ability to articulate technical issues in simple terms.
Developing, managing, testing and implementing database back-up, recovery and maintenance plans.Performing database capacity management, Handling database incidents and root cause analysis.Recovering databases during Disaster Recovery testing and incidents.
- Liaising with Project Managers, Developers, Application Support, Release, infrastructure teams to ensure database integrity, security and performance.

You will report to GT SDC Operations Lead.

**What you’ll bring**

We’re looking for someone who has these abilities and skills:
**Required Skills and Abilities**:
Relevant years of experience managing Relational Database Management Systems (DBMS) - SQL Server.

Relevant years of experience designing, implementing and managing High Availability database solutions.

Hands-On experience working in Azure Platform: SQL DB, ADLS, Azure Synapse, Azure Databricks, Azure Data Factory, CosmosDB.Knowledge of CI/CD Pipelines: Harness.Exposure to migrating existing SQL Server (on-premis) data loads to Cloud (Azure).

Excellent working knowledge of SQL scripting / programming.

Effective working knowledge of IT Operations and support organisations would be an advantage.Ability to work self-directedly with less supervision is required.Knowledge of third party database auditing and performance monitoring solutions.

Relevant years of Erwin or similar DM tools is a plus.

Relevant years of producing technical documentation.Prior work experience with performance tuning, query plan analysis, and indexing.
- Experience doing backups & restores using SQL Litespeed/CommVault is a plus.

**Desired Skills and Abilities**:
Comprehensive knowledge of DBMS.

Able to organise self and others including effective scheduling, prioritisation and time management skills, completing tasks to tight deadlines. Demonstrates a ‘can do’ attitude.Proven track record of knowing what it takes to provide a consistently first class customer service internally and/or externally.Ability to build effective working relationships (Internally/Externally), establishing credibility amongst a wide and demanding client group.
- Comfortable taking ownership for own work, identifying the need for action (using initiative) whilst working effectively within a team.

**What we offer**

AXA XL, the P&C and specialty risk division of AXA, is known for solving complex risks. For mid-sized companies, multinationals and even some inspirational individuals we don’t just provide re/insurance, we reinvent it.

How? By combining a comprehensive and efficient capital platform, data-driven insights, leading technology, and the best talent in an agile and inclusive workspace, empowered to deliver top client service across all our lines of business property, casualty, professional, financial lines and specialty.

With an innovative and flexible approach to risk solutions, we partner with those who move the world forward.

**Who we are**

AXA XL is committed to equal employment opportunity and will consider applicants regardless of gender, sexual orientation, age, ethnicity and origins, marital status, religion, disability, or any other protected characteristic.

At AXA XL, we know that an inclusive culture and a diverse workforce enable business growth and are critical to our success. That’s why we have made a strategic commitment to attract, develop, advance and retain the most diverse workforce possible, and create an inclusive culture where everyone can bring their full selves to work and can reach their highest potential. _It’s about helping one another — and our business — to move forward and succeed._
- Five Business Resource Groups focused on gender, LGBTQ+, ethnicity and origins, disability and inclusion with