HamburgerMenu
hirist

Opstree Solutions - Database Administrator - MySQL/PostgreSQL

OpsTree Solutions
Bangalore
3 - 5 Years
star-icon
3.8white-divider92+ Reviews

Posted on: 17/09/2025

Job Description

Job Description :


- Design and operate scalable, secure, and automated MySQL, PostgreSQL infrastructure on AWS using services such as RDS, or self-managed EC2 instances.

- Champion a culture of automation over manual intervention, reducing repetitive tasks through Infrastructure-as-Code (e.g., Terraform) and scripting (Python, Bash, Go).

- Proactively identify areas of operational toil and implement automated solutions to reduce manual errors, improve efficiency, and increase engineering velocity.

- Lead performance tuning at all levels queries, schema, indexes, and underlying systems ensuring low-latency, high-throughput access patterns.

- Own the lifecycle and execution of major MySQL, PostgreSQL version upgrades, including planning, backward compatibility, rollback readiness, and automation of upgrade workflows.

- Architect and manage scale-out strategies using replication, sharding, or middleware such as ProxySQL, Vitess, or Percona.

- Implement efficient partitioning and data archival strategies to support long-term data retention, cost management, and compliance.

- Ensure alignment with security and compliance standards (SOC 2, PCI DSS, ISO 27001), implementing encryption, role-based access, auditing, and data classification controls. Bring forth database security hardening recommendations and work with the stakeholders to implement and secure the systems.

- Build observability into the database stack using tools like CloudWatch, PMM, or Prometheus/Grafana for real-time health insights and proactive alerting.

- Support high-severity incident response, conduct RCA/postmortems, and lead improvements to prevent recurrence.

- Mentor engineers across teams, set technical standards for DB schema architecture, DB operations, and advocate for reliability best practices.


- Work with multiple teams to identify existing opportunities to optimize and fine tune their queries, DB access patterns and the existing DB system infrastructure.

info-icon

Did you find something suspicious?