Database Administrator – Query Optimization Engagement

Vertex Analytics

Project-based · Remote · Flexible hours

About the role

Vertex Analytics is preparing a mobile‑backend alignment for an upcoming app store launch. We need a Database Administrator to design, tune, and secure the data layer that will power real‑time analytics and user profiles.

Key responsibilities

• Architect and implement scalable schemas in PostgreSQL, MongoDB, and MySQL
• Optimize query performance for high‑frequency mobile data ingestion
• Set up automated backups, replication, and disaster‑recovery procedures
• Collaborate with mobile engineers to align API contracts and data contracts
• Monitor database health, conduct capacity planning, and resolve incidents

Must-have skills

• 3+ years managing PostgreSQL, MongoDB, and MySQL in production
• Strong SQL tuning and indexing expertise
• Experience with CI/CD pipelines for database migrations
• Understanding of security best practices for mobile data

Nice to have

• Familiarity with cloud‑native database services (e.g., AWS RDS, Atlas)
• Knowledge of containerized database deployments