Expert Database Administrator

Finastra Guadalajara, Mexico

Company

Finastra

Location

Guadalajara, Mexico

Type

Full Time

Job Description

Responsibilities

What you will contribute:

The role is responsible for building/managing business critical Oracle & PostgreSQL Databases in Azure PaaS. Also includes maintaining, enhancing, tuning, monitoring, and alerting existing and new databases, and supporting production operations. Strong skills and Working experience with Oracle 19c (RAC/Standby/Data Guard) & PostgreSQL in Azure Prepare Oracle/PostgreSQL roadmap for the future, comfortable in acting as product owner, manage stakeholders across the organization.

Oracle:

  • Overall IT experience of 10-15 years. 8+ years of experience in managing Oracle databases on Linux platforms
  • 5+ years of experience managing and tuning large and complex OLTP and warehouse databases using Oracle 19c.
  • Experience in tuning, monitoring, and securing Oracle databases Experience with Oracle Data Guard, ASM, RAC, AWR, and OEM
  • Experience in setting up HA/DR/Replication in Azure-PaaS/IaaS models.
  • Demonstrated experience writing complex stored procedures and queries.
  • Design database schema to meet new enhancement requirements.
  • Develop ETL strategies for integrating or migrating data from multiple sources
  • Proven experience with integration from Oracle to PostgreSQL.
  • Develop automation technologies to speed up loading data into the end target.

Want more jobs like this?

Get Data and Analytics jobs in Guadalajara, Mexico delivered to your inbox every week.

By signing up, you agree to our Terms of Service & Privacy Policy.

Postgre SQL

  • Strong Hands on 3-5-year experience in database administration of PostgreSQL databases on Azure PaaS, developing, documenting, and advocating best practices in Azure PaaS.
  • Managing / supporting PostgreSQL Azure PaaS/IaaS configuration.
  • Strong In-depth knowledge of Postgres internals.

General DBA skills:

  • Design and develop relational databases.
  • Ability to troubleshoot, diagnose & resolve complex database issues.
  • Skilled with performance tuning, recovery etc.
  • Good understanding of the differences between OLTP and OLAP systems and the different physical modeling and design considerations needed for each
  • Experience in operational and incident management / resolution.
  • Enhanced documentation skills - Prepare SoP / best practices to be shared with the team.
  • Develop appropriate corrective actions to resolve production data issues, not limited to performance tuning, recovery etc.
  • Build best practices/standard and provide guidance to the development team regarding database design and usage.

Apply Now

Date Posted

11/08/2024

Views

0

Back to Job Listings ❤️Add To Job List Company Info View Company Reviews
Positive
Subjectivity Score: 0.9

Similar Jobs

Security Assistant - Department of Veterans Affairs - Veterans Health Administration

Views in the last 30 days - 0

View Details

Physician - Orthopedic/Total Joint Surgeon - CHRISTUS Health

Views in the last 30 days - 0

View Details

Administrative Assistant - Wexford Health Sources

Views in the last 30 days - 0

View Details

Medical Records Clerk - Wexford Health Sources

Views in the last 30 days - 0

View Details

Substance Abuse Counselor - NMCD - Wexford Health Sources

Views in the last 30 days - 0

View Details

Division Chief for Urologic Surgery - University of New Mexico, Urology Division

Views in the last 30 days - 0

View Details