Location & Hours: Remote - 4 PM to 12AM EST
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 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.
**Job Types**: Full-time, Permanent
Pay: $40,200.00 - $58,200.00 per month
Application Question(s):
**Experience**:
- postgresql: 4 years (required)