MSSQL Senior DBA
Guardian Life
**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** **s** **kills:**
+ 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 mirroringexperience
+ SQL coding and tuning experience
+ Power Shell scripting and automation experience
+ SQL Server Management Studio experience
+ Working knowledge of SSIS and SSRS
+ AWS/Cloud Servicesexperience: EC2, RDS, and AuroraCloud 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** **sk** **ills:**
+ 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;orAnsible.
+ Development or enhancement of training and upskillingprograms
+ 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 ofdatabase and database system issues to resolve issue & determineroot cause
+ Process all support requests within SLA by followingprocedural requirements
+ Escalate to vendors, where necessary,to ensure timelyresolution
+ Thoroughly document steps taken to resolve incidents and fulfill catalog requestswithin ServiceNow tickets
+ Develop, document, and update standard operatingprocedures and knowledgebase articles
+ Identify, address, and resolve repeating alert trends to improve stability and performance
+ Suggest defects and product/infrastructureenhancements to improve stability and automation
+ Participation in periodic skills enhancement sessions andtraining 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**
Every day, Guardian helps our 29 million customers realize their dreams through a range of insurance and financial products and services. Our Purpose, to inspire well-being, guides our dedication to the colleagues, consumers, and communities we serve. We know that people count, and we go above and beyond to prepare them for the life they want to live, focusing on their overall well-being — mind, body, and wallet. As one of the largest mutual insurance companies, we put our customers first. Behind every bright future is a GuardianTM. Learn more about Guardian at guardianlife.com .
Confirm your E-mail: Send Email
All Jobs from Guardian Life