Priya Raman Senior Database Administrator
Boston, MA • priya.raman@gmail.com • +1 617-555-0182
Profile Summary
- Senior Database Administrator with 8 years of experience operating enterprise SaaS and developer-tooling teams across ticketing, CI/CD, and observability platforms, specializing in high availability, disaster recovery, performance tuning, and zero-downtime change management.
- Well-rounded skill set across relational (PostgreSQL, Oracle), NoSQL (MongoDB), managed cloud (AWS RDS), high availability (Patroni), backup (pgBackRest), schema migrations (Liquibase), and automation (Terraform, Ansible, Python).
- Deep expertise in HA architecture, backup & DR, performance tuning, and change management, leveraging methodologies such as GitOps for DB and compliance audits to drive fast, reliable, and audit-ready database operations across the estate.
- Engaged collaborator working cross-functionally with Platform, SRE, Security, Compliance, and Application teams in regulated SaaS environments, contributing to schema reviews, incident triage, and audit prep with a stability-first mindset.
- Emerging leader who shares technical excellence and fosters a culture of zero-downtime migrations and 99.99% availability through schema-review office hours and DR drills, while leading DBA guild sessions and authoring widely adopted runbook and replication-pattern guides.
Technical Skills
- Relational Databases:
- PostgreSQL, Oracle, SQL Server, MySQL, MariaDB, IBM Db2
- NoSQL & In-Memory:
- MongoDB, Cassandra, DynamoDB, Redis, Elasticsearch
- HA, Replication & Backup:
- Patroni, pgBackRest, Oracle Data Guard, RMAN, Always On AGs, MongoDB replica sets
- Cloud & Managed Services:
- AWS RDS, AWS Aurora, Cloud SQL, Azure SQL, RDS Proxy, AWS Backup
- Performance & Tuning:
- pg_stat_statements, AWR/ASH, SQL Profiler, Performance Insights, EXPLAIN ANALYZE, index tuning
- Security & Compliance:
- TDE, TLS in transit, Kerberos, LDAP, AAD, row-level security, SOX, HIPAA, PCI, GDPR
- Automation & IaC:
- Terraform, Ansible, Python, Bash, PowerShell, Liquibase, Flyway, GitHub Actions
- Monitoring & Observability:
- Datadog, Prometheus + Grafana, CloudWatch, pgwatch2, Sentry, New Relic
Education
Work Experience
- Led installation, configuration, and upgrades across multi-region AWS RDS and self-managed estates, standardizing patch and parameter workflows behind Datadog dashboards, and shipped 3 major-version upgrades across 18 clusters with rolling cutovers, blue-green swaps, and zero data loss.
- Owned backup, recovery, and DR for 42 databases using pgBackRest with point-in-time recovery, ran weekly restore drills end-to-end across two geo-redundant regions, and held RPO ≤ 5 min and RTO ≤ 30 min across every quarterly DR test.
- Stood up streaming replication and automated failover with Patroni across 18 production clusters, tuned witness quorum and connection routing through HAProxy, drove median failover to under 30 seconds, and lifted database availability from 99.9% to 99.99%.
- Owned performance monitoring and tuning using pg_stat_statements and execution-plan analysis, reindexed hot tables, partitioned the orders surface, cut p95 query latency from 840 ms to 120 ms, and sustained 12k QPS peak through Black Friday traffic.
- Led security, access control, and compliance work: rolled out encryption at rest with AWS KMS, automated secrets rotation through HashiCorp Vault, layered row-level security, ran SOX and PCI audits with read-only auditor roles, and closed 47 findings across 3 audit cycles.
- Partnered with platform teams on schema change and release management via Liquibase, gated DDL through twice-weekly review boards, change windows with rehearsed rollback playbooks, and read-only auditor sign-off, shipping 220 migrations with 0 production outages.
- Drove automation and Infrastructure as Code for provisioning and routine ops using Terraform and Ansible, replaced ticket-based work with 14 self-service runbooks wired into GitHub Actions, and cut on-call toil by 60% in two quarters.
- Managed Oracle Data Guard standbys for the legacy core, automating switchover and recovery with RMAN and custom Python tooling, cutting failover drill time from 4 hours to 35 minutes.
- Owned capacity planning and storage for a 40 TB estate, partitioning hot tables, archiving cold data to S3, and reclaiming 9 TB of storage while keeping read latency flat.
- Established change management discipline with peer reviews on every DDL and a staging-before-prod gate, holding production-deploy success rate at 99.5% across 180 releases.
- Mentored 2 junior DBAs, authored 6 runbooks (failover, RMAN restore, deadlock triage, replication health, capacity review, audit prep), and ran the on-call rotation for 15 production schemas.