Summary
Dedicated Junior Database Administrator with 2 years of experience in managing, optimizing, and securing relational databases. Proven ability to support critical database operations, implement backup and recovery strategies, and ensure data integrity. Eager to leverage strong SQL proficiency, problem-solving skills, and a commitment to efficient data management in a dynamic technology environment.
Experience
- Managed and maintained over 50 production databases (SQL Server, MySQL), ensuring 99.9% uptime for critical business applications.
- Implemented and monitored daily backup and recovery procedures, reducing potential data loss by 15% through optimized schedules.
- Supported senior DBAs in monitoring database performance metrics and identifying bottlenecks for SQL Server instances.
- Developed and maintained documentation for database configurations and operational procedures, improving onboarding efficiency by 10%.
Projects
- Designed and implemented a normalized relational database schema for an e-commerce platform using PostgreSQL, supporting complex product catalogs and order processing.
- Developed a Python script utilizing `psutil` and database client libraries to collect real-time CPU, memory, and query execution metrics from MySQL instances.
- Integrated data into a simple web dashboard using Flask to visualize key performance indicators, aiding in proactive issue identification.
- Streamlined performance data collection process, reducing manual monitoring time by 15 hours per month.
- Created a Bash script to automate daily full and weekly differential backups for multiple PostgreSQL databases, ensuring data resilience.
- Implemented secure remote storage (SFTP) for backup files, enhancing data security and disaster recovery capabilities.
- Configured logging and email notifications for backup job status, achieving 100% visibility into backup success/failure rates.
Education
- Graduated with Summa Cum Laude, GPA: 3.9/4.0
- Awarded Dean's List for 6 consecutive semesters
- Completed a capstone project on 'Scalable Database Design for E-commerce'



