![Mobile National MS Society Logo](https://dn9tckvz2rpxv.cloudfront.net/nationalmssociety.jobs/Logo.png)
Job Information
The Hartford Senior Database Reliability Engineer (PostgreSQL) - Hybrid in Hartford, Connecticut
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 PGDUMP & PGRESTORE 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 (https://www.thehartford.com/about-us) | Culture & Employee Insights (https://www.thehartford.com/careers/employee-stories) | Diversity, Equity and Inclusion (https://www.thehartford.com/about-us/corporate-diversity) | Benefits (https://www.thehartford.com/careers/benefits)
Human achievement is at the heart of what we do.
We believe that with the right encouragement and support, people are capable of achieving amazing things.
We put our belief into action by ensuring individuals and businesses are well protected, and by going even further – making an impact in ways that go beyond an insurance policy.
Nearly 19,000 employees use their unique talents in careers that span a variety of disciplines – from developing the latest technology to creating and promoting our products to evaluating future financial risks.
We’re also committed to programs that drive education and support volunteerism, which put human beings first. We do it because it’s the right thing to do, and because when our customers, communities and employees succeed, we all do.
About Us (https://www.thehartford.com/about-us)
Culture & Employee Insights
Diversity, Equity and Inclusion (https://www.thehartford.com/about-us/corporate-diversity)
Benefits
Legal Notice (https://www.thehartford.com/legal-notice)
Accessibility StatementProducer Compensation (https://www.thehartford.com/producer-compensation) EEO
Privacy Policy (https://www.thehartford.com/online-privacy-policy)
California Privacy Policy
Your California Privacy Choices (https://www.thehartford.com/data-privacy-opt-out-form)
International Privacy Policy
Canadian Privacy Policy (https://www.thehartford.com/canadian-privacy-policy)
The Hartford
-
- The Hartford Jobs