Gurpreet Kaur Email and Phone Number
• Implemented Copy activity, Custom Azure Data Factory Pipeline Activities for On-cloud ETL processing using various databases including Snowflake Database.• Migrated data from on-premises databases to Cloud databases/Snowflake using ADF.• Created Pipelines in ADF using Linked Services/Datasets/Pipeline/ to Extract, Transform, and load data from different sources like Azure SQL, Blob storage, AWS S3 to snowflake warehouse.• Participated in a collaborative team designing software and developing a Snowflake data warehouse within ADF.• Created ADF package to load the data from sales_warehouse_product and sales_warehouse_detail tables by using merge join and loaded into respective fact table i.e. Fact Inventory Sales in order to accomplish Inventory Sales Report. Implemented snow pipes to auto ingest the data from various file formats (Parquet,Json,CSV) to snowflake tables• Implemented timestamp-based CDC and SCD type1 and type2 using ADF pipelines to capture delta in snowflake.• Experience in Migrating MS SQL server, Teradata objects into Snowflake environment.• Created Snowflake Stages for copying the Data from Various types of files like Parquet, Json, and csv to Snowflake tables by.• Created snowflake tasks for various types of schedules.• Design and developed batch and real-time data processing layer.• Overseen the migration of data from legacy systems to new solutions.• Design & implement migration strategies for traditional systems on Azure (Lift and shift/Azure Migrate, other third-party tools).• Experienced as On-Call 24x7 production DBA support.• Interacted with diverse clients constantly, promoting excellent communication and client service skills.• Experienced in Oracle 11g ,12c, 18c, and 19c architecture.• Automated manual DBA tasks by writing UNIX Shell Scripting, and Oracle PL/SQL language (stored procedure, functions, and packages) and Implemented UNIX Scripts using CRONJOB for daily activities and Windows Task Scheduler.• Good Experience in implementing GoldenGate homogeneous, heterogeneous, and replicating databases using the golden gate and implemented unidirectional and Bi-directional replication on oracle databases.
Geologic Systems Ltd.
View- Website:
- geologic.com
- Employees:
- 132
-
Database AdministratorGeologic Systems Ltd. Aug 2023 - PresentCalgary, Alberta, Canada
-
Oracle Goldengate AdministratorSuncor Apr 2021 - Oct 2022Calgary, Alberta, Canada• Worked with clients, system admins, and developers to define information flow helping to transform business requirements into the environment-specific database.• Experienced working with multiple development methodologies such as Agile.• Upgrading Mobila Modernization project from 12c to 19c.• Installed and configured of GoldenGate on 19c database for data replication.• Setup goldengate during database migration from UNIX to Linux server. Analyzed database requirements fordevelopers and business system analysis.• Involved in database troubleshooting and maintenance activities and solved Goldengate issues such like abend, lagging, long transaction issues.• Resolved the issues in conflicts between the target and source database in Goldengate.• Good understating of GG monitoring via GG Monitor and Veridata.• Installed and configure Oracle Goldengate 19c and implemented DDL and Bi-directional replication.• Experienced in Oracle 11g, 12c, 18c, and 19c architecture.• Good Experience in implementing Goldengate classic architecture homogeneous, heterogeneous, and replicating databases using the goldengate and implemented unidirectional and Bi-directional, Peer-To- Peer replication on oracle databases.• Installed and configured Goldengate Jagent to work with OEM GoldenGate Plugin.• Good knowledge of Goldengate microservices 21c.• Created database links to retrieve data from multiple servers.• Performed Schema level and Table level data refreshes from production to QA/Dev environments using Datapump EXPDP/IMPDP.• Automated manual DBA tasks by writing UNIX Shell Scripting, Oracle PL/SQL language and Implemented UNIX Scripts using CRONJOB for daily activities and Windows Task Scheduler. -
Database AdministratorCintra Software And Service Hr May 2018 - Sep 2019India• Experienced as On-Call 24x7 production DBA support.• Worked with clients, system admins, and developers to define information flow helping to transform business requirements into the environment-specific database.• Well versed with different topologies of GoldenGate implementation. • Planned and upgraded databases using Patch Set Updates (PSU).• Performed Zero Downtime migrations from Non Exadata machines to Exadata machines using Oracle GoldenGate.• Monitored and performance tuning of Goldengate sessions at Database level and GGSCI level and investigated failures using ggserr.log, report files, and LogDump utility. • Upgraded Oracle Goldengate from 11gR2 to 12c, implemented OGG 12c new features in mission-critical production environment. • Maintained Oracle Database and PL/SQL Code used to enhance features for Billing Systems.• Responsible for the creation and management of users, roles, profiles, and privileges.• Created primary structures such as tablespaces, tables, views, and indexes.• Increased department-wise utilization and productivity by 15%. -
Associate Database AdministratorKrishna Innovative Software Private Limited May 2016 - Apr 2018India• Developed and participated in database upgrade and patching.• Developed and worked in a RAC environment and also experienced in DataGuard.• Created database installations on client machine/server and handled overseas operations.• Hands-on experience in planning, designing, cloning, and refresh using ACTIVE, Manual, and RMAN. Oracle Backups and Recovery tasks such as complete/incomplete recovery block recovery, export/import logical and physical backup.• Checked and monitored the database’s performance every day and took preventive or corrective action. -
Junior Database AdministratorAnr Software Pvt. Ltd. Aug 2014 - Mar 2016IndiaKey Responsibilities-Responsible for creating and managing tablespace and datafiles.-Installed, configured and managed database in UNIX/LINUX environments.-Maintained and updated the database schemas (Like schemas refresh) as requested by the Lead Oracle DBA.-Performed on request of change release upgrade.
Gurpreet Kaur Education Details
-
Computer Science
Frequently Asked Questions about Gurpreet Kaur
What company does Gurpreet Kaur work for?
Gurpreet Kaur works for Geologic Systems Ltd.
What is Gurpreet Kaur's role at the current company?
Gurpreet Kaur's current role is Azure Data Engineer | ETL Developer | Oracle Database Administrator | Oracle Certified | Oracle Golden Gate | Agile.
What schools did Gurpreet Kaur attend?
Gurpreet Kaur attended Lovely Professional University.
Who are Gurpreet Kaur's colleagues?
Gurpreet Kaur's colleagues are Christine Liu, Shirin R., Henry "ted" Kernan, Michael Macleod, Crystal Rhyno, Andrea Svenningson, Daniel Vilela (Mba, Bsc).
Not the Gurpreet Kaur you were looking for?
-
-
-
Gurpreet Kaur
Stoney Creek, On2gmail.com, extentia.com -
gurpreet kaur
Bridgetown, Ns -
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial