Oracle Database Administrator

Allstate Insurance Company; Tijuana; A distancia; MXN 1,479,000 - 1,850,000; Jornada completa

Descripción de la vacante

A leading insurance provider is seeking a Senior Database Administrator in Tijuana, Mexico. The role involves designing, implementing, and supporting database solutions for large-scale systems, ensuring data availability and integrity, and collaborating with teams for optimization. Ideal candidates will have over 5 years of experience with Oracle technologies. This position offers remote work flexibility for residents of Mexico.

Formación

• 5+ years of hands-on Oracle Database Administrator experience.
• Experience supporting large-scale enterprise database environments.
• Strong understanding of Oracle performance tuning, ASM, RMAN, and Oracle Enterprise Manager.

Responsabilidades

• Design and maintain physical database structures for enterprise applications.
• Manage day-to-day database administration including installations and security.
• Analyze performance issues and recommend database tuning enhancements.

Conocimientos

Oracle Database Administration

Database performance tuning

Disaster Recovery planning

Scripting (Shell, PL/SQL, Python, or PowerShell)

Herramientas

Oracle RAC

Oracle Data Guard

Oracle GoldenGate

Descripción del empleo

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 Database Administrator is responsible for designing, implementing, and supporting database solutions for medium- to large-scale systems. This role provides advanced operational support across the database environment, ensures data availability and integrity, and contributes to lifecycle management with minimal supervision. The Senior DBA performs performance optimization, disaster recovery planning, troubleshooting, and collaborates with cross-functional teams to deliver secure and highly performant database solutions.

Thispositionofferstheflexibilitytoworkremotely;however,candidatesmustresideinMexico.

Key Responsibilities

• Design, create, and maintain physical database structures for enterprise applications.
• Convert logical data models into physical models and generate DDL scripts for implementation.
• Manage day-to-day database administration, including installations, upgrades, patching, security, capacity planning, and automation scripting.
• Plan, execute, and validate Disaster Recovery (DR) tests independently for lower-tier systems and assist with higher-tier environments.
• Participate in recovery and rollback procedures; ensure backup processes meet availability and data integrity requirements.
• Analyze performance issues and recommend database tuning and configuration enhancements.
• Collaborate with application developers, systems analysts, and vendors to diagnose and resolve complex performance incidents.
• Implement and support replication and high-availability strategies using Oracle technologies such as Data Guard, GoldenGate, DPROP, and database mirroring tools.
• Help design and optimize replication strategies aligned to organizational data protection standards.
• Detect database bugs and identify required patches.
• Coordinate with Oracle support for patch validation and create rollout plans to ensure long-term stability and problem resolution.
• Work closely with architects, system teams, and developers to understand requirements and propose efficient database solutions.
• Maintain documentation for database configurations, standards, recovery procedures, and runbooks.

Qualifications

Technical Skills and Experience

• 5+ years of hands-on Oracle Database Administrator experience.
• Experience supporting large-scale enterprise database environments.
• Strong understanding of Oracle performance tuning, ASM, RMAN, and Oracle Enterprise Manager.
• Experience with Oracle RAC, Data Guard, and GoldenGate preferred.
• Scripting experience (Shell, PL/SQL, Python, or PowerShell) is a plus.

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.