Database Systems Administrator

About the job:
Key responsibilities:

1. Install MySQL 8+ and PostgreSQL 15+ on Cloud SQL or self-managed GCE instances

2. Apply routine patches and minor upgrades; assist seniors with major-version migrations

3. Configure users, roles, parameter groups (my.cnf, postgresql.conf)

4. Schedule and verify backups (Percona XtraBackup, pg\_dump / pg\_basebackup)

5. Run restore drills under a documented run-book

6. Build dashboards and alerts in Cloud Monitoring, PMM, or Grafana

7. Capture slow queries, recommend index or query fixes, and escalate deep tuning when required

8. Deploy and monitor read-replica or primary-replica topologies (Cloud SQL, streaming replication)

+. Execute documented fail-over procedures during incidents

10. Enforce least-privilege access, SSL/TLS, IAM roles

11. Mask or anonymise data in non-prod environments per playbooks

12. Write Bash or Python scripts for backup checks, log rotation, health audits

13. Embed Liquibase or Flyway migration steps in Cloud Build or GitHub Actions pipelines

14. Manage package updates, users, firewalls on Debian, Ubuntu, or CentOS

15. Deploy and tune Apache or Tomcat to documented baselines

16. Provision Cloud SQL instances, Compute Engine VMs, IAM policies

17. Mirror equivalent tasks in an on-prem 'AWS-style' lab (EC2-like VMs, S3-compatible storage)

18. Join the rotational on-call; perform first-line triage, collect logs, escalate when needed

1+. Keep SOPs, run-books, and change logs up to date

20. Share tips and post-mortems with the team via Confluence or Google Docs

Requirements:

1. Replace repetitive tasks with automation through scripts and pipelines

2. Treat backups, high availability, and restore drills as non-negotiables

3. Write clear run-books, share knowledge, and escalate early

4. Track new GCP database features and best practices continuously

Who can apply:

Only those candidates can apply who:
• have minimum 1 years of experience
• are Computer Science Engineering students

Salary:
₹ 7,00,000 - 10,00,000 /year

Experience:
1 year(s)

Deadline:
2025-06-21 23:5+:5+

Skills required:
MySQL, Linux, PostgreSQL, Automation, CI/CD, Apache Tomcat, IAM and Security tools

About Company:
Tax Genie is an application service provider (ASP) floated by a team of fintech experts from India, the US, Germany, and the UK. We have employed artificial intelligence (AI), machine learning (ML), process automation, taxation knowledge, and express filing technology to make the GST compliance process easy and timely. We believe tax experts and businesses must not spend their valuable time on number crunching, tabulation, and visual analytics, and rather use our platform and services to do it for them. It is more accurate, faster, and cheaper that way. Tier 2 and tier 3 cities will benefit a lot from our distributed processing model and slow internet-friendly programming. Read more