Accomplished Database Administrator with a proven track record at Gemstone Travel Management Systems, adept in data migration and SQL proficiency. Excelled in automating maintenance tasks, enhancing system reliability, and providing exceptional technical support. Demonstrates strong analytical skills and a commitment to optimizing database performance for improved user experience.
Overview
20
20
years of professional experience
1
1
Certification
Work History
Database Administrator/Applications Specialist
Gemstone Travel Management Systems
Sherwood Park, AB
02.2016 - Current
Migrated existing databases from one platform to another with minimal downtime.
Wrote scripts and processes for data integration and bug fixes.
Developed scripts for automating routine maintenance tasks such as index rebuilds and statistics updates.
Developed redundant systems and procedures for disaster recovery and archiving to maintain data protection.
Created new tablespaces for applications to store their data in the database.
Ensured that all the stored procedures are optimized for better performance of the system.
Communicated with data architects, programmers and engineers to keep projects on track.
Analyzed system logs regularly to identify any potential problems or suspicious activities.
Devised reports and visualizations to present requested data in sleek format.
Automated routine database tasks to improve system reliability and reduce manual errors.
Resolved customer queries related to database issues promptly and accurately.
Monitored database performance and implemented changes to improve response times.
Coordinated with other teams such as network administrators and system admins for resolving complex issues.
Provided technical support and training to end-users and junior DBAs.
Database Adminstrator/Web Developer
Pacific Western Transportation
Calgary, Alberta
02.2005 - 01.2016
Converted existing applications by transitioning from Access databases to SQL Server.
Analyzed database applications and made necessary adjustments to parameters and architecture to improve performance.
Monitored database performance and implemented changes to improve response times.
Designed functional queries and enhanced backend reliability through stored procedure maintenance.
Utilized Asp.Net, CSS, JavaScript, and HTML to create Web UI for seamless user experience.
Education
Associate of Science - Computer Information Systems
Keyano College
Fort McMurray
06-2002
Skills
Database analysis
Data conversion and migration
Backup and recovery
Database troubleshooting
Query optimization
SQL proficiency
Index management
Systems administration
Microsoft Azure Administration and Certification (AZ-900 and DP-900)
Certification
Azure AZ-900 Certified
Azure DP-900 Certified
ITIL Certified
Accomplishments
Awarded True Gem Award from Gemstone Travel Management Systems in 2020
Awarded Heavy Lifter Recognition from Gemstone Travel Management Systems for doing a large share of the load for a big project in 2019
Timeline
Database Administrator/Applications Specialist
Gemstone Travel Management Systems
02.2016 - Current
Database Adminstrator/Web Developer
Pacific Western Transportation
02.2005 - 01.2016
Azure AZ-900 Certified
Azure DP-900 Certified
ITIL Certified
Associate of Science - Computer Information Systems
Keyano College
Similar Profiles
Ricky ShawRicky Shaw
Regional Property Manager at Gemstone Property ManagementRegional Property Manager at Gemstone Property Management
Bank and Credit Card Reconciliation Officer at QBT Travel/Corporate Travel ManagementBank and Credit Card Reconciliation Officer at QBT Travel/Corporate Travel Management