Roles & Responsibilities
Key Responsibilities:
1. Database Architecture & Strategy
- Define and govern database architecture standards for PostgreSQL, MySQL, MongoDB (and related technologies).
- Design scalable multi-tenant SaaS database architecture supporting 3,000+ concurrent users.
- Lead architectural decisions for high availability, failover strategy, geo-replication, and sharding.
- Drive database modernization initiatives and cloud migration strategies.
- Establish long-term database capacity planning aligned with product roadmap.
2. High Availability, Scalability & Performance Leadership
- Architect and manage clustering, replication, mirroring, standby, and failover strategies ensuring ≥99.9% uptime.
- Lead performance tuning initiatives for multi-terabyte, high-volume transaction systems (millions of records/day).
- Design indexing, partitioning, query optimization, and workload balancing strategies.
- Conduct proactive performance audits and system health reviews.
3. Cloud & Infrastructure Governance
- Own database environments across AWS, Azure, and GCP (RDS, Cloud SQL, Azure DB).
- Optimize cloud database cost models (FinOps alignment).
- Define infrastructure sizing standards and resource utilization benchmarks.
- Lead DR strategy with clearly defined RPO/RTO and conduct DR simulation exercises.
4. Security, Compliance & Risk Management
- Establish database security frameworks including encryption (at rest & in transit), RBAC, auditing, and masking.
- Ensure compliance with enterprise security standards and regulatory requirements.
- Conduct periodic security reviews and vulnerability assessments.
- Govern database access approvals and change management processes.
5. DevOps, Automation & CI/CD Integration
- Design database automation frameworks using Bash, Python, Infrastructure-as-Code.
- Integrate database deployment pipelines into CI/CD processes.
- Standardize database version control, schema migration, and rollback procedures.
- Implement observability frameworks using monitoring tools (Prometheus, Datadog, New Relic, etc.).
6. Change Governance & Quality Control
- Review and approve database design changes before QA and production deployment.
- Establish database code review standards (SQL, stored procedures, indexing).
- Ensure database best practices are followed across development teams.
7. Leadership & Cross-Functional Collaboration
- Mentor and guide junior DBAs and database engineers.
- Act as escalation point for complex database incidents.
- Work closely with Product, Engineering, DevOps, and Security leadership.
- Provide executive-level reporting on database health, capacity, and risks.
8. Innovation & Technology Evaluation
- Evaluate emerging database technologies (Distributed DB, NewSQL, NoSQL, AI-driven DB ops).
- Recommend architectural improvements aligned with business scalability goals.
- Lead PoCs for new database platforms or performance frameworks.
Required Qualifications:
- 8–12+ years of progressive experience in database administration and architecture.
- Proven expertise managing multi-terabyte, high-transaction, multi-tenant SaaS environments.
- Deep hands-on experience with PostgreSQL (mandatory), MySQL, MongoDB.
- Strong experience with AWS, Azure, or GCP managed database services.
- Expertise in clustering, replication, high availability, and distributed systems.
- Strong Linux administration knowledge.
- Experience with containerization (Docker, Kubernetes) and cloud-native deployments.
- Strong scripting capability (Bash, Python, SQL).
- Demonstrated experience in leading database strategy or technical ownership.
Preferred Qualifications:
- Experience with MSSQL, Oracle, Cassandra (or distributed NoSQL systems).
- DBA Certifications (Oracle, PostgreSQL, MySQL).
- AWS/Azure Professional-level certifications.
- Experience in SaaS multi-tenant product environments.
- Exposure to DevOps maturity models and SRE principles.
