Jaymin Soni

I am highly motivated Database Architect with BI developer and project management skills that I have developed over the past 8 years. I am committed to excellence in usability and accessibility standards, as well as project process management and service delivery.

At my current position as ETL Data Conversion Specialist at Advanced Utility System, once of my major responsibilities includes converting North American government client’s legacy data to AUS utility system.

I had served as Database Administrator/Analyst for Kobian Canada Inc. from 2013 to 2016, where I was repeatedly recognized for developing innovative solutions, globally deployed software and systems. I was responsible for complete development life cycle including gathering requirements, analysis, designing, coding, deployment and maintenance. I was also conducting installation, configuration, upgrade and migration of data, as well as backup and recovery, database security, storage and monitoring the database server.

I am able to quickly identify new resolutions that will not only help solve major business problems, but also ensure that the business maintains local, federal and business sector compliance given my extensive research abilities and deep industry knowledge.

Resume

7+ Years of Experience

Education

2012
Sheridan College Brampton, ON

Diploma in Computer System Technician - Software Engineering

2010
H.L. Institute of Comp. Ahmedabad, India

Bachelor in Computer Application

Experience

Jun 2018 - Current
Advanced Utility System

ETL Data Conversion Specialist

At my current position as ETL Data Conversion Specialist at Advanced Utility System, once of my major responsibilities includes converting North American government client’s legacy data to AUS utility system.

Apr 2017 - May 2018
Juice Worldwide

Database Analyst

Data migration and Data conversion • Created and managed scripts for mapping legacy data from legacy database to new database • Wrote scripts to migrate and convert data from legacy system to new system • Wrote triggers and automated scripts to sync data between legacy and new system • Created legacy mapping DB to easily sync legacy and new system’s database. Database Administrator and analyst tasks (AWS RDS, Dynamo DB, MySQL, MSSQL) • Deployed MYSQL databases on Amazon RDS. • Managed multiple MySQL databases on Amazon RDS and MSSQL database. • Developed and maintained MYSQL (Application Database), MSSQL (SSRS Reporting Database), and MYSQL (SSRS Reporting Database). • Managed NoSQL data on Amazon Dynamo DB. • Setup backup, group policy and security on Amazon RDS account • Created development, staging and live database server • Created Stored Procedures, Triggers and Functions via Code Repositories (GitHub with Source tree). • Indexing database tables and improving performance of database.

Jun 2013 - Aug 2016
Hipstreet

Database Administrator/Analyst

I had served as Database Administrator/Analyst for Kobian Canada Inc. from 2013 to 2016, where I was repeatedly recognized for developing innovative solutions, globally deployed software and systems. I was responsible for complete development life cycle including gathering requirements, analysis, designing, coding, deployment and maintenance. I was also conducting installation, configuration, upgrade and migration of data, as well as backup and recovery, database security, storage and monitoring the database server.

Feb 2013 - Apr 2013
Jeds Construction

Web Developer and IT Support

Web development – www.jeds.ca • Designed, coded and modified website, from layout to function and according to requirements. • Regular maintenance of the website to ensure that information and linkages remain timely and accurate including the archiving of obsolete information and inputting of new/updated information. Migrated company infrastructure to MS windows server 2008 R2 • Migrated company infrastructure from windows 7 professional server to MS windows 2008 R2 server. • Installed, configured and setup server 2008 R2 with DNS. • Setup DHCP and company forest. Network Drive setup and permission for each users and groups • Migrated each work station to new server from old server • Daily on going IT support and Backup server installation

Cloud Databases

AWS Relational Database

95%

AWS EC2

80%

AWS S3

85%

SQL Azure Database

90%

Azure Data Factory - ADF

60%

Azure Data Lake - ADL

60%

Azure Data Warehouse

70%

Database Skills

Relational Database

90%

Database Normalization

85%

Backup, Recovery & Security

75%

Performance & Tuning Database

80%

Database Design & Modeling

85%

DFD & ERD

85%

SSRS - Reporting Server

80%

SSIS - ETL Packages

80%

Agile & Iterative Waterfall

80%

Database Migration

90%

Data Conversions

90%

Contact

Get in Touch

647-779-1989

Toronto

jaymin.soni@ymail.com

Freelance Available

How Can I Help You?