**Sr Cloud DBA - PostgreSQL**
**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 mínimal 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.
**Benefits**:
- Major medical Insurance
- Life Insurance
- Food Vouchers
- Savings fund (after the first year in the company)
This is a hybrid position (once a week in the office in Guadalajara)
Tipo de puesto: Jornada completa
Sueldo: $60,****** - $65,****** al mes
Lugar de trabajo: remoto híbrido en *****, Puerta Aqua, Jal.