Summary
Highly analytical and results-driven Database Administrator with 6 years of experience specializing in SQL Server and AWS cloud environments. Proven expertise in optimizing database performance, ensuring data integrity, and implementing robust security protocols for complex, high-transaction systems. Adept at collaborating with development and operations teams to deliver scalable and efficient database solutions that significantly improve system reliability and reduce operational costs.
Experience
- Designed and implemented high-availability solutions for critical production databases, reducing downtime by 99.99% for mission-critical applications, supporting over 500,000 daily users.
- Optimized SQL queries and database schemas across 30+ production databases, resulting in a 25% average improvement in query response times and a 15% reduction in server load.
- Led the migration of 15 on-premise SQL Server databases to AWS RDS, achieving a 30% cost savings in infrastructure and a 40% increase in deployment agility.
- Developed and automated backup and disaster recovery procedures, ensuring RTO of under 4 hours and RPO of 15 minutes for all Tier-1 data.
- Mentored and provided technical guidance to a team of 3 junior DBAs, enhancing team productivity by 20% through best practices and knowledge sharing.
- Managed and maintained over 50 production and development SQL Server databases, ensuring 99.9% uptime and optimal performance for internal business applications.
- Executed performance tuning strategies, including index optimization and query refactoring, which improved report generation times by an average of 35%.
- Implemented and monitored database security protocols, successfully passing 3 annual SOX compliance audits with zero critical findings.
- Automated routine DBA tasks using PowerShell and T-SQL scripts, reducing manual effort by 15 hours per week and increasing operational efficiency.
- Participated in the design and implementation of new database features, collaborating with a team of 10 developers to deploy 4 major product releases annually.
Projects
- Developed a Python script to automate daily health checks for SQL Server instances, generating comprehensive reports on performance metrics and potential issues.
- Integrated with email notification system, reducing manual monitoring time by 80% and proactively identifying critical database anomalies.
- Open-sourced the script, receiving 50+ stars and forks from the DBA community for its utility.
- Created a PowerShell module to analyze AWS RDS usage patterns and recommend cost-saving opportunities through instance resizing and reservation purchases.
- Identified potential savings of up to 20% on monthly RDS expenditures for non-production environments.
- Implemented a scheduled task to apply recommendations automatically, leading to a measurable reduction in cloud spend.
- Designed and deployed a custom Grafana dashboard for real-time monitoring of SQL Server performance metrics, utilizing Telegraf as a data collector.
- Provides critical insights into CPU, memory, I/O, and query wait statistics, enabling faster root cause analysis for performance bottlenecks.
- Currently extending with anomaly detection features using machine learning models for proactive alerting.
Education
- Graduated with Honors, GPA: 3.8/4.0
- Relevant Coursework: Database Systems, Data Structures & Algorithms, Network Security
- Member of the UW Database Management Student Group

