Sr. Database Administrator - Postgres/Oracle DBA - Hybrid

The Hartford • Hartford, CT

460d • $84,320 - $156,240 • Remote

About The Position

The Senior Database Manager position at The Hartford involves managing and optimizing Oracle databases on both on-premises and cloud environments. The role focuses on database design, implementation, and maintenance to support various business applications, ensuring high performance and security. The position requires collaboration with application teams and cloud organizations to facilitate database migrations and enhancements, contributing to the company's strategic goals in a hybrid work environment.

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.

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.

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 Databases on Exadata in AWS.
• 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.

Benefits

• Short-term or annual bonuses
• Long-term incentives
• On-the-spot recognition

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Industry: Insurance Carriers and Related Activities
• Education Level: Bachelor's degree