Priya Raman Senior Database Administrator
Boston, MA • priya.raman.dba@gmail.com • +1 617-555-0182
Profile Summary
- Senior Database Administrator with 8 years of experience running mixed SQL Server and PostgreSQL estates for education technology and records management companies, specializing in high availability, tested recovery, and cloud database migrations.
- Hands-on with relational (PostgreSQL, SQL Server, Oracle Database), NoSQL (MongoDB), managed cloud (Amazon RDS, Amazon Aurora), high availability (Patroni, Always On availability groups), backup (pgBackRest) and monitoring (Datadog), and holds the Microsoft Certified: Azure Database Administrator Associate certification.
- Deep expertise in point-in-time recovery, replication and failover design, index and query plan tuning, and low-downtime cutovers, working from RPO and RTO targets tested in drills and ITIL change management to keep fast, recoverable databases that hold up through semester peaks.
- Trusted partner working daily with application engineers, SRE, security, and the analytics team on an audited SaaS platform that runs around the clock, reviewing schema changes, joining incident calls and preparing the database evidence for each audit.
- Senior DBA who raises the standard for restore testing and change review across the team, while running monthly office hours on execution plans for developers and keeping the runbook library the on-call rotation works from.
Technical Skills
- Relational Databases:
- PostgreSQL, SQL Server, Oracle Database, MySQL, MariaDB
- NoSQL & Caching:
- MongoDB, Redis, Amazon DynamoDB
- HA & Backup Tools:
- Patroni, Always On availability groups, pgBackRest, Oracle RMAN, Oracle Data Guard, AWS Backup
- Cloud Database Services:
- Amazon RDS, Amazon Aurora, AWS DMS, Amazon RDS Proxy, Azure SQL Managed Instance
- Monitoring & Performance Tools:
- Datadog, Query Store, pg_stat_statements, Oracle AWR, execution plans, Grafana
- Security & Compliance:
- Transparent Data Encryption, row-level security, HashiCorp Vault, SQL Server Audit, pgAudit, SOX, SOC 2, FERPA
- Scripting & Automation:
- T-SQL, PL/pgSQL, PowerShell, Python, Bash, Terraform, Ansible, Liquibase
Education
Work Experience
- Upgraded 64 SQL Server instances from 2016 to 2022 a year before Microsoft ended support, and moved 21 PostgreSQL clusters from version 13 to 16 with pg_upgrade in link mode, with no rollbacks across the whole program.
- Rebuilt backups for 310 databases on pgBackRest and native SQL Server backups, with copies in Amazon S3 Object Lock, then ran monthly restore drills that cut tested recovery of the courseware platform from 6 hours to 40 minutes.
- Set up Patroni streaming replication on 14 PostgreSQL clusters and Always On availability groups for the SQL Server tier, with quarterly failover drills that raised database availability for the learning platform from 99.9% to 99.98%.
- Tuned the 45 heaviest queries found in Datadog Database Monitoring and Query Store, adding covering indexes and fixing stale statistics, which brought p95 latency on the gradebook API from 1.4 seconds to 180 ms before the fall semester rush.
- Replaced 180 shared database logins with least-privilege roles, moved credentials into HashiCorp Vault with 30-day rotation and switched on audit logging for student records, closing all 23 database findings from the SOC 2 Type II audit.
- Built the growth forecast for a 48 TB estate, partitioned the student activity tables by month, archived closed terms to S3 and put PgBouncer in front of the busiest clusters, reclaiming 11 TB of primary storage.
- Migrated 120 on-premises SQL Server and Oracle Database databases to Amazon RDS and Amazon Aurora PostgreSQL with AWS DMS, rehearsing every cutover with a rollback path and keeping downtime under 15 minutes per database.
- Moved instance builds to Terraform and Ansible, replaced daily checklists with PowerShell and Python jobs that save 70 hours a month, and sent 640 schema changes through Liquibase review and change control without an outage.
- Ran 38 Oracle 19c databases for the records management platform with Oracle Data Guard standbys and RMAN backups, and scripted the switchover steps so a full drill took 25 minutes instead of an afternoon.
- Wrote T-SQL and PowerShell health checks for 150 SQL Server instances that caught failed jobs, full disks and long blocking chains early, cutting after-hours pages to the database team by 40%.
- Handled the database side of a data center move for 22 customer-facing applications, rehearsing each cutover twice and finishing 3 weeks before the old site’s lease ran out.