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
Junior Database AdministratorTechSolutions Inc.
- 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
- 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
- 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
- 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
- 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
- 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