DBA / Database Administrator_Shanghai

Tasks

• Build database monitoring and alerting dashboards
• Collaborate on query design database architecture and system efficiency
• Design infrastructure for maximum database performance
• Diagnose performance bottlenecks across database OS storage and hardware
• Establish database maintenance backup recovery and capacity planning best practices
• Install and manage PostgreSQL on bare metal servers
• Optimize OLAP analytical database schema indexing partitioning and queries
• Review and improve database performance availability and resilience
• Tune PostgreSQL performance and reliability

Perks/Benefits

• N/A

Skills/Tech-stack

Backup and Recovery | Capacity Planning | Database Maintenance | Database monitoring | Indexing | Linux | NVMe | OLAP | Observability | Partitioning | Performance Tuning | PostgreSQL | Query Optimization | SSD | Storage performance | System Tuning