Job Description:-
This is a dual-hat role: you will own both the Linux server infrastructure and the PostgreSQL database layer. You'll work closely with the development team to ensure our backend services run reliably, our databases perform optimally, and our deployments are automated and repeatable. This is a hands-on, ownership role — not a ticket-handler.
LINUX SYSADMIN RESPONSIBILITIES
- Provision, configure, and maintain Linux servers (Ubuntu / CentOS / Red Hat) across on-premise and cloud environments.
- Manage Nginx / Apache web server configuration, reverse proxies, load balancing, and SSL termination.
- Set up and maintain CI/CD pipelines using Jenkins, GitHub Actions, or equivalent tools.
- Manage Docker containers and docker-compose deployments; basic Kubernetes cluster administration.
- Monitor system health, resource utilisation, and uptime using tools like Prometheus, Grafana, or Netdata.
- Configure firewalls, security groups, SSH hardening, and implement security best practices.
- Manage backup strategies, disaster recovery procedures, and restore testing.
- Handle log management, alerting, and incident response for production environments.
- Support application deployments and coordinate with developers on environment configuration.
POSTGRESQL DBA RESPONSIBILITIES
- Design, implement, and maintain PostgreSQL databases for transactional and analytical workloads.
- Perform query optimisation, index design, EXPLAIN ANALYSE, and schema refactoring for performance.
- Set up and manage replication (streaming replication, logical replication), standby servers, and failover.
- Implement and test backup strategies using pg_dump, pg_basebackup, WAL archiving, and PITR.
- Monitor database health: connection pooling (PgBouncer), lock contention, slow query logs, autovacuum.
- Manage Supabase-hosted PostgreSQL environments including Row Level Security, extensions (pgvector, PostGIS), and edge functions.
- Support developers with schema design, migration scripts, and database best practices.
- Implement role-based access control, audit logging, and data security policies.
- Perform capacity planning and scaling decisions for growing transaction volumes.
Pay: ₹25,000.00 - ₹35,000.00 per month
Work Location: In person
