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
Senior Database AdministratorCloudVista Technologies
- 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.
Database AdministratorInnovate Solutions Inc.
- 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
Automated Database Health Check Script
- 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.
Cloud Cost Optimization for RDS Instances
- 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.
SQL Performance Dashboard (Grafana Integration)
- 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
University of WashingtonBachelor of Science in Computer Science
- 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
Skills
Database Systems
SQL Server (2012-2022)MySQLPostgreSQLAzure SQL DatabaseAWS RDSOracle (basic administration)
Cloud Platforms
AWS (EC2, RDS, S3, CloudWatch, Lambda)Azure (SQL Database, VMs, Data Factory)GCP (Cloud SQL)
Database Tools
SSMSAzure Data StudioRedgate SuitedbForge StudioDataGripSQL Profiler
Scripting & Automation
T-SQLPowerShellPythonBashSQLCMD
Concepts & Methodologies
High AvailabilityDisaster RecoveryPerformance TuningData ModelingETLSecurity ManagementBackup & RecoveryIndexing Strategies