Oracle Database Administrator/ Oracle DBA - Hybrid

Posted:
5/6/2024, 5:00:00 PM

Location(s):
Connecticut, United States ⋅ Hartford, Connecticut, United States

Experience Level(s):
Junior ⋅ Mid Level ⋅ Senior

Field(s):
Software Engineering

Workplace Type:
Hybrid

Database Mgr - IB08DE

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 Enterprise Database Management organization is seeking a results-oriented, committed, and self-motivated individual contributor with Oracle Database skills on Linux and Exadata servers for both on-prem and cloud solutions. The team is responsible for analyzing, developing, and maintaining OLTP Oracle 19c backend databases in support of the various business applications for The Hartford. AWS cloud skills with Oracle and PostgreSQL are preferred. Basic automation skills, such as Ansible, Python, terraform for IAC are great to have. In this role, this individual will partner with the Application team to create and maintain database designs for business and enterprise projects in accordance with The Hartford’s best practices and published standards. This individual will collaborate with the Cloud organization to facilitate database migrations from the on-prem system to the Cloud.

Sustaining The Hartford’s unique workplace culture is vital to delivering on our purpose – underwriting human achievement – and continuously producing outstanding results. Our enterprise work model, which reflects a mix of in-office, hybrid and fully remote roles, helps us attract, retain and develop the talent we need to achieve the company’s strategic goals.   This role will have a Hybrid work arrangement. 

This role will have a Hybrid work arrangement located in Hartford, CT. Candidates will have the expectation of working in an office 3 days a week (Tuesday through Thursday).

Major Responsibilities

  • Drive design, creation, and management of Oracle databases running on Oracle 19c environments on Exadata, LINUX, AIX with features for data compression, partitioning, RAC, RMAN, Data Guard

  • Drive design, creation, and management of Oracle databases running on Oracle 19c environments on Aurora Postgres, Oracle RDS and Oracle EC2

  • Participate in design, development, and implementation of database architecture and database solutions for “Speed-to-Market” Agile projects underway.

  • Perform tuning with expertise on Oracle performance analysis tools such as ASH and AWR along with SQL Plan Baselines, SQL Profiles

  • Master the latest DB features and apply them to provide a measurable value on applications.

  • Perform analysis and end-to-end execution from roadmap to implementation of database consolidations, migrations, conversions, and upgrades.

  • Work to reduce complexity and cost in database environments through analysis, simplification, and automation using Ansible, Python, terraform or other tools.

  • Conduct Oracle database configuration reviews, audits, and troubleshooting on version 19c for all platforms supported by Oracle.

  • Control and monitor user access to databases and maintain database security.

  • Manage capacity planning and forecasting for various platforms.

  • Facilitate databases migration from an on-prem system to the Cloud.

  • Maintain documentation of systems and standard operating policies and procedures

  • Collaborate and participate in application release planning and implementation.

  • Work with HIG onshore and offshore database partners to ensure availability, performance, quality, and Service Level Agreement specifications.

  • Educate and influence stakeholders to promote an understanding of the environments, increase simplification, risk management, and promote reuse and innovation.

  • The ability to learn fast on the job by partnering with senior resources

Qualifications:

  • Bachelor’s degree in computer science or a related discipline

  • Requires at least 3 plus years of experience with implementations, upgrades, conversions, and consolidation projects with Oracle databases.

  • Solid knowledge of Oracle 19c and technical database concepts, including tuning databases, migrations, and backup/recovery techniques

  • General understanding of automation tools, such as Ansible, Python, terraform for IAC.

  • Knowledge and experience in AWS

  • Hands-on cloud migration experience is preferred.

  • Postgres Database administration is preferred.

  • Strong organizational and communication skills with the ability to handle multiple priorities.

  • Candidate must be authorized to work in the US without company sponsorship.

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:

$84,320 - $126,480

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