Mayur Patel Email & Phone Number

Caledon, Ontario, Canada

• Provides support of the software product installation, configuration, maintenance, upgrade, user account administration, troubleshooting, system/database monitoring, capacity planning and performance tuning for production, development, test and training databases in a Microsoft SQL and Oracle database environments.• Design, develop, and create AMANDA folders, processes, checklists.• Design and develop Oracle PLSQL stored procedures, functions, etc.• Deploy, troubleshoot, and… Show more • Provides support of the software product installation, configuration, maintenance, upgrade, user account administration, troubleshooting, system/database monitoring, capacity planning and performance tuning for production, development, test and training databases in a Microsoft SQL and Oracle database environments.• Design, develop, and create AMANDA folders, processes, checklists.• Design and develop Oracle PLSQL stored procedures, functions, etc.• Deploy, troubleshoot, and optimize solutions to AMANDA running on Apache Tomcat application Server.• Patching and upgrading AMANDA with latest versions.• Ensure the performance, quality, and responsiveness of applications.• Establishes database backup and recovery standards and procedures. Provides backup and recovery services. Monitor daily, weekly and monthly data backups, if required restore databases.• Maintain database security by implementing the security policies, evaluating trends, anticipating security requirements, and applying security patches and fixes to Always on clustering SQL Server and Oracle database environment.• Design and implement data-marts, data extraction, data transformation, data load processes, and procedures through ELT and/or ETL methodologies. Provide support on existing data structures, processes, and procedures.• Database migration from on premise SQL database 2016,2019 to Azure Databases. • Provide professional and technical expertise in design and operation of Datawarehouse (DWH), Master Data Management (MDM), and Business Intelligence (BI) initiatives by implementing database technologies, data governance, data quality, data extraction, data load, data consistency and accuracy, data security, and availability components and produce reports and dashboards for KPIs . Managing various reports with PowerBI, SSRS and Crystal Reports for Town’s reporting portal. Show less

Regina, Saskatchewan, Canada

• Design & implement stored procedures, views, triggers & other application database code objects• Maintained SQL scripts indexes and complex queries for analysis and extraction.• Ensured best practice application to maintain security and integrity of data.• Query optimization for developers group across the organization• Design & create various relational databases & to ensure data retrieval that optimize statistical efficiency, data quality• Locate and define new process… Show more • Design & implement stored procedures, views, triggers & other application database code objects• Maintained SQL scripts indexes and complex queries for analysis and extraction.• Ensured best practice application to maintain security and integrity of data.• Query optimization for developers group across the organization• Design & create various relational databases & to ensure data retrieval that optimize statistical efficiency, data quality• Locate and define new process improvement opportunities• Creating maintenance job using SSIS Packages for Transformed data from one server to another server.• Maintaining linked servers across various database instances• Design SQL Server SSIS & DTS Packages for extract, transform & load (ETL) for data manipulation & data cleansing• ETL for new ERP system from various sources using Information Builders Data Migrator Tool (DM).• Developing and Maintaining Database backup weekly and monthly jobs and restoring if required.• Database Migration from SQL Server 2005 to 2012, SQL Server 2005 to 2008R2, SQL Server 2008 R2 to 2016.• Database Upgradation from SQL Server 2008 R2 to 2012, 2016. Show less

Ontario, Canada

• Provides support of the software product installation, configuration, maintenance, upgrade, user account administration, troubleshooting, system/database monitoring, capacity planning and performance tuning for production, development, test and training databases in a Microsoft SQL and Oracle database environments.• Establishes database backup and recovery standards and procedures. Provides backup and recovery services. Monitor daily, weekly and monthly data backups, if required restore… Show more • Provides support of the software product installation, configuration, maintenance, upgrade, user account administration, troubleshooting, system/database monitoring, capacity planning and performance tuning for production, development, test and training databases in a Microsoft SQL and Oracle database environments.• Establishes database backup and recovery standards and procedures. Provides backup and recovery services. Monitor daily, weekly and monthly data backups, if required restore databases.• Maintain database security by implementing the security policies, evaluating trends, anticipating security requirements, and applying security patches and fixes to Always on clustering SQL Server and Oracle database environment.• Design and implement data-marts, data extraction, data transformation, data load processes, and procedures through ELT and/or ETL methodologies. Provide support on existing data structures, processes, and procedures.• Provide professional and technical expertise in design and operation of Datawarehouse (DWH), Master Data Management (MDM), and Business Intelligence (BI) initiatives by implementing database technologies, data governance, data quality, data extraction, data load, data consistency and accuracy, data security, and availability components and produce reports and dashboards for KPIs . Managing various reports with PowerBI, SSRS and Crystal Reports for Town’s reporting portal.• Responsible for data analysis and database management. Involved in maintenance, enhancement, designing of data dictionaries, physical and logical database models, and performance tuning. Familiar with AMANDA Licensing software by CSDC, Laserfiche Licensing software by Ricoh, CAMS Licensing software by White Acre. Maintaining and contacting relation with various Software Vendors for continues and effective support. • Managing Helpdesk tickets via Track-IT and maintaining ratio of pending tickets below 10 per month. Show less

Saskatchewan, Canada

• Design & implement stored procedures, views, triggers & other application database code objects• Maintained SQL scripts indexes and complex queries for analysis and extraction.• Ensured best practice application to maintain security and integrity of data.• Query optimization for developers group across the organization• Design & create various relational databases & to ensure data retrieval that optimize statistical efficiency, data quality• Locate and define new process… Show more • Design & implement stored procedures, views, triggers & other application database code objects• Maintained SQL scripts indexes and complex queries for analysis and extraction.• Ensured best practice application to maintain security and integrity of data.• Query optimization for developers group across the organization• Design & create various relational databases & to ensure data retrieval that optimize statistical efficiency, data quality• Locate and define new process improvement opportunities• Creating maintenance job using SSIS Packages for Transformed data from one server to another server.• Maintaining linked servers across various database instances• Design SQL Server SSIS & DTS Packages for extract, transform & load (ETL) for data manipulation & data cleansing• ETL for new ERP system from various sources using Information Builders Data Migrator Tool (DM).• Developing and Maintaining Database backup weekly and monthly jobs and restoring if required.• Database Migration from SQL Server 2005 to 2012, SQL Server 2005 to 2008R2, SQL Server 2008 R2 to 2016.• Database Upgradation from SQL Server 2008 R2 to 2012, 2016. Show less

India