Job
Description
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. 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. Learn more at axaxl.com 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 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 Learn more at axaxl.com/about-us/inclusion-and-diversity. AXA XL is an Equal Opportunity Employer. Want to know more? At AXA XL, Sustainability is integral to our business strategy. In an ever-changing world, AXA XL protects what matters most for our clients and communities. We know that sustainability is at the root of a more resilient future. Our 2023-26 Sustainability strategy, called “Roots of resilience”, focuses on protecting natural ecosystems, addressing climate change, and embedding sustainable practices across our operations. Our Pillars 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. For more information, please see axaxl.com/sustainability. Show more Show less
