Administer, monitor, and maintain PostgreSQL databases (250GB+) in production environments (AWS RDS, Aurora, EC2)
Ensure database availability, performance, and data integrity through proactive monitoring and maintenance
Perform routine database administration tasks including patching, upgrades, vacuuming, reindexing, and statistics management
Execute and manage backup, restore, and disaster recovery procedures, including regular testing of recovery plans
Handle user access management, roles, and database security to ensure compliance with best practices
Perform capacity planning, storage management, and growth forecasting
Troubleshoot database issues, including performance bottlenecks, locking/contention, and failed jobs
Support application teams with query tuning, schema changes, and release deployments
Manage database migrations, upgrades, and change requests with minimal downtime
Maintain documentation for database configurations, standards, and operational procedures
Participate in on-call rotations and provide support for production incidents

7+ years of experience in a senior database administrator or Database Engineering role
Strong hands-on PostgreSQL administration experience, including backups, recovery, and performance tuning
Solid understanding of database security, access control, and compliance practices
Experience managing large-scale production databases (250GB+), including maintenance and lifecycle management
Strong Linux administration skills (processes, disk, memory, networking)
Experience with monitoring tools and performance diagnostics
Proficiency in SQL and at least one scripting language (Bash, Python, or similar)
Familiarity with cloud-based database deployments, preferably AWS (RDS, Aurora, EC2, S3)
Strong organizational and documentation skills

ClickUp is hiring a Senior Database Administrator