Senior Engineer, Database Administration - MySQL

Senior Engineer, Database Administration - MySQL

To be considered for an interview, please make sure your application is full in line with the job specs as found below.

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 creating 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-on, 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.

You will

• Be part of an on-call rotation providing 24x7x365 incident and outage response, including non-business hours changes.
• Perform initial investigation and / or troubleshooting of database and database system issues to resolve issues & 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.
• Participate 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.

You have

In-depth knowledge and troubleshooting skills in the following :

Must have skills :

• Demonstrated experience in MySQL Database Administration.
• MySQL replication experience.
• SQL coding and tuning experience.
• Shell scripting and automation experience.
• MySQL Enterprise Manager experience.
• 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 MySQL’s underlying storage engines, such as InnoDB and MyISAM.
• Ability to handle common database procedures, such as upgrade, backup, recovery, migration, etc.
• Profile server resource usage, optimize and tweak as necessary.
• Expert level MySQL RDBMS installation / configuration, patching, troubleshooting, performance tracking / tuning, backup / 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 able to perform work with minimal supervisory direction.
• 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 or any other monitoring tool, 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, cron, or other techniques.
• Experience in DB2 UDB, Oracle, Postgres, Microsoft SQL Server, MongoDB, and / or Cassandra is a plus.
• Experience with configuration management tools : SCCM; Puppet; or Ansible.
• Development or enhancement of training and upskilling programs.
• Bachelor’s Degree or similar required.

Location

• Holmdel, NJ or Bethlehem, PA.
• The Database Service is scheduled to work Monday through Friday 8 : 00 AM ET till 5 : 00 PM ET.
• 3-days remote and 2-days in the office.
• We operate on a 24x7x365 using an on-call rotation.
• Our India-based staff starts at 2 : 30 AM ET and US-based staff covers until 5 : 00 PM ET.
• On-call is from 5 : 00 PM ET until 2 : 30 AM ET Monday through Thursday and Friday 5 : 00 PM ET until Sunday 2 : 30 AM ET.

Salary Range

$114,080.00 - $187,415.00. The salary range reflected above is a good faith estimate of base pay for the primary location of the position.

The salary for this position ultimately will be determined based on the education, experience, knowledge, and abilities of the successful candidate.

In addition to salary, this role may also be eligible for annual, sales, or other incentive compensation.

Our Promise

At Guardian, you’ll have the support and flexibility to achieve your professional and personal goals. Through skill-building, leadership development and philanthropic opportunities, we provide opportunities to build communities and grow your career, surrounded by diverse colleagues with high ethical standards.

Equal Employment Opportunity

Guardian is an equal opportunity employer. All qualified applicants will be considered for employment without regard to age, race, color, creed, religion, sex, affectional or sexual orientation, national origin, ancestry, marital status, disability, military or veteran status, or any other classification protected by applicable law.

Accommodations

Guardian is committed to providing access, equal opportunity and reasonable accommodation for individuals with disabilities in employment, its services, programs, and activities.

Guardian also provides reasonable accommodations to qualified job applicants (and employees) to accommodate the individual's known limitations related to pregnancy, childbirth, or related medical conditions, unless doing so would create an undue hardship.

If reasonable accommodation is needed to participate in the job application or interview process, to perform essential job functions, and / or to receive other benefits and privileges of employment, please contact applicant [email protected].

J-18808-Ljbffr