Oracle Database Administrator - Integon

Integon is a part of The Allstate Corporation, which means we have the same innovative drive that keeps us a step ahead of our customers' evolving needs. It's how we've become industry leaders in property and casualty insurance servicing. We support our insurance company affiliates by offering property and casualty insurance products inclusive of personal auto, homeowners, RV, motorcycle, small business auto insurance and more.

Job Description
The Senior Consultant I creates database structures for medium to large projects, provides support in the day to day operational management of Database Technologies and aids in software maintenance lifecycle management with little to no assistance. The individual analyzes, consults, and recommends different options for database performance tuning, database configuration implementation, creates and maintains scripts and test plan execution.

Key Responsibilities

Executes Disaster Recovery tests independently for lower tiered databases and assists for higher tiered databases

Understands and implements replication strategies per strategic solution and database, critically utilizing tools such as DPROP, Golden Gate, Mirroring, Data Guard, etc.

Participates in recovery/rollback as necessary and participates in tests of back-up procedures to ensure integrity of the back-ups

Identifies bugs and patches related to issues/incidents, works with database vendor support for patch validation; creates rollout plan for permanent problem resolution

Analyzes, consults, and recommends different options for database performance tuning, database configuration implementation and collaborates with vendors and subject matter experts on complex incidents

Creates physical data models by gathering requirements and working with application developers, System Analysts and Architects for low complex models with little or no assistance; converts logical data models into physical data models and generate DDL for implementation

Joining our team isn't just a job - it's an opportunity. One that takes your skills and pushes them to the next level. One that encourages you to challenge the status quo. One where you can shape the future of protection while supporting causes that mean the most to you. Joining our team means being part of something bigger - a winning team making a meaningful impact.