Farahnaz Rajaei
Richmond Hill,Canada
Summary
Experienced Data Engineer Lead with a strong background in managing data projects, leading teams, and implementing data solutions using modern cloud technologies. Seeking a position as a Data Engineer Manager to leverage my leadership skills, technical expertise, and passion for innovation in a dynamic environment.
Overview
19
19
years of professional experience
1
1
Certification
Work History
Data Engineer Lead
Ontario Teachers' Pension Plan (OTPP)
05.2023 - Current
- Lead and manage an offshore team to successfully complete projects on time and with the highest quality, inspiring full engagement and a strong sense of responsibility
- Work closely with offshore teams to define and achieve their goals, igniting their passion for growth and inspiring them to excel both professionally and personally
- Build personal connections with team members, ensuring each individual feels heard, valued, and empowered, knowing that their voice and ideas truly matter
- Apply coaching methodologies based on ICF principles to inspire and motivate the team
- Lead and design solutions for replicating data from SQL and Oracle platforms to Snowflake and Azure SQL MI using Fivetran (HVR 6) as the ETL tool
- Design and build Fivetran (HVR 6) solution, including creating the architecture with a hub server in Azure VM and a repository database in Azure SQL
- Ensure disaster recovery and high availability solutions are integrated into the design
- Automate processes using REST API to create channels, manage jobs, and perform data refreshes and comparisons
- Monitor data capture and integration processes
- Use JIRA to manage my tasks, track progress, and ensure alignment with Agile methodologies
- Develop and manage data pipelines using Azure Synapse and Azure Data Factory
- Utilize Azure Arc for on-prem server inventory and monitoring
- Patch all SQL servers across the organization using SCCM, ensuring automatic application of updates
- Manage change management processes using ServiceNow.
Senior SQL DBA
EOne Entertainment
10.2019 - 05.2023
- Managed DEV, STG, UAT, and Production environments on Microsoft Azure
- Created managed SQL instances and migrated SQL databases from on-premises to Azure using Microsoft Data Migration Assistant
- Designed and implemented high-availability solutions, including replication and disaster recovery setups on Azure
- Led the migration of SSIS from on-premises to Azure, integrating Oracle clients on Azure VMs
- Monitored server health, performed backups, and ensured data integrity across environments.
Senior SQL DBA
Healthcare of Ontario Pension Plan (HOOPP)
09.2018 - 09.2019
- Created DEV, UAT, and Production environments on Microsoft Azure
- Managed migration projects from SQL 2008 R2 to SQL 2016
- Utilized Azure DevOps for task management and sprint planning in an Agile environment
- Monitored SQL servers using Spotlight and provided daily issue resolutions
- Collaborated with DevOps teams to automate processes and improve operational efficiency.
SQL Database Administrator / Project Manager
TD Bank
09.2016 - 09.2018
- Led the migration of servers from Windows 2003 to Windows 2012, following TD Bank's rigorous processes
- Installed and configured SQL Server instances in clustered and standalone environments
- Managed database migrations and ensured the secure transfer of data, including logins and jobs
- Acted as a project manager, overseeing the execution of multiple database migration projects
- Utilized Agile methodologies to manage project timelines, budgets, and resources.
SQL Database Administrator
IBM
10.2014 - 09.2016
- Provided 24x7 on-call database support for BNS, managing over 700 SQL Server instances
- Installed and configured SQL Server clusters and standalone servers, ensuring high availability
- Managed data migrations and implemented disaster recovery solutions tailored to client needs
- Utilized tools like PSSdiag and SQL Nexus for performance monitoring and troubleshooting.
SQL Database Administrator / Project Manager
PricewaterhouseCoopers (PwC)
05.2007 - 09.2014
- Managed complex database migration projects, including the migration of databases to a data center in India
- Worked closely with architects and storage teams to design server infrastructure and storage solutions
- Installed and configured SQL Server instances, including SSRS, SSAS, and SSIS
- Provided continuous monitoring and real-time analysis of SQL Server performance
- Led the setup of a 6-node A/A SQL Server 2008 R2 cluster for an audit application.
Microsoft SQL Server Support Engineer
Microsoft
10.2005 - 05.2007
- Provided support and consultation for SQL Server 2000/2005 production databases across North America
- Advised clients on best practices for database development, administration, and performance optimization
- Developed and implemented backup/restore and disaster recovery strategies
- Resolved complex issues related to database corruption, performance bottlenecks, and security.
Education
Bachelor of Science in Computer Engineering (Software) -
Azad University, Tehran
01.1998
Snowflake Fundamentals Course -
Skills
- SQL
- Python
- Strong communication
- Team leadership
- Problem-solving
- Collaboration
- Agile methodologies
- Scrum
- JIRA
- ServiceNow
- Interpersonal Skills
- Multitasking
- Enterprise information architecture
- Interpersonal Communication
- Adaptability and Flexibility
- Goal Setting
- Problem-solving abilities
- Team building
- Relationship Building
- Task Prioritization
- Database structures
- RDMS Design
- Database Development
- Warehouse models
- Database Design
- SQL and Databases
- Data Migration
- Microsoft Azure
- DevOps processes
Certification
- Microsoft Certified Database Administrator (MCDBA)
- Project Management Certification
- ITIL Certification
- Microsoft Certified Technology Specialist (MCTS) in SQL Server
- Microsoft Certified: Azure Database Administrator Associate
Timeline
Data Engineer Lead
Ontario Teachers' Pension Plan (OTPP)
05.2023 - Current
Senior SQL DBA
EOne Entertainment
10.2019 - 05.2023
Senior SQL DBA
Healthcare of Ontario Pension Plan (HOOPP)
09.2018 - 09.2019
SQL Database Administrator / Project Manager
TD Bank
09.2016 - 09.2018
SQL Database Administrator
IBM
10.2014 - 09.2016
SQL Database Administrator / Project Manager
PricewaterhouseCoopers (PwC)
05.2007 - 09.2014
Microsoft SQL Server Support Engineer
Microsoft
10.2005 - 05.2007
Bachelor of Science in Computer Engineering (Software) -
Azad University, Tehran
Snowflake Fundamentals Course -
Similar Profiles
Prashanth BalagopalPrashanth Balagopal
Business Analyst at Ontario Teachers' Pension PlanBusiness Analyst at Ontario Teachers' Pension Plan
Chahil PatelChahil Patel
Project Assistant at Ontario Teachers' Pension PlanProject Assistant at Ontario Teachers' Pension Plan
Niralee BhattNiralee Bhatt
Analyst, Business Intelligence and Reporting at Healthcare of Ontario Pension PlanAnalyst, Business Intelligence and Reporting at Healthcare of Ontario Pension Plan
Hila NagarHila Nagar
Barista / Bakery Team Member at Olive BranchBarista / Bakery Team Member at Olive Branch
Brandon (Sang Woo) KimBrandon (Sang Woo) Kim
Clinical Student Nurse at North York General Hospital - 7SE NeurologyClinical Student Nurse at North York General Hospital - 7SE Neurology