Must have 7+ years advance level in Azure PostgreSQL Performance Tuning, Optimization with best practices
- 5 years + hands-on experience with Microsoft Flex Servers, KQL queries, Query store, Intelligent tuning, and query stats
- 5 years+ Experience in design High availability (Reliability) in Azure Database for PostgreSQL
- 5 years + Experience Geo-disaster recovery in Azure Database for PostgreSQL
- Experience in setup Read replicas in Azure Database for PostgreSQL - Versátil Server
- Demonstrable experience working with huge, interdependent, complex datasets and data structures.
- Ability to efficiently write database code without compromising data quality, privacy, or security.
- Knowledge of database design principles, query optimization, index management, integrity checks
- Work with product owners to ensure database code meets requirements
- Advance in in data modeling. Identify potential issues in database and SQL issues to solve them early.
- Expert in physical and logical PostgreSQL database design and identify flaws in the design and fix.
- Design, Architect and Tune PostgreSQL databases on the Azure Database for PostgreSQL - Flexible Server
- Excellent with troubleshooting skills in Microsoft Azure PostgreSQL layers (servers and databases)
- Plan and coordinate with Microsoft for data backups, DR restore/recovery and setup vendor escalation procedures.
- Manage PostgreSQL database Security, Audit, and Hardening
- Provide 24 x 7 operation and on-call production support
Additional required skills are Amazon S3; AWS Command Line Interface (CLI); Azure Automation; Azure Database for Postgresql; Database Performance Tuning; DB Performance Tuning; Disaster Recovery (DR); Disaster Recovery Testing; Linux Command; Partitioning; PostgreSQL; Scripting; SQL Query Development; Terraform on Microsoft Azure. Deep knowledge and hands-on cloud infrastructure experience of handling High Availability, Reliability, Backup/Restore, GEO redundancy and Disaster Recovery scenarios
Pay: $12,882.06 - $29,055.17 per month
**Experience**:
- Azure postgreSQL: 5 years (required)
**Language**:
- English (required)
Work Location: Remote
Expected Start Date: 20/01/2025
📌 PostgreSQL Dba (México)
🏢 narwal
📍 México