Senior Database Reliability Engineer (PostgreSQL) - Hybrid

Posted:
7/23/2024, 5:00:00 PM

Location(s):
Charlotte, North Carolina, United States ⋅ Connecticut, United States ⋅ Hartford, Connecticut, United States ⋅ North Carolina, United States

Experience Level(s):
Senior

Field(s):
DevOps & Infrastructure ⋅ Software Engineering

Sr Database Mgr - IB07EE

We’re determined to make a difference and are proud to be an insurance company that goes well beyond coverages and policies. Working here means having every opportunity to achieve your goals – and to help others accomplish theirs, too. Join our team as we help shape the future.   

         

The Hartford is currently looking for a Senior Database Reliability Engineer. This role provides in-depth consulting to client and IT management and staff at the highest technical level in the identification and resolution of information flow, content issues and the transformation of business requirements into relational database definitions. Performs data modeling studies and develops detailed data models.  Works with client and IT management and staff to establish and maintain consistent data element definitions across computing environments including Web and e-commerce. Recommends access rules in accordance with established security and privacy practices. Participates in the development and maintenance of corporate data architecture, data management standards and conventions, data dictionaries and data element naming standards and conventions for multiple computing environments. Prepares written reports of findings and recommendations.  Prepares business requirements reports, feasibility studies, and cost justification statements.  Consults with client management on approaches to address business needs and opportunities. Provides linkage and continuity to business units and development groups in the implementation of recommendations. Acts as an expert technical resource to client and development management and staff in all phases of the development and implementation process. ​

Job Responsibilities:

RDS Instance Creation/Deletion

  • Aurora RDS
    • Instance Creation/Deletion
    • User Management
    • Database design
    • Database Backups and Restores
    • Database Performance Management
    • Database Patching
    • High Availability and Disaster Recovery Testing
    • Database Activity Monitoring
    • Perform Data Masking
    • Database Configuration Changes
    • Data refresh between the databases and environment
  • Database Release Management
  • Database Incident management
  • Certificate and Access Key management
  • Respond to Audit Enquiries
  • Apply Data fixes to Aurora databases.
  • Database Capacity planning and provisioning
  • Manage offshore PostgreSQL DB team.

Qualifications from the PostgreSQL DBA requirement:

Qualifications:

  • Bachelor’s degree in computer science or a related discipline
  • Requires at least 6 plus years of experience with implementations, upgrades, conversions, and consolidation projects with Oracle or MS SQL Server database.
  • Automation skills, such as Ansible, Python, terraform for IAC.
  • Knowledge and experience of AWS or Oracle Cloud Infrastructure and Cloud Service
  • Hands-on cloud migration experience is preferred.
  • Comprehension of PostgreSQL architecture with the ability to complete daily activities on a database.
    • Role creation
    • Service account privileges issues
    • Permission or login issues
    • Release deployment and DML outside of a CI/CD pipeline
  • Experience working with pgAdmin.
  • Understanding of AWS persona based access.
  • Knowledge of AWS writer and reader instances.
  • Knowledge of PSQL (Command Line).
  • Migration of objects and schemas using PG_DUMP & PG_RESTORE for Postgres.
  • Aurora database design knowledge (Storage, Global, switchover, Aurora engine product).
  • Distinction between serverless, headless and persistent AWS instances.
  • Installation of Extensions in AWS Aurora or RDS PostgreSQL
  • Utilizing AWS Catalogs or CI/CD to create a Database.
  • PGPSQL, Scheduling jobs via lambda.
  • Experience in upgrading Aurora and RDS PostgreSQL database (Minor, Major upgrade).
  • Performance tuning experience across cloud native technologies
  • Requires strong organizational and communication skills with the ability to handle multiple priorities.
  • AWS Cloud Practitioner and / or Solution Architect certifications preferred.
  • Strong understanding of observability & monitoring
  • Candidate must be authorized to work in the US without company sponsorship.

As a condition of your employment for HIMCO, you will be required to affirm to HIMCO’s Code of Ethics and understand that you will be required to comply with the disclosure of accounts, holdings and pre-clearance of trades for the accounts of you and your household family members as more fully described in the Code of Ethics Key Points.  If you will be deemed to be a “Covered Associate” under HIMCO’s Pay to Play Policy, you will also need to disclose all political contributions that you have given within the past 2 calendar years.

Compensation

The listed annualized base pay range is primarily based on analysis of similar positions in the external market. Actual base pay could vary and may be above or below the listed range based on factors including but not limited to performance, proficiency and demonstration of competencies required for the role. The base pay is just one component of The Hartford’s total compensation package for employees. Other rewards may include short-term or annual bonuses, long-term incentives, and on-the-spot recognition. The annualized base pay range for this role is:

$104,160 - $156,240

Equal Opportunity Employer/Females/Minorities/Veterans/Disability/Sexual Orientation/Gender Identity or Expression/Religion/Age

About Us | Culture & Employee Insights | Diversity, Equity and Inclusion | Benefits