Dedicated and results-driven Database Administrator with over 7 years of hands-on experience in managing, optimizing, and securing critical database systems. Adept at orchestrating complex database environments while ensuring data integrity, availability, and performance. Proficient in a wide range of database technologies, with a strong command of Microsoft SQL Server and Oracle Database. Team-oriented with strong work ethic.
Overview
7
7
years of professional experience
1
1
Certification
Work History
Database Administrator
Comfort Therapeutic Services
08.2018 - Current
Achieved 99.99% uptime for critical SQL Server services and databases, minimizing downtime impact on end users.
Performed daily backups, reducing data loss potential by 98% and ensuring rapid recovery in case of failures.
Review, install, test, schedule, and move to production all security patches for all environments, including database engine, SSIS, SSAS, SSRS
Efficiently managed user access requests, averaging 20 permissions changes per week to align with evolving needs.
Monitor SQL Server and Windows Server performance, making adjustments when necessary following approved technical and Change Control procedures
Streamlined ETL processes by automating 25+ SQL Server Agent jobs, reducing manual intervention by 80%.Design, document, and implement database schema and ETLs
Enhanced query performance by optimizing and tuning 50+ stored procedures, resulting in 40% reduction in execution time.
Optimized SQL Server performance by proactively identifying and resolving bottlenecks, resulting in 15% improvement in query response times.
Implemented Transparent Data Encryption (TDE) for all SQL Server databases, enhancing data security and compliance with industry standards.
Conducted monthly capacity planning assessments, ensuring databases had sufficient resources, reducing performance-related issues by 15%.
Created technical documentation for database related information
Assist end users with database related issues and requests
Worked with cross-functional teams to develop and implement procedures to prevent data loss and maximize system availability.
Developed scripts and processes for data integration and maintenance.
Regularly communicated database status to senior management through weekly reports, facilitating informed decision-making.
Oracle Database Administrator (contractor)
FedEx
12.2016 - 01.2018
Collaborated with cross-functional teams to plan and execute functional tests, resulting in 20% reduction in post-release defects.
Resolved complex technical issues within assigned applications, achieving average problem resolution time of 48 hours.
Maintained, organized, and accessible knowledge repository, consisting of SOP documents, facilitating knowledge transfer and improving team productivity.
Achieved 99.9% responsiveness rate in addressing production issues, minimizing downtime and ensuring continuous service availability.
Successfully improved database performance by optimizing SQL queries and configurations, resulting in 30% reduction in query response times.
Performed seamless installations and maintained database software, minimizing disruptions and ensuring up-to-date software versions.
Manage backup and recovery of databases using RMAN and/or Network Appliance Snapshots.
Implemented robust security measures in compliance rate with corporate data security policies.
Developed database procedures, triggers, and SQL scripts to streamline data processing for development teams, reducing data processing time by 25%.
Contributed to defining and implementing database standards, resulting in greater consistency and adherence to best practices.
Conducted proactive database monitoring, reducing error-related downtime by 15% and improving system reliability.
Education
Bachelor of Science - Data Management/Data Analytics