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 - flexible 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