Rachel Thompson

• Phone: +1 416 555 0123
• Email: rachel.thompson@email.com
• Location: Toronto, Canada
• LinkedIn: rachelthompson_dbarch

Summary

Over 10 years of experience designing, implementing, and optimizing complex database architectures for enterprise-level applications. Led the migration of critical business systems to cloud-native database solutions, improving data processing efficiency by 30% and reducing operational costs by 15%. Expertise in data modeling, performance tuning, and ensuring data integrity and security across diverse environments.

Experience

Lead Database Architect, Maple Leaf Technologies -- Toronto, Canada

Mar 2019 – present

• Architected and oversaw the implementation of a new data warehousing solution using Snowflake, processing over 10TB of data daily with a 40% reduction in query execution times.

• Developed and enforced database design standards and best practices across 5 development teams, resulting in a 25% decrease in database-related incidents.

• Led the evaluation and selection of new database technologies, including NoSQL databases, to support evolving business requirements and improve scalability.

• Mentored junior database administrators and developers, fostering a culture of continuous learning and technical excellence.

Senior Database Architect, Northern Data Solutions -- Toronto, Canada

Aug 2014 – Feb 2019

• Designed and optimized relational database schemas for high-traffic e-commerce platforms, supporting over 1 million transactions per day.

• Implemented robust backup and recovery strategies for critical production databases, achieving 99.99% data availability.

• Collaborated with software development teams to integrate database solutions, ensuring efficient data access and application performance.

• Performed regular database performance tuning and capacity planning, proactively identifying and resolving potential bottlenecks.

Database Administrator, Ontario Digital Innovations -- Toronto, Canada

June 2011 – July 2014

• Managed and maintained SQL Server and Oracle databases, ensuring optimal performance and reliability.

• Developed and automated routine database maintenance tasks, improving operational efficiency by 20%.

• Assisted in the design and implementation of database security policies and procedures.

• Provided first-line support for database-related issues, resolving incidents within service level agreements.

Education

University of Toronto, Master of Science in Computer Science -- Toronto, Canada

Sept 2010 – May 2011

Ryerson University (now Toronto Metropolitan University), Bachelor of Science in Computer Science -- Toronto, Canada

Sept 2006 – May 2010

Skills

Database Technologies: SQL Server, Oracle, PostgreSQL, MySQL, Snowflake, Azure SQL Database, AWS RDS, MongoDB, Cassandra, Redis

Cloud Platforms: Microsoft Azure, Amazon Web Services (AWS), Google Cloud Platform (GCP)

Data Modeling & Design: Dimensional Modeling, ERD, Schema Design, Normalization, Denormalization, Data Warehousing

Performance & Optimization: Query Optimization, Indexing Strategies, Performance Tuning, Capacity Planning, Database Monitoring

Programming & Scripting: T-SQL, PL/SQL, Python, PowerShell, Bash

Tools & Methodologies: SSIS, SSRS, SSAS, Informatica, ETL Tools, Data Governance, Backup & Recovery, High Availability, Disaster Recovery