Match score not available

Unlock Premium Benefits Today!
🚀 Elevate your career with priority access.
Stand out to top recruiters with Jobgether Priority Access:
  • ✅ Top Match: We help you identify job offers where you're a perfect fit.
  • ✅ Exclusive Referral Service: Connect directly with recruiters as a Jobgether Certified Premium User.
  • ✅ Personalized Feedback: Receive feedback and expert guidance on applications, and have your profile manually reviewed.

Start Your Free Trial Now!

Start my free trial

MSSQL Senior DBA

unlimited holidays - fully flexible
Remote: 
Hybrid
Contract: 
Full time
Experience: 
Senior (5-10 years)
Work from: 
Chennai (IN)

Offer summary

Qualifications:

10+ years of MS SQL DBA experience, Bachelor's Degree or similar required, Strong SQL coding and tuning skills, Experience with AWS/Cloud Services.

Key responsabilities:

  • Provide operational support for database systems
  • Perform initial investigation and troubleshooting of issues
Guardian Life logo
Guardian Life Financial Services XLarge http://guardianlife.com/
5001 - 10000 Employees
HQ: New York
About Guardian Life
Who we are Guardian makes a difference in the lives of people when they need us most. With over 160 years of stability and fiscal integrity, we are a trusted resource to generations of families and business owners, inspiring well-being and helping build financial confidence. Today, we stand behind 29 million consumers, helping them prepare and plan for a bright future for themselves and their families. We help business owners care for their employees. And we help people recover and thrive in times of unexpected loss. As a modern mutual insurance company, we believe in driving value beyond dividends. We invest in our colleagues and are building a progressive, innovative and inclusive culture. We uplift individuals and communities through thoughtful social and environmental programs. What we stand for In 1860, a community of immigrants joined together to insure and protect their businesses and families. They were guided by powerful ideals that we’ve continued to stand behind and evolved throughout the years: we do the right thing, we believe people count, we courageously shape the future together, and we go above and beyond for the people we serve. Guardian employees embrace and live by these values every day. They remind us to put people at the heart of all we do so that we can help protect what matters most to you. Want to help bring these values to life? Join us for a rewarding career and the opportunity to shape the future. Disclosures: Financial information concerning Guardian as of December 31, 2022, on a statutory basis: Admitted assets = $76.0 billion; liabilities = $67.2 billion (including $55.0 billion of reserves); and surplus = $8.8 billion. Dividends are not guaranteed. They are declared annually by Guardian’s Board of Directors. Guardian® is a registered trademark of The Guardian Life Insurance Company of America. © Copyright 2023 The Guardian Life Insurance Company of America 2023-156184 Exp. 5/25
See more Guardian Life offers

Job description

Job Description:
Position Summary



Do you have the desire to be part of a growing and innovative team? Is a culture where “People Count” and “We do the Right Thing” important to you? If so, Guardian Life Insurance Company is actively seeking a passionate, driven Senior, Database Engineer to provide operational support for Guardian Database Systems, design and build database systems using automation in both data center and cloud platforms, including identifying build defects and create self-healing routines.



You are



Seeking to work in a world class database technologist team where our mission is to “Design, Build, Deliver, and Maintain database systems that are issue-free, always available, highly secure, and peak performing”. Able to assess issues quickly performing various database techniques to restore performance and stability. A fast-paced learner who is eager to learn more about enterprise database technologies who has many of the desired technology competencies
Qualifications:

You have  

 

In-depth knowledge and troubleshooting skills in the following: 

 

Must have skills: 

  • 10+ years of MS SQL Server DBA experience 

  • Thorough knowledge of implementing and maintaining security controls in a highly regulated industry with MS SQL databases 

  • MS SQL Server replication, always on, and mirroring experience 

  • SQL coding and tuning experience 

  • Power Shell scripting and automation experience 

  • SQL Server Management Studio experience 

  • Working knowledge of SSIS and SSRS 

  • AWS/Cloud Services experience: EC2, RDS, and Aurora Cloud deployments experience: Jenkins, Bitbucket, Terraform 

  • Hands-on, technically adept DBA, capable of performing required DB tasks  

  • Strong troubleshooting/performance tuning skills 

  • Ability to assess and improve SQL performance 

  • Understanding of MS SQL Server underlying storage engine 

  • Ability to Handle common database procedures, such as upgrade, backup, recovery, migration, etc. 

  • Profile server resource usage, optimize and tweak as necessary 

  • Expert level MS SQL Server RDBMS installation/configuration, patching, troubleshooting, performance tracking/tuning, back-up/recovery, remote monitoring skills with hands-on experience in large and very dynamic environments 

  • Strong commitment to following SDLC/Change-Management principles 

  • Self-starter and be able to perform work with minimal supervision  

  • Knowledge of data quality, data management, and data testing strategies and practices 

  • Strong communication skills, both oral and written 

  • Strong experience working with ticketing tools such as ServiceNow, Zenoss, Foglight, or other monitoring tools, Cloud monitoring tools (CloudWatch, CloudTrail), AppDynamics (or similar APM tool) 

  • Strong problem-solving and troubleshooting skills 

  • Keen analytical and structured approach to problem solving 

  • Ability to accommodate flexible work schedules 

 

Desired skills: 

  • Ability to diagnose problems and triage/resolve issues across various tiers (application, network, database, server, or storage tiers) 

  • Ability to implement automation to reduce manual administrative tasks through use of jobs, scripts, or other techniques 

  • Experience in DB2 UDB, Oracle, Postgres, MySQL, and/or Cassandra is plus  

  • Experience with configuration management tools: SCCM; Puppet; or Ansible. 

  • Development or enhancement of training and upskilling programs 

  • Bachelor’s Degree or similar required 

 

You will 

 

  • Be part of an on-call rotation providing 24x7x365 incident and outage response, including non-business hours support  

  • Perform initial investigation and/or troubleshooting of database and database system issues to resolve issue & determine root cause 

  • Process all support requests within SLA by following procedural requirements 

  • Escalate to vendors, where necessary, to ensure timely resolution 

  • Thoroughly document steps taken to resolve incidents and fulfill catalog requests within ServiceNow tickets 

  • Develop, document, and update standard operating procedures and knowledgebase articles 

  • Identify, address, and resolve repeating alert trends to improve stability and performance 

  • Suggest defects and product/infrastructure enhancements to improve stability and automation 

  • Participation in periodic skills enhancement sessions and training courses 

  • Be a project lead, as well as a project participant for various activities: cloud migration, lifecycle management, application modernization, capacity planning, financial optimization, performance, and stability optimization, build and design state configuration automation, etc

Location:

This position can be based in any of the following locations:

Chennai, Gurgaon

Current Guardian Colleagues: Please apply through the internal Jobs Hub in Workday

Required profile

Experience

Level of experience: Senior (5-10 years)
Industry :
Financial Services
Spoken language(s):
English
Check out the description to know which languages are mandatory.

Hard Skills

Windows PowerShellMicrosoft SQL ServersDatabase ProgrammingAmazon Web ServicesPerformance TuningCloud ServicesSQL Backup And RestoreDatabase AdministrationChange ManagementSQL Server Management StudioSsrs 2012Database SecurityApache CassandraPostgreSQLIBM DB2MySQLPuppet (Configuration Management Tool)Oracle RightNowAnsible

Other Skills

  • Analytical Thinking
  • Communication
  • Problem Solving
Are you interested?

Related jobs

See more jobs
Sign in or sign up with Google or LinkedIn