SUMMARY:

• Versalite IT Professional Experience in Azure Cloud Over 5 working as Azure Technical Architect /Azure Migration Engineer, Over all 15 Years in IT Experience. in Software Development,Analysis Datacenter Migration,Azure Data Factory (ADF) V2. Managing Database,Azure Data Platform services (Azure Data Lake(ADLS), Data Factory(ADF), Data Lake Analytics, Stream Analytics, Azure SQL DW, HDInsight/Databricks, NoSQL DB),SQL Server, Oracle,Data Warehouse etc.
• Build multiple Data Lakes. Build how the data will be received, validated, transformed and then published
• Experience in implementing hybrid connectivity between Azure and on - premise using virtual networks, VPN and Express Route
• Plan and Develop roadmaps and deliverables to advance the migration of existing solutions on-premise systems/applications to Azure cloud
• Experience with Azure transformation projects and Azure architecture decision making Architect and implement ETL and data movement solutions using Azure Data Factory(ADF), SSIS
• Develop Power BI reports & effective dashboards after gathering and translating end user requirements
• Recreating existing application logic and functionality in the Azure Data Lake, Data Factory, SQL Database and SQL datawarehouse environment
• Develop dashboards and visualizations to help business users analyze data as well as providing data insight to upper management with a focus on Microsoft products like SQL Server Reporting Services (SSRS) and Power BI.
• Engage with business users to gather requirements, design visualizations and provide training to use self-service BI tools.
• Developed and maintained multiple Power BI dashboards/reports and content packs
• Created POWER BI Visualizations and Dashboards as per the requirements
• Used various sources to pull data into Power BI such as SQL Server, Excel, Oracle, SQL Azure etc.
• Plan and Develop roadmaps and deliverables to advance the migration of existing solutions on-premise systems/applications to Azure cloud
• Architect & implement medium to large scale BI solutions on Azure using Azure Data Platform services (Azure Data Lake, Data Factory, Data Lake Analytics, Stream Analytics, Azure SQL DW, HDInsight/Databricks, NoSQL DB)
• Propose architectures considering cost/spend in Azure and develop recommendations to right-size data infrastructure
• Datacenter Migartion, Azure Data Services have strong virtualization experience
• Experience in troubleshooting and resolving architecture problems including database and storage, network, security and applications
• Design and implement database solutions in Azure SQL Data Warehouse, Azure SQL
• Implement ad-hoc analysis solutions using Azure Data Lake Analytics/Store, HDInsight
• Design & implement migration strategies for traditional systems on Azure (Lift and shift/Azure Migrate, other third-party tools) worked on Azure suite: Azure SQL Database, Azure Data Lake(ADLS), Azure Data Factory(ADF) V2, Azure SQL Data Warehouse, Azure Service Bus, Azure key Vault, Azure Analysis Service(AAS), Azure Blob Storage, Azure Search, Azure App Service,Azure data Platform Services.
• Design and implement end-to-end data solutions (storage, integration, processing, visualization) in Azure
• Experience managing Azure Data Lakes (ADLS) and Data Lake Analytics and an understanding of how to integrate with other Azure Services. Knowledge of USQL and how it can be used for data transformation as part of a cloud data integration strategy
• Establish database standards for operations, upgrades, migrations and onboarding new applications and/or customers
• Develop workload migration plan in conjunction with other technical teams
• Design and implement streaming solutions using Kafka or Azure Stream Analytics
• Code and automation create to New System for scaling deployment mission criticle operation of Cloud
• Develop, test, and maintain SQL queries, and stored procedures built and with established standards
• Experience with MS SQL Server Integration Services (SSIS),T-SQL skills, stored procedures, triggers
• Deploying Azure Resource Manager JSON Templates from PowerShel
• Azure Analysis Services (SSAS) and SQL Server Reporting Services (SSRS) and Familiarity with Excel PowerPivot, PowerView, and PowerBI
• Experience in Performance Tuning and Optimization (PTO),Microsoft Hyper-V virtual infrastructure
• Ensures compliance to server specific architectural standards and implementation practices
• Creates and maintains Disaster Recovery procedures and participates in periodic disaster recovery testing
• Utilize automation tool such as Terraform, Ansible, or similar
• Worked in mixed role DevOps:Azure Arcitect/System Engineeering, network operaions and data engineering
• Collaborate with application architects on infrastructure as a service (IaaS) applications to Platform as a Service (PaaS)
• Deploying Azure Resource Manager JSON Templates from PowerShel
• Configuring SQL Azure firewall for security mechanism
• Created Azure SQL database, performed monitoring and restoring of Azure SQL database. Performed migration of Microsoft SQL server to Azure SQL database.
• Advise on cost efficiency for future usage and cost optimization for current infrastructure
• Establish, design and support an enterprise Cloud SQL architecture that provides the required capacity, control and supports the long-term strategic goals for enterprise database solution
• Azure Data Factory(ADF),Integration Run Time(IR),File System Data Ingestion, Relational Data Ingestion
• Migration of on premise data (Oracle/ SQL Server/ DB2/ MongoDB) to Azure Data Lake Store(ADLS) using Azure Data Factory(ADF V1/V2).

TECHNICAL SKILLS:

Azure Cloud: Azure SQL Database, Azure Data Lake, Azure Data Factory(ADF), Azure SQL Data Warehouse, Azure Service Bus,Azure Analysis Service(AAS), Azure Blob Storage, Azure Search, Azure App Service, Redis Cache using Pipeline and SSIS, infrastructure-as-a-Service(IaaS),Database-as-a-Service(DBaaS),Data Migration Service(DMS), Azure SQL Data, Elastic Pools,Geo Replication .Geo-restore,JSON,ARM template,SQL Data Synch,Azure Cli, Azure SQL Analytics, Azure Network components (virtual network, network security group, User defined Route, Gateway, Load Balancer etc, Virtual Machines, Express Route, Traffic Manager, VPN, Load Balancing, Auto Scaling

ETL Tools: Azure Data Factory(ADF), Azure Database migration Service(DMS), ETL SQL Server Integration Services (SSIS), SQL Server Reporting Services(SSRS), ETL Extract Transformation and Load., Business Intelligence(BI),BCP.

Storage: Azure Storage,Azure Blob Storage, Azure Backup, Azure Storage Disks- Premium, Azure Files, Azure Data Lake Storage Gen 1,AWS S3 Cloud Storage, AWS EBS, AWS Storage gateway, NETApp/EMC Storage Technologies, SAN

Performance Monitoring Tools used: Azure SQL Analytics, SQLSentry One, Spot Light, IDERA, Solar Winds, Red Gate, LiteSpeed, SQL SentryOne, IBM Tivoli TSM, Doubletake, SQL Server Profiler, System Monitor, Tivoli Monitoring, BMC Patrol, Lumigent Entegra, Informix,AWS Cloud Watch, Goden Gate etc

Operating System: Azure Virtual Machive(VM),Windows Server 2016, Windows Server 2012, Windows 2008 R2,/2000 Server(64bit), Windows 2000 Advanced Server server, Windows XP, Unix, LINUX.Shell Script, AWS EC2

Scripting: Windows Power Shell,Shell Script,Azure CLI, Transact SQL, AWS CLI,UNIX

Cloud Computing: Microsoft Azure Cloud technologies, Azure Backup AWS(Amazon web Services) Data Modeling logical and physical Data Modeling /Database design using Erwin and Visio etc

AWS: EC2,VPC,EBS,S3,IAM, Auto Scaling Group, opsWorks, AMI (Amazon Machine Image), Cloud formation template, CloudTrail, SNS,Route 53,coud Formation, CloudTrail, CloudWatch

Databases: Azure SQL Database,Azure data warehouse, Azure Data azure data factory,Azure Data Synch, Elastic Pools,SQL Server 2017,SQL Server 2016, SQL Server 2014, SQL Server 2012,2008 R2, SQL 2005,2000,Azure SQL Database, RDBMS,Microsoft Azure VM, Business Intelligence(BI), Amazon Web Service (AWS), AWS Cloud Watch,Oracle11g, MYSQL 5.x, MS Access,OLAP,OLTP,AWS RDS,AWS Cloud,Microsoft Azure Cloud

PROFESSIONAL EXPERIENCE:

Confidential

Azure Migration Engineer

Responsibilities:

• Design and implement end-to-end data solutions (storage, integration, processing, visualization) in Azure
• Design and implement database solutions in Azure SQL Data Warehouse, Azure SQL
• Architect & implement medium to large scale BI solutions on Azure using Azure Data Platform services (Azure Data Lake, Data Factory, Data Lake Analytics, Stream Analytics, Azure SQL DW, HDInsight/Databricks, NoSQL DB)
• Design & implement migration strategies for traditional systems on Azure (Lift and shift/Azure Migrate, other third-party tools
• Develop dashboards and visualizations to help business users analyze data as well as providing data insight to upper management with a focus on Microsoft products like SQL Server Reporting Services (SSRS) and Power BI.
• Engage with business users to gather requirements, design visualizations and provide training to use self-service BI tools.
• Developed and maintained multiple Power BI dashboards/reports and content packs
• Created POWER BI Visualizations and Dashboards as per the requirements
• Used various sources to pull data into Power BI such as SQL Server, Excel, Oracle, SQL Azure etc.
• Propose architectures considering cost/spend in Azure and develop recommendations to right-size data infrastructure
• Develop conceptual solutions & create proof-of-concepts to demonstrate viability of solutions
• Technically guide projects through to completion within target timeframes
• Collaborate with application architects and DevOps
• Identify and implement best practices, tools and standards
• Architect and implement ETL and data movement solutions using Azure Data Factory, SSIS create and run SSIS Package ADF V2 Azure-SSIS IR
• Design and implement database solutions in Azure SQL Data Warehouse, Azure SQL
• Recreating existing application logic and functionality in the Azure Data Lake, Data Factory, SQL Database and SQL datawarehouse environment. experience in DWH/BI project implementation using Azure DF
• Migrate data from traditional database systems to Azure databases
• Interacts with Business Analysts, Users, and SMEs on requirements
• Designs Logical and Physical Data Model for Staging, DWH and Data Mart layer.
• Recommend, Design and construct policies and standards that impact infrastructure operations and services but also improve overall business performance. (Strategic)
• Provide leadership and work guidance to less experienced personnel (Leadership).
• Work with similar Microsoft on-prem data platforms, specifically SQL Server and related technologies such as SSIS, SSRS, and SSAS
• Develop dashboards and visualizations to help business users analyze data as well as providing data insight to upper management with a focus on Microsoft products like SQL Server Reporting Services (SSRS) and Power BI.
• Engage with business users to gather requirements, design visualizations and provide training to use self-service BI tools.
• Developed and maintained multiple Power BI dashboards/reports and content packs
• Created POWER BI Visualizations and Dashboards as per the requirements
• Used various sources to pull data into Power BI such as SQL Server, Excel, Oracle, SQL Azure etc.
• Propose architectures considering cost/spend in Azure and develop recommendations to right-size data infrastructure
• Experience managing Azure Data Lakes (ADLS) and Data Lake Analytics and an understanding of how to integrate with other Azure Services. Knowledge of USQL and how it can be used for data transformation as part of a cloud data integration strategy
• Identify potential problems and recommend alternative technical solutions
• Participating in Technical Architecture Documents, Project Design and Implementation Discussions
• Azure Automation through Runbooks Creation, Migration of existing .PS1 scripts, Authorizing, Configuring, Scheduling
• Migration of on premise data (Oracle/ SQL Server/ DB2/ MongoDB) to Azure Data Lake Store(ADLS) using Azure Data Factory(ADF V1/V2).
• Configuring Network Security Groups (NSG).
• Work within and across Agile teams to design, implement, test and support technical solutions across a full stack of technologies
• Work closely across teams (Support, Solution Architecture) and peers to establish and follow best practices while solving customer problems
• Collaborate with application architects on infrastructure as a service (IaaS) applications to Platform as a Service (PaaS)
• Design and implementation of High Availability(HA) systems (24x7x365) an
• Expertise in setup High Availability and Recoverability of databases using with SQL Server technologies including AlwaysOn on Azure VM
• Architect, design and validate Azure infrastructure-as-a-Service(IaaS) environment
• Worked with Azure transformation project and Azure architecture decision
• Cloud Security Architecture, Governance, Best practices and tools
• Azure Cloud Build and Automation using ARM template
• Deploying Azure Resource Manager JSON Templates from PowerShell worked on Azure suite: Azure SQL Database, Azure Data Lake, Azure Data Factory, Azure SQL Data Warehouse, Azure Analysis Service
• Design Setup maintain Administraor the Azure SQL Database, Azure Analysis Service, Azure SQL Data warehouse, Azure Data Factory, Azure SQL Data warehouse
• Worked on SQL Server Integration Services (SSIS),SSAS, SSRS,T-SQL skills, stored procedures, triggers
• SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS) and Familiarity with Excel PowerPivot, PowerView, and PowerBI
• Build Complex distrubuted systems involving huge amount data handling, collecting metrics building data pipeline, and Analytics

Confidential

Power BI Developer |Azure SQL Database| Azure Data Factory(ADF)| Azure Migration Engineer

Responsibilities:

• Design and implement end-to-end data solutions (storage, integration, processing, visualization) in Azure
• Architect and implement ETL and data movement solutions using Azure Data Factory, SSIS
• Develop dashboards and visualizations to help business users analyze data as well as providing data insight to upper management with a focus on Microsoft products like SQL Server Reporting Services (SSRS) and Power BI.
• Engage with business users to gather requirements, design visualizations and provide training to use self-service BI tools.
• Developed and maintained multiple Power BI dashboards/reports and content packs
• Created POWER BI Visualizations and Dashboards as per the requirements
• Used various sources to pull data into Power BI such as SQL Server, Excel, Oracle, SQL Azure etc.
• Propose architectures considering cost/spend in Azure and develop recommendations to right-size data infrastructure
• Design and implement database solutions in Azure SQL Data Warehouse, Azure SQL
• Migrate data from traditional database systems to Azure SQL databases
• Implement ad-hoc analysis solutions using Azure Data Lake Analytics/Store, HDInsight
• Design and implement streaming solutions using Kafka or Azure Stream Analytics
• Design and develop data visualizations in Power BI
• Prepare documentation and architectural designs
• Propose architectures that consider cost/spend in Azure and develop recommendations to right-size Azure data infrastructure
• Work with similar Microsoft on-prem data platforms, specifically SQL Server and related technologies such as SSIS, SSRS, and SSAS
• Design & implement data security and governance policies and standards
• Migrate data from traditional database systems to Azure databases
• Recreating existing application logic and functionality in the Azure Data Lake, Data Factory, SQL Database and SQL datawarehouse environment. experience in DWH/BI project implementation using Azure DF
• Interacts with Business Analysts, Users, and SMEs on requirements
• Designs Logical and Physical Data Model for Staging, DWH and Data Mart layer.
• Recommend, Design and construct policies and standards that impact infrastructure operations and services but also improve overall business performance. (Strategic)
• Develop dashboards and visualizations to help business users analyze data as well as providing data insight to upper management with a focus on Microsoft products like SQL Server Reporting Services (SSRS) and Power BI.
• Engage with business users to gather requirements, design visualizations and provide training to use self-service BI tools.
• Developed and maintained multiple Power BI dashboards/reports and content packs
• Created POWER BI Visualizations and Dashboards as per the requirements
• Used various sources to pull data into Power BI such as SQL Server, Excel, Oracle, SQL Azure etc.
• Propose architectures considering cost/spend in Azure and develop recommendations to right-size data infrastructure
• Experience managing Azure Data Lakes (ADLS) and Data Lake Analytics and an understanding of how to integrate with other Azure Services. Knowledge of USQL and how it can be used for data transformation as part of a cloud data integration strategy
• Participating in Technical Architecture Documents, Project Design and Implementation Discussions
• Azure Automation through Runbooks Creation, Migration of existing .PS1 scripts, Authorizing, Configuring, Scheduling
• Dev Ops tools, processes and best practices including automation of resource provisioning/maintenance
• Compute and Storage area in multi-platform environment such as Linux and Windows
• Design and implementation of High Availability(HA) systems (24x7x365) and Disaster Recovery models(DR): including Setup, Configuration, and Monitoring of Database Recovery strategies such as AlwaysOn, Failover Clustering, Replication, Log Shipping and Database Mirroring

Confidential

SQL Server Developer | DBA

Responsibilities:

• Manage a centralized MS SQL Server 2014, SQL 2012 and 2008R2 Platform consisting of thousands of mission critical databases
• Design and implementation of High Availability(HA) systems (24x7x365) and
• Expertise in High Availability and Recoverability of databases using standard MS SQL technologies including Always On
• Migrate SQL Server and Oracle database to Microsoft Azure Cloud.
• Migrate the Data using Azure database Migration Service(AMS)
• Provide on Call Support for Prod mission-critical (24x7) or problematic databases, and own problem resolution from end-to-end
• Worked Azure SQL Database Environment
• Manage SQL Server databases through multiple project lifecycle environments, from development to mission-critical production systems
• Design, setup administrator AlwaysOn high-availability(HA) and Disaster recovery(DR) solution in SQL Server 2014
• Worked in roadmap development migration to all lower version of SQL Databases to Microsoft SQL Server 2014
• Responsible for capturing various database, server, and application metrics, observing trends that will help longer-term capacity planning and analysis efforts
• Design, Implement and maintain of Disaster Recovery(DR) and High Availability (HA )solutions with Log Shipping, Replication Database Mirroring, etc
• Extensive worked on Migrating Databases residing on servers in one data center to another and Upgrading Database platforms to newer versions
• Experience working with Windows Hyper-V Server, Azure, Windows Clustering including
• Participate in software design reviews with developers to ensure that the architecture is scalable to meet long-term performance goals.
• Database optimizing, Indexing, Index Partitioning, Table Partitioning, disk partitions, Query optimizing, and Disk optimizing.
• Responsible for administration, maintenance, performance monitoring and availability of Enterprise Production SQL server environments
• Evolve the quality and consistency of service delivered by our platforms through automation and process improvement
• Design and Deploy Microsoft SQL Server on Virtualizing with VMware vSphere
• Install, and setup configure Windows Server Failover Clustering (WSFC) in Windows 2012
• Ensure backup and recoverability of all enterprise SQL server databases
• Contribute to the ongoing development of technology and production processes company-wide.Keep abreast of new design tools, hardware, software and technology and make recommendations for future deployment
• Document technical details of issues resolved and assist the team with building and maintaining technical repositories.
• Work closely with the infrastructure team to perform SQL Server installations and to configure hardware and software so that it functions optimally with the DBMS. Plan and implement database upgrades as needed
• Ensure appropriate procedures are followed for implementation of data and database changes
• Develop and adhere to common database standards and procedures within a production operations unit. Maintain documentation related to database platforms, guidelines, methods and standards.
• In-depth query performance tuning - detailed understanding of the query optimizer, execution plans, plan cache, cost estimation, indexes, and statistics
• Strong working knowledge SAN/storage, hardware, and network components used in SQL Server implementations Extensive worked with NetApp/EMC storage technologies
• Upgrade and Migrate all SQL Server databases from One Data Centre to Other in Enterprise Level data Centre
• Worked as data architect or data modeler. Administers and controls an organization's data resources, including multiple relational databases and servers
• Carry out cause analysis of Database/SQL performance problems and recommend a solution for Production as well as Release environments.
• Contribute to the ongoing development of technology and production processes company-wide. Keep abreast of new design tools, hardware, software and technology and make recommendations for future deployment
• Coordinate, schedule and implement database related patches; both software and security
• Experience of Reporting, Analysis and Integration Services (SSRS/SSIS/SSAS)

Confidential

SQL Server Developer | DBA

Responsibilities:

• Upgrade and Migrate all SQL Server databases from One Data Centre to Other in Enterprise Level data Centre
• Serve as primary DBA support for mission-critical (24x7) or problematic databases, and own problem resolution from end-to-end
• Work with IT-Infrastructure team to design/optimize physical server and disk structure layout in production, test and development environments
• Install Setup maintain and administering Microsoft Cluster(MSCS) in SQL Server 2005, SQL Server 2008 R2 on Windows 2008 and Windows 2003
• Carry out root cause analysis of Database/SQL performance problems and recommend a solution for Production as well as Release environments.
• Carry out analysis of performance reports and proactively identify expensive SQLs and other performance bottlenecks.
• Keep abreast of new, performance-related SQL Server features and evangelize their use across IT teams.
• Responsible for supporting and managing the enterprise-wide databases in Production, development and test environments
• Migrated databases from SQL Server Using, ETL tool such as SQL Server Integration Services (SSIS),
• Identified critical hardware and software upgrades required and worked with technical & business personnel from proposal to implementation
• Microsoft SQL Server management and performance tuning. Focuses on index tuning, query modifications, Table partitioning and hardware optimization.
• Extensive worked on Migrating Databases residing on servers in one data center to another and Upgrading Database platforms to newer versions
• Experience working with Windows Hyper VM Server, Windows Clustering including
• Active Directory and proper disk configuration

Confidential

SQL Server Developer | SQL DBA

Responsibilities:

• Managing more than 175 SQL Servers, processing more than 12 million transactions per day with other DBA staff and automated most of the jobs to cut the high management cost and increased productivity
• Take responsibility for database monitoring, troubleshooting, performance tuning 24x7 availability of SQL Server databases
• Involved in advanced performance tuning, database design, capacity planning and establishing standards for SQL installations, maintenance, tuning, and coding standards
• Redesigned a thorough backup and recovery strategy for all major production systems
• Run diagnostic tools to identify database performance bottlenecks including Clustering and replication experience
• Prepare set up environment for Disaster Recovery (DR Server) with Standby by ServerSet up configure and maintain Microsoft Cluster in SQL Server 2000/2005
• Design setup maintaining strategies for High Availability systems (24x7x365)
• Set and maintain and troubleshoot Replication, Log-Shipping, in SQL Server 2005/2
• Designed and implemented Transactional and Snapshot Replication for Synchronization data between production and standby server in SQL Server 2005
• Administrator all SQL Server Databases creation/Installation/configuration, backups, recovery/restore, automate jobs, performance tuning
• Responsible for logical and physical Database design RDBMS with a significant effort towards application and database tuning
• Take responsibility for database monitoring, troubleshooting, performance tuning and the 7x24 availability of SQL Server databases summaries to consistently meet aggressive product release timeframes
• Monitor and Maintain DB growth and capture changes for capacity planning
• Take responsibility for database monitoring, troubleshooting, performance tuning and the 7x24 availability of SQL Server databases
• Design and implement disk structures, space management strategies, transaction log architectures and recovery models
• Wrote installation and procedural manuals for support staff
• Performing substantial data cleanup, restructuring, and reporting deployed and monitored SSIS Packages including upgrading DTS to SSIS
• Index evaluation and recreating of indexes and views based on data collection methods data modeling using ERWIN to document and maintain data model And data Dictionaries
• Monitored Database Logs database objects, such as tables, indexes, rules, user-defined data types, defaults, database triggers & stored procedures (to implement complex business rules) worked with the application support/development teams for database upgrades and releases
• Improve database efficiency by continuously monitoring database performance bottlenecks and perform tuning when required database support & problem resolution within virtualized and non-virtualized Windows 32-bit & 64-bit
• Planning, implementation, and documentation of Microsoft SQL Server 2005/2008 environments
• Deploy, maintain and test enhance all backup, failover, failback and disaster recovery capabilities of the databases as appropriate

Confidential

Senior SQL Server DBA

Responsibilities:

• Administrator all SQL Server Databases creation/Installation/configuration, backups, recovery/restore, automate jobs, performance tuning, etc.
• Involved in advanced performance tuning, database design, capacity planning and establishing standards for SQL installations, maintenance, tuning, and coding standards managing over 50 SQL Servers in multiple countries supporting several hundred users
• Setup and maintain High Availability with Cluster
• Successfully maintain peak performance of all primary databases by providing advanced tuning methods, customized scripts deploy, maintain and enhance all backup, failover and disaster recovery capabilities of the databases as appropriate
• Prepare and set up environment for Disaster Recovery (DR Server) with Standby by Server
• Designed and implemented Replication, Log Shipping in SQL Server 2000
• Provided analysis and recommendations for implementing full-text indexing to meet management requirements designing, documenting, and performing all Replication Agent test plans, test designs, test cases, and test summaries to meet aggressive product release timeframes consistently
• SQL Server troubleshooting worked for Sox compliance Auditing creating, testing, and reviewing set and maintain Log-Shipping, Replication in SQL Server 2000 take responsibility for database monitoring, troubleshooting, performance tuning and the 7x24 availability of SQL Server databases
• Optimized the code and database for maximum performance