CommunityJobsAdviceEventsReviewsFor EmployersFor ClientsCoach Connect
CommunityJobsAdviceEvents
JOB SEARCH

Expert DBA - PostgreSQL

Finastra

Guadalajara, Mexico

#10148

Position summary

nce in managing databases of various sizes, 5+ years of strong working knowledge of PostgreSQL Flex server in Azure.

  • You are also well versed with other flavors of PostgreSQL databases in Azure.

  • Working experience with Azure Flex-server for PostgreSQL is a must.

  • Should have working experience on Oracle databases.

Qualifications

Requirement -

  • Strong Hands on 6+ year experience in database administration of PostgreSQL, developing, documenting, and advocating best practices.

  • 2+ Yrs working experience in Oracle databases 12c/19c.

  • Mentor and share best practices on PostgreSQL within team.

  • Managing / supporting PostgreSQL Azure PaaS/IaaS configuration specifically Azure Flex-server.

  • Well versed with other servers/flavors of PG databases in Azure, like Cosmos DB for PG(Citus)

  • Experience in setting up HA/DR/Replication in Azure-PaaS/IaaS models.

  • Setting up backup/recovery, Performance tuning, enabling monitoring/alerting for PostgreSQL Flex-server.

  • Build best practices/standard and provide guidance to the development team regarding database design and usage.

  • Strong In-depth knowledge of PG internals.

  • Demonstrated experience writing complex stored procedures and queries.

  • Develop automation technologies to speed up loading data into the end target.

  • Design and develop relational databases.

  • Develop appropriate corrective actions to resolve production data issues, not limited to performance tuning, recovery etc.

  • 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.

  • Experience in operational and incident management / resolution.

  • Enhanced documentation skills - Prepare SoP / best practices to be shared with the team.

Skills & Knowledge -

  • University degree/College diploma in computer science or a related field of study.
  • Ability to troubleshoot and, diagnose and resolve complex database issues.
  • Good understanding of the differences between OLTP and OLAP systems and the different physical modeling and design considerations needed for each.
  • Knowledge of any of the following would be advantageous:
    Previous experience in Financial Services management, analysis and reporting.
  • Self-motivated individual who enjoys technical challenges and takes pride in delivering high quality work in fast paced environment.
  • Capable of managing multiple projects concurrently while maintaining a high level of attention to detail on each project with minimal supervision.
  • Ability to learn new technologies as needed to provide the best solutions to our customers.
  • Ability to work effectively in a team environment to encourage collaboration, innovation, and continuous improvement.