PostgreSQL Administrator for Performance Tuning

SwiftTask Agency

Freelance · Remote · Flexible hours

About the role

SwiftTask Agency is launching a data‑intensive project that relies on robust PostgreSQL performance. We need an experienced PostgreSQL Administrator to fine‑tune, monitor, and secure our databases while ensuring high availability.

Key responsibilities

• Design and implement PostgreSQL schemas and indexing strategies
• Perform performance tuning, query optimization, and capacity planning
• Set up replication, backup, and disaster‑recovery processes
• Monitor database health and resolve incidents promptly
• Collaborate with developers to integrate database changes smoothly

Must-have skills

• 3+ years managing PostgreSQL in production environments
• Strong SQL proficiency and query optimization experience
• Knowledge of replication, backup, and security best practices
• Familiarity with Linux/Unix administration

Nice to have

• Experience with MongoDB or MySQL migrations
• Exposure to cloud database services (AWS RDS, GCP Cloud SQL)