Job Information
Guardian Life Senior PostgreSQL DBA in Bethlehem, Pennsylvania
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-on, highly secure, and peak performing”. Able to assess issues quickly performing various database technics 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 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.
You have
In-depth knowledge and troubleshooting skills in the following:
Must have skills:
10+ years of PostgreSQL DBA experience
Thorough knowledge of implementing and maintaining security controls in a highly regulated industry with PostgreSQL databases
PostgreSQL replication experience
SQL coding and tuning experience
Shell scripting and automation experience
PostgreSQL PGAdmin client connectivity tool 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 experience
Strong troubleshooting/performance tuning skills
Ability to assess and improve SQL performance
Understanding of PostgreSQL’s underlying storage engines
Ability to Handle common database procedures, such as upgrade, backup, recovery, migration, etc.
Profile server resource usage, optimize and tweak as necessary
Expert level PostgreSQL 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 supervisory direction
Knowledge of data quality, data management, and data testing strategies and practices
Strong communication skills, both oral and written
Solid 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, MySQL, Microsoft SQL Server, MongoDB, 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
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. Today we are working 3-days remote and 2-days in the office. We operate on a 24x7x365 using an on-call rotation which the candidate will be a part of. Our India-based staff starts at 2:30 AM ET and US-based staff covers until 5:00 PM ET. On-call is 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.
Inspire Well-Being
As part of Guardian’s Purpose – to inspire well-being – we are committed to offering contemporary, supportive, flexible, and inclusive benefits and resources to our colleagues.
Health Care
Choice of [high deductible/copay] medical plans* with prescription drugs, including coverage for fertility and transgender inclusive benefits
Dental plan
Vision plan
Health care accounts – flexible spending, health reimbursement, and health savings accounts
Critical illness insurance
Life and Disability Insurance
Company-paid Life and Disability insurance plus voluntary supplemental coverage
Accident insurance
Retirement and Financial
401(k) retirement plan with a company match, plus an annual age/service-based Company contribution and an annual profit-sharing contribution, if applicable
Complimentary 1:1 financial guidance with a licensed Fidelity representative
Time Off and Remote Work
Flexible work arrangements (part in-person/part remote)
Unlimited paid time off for most roles plus time off for volunteering, jury duty, voting, and bereavement
Personal holidays for colleagues to use in recognition of religious, cultural, or civic days
Paid parental leave and paid family and medical leave policies
Emotional Well-being and Work-Life
Emotional well-being, mental health, and work/life resources powered by Spring Health
Wellness programs, including fitness program and equipment reimbursement
Child, adult, and elder back-up care support through Bright Horizons
Adoption assistance
College planning
Tuition reimbursement
Student loan assistance
Commuter benefits in select metropolitan areas
Equity & Inclusion
Opportunities to build inclusive and meaningful connections through involvement in colleague-led affinity groups:
Employee Resource Groups:
Colleague Connection Committees
Community Involvement Committees
A culture that encourages colleagues to bring their authentic selves to work
Voluntary self-ID
Pronunciation and phonetic spelling of names
Benefits apply to full-time eligible employees. Interns are not eligible for most Company benefits.
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_accommodation@glic.com .
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 .
Guardian Life
-
- Guardian Life Jobs