Database Administrator

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.

• 
  
  
Expertise in database troubleshooting, performance tuning, query tuning of SQL/T-SQL, partitioning, file group implementation and design database Indexes for high performance, as part of the migration/upgrade activities.

Work self-directedly and in coordination with other application developers to investigate, analyze and resolve issues.

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

• Five Business Resource Groups focused on gender, LGBTQ+, ethnicity and origins, disability and inclusion with 20 Chapters around the globe
• Robust support for Flexible Working Arrangements
• Enhanced family friendly leave benefits
• Named to the Diversity Best Practices Index
• Signatory to the UK Women in Finance Charter

• Valuing nature: How we impact nature affects how nature impacts us. Resilient ecosystems - the foundation of a sustainable planet and society – are essential to our future. We’re committed to protecting and restoring nature – from mangrove forests to the bees in our backyard – by increasing biodiversity awareness and inspiring clients and colleagues to put nature at the heart of their plans.
• Addressing climate change: The effects of a changing climate are far reaching and significant. Unpredictable weather, increasing temperatures, and rising sea levels cause both social inequalities and environmental disruption. We're building a net zero strategy, developing insurance products and services, and mobilizing to advance thought leadership and investment in societal-led solutions.
• Integrating ESG: All companies have a role to play in building a more resilient future. Incorporating ESG considerations into our internal processes and practices builds resilience from the roots of our business. We’re training our colleagues, engaging our external partners, and evolving our sustainability governance and reporting.
• AXA Hearts in Action: We have established volunteering and charitable giving programs to help colleagues support causes that matter most to them, known as AXA XL’s “Hearts in Action” programs. These include our Matching Gifts program, Volunteering Leave, and our annual volunteering day – the Global Day of Giving.