Database Administrator

VasyERP Solutions; Ahmedabad District; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

VasyERP Solutions is an Ahmedabad-based startup delivering cloud-based ERP and POS platforms for manufacturing and retail sectors in India and beyond. The Database Administrator will ensure the database runs smoothly, optimize performance, and oversee backups, security, and access controls across systems.

We expect hands-on PostgreSQL expertise, strong SQL skills, and proactive troubleshooting with a focus on reliability, security, and disaster recovery in a fast-growing environment.

Qualifications

• Database design & development with PostgreSQL
• Query optimization & performance tuning
• Backup, recovery & security management
• Database monitoring & maintenance
• Collaboration & troubleshooting

Responsibilities

• Ensure database runs smoothly and as expected
• Optimize PostgreSQL performance
• Create backups for disaster recovery
• Monitor security and access
• Collaborate with developers and cross-functional teams

Skills

PostgreSQL

SQL

Performance tuning

Backup & Recovery

Linux/Windows familiarity

Problem solving

Documentation

Communication

Tools

pgBouncer

pgBadger

AWS RDS

Azure

Job description

VasyERP (Funded by Reliance Industries) is an Ahmedabad situated young start-up working into cloud-based ERP products. We design and develop ERP & point of sale (POS) platforms for manufacturing and retail industries in India and internationally.

About the Role:

As a Database Administrator, you will be responsible for ensuring that the database runs smoothly and functions as expected to ensure business goals are achieved. Look for ways to optimize the performance of the database, create backups that come in handy during disaster recovery, and monitor security and access.

Candidate Requirement:

• 3+ years hands-on experience in PostgreSQL.
  • Must have a deeper understanding of PostgreSQL architecture and internals.
  • Experience in handling large databases and optimizing PostgreSQL performance.
  • Strong SQL skills: writing complex queries, stored procedures/triggers, understanding execution plans and indexes.
  • Proven experience troubleshooting and solving complex database schema or warehouse issues.
  • Experience with backups/recovery, performance tuning, and database security.
  • Familiarity with Linux/Windows for deploying and maintaining PostgreSQL servers.
  • Strong problem-solving and debugging skills for performance and query optimization.
  • Good communication and documentation skills; ability to collaborate effectively with developers and cross-functional teams.
• Must have a deeper understanding of PostgreSQL architecture and internals.
• Experience in handling large databases and optimizing PostgreSQL performance.
• Strong SQL skills: writing complex queries, stored procedures/triggers, understanding execution plans and indexes.
• Proven experience troubleshooting and solving complex database schema or warehouse issues.
• Experience with backups/recovery, performance tuning, and database security.
• Familiarity with Linux/Windows for deploying and maintaining PostgreSQL servers.
• Strong problem-solving and debugging skills for performance and query optimization.
• Good communication and documentation skills; ability to collaborate effectively with developers and cross-functional teams.

Must-Have Requirements:

• Database Design & Development – Design and maintain efficient database schemas, tables, indexes, and relationships; develop stored procedures, triggers, and views.
  • Query Optimization & Performance Tuning – Analyze and optimize SQL queries, indexes, and database configurations to ensure high performance and scalability.
  • Backup, Recovery & Security Management – Implement and monitor database backup, restoration, and user access policies to ensure data integrity and security.
  • Database Monitoring & Maintenance – Regularly monitor database health, resource usage, and logs; perform preventive maintenance and apply patches or upgrades as needed.
  • Collaboration & Troubleshooting – Work closely with developers teams to resolve database issues, deploy schema changes, and ensure seamless data integration across systems.
• Query Optimization & Performance Tuning – Analyze and optimize SQL queries, indexes, and database configurations to ensure high performance and scalability.
• Backup, Recovery & Security Management – Implement and monitor database backup, restoration, and user access policies to ensure data integrity and security.
• Database Monitoring & Maintenance – Regularly monitor database health, resource usage, and logs; perform preventive maintenance and apply patches or upgrades as needed.
• Collaboration & Troubleshooting – Work closely with developers teams to resolve database issues, deploy schema changes, and ensure seamless data integration across systems.

Good-to-Have Requirements

• Experience with pgBouncer, pgBadger, or other PostgreSQL monitoring tools.
  • Exposure to high-availability setups or cloud-managed PostgreSQL (AWS RDS, Azure).
  • Experience in data warehouse and data lake management and optimization.
  • Hands-on experience in disaster recovery planning and management.
• Exposure to high-availability setups or cloud-managed PostgreSQL (AWS RDS, Azure).
• Experience in data warehouse and data lake management and optimization.
• Hands-on experience in disaster recovery planning and management.