TemplateA ready-made website. Make it yours in a click.
Copy this website

Summary

Experience

Junior Database AdministratorTechSolutions Inc.
San Francisco, CAJun 2022Present
  • 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.
Database InternDataFlow Solutions
San Jose, CAJun 2021May 2022
  • 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

E-commerce Database Design & Implementation
Sep 2021Dec 2021
  • Designed and implemented a normalized relational database schema for an e-commerce platform using PostgreSQL, supporting complex product catalogs and order processing.
Database Performance Monitoring Dashboard
Mar 2022May 2022
  • 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.
Automated Database Backup Script
Jan 2023Present
  • 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

San Jose State UniversityBachelor of Science in Information Technology
San Jose, CAAug 2018May 2022
  • 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'

Skills

Database Systems
MySQLPostgreSQLSQL ServerOracleMongoDB (NoSQL)
Database Tools & Administration
SQLT-SQLPL/SQLSSMSPgAdminDBeaverToadDataGripAWS RDS
Operating Systems & Scripting
Linux (Ubuntu, CentOS)Windows ServerBash ScriptingPython
Concepts & Practices
Database DesignNormalizationBackup & RecoveryPerformance TuningSecurityETL