**Work on multi-billion projects for thousands users, setup, configure Azure resources in DEV, TEST, UAT, PROD; Create databases, design tables, views, indexes, other objects for projects in Azure Managed Instances, Single Databases, Synapse, Tableau & Azure VMs**Plan, Install, Configure & work with SQL 2005-2022, Azure, maintenance, setup, deployment using github CI/CD pipeline, Sybase ASE, troubleshoot performance for client applications**Use Extract, Load Transform (ETL/ELT), Azure Data Factory, Azure Synapse; Using Power BI, Power Query Editor, MDX, Power BI desktop, Power BI service, DAX for DIMA reports**Work with Synapse workspaces, Configure Synapse Dedicated SQL Pools, Azure Data Lake Gen-2 storage account**Use Azure Postgres, Sybase backups, design & Cosmos DB, capacity planning, Pricing, Develop and maintain best practices, guidelines for Cosmos DB design, implementation; design and optimize data access and queries, Microsoft Fabric**Participate in problem analysis, resolution including deadlocks, performance, access times, application recoveries; write T-SQL queries, triggers, data definition, manipulation languages for new projects and existing databases**Work on new projects on-premises and Azure SQL DB environment, migrate databases to Azure**Find slow reports in Power BI. Checked TSQL to find the right tables and columns from Power BI. Run query in SSMS, MongoDB. execution plan for queries**Use DMVs for UPDATE STATS on index/column. Find missing indexes, outdated STATS and SQL joins, check index fragmentation, re-write queries**Create indexes, check Azure portal Query performance Insight, Performance Recommendations**Create Databases, Replication Instances in Azure, AWS, migration, DMS, create source/target endpoints for SQL migration to Cloud, Core concepts of DBMS, Server administration, maintenance; used Cherwell and ServiceNow**Manage SQL Prod, UAT, Staging, Test & Dev databases, Azure SQL, IaaS, PaaS in high-availability

*** Installation, Configuration, Troubleshooting, Backups, Restores, Recovery, Database Refresh, SSIS, Azure SQL Databases, Patching, Always-ON Availability Groups, Always On Failover Clusters Instances (FCI), Integration Services, Reporting Services, SQL Server Automation, Azure Data Factory, Replication, Failover Groups, Database mirroring, Log Shipping, Apply Hotfixes, Patches and Service Packs.*** Install, configure and supporting Reporting Services (SSRS), Integration Services (SSIS), Analysis Services (SSAS) running on SQL2012, 2014, 2016, 2017. Responsible for support installation, configuration, security, operation, and maintenance of SQL Servers and new servers builds on SQL 2019 and Azure manage instances*** Design and implement database components, performance tuning, monitoring, *** Cloud database authentication and security, Cloud Database migration using DMA and Database Migration Services, Cloud database monitoring and cost estimates*** Creating new Azure databases using SQL Databases, Managed Instances, VM on Azure, migrating on-Premise to Azure PostGres databases and Azure SQL databases, Performance Tuning*** DB Refreshes/Restores, Handling Daily W.O, SRs, Change/Release Tickets, Cleaning spaces, Releases to Prod, Test/QA, New Projects work, troubleshooting; DB Administration, large scale Enterprise data processing, Backups Recovery, Cloning, Create Databases and objects, Automation Jobs, Database Maintenance, Migrate Objects & data from Dev to Test to Production.

Working with IT division, Government of Sask, I am supporting physical and Virtual Servers VMware on SQL Server instances running on Premises and Azure Cloud as DBA, using SQL 2019, SQL2017, SQL2016, SQL2014, SQL Server 2012 (R2), SQL 2008 (R2), 2005, SQL 2000, SQL7.0, SQL6.5 in Windows Server 2000, 2003 and 2008 (R2), 2012R2, Oracle 11G and DB2 platform and MySQL5.0. I provide support on MSCRM2016/2015/2013/2011/4.0 for various ministries and Share Point MOSS 2007/2010/WSS3.0, Helpdesk databases, Reporting Services 2008 and 2005 and CRM databases as SQL Server DBA; Some Oracle databases; monitor the performance of databases, handle Work Orders, Service Requests, Monitoring alerts, Backups, recovery, Disaster recovery, monitoring, performance tuning, Change and Problem tickets, Incidents, On-Call and other DBA related activities. Installed, Configured PostGreSQL on Cloud, MongoDB, AWS MongoDB for Linux on EC2, Azure CosmosDB, MySQL, SQL Server, Neo4J, Oracle and Sybase, IaaS, PaaS, TSQL Install, Create PaaS databases and IaaS VMWare on Azure Cloud, Migrate DB2 to Azure Cloud for Ministry clients, migrated SSIS packages from SSIS Catalog to Azure Data Factory, migrate SQL Databases to Azure Single databases, Managed Instances, and IaaS VMWare using DMA and DMS tools and integration Creating new Azure databases using SQL Databases, Managed Instances, VM on Azure, migrating on-Premise to Azure PostGres databases and SQL databases in MS Azure using Database Migration Services (DMS) and backup dump files. Connecting and managing Azure PostGreSQL and SQL databases using Azure data studio, PSQL, SSMS and Azure Portal; Worked with Microsoft Azure Arc data services Used Amazon Cloud - AWS RDS Postgres, Redshift and Azure PostgreSQL Hyperscale, MongoDB Create Azure Data Factory, Azure Storage Accounts and Azure Databricks, Data Lakes

IBM supports its clients on SQL Server 2008/2005/2000/7 and Oracle platforms. Being a member of SQL Server team, I supported and administer the enterprise databases of IBM clients including government, education, telecommunication, banks, financial, marketing organizations and health industry. IBM provides change management and problem management support to 60 production Servers, 15 development Servers and 8 test Servers on SQL Server side. Working with the clients, my duties include providing services on SQL Database Administration, Maintenance, Support, perform some development tasks.

Worked with Suncor (Oil and Gas) Calgary on its client databases, I was responsible to support a total of 90 physical and virtual servers and 50 Oracle 11G Servers, 110 SQL instances on SQL Server 2008, 2005 and 2000 on Windows Server 2000, 2003 and 2008. I also provided support on Microsoft CRM, SharePoint, Medgate, Helpdesk and SCCM databases as a DBA; monitor the performance of databases, backups recovery, preparing reports, database consolidation, Clustering, High-availability and network activities and O.S level support.

Ideaca is a mid-size IT Consulting firm that implements and supports business applications with over 250 IT professionals in Toronto, Edmonton, Calgary & Vancouver. Ideaca professionals are committed to understand and identify the business needs of its clients, choose appropriate technology and execute projects within scope, on time and within budget. The company provides support to its clients on Database level, it manages its client database Servers and work with clients to start new projects. Being a member of national team, I was responsible for development, 24/7 on-call maintenance, administration and Support of Enterprise internal, external and customers databases. I was working in Development, Test, Training, Support and Production Servers using SQL Server 2000/2005/2008, Postgres and MySQL Databases.

TELUS is a well-known Canadian Telecommunication firm providing wired and wireless communications services. Being a member of 18 national DBA team, I was responsible for 24/7 on-call maintenance, administration & Support of enterprise databases. I worked in Development, Test, Training, Support, Acceptance, Playground and Production environment running database Servers using SQL Server 7/2000/2005. I was supporting 18 clients with 28 Servers/instances as Prime DBA and 19 clients with 35 Servers/instances.

IBM supports its clients on SQL Server 2000/7 and Oracle platforms. Being a member of SQL Server team, I supported and administer the enterprise databases of IBM clients including government, education, telecommunication, banks, financial, marketing organizations and health industry. IBM provides change management and problem management support to 60 production Servers, 15 development Servers and 8 test Servers on SQL Server side.

CanatechIT is a consulting firm which supports its clients on SQL Server 2000 and 7.0. Being a member of Business Analysts team, I supported and administer clients databases in education, telecommunication, banks, financial, marketing organizations and health industry. CanatechIT provides support to production, development and test Servers on SQL Server. Working with these clients; my duties include System Study, Analysis, new Projects, SQL Database Administration, Maintenance, Support and DB/Software development.

BTE is an organization conducting exams in Technical, Trade & Science for students throughout the province. I worked as SQL Server DBA using SQL Server 2000 and 7.0. Being a member of team, I created, supported and administered databases for students data, exams data and other related activities. I provided support to production, dev and test Servers using SQL Server. Working with third party and internal staff, my duties included System Study, Analysis, SQL Admin, Maintenance, Support, perform Software development duties.