Senior PostgreSQL DBA

Sorry, this job was removed at 05:19 p.m. (CST) on Friday, Aug 02, 2024
Be an Early Applicant
Holmdel, NJ
114K-187K Annually
7+ Years Experience
Insurance • Financial Services
The Role

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!

  • 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!

  • 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.

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

  • 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.

$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.

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.

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.

  • 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

  • Company-paid Life and Disability insurance plus voluntary supplemental coverage
  • Accident insurance

  • 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

  • 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, 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

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

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.

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 [email protected].

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

The Company
HQ: New York, NY
8,709 Employees
On-site Workplace
Year Founded: 1860

What We Do

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

Jobs at Similar Companies

Energy CX Logo Energy CX

Talent Acquisition Specialist

Greentech • Professional Services • Business Intelligence • Consulting • Energy • Financial Services • Utilities
Easy Apply
Chicago, IL, USA
55 Employees
65K Annually

MassMutual India Logo MassMutual India

BI Developer

Big Data • Fintech • Information Technology • Insurance • Financial Services
Hyderabad, Telangana, IND

TBD Logo TBD

Tech Lead/Staff Engineer, TBD

Blockchain • Fintech • Financial Services • Cryptocurrency
Remote
Hybrid
San Francisco, CA, USA
190 Employees
240K-359K Annually

Similar Companies Hiring

TBD Thumbnail
Fintech • Financial Services • Cryptocurrency • Blockchain
New York, NY
190 Employees
Energy CX Thumbnail
Utilities • Professional Services • Greentech • Financial Services • Energy • Consulting • Business Intelligence
Chicago, IL
55 Employees
MassMutual India Thumbnail
Insurance • Information Technology • Fintech • Financial Services • Big Data
Hyderabad, Telangana

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account