Oracle Database Administrator/ Oracle DBA - Hybrid

$84,320 - $126,480/Yr

The Hartford - Hartford, CT

Full-time - Mid Level

Remote - Hartford, CT

Insurance Carriers and Related Activities

About the position

The Enterprise Database Management organization at The Hartford is seeking a results-oriented, committed, and self-motivated individual to join our team as a Database Manager. This role is pivotal in shaping the future of our database management practices, focusing on Oracle Database skills on Linux and Exadata servers for both on-premises and cloud solutions. The successful candidate will be responsible for analyzing, developing, and maintaining OLTP Oracle 19c backend databases that support various business applications. The Hartford is dedicated to underwriting human achievement, and this position plays a crucial role in delivering outstanding results through effective database management. In this position, you will partner with the Application team to create and maintain database designs for business and enterprise projects, ensuring adherence to The Hartford's best practices and published standards. Collaboration with the Cloud organization is essential, as you will facilitate database migrations from on-prem systems to the Cloud. The role offers a hybrid work arrangement, requiring candidates to work in the Hartford, CT office three days a week (Tuesday through Thursday), reflecting our commitment to a flexible work environment that attracts and retains top talent. As a Database Manager, you will drive the design, creation, and management of Oracle databases running on Oracle 19c environments on Exadata, LINUX, and AIX, utilizing features such as data compression, partitioning, RAC, RMAN, and Data Guard. You will also participate in the design, development, and implementation of database architecture and solutions for Agile projects, ensuring a “Speed-to-Market” approach. Your expertise in Oracle performance analysis tools, such as ASH and AWR, will be critical in tuning databases and providing measurable value to applications. Additionally, you will conduct database configuration reviews, audits, and troubleshooting, while managing user access and maintaining database security.

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.

Requirements

• Bachelor's degree in computer science or a related discipline.
• 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.

Nice-to-haves

• Basic automation skills, such as Ansible, Python, terraform for IAC are great to have.
• AWS cloud skills with Oracle and PostgreSQL are preferred.

Benefits

• Short-term or annual bonuses
• Long-term incentives
• On-the-spot recognition
• Comprehensive health insurance
• 401k retirement savings plan
• Paid time off and holidays
• Flexible work arrangements