Himalayas logo
AllstateAL

Oracle Database Administrator

The Allstate Corporation is one of the largest publicly held personal lines insurers in the United States, offering a wide range of insurance products including auto, home, life, and business insurance. Founded in 1931 as part of Sears, Roebuck and Co., Allstate became an independent company in 1995 and is widely known for its slogan 'You're In Good Hands With Allstate®'.

Allstate

Employee count: 5000+

Mexico only

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.

In the event you need assistance or accommodation in completing your online application, please contact Integon via WhatsApp at 664.203.4492

Direct General Auto & Life, Personal Express Insurance, Century-National Insurance, ABC Insurance Agencies, NatGen Preferred, NatGen Premier, Seattle Specialty, National General Lender Services, ARS, RAC Insurance Partners, Mountain Valley Indemnity, New Jersey Skylands, Adirondack Insurance Exchange, VelaPoint, Quotit, HealthCompare, AHCP, NHIC, Healthcare Solutions Team, North Star Marketing, Euro Accident.

About the job

Apply before

Posted on

Job type

Full Time

Experience level

Senior

Location requirements

Hiring timezones

Mexico +/- 0 hours

About Allstate

Learn more about Allstate and their company culture.

View company profile

The Allstate Corporation's story began on April 17, 1931, amidst the financial uncertainties of the Great Depression. Born as a subsidiary of Sears, Roebuck and Co., the idea for Allstate Insurance Company emerged from a simple proposal by insurance broker Carl L. Odell to his neighbor, Robert E. Wood, then president of Sears. Odell envisioned selling auto insurance by direct mail, mirroring Sears' successful catalog sales model. The Sears board approved, and Allstate, named after Sears' tire brand, commenced operations, initially offering auto insurance directly to consumers. The first policy insured a 1930 Studebaker, and the first claim was remarkably straightforward – a customer walked into the one-room headquarters with a door handle pried off by a would-be thief. By the end of its first year, Allstate had 4,217 active car insurance policies, a number that grew to over 113,000 by the decade's end.

The company's early years saw innovation in its approach. In 1933, Allstate utilized the Century of Progress World's Fair in Chicago to sell insurance at a booth in the Sears pavilion. A year later, the first permanent sales office opened within a Chicago Sears store. Recognizing the evolving needs of its customers and the changing landscape of the nation, Allstate began to expand its offerings. Fire insurance was added in 1954, followed by homeowners and life insurance in 1957. The iconic slogan, 'You're In Good Hands With Allstate®,' was conceived in 1950 by General Sales Manager Davis W. Ellis and quickly became a cornerstone of the company's identity. The 1950s also marked Allstate's international expansion, with operations beginning in Canada in 1953. The Allstate Foundation, one of the country's pioneering corporate foundations, was established in 1952, underscoring a commitment to community and safety, initially focusing on driver training scholarships. This dedication to societal well-being continued through decades, with initiatives supporting nursing scholarships and neighborhood revitalization. A significant milestone occurred in 1993 when Allstate became a publicly traded company. Two years later, in June 1995, Sears divested its remaining shares, making Allstate a fully independent entity in what was then the largest IPO in U.S. history. Throughout its journey, Allstate has continued to adapt and grow, acquiring companies like National General and expanding its services to meet the diverse needs of millions of households across North America.

Employee benefits

Learn about the employee benefits and perks provided at Allstate.

View benefits

Paid company holidays

Paid company holidays.

Life Insurance

Life insurance coverage.

Dental Insurance

Dental insurance coverage.

Healthcare Insurance

Healthcare insurance coverage.

View Allstate's employee benefits
Claim this profileAllstate logoAL

Allstate

View company profile

Similar remote jobs

Here are other jobs you might want to apply for.

View all remote jobs

185 remote jobs at Allstate

Explore the variety of open remote roles at Allstate, offering flexible work options across multiple disciplines and skill levels.

View all jobs at Allstate

Remote companies like Allstate

Find your next opportunity by exploring profiles of companies that are similar to Allstate. Compare culture, benefits, and job openings on Himalayas.

View all companies

Find your dream job

Sign up now and join over 100,000 remote workers who receive personalized job alerts, curated job matches, and more for free!

Sign up
Himalayas profile for an example user named Frankie Sullivan
Allstate hiring Oracle Database Administrator • Remote (Work from Home) | Himalayas