Catherine Karachi
Summary
Over 5 years of experience as a SQL Server Database Administrator, managing SQL Server versions 2005 to 2019 across various environments, including Production, Test, and Development. Expertise in installation, configuration, performance tuning, and high availability solutions, ensuring data accuracy and security. Proven track record in proactive database optimization, enhancing system efficiency and reliability. Strong technical skills in SQL Server, Oracle databases, and data migration, focusing on collaboration and meeting tight deadlines.
Overview
8
8
years of professional experience
1
1
Certification
Work History
SQL Server Database Administrator
INALFA Roof Systems
11.2018 - 10.2024
- Executed planning and installation of Microsoft SQL Server from 2005 SP4 to 2019, performing configuration and upgrades during scheduled non-production hours.
- Implemented a comprehensive backup and recovery strategy aligned with the company's SLA for RPO and RTO metrics..
- Enforced data security protocols through user permission management based on least privilege principles, utilizing TDE and DDM technologies.
- Utilized SQL Server Profiler and Extended Events for performance monitoring; ensured database integrity through regular checks.
- Established High Availability and Disaster Recovery options, including Always On configurations and database mirroring for fault tolerance.
- Addressed database integrity issues, resolved performance challenges, and optimized queries through rigorous troubleshooting efforts.
- Provided thorough support for SQL Server databases across multiple lifecycle environments, enhancing operational efficiency.
- Developed detailed documentation on database standards, technology features, and troubleshooting methods.
Junior SQL Server Database Administrator
Crosswinds Global Consulting
01.2018 - 09.2019
- Managed backup and recovery processes for production databases, utilizing third-party tools like LiteSpeed.
- Participated in 24/7 on-call support rotation for production database issues.
- Collaborated with teams to allocate hardware resources for high availability and performance optimization.
- Implemented data warehouse solutions for SQL Server databases, including replication strategies.
- Performed monthly audits of server security, performance metrics, and best practice enhancements.
- Conducted installations and configurations of SQL Server environments for various uses.
- Executed data import/export operations using BULK INSERT techniques and utilities.
- Maintained application performance by focusing on query optimization and resource monitoring.
Helpdesk Technician
Access Home Healthcare & Transportation
01.2017 - 08.2018
- Facilitated Service Desk support for end-users via in-person and remote channels.
- Responded quickly to ServiceNow tickets, ensuring timely resolution of requests.
- Delivered day-to-day telephone assistance to the end-user community.
- Monitored existing incidents in ServiceNow, prioritizing tickets by criticality.
- Provided Tier II support for hardware and software installation and troubleshooting.
- Resolved network connectivity issues while maintaining software functionality.
Education
Bachelor’s degree - political science, Information Technology
University of Waterloo
CanadaBachelor’s degree - international relations
International University
Nairobi, KenyaTraining program - SQL Server 2016, SQL server 2017 Administration, SQL server 2019 Administration, TSQL Programming
KiawiTech Consulting LLC
Skills
- Database performance optimization
- SQL Server administration
- High availability solutions
- Data security and encryption
- Performance monitoring tools
- Query optimization techniques
- Client interaction skills
- Backup and recovery strategies
- Database troubleshooting expertise
- Relational database management
- Disaster recovery planning
- Database documentation practices
- SQL proficiency and installation
Certification
- MCSA SQL Server 2016 Database Administration
- Pursuing 70-764 Administering a SQL Database infrastructure
- Pursuing 70-765 Provisioning SQL Databases
References
Available upon request
Timeline
SQL Server Database Administrator
INALFA Roof Systems
11.2018 - 10.2024
Junior SQL Server Database Administrator
Crosswinds Global Consulting
01.2018 - 09.2019
Helpdesk Technician
Access Home Healthcare & Transportation
01.2017 - 08.2018
Bachelor’s degree - political science, Information Technology
University of Waterloo
Bachelor’s degree - international relations
International University
Training program - SQL Server 2016, SQL server 2017 Administration, SQL server 2019 Administration, TSQL Programming
KiawiTech Consulting LLC
Similar Profiles
Alhassan IbrahimAlhassan Ibrahim
Glass Technician at Inalfa Roof SystemsGlass Technician at Inalfa Roof Systems
Donelson TheoduleDonelson Theodule
Line Leader at Inalfa Roof SystemsLine Leader at Inalfa Roof Systems
Kenneth WallerKenneth Waller
Warehouse Supervisor at Inalfa Roof SystemsWarehouse Supervisor at Inalfa Roof Systems
Torrance V. DunnTorrance V. Dunn
SQL Server Database Administrator at Gunnison Consulting Group, Inc.SQL Server Database Administrator at Gunnison Consulting Group, Inc.
Anabil SahaAnabil Saha
Database Administrator(MS SQL Server & PostgreSQL) at SCS Tech India Pvt LtdDatabase Administrator(MS SQL Server & PostgreSQL) at SCS Tech India Pvt Ltd