•Collaborate with stakeholders to understand business requirements & done functional & technical designing, architecting, and implementing of Azure public & hybrid data solutions. •As an SME, implemented end-to-end cloud migration methodology and architecture. •Implemented cost optimization strategies, orchestration, & scalability features & estimate engineering efforts for data migration projects.•Designed, developed, and optimized Azure Data Factory Pipelines and Azure Databricks notebooks. •Designed and implemented highly available architectures using Azure services like Availability Zones & Azure Site Recovery.•Spearheaded and orchestrated architectural design and implementation of Migration, and Data Engineering projects on Azure, with a focus on Azure Data Factory, Azure Databricks, and Azure Synapse Analytics.•Lead cloud migration strategies, including lift-and-shift & re-architecting strategies. Integrate Azure services with on-premises infrastructure. •Specialized in ETL processes, data modeling and database management, Microsoft Power BI reports development.•Implemented data governance, data quality management and data lineage using Microsoft Purview and Azure Databricks Unity Catalog.

•Leading and architecting Cloud infrastructure, Migration and Data Engineering and modernization projects on Azure Cloud, Azure Data Factory, Azure Databricks and Azure Synapse Analytics.•Designed and implemented Azure data solutions including data modeling, SQL data warehousing, ETL and Analytics. Administer and optimize databases for performance and scalability. •Lead migration of MSX CRM changes in the Microsoft Sales Power BI reports in Azure Databricks environment.•Requirements gathering, cost optimization, stakeholder engagement and project planning. •Leading the calls with Microsoft Sales Power BI reports development Leads, Azure Data Analytics development & Operation Teams to get the report issues resolved for the Microsoft Leaders and Sales teams from the field.•Azure Synapse Analytics integration with Azure DevOps to automate CI/CD pipelines.•Constantly worked with Microsoft stake holders on Process & Service Improvement plans & strategies for rapid resolutions.•Investigated Azure SQL database DTU & other performance issues & escalating to features teams based on the issues. Batch performance & throttling issues.

•Analyzed the business requirements, designed and developed Microsoft Sales Power BI reports for the Leaders and Sales Managers as per their business requirements to accelerate the Sales Closures and generate revenue for the Client.•Pro-actively identify potential business opportunity for client by analyzing the trends, requirements and issues from the field and interacting on daily basis. •Implemented Azure data solutions including data modeling, SQL data warehousing, ETL and Analytics.•Designed, orchestrate and creating Azure Data Factory Pipelines of Microsoft Sales data from different sources to build the reports. •Migration of Azure Data Factory pipelines source files to Gen2 Azure Data Lake Storage Parquet format. Fix the issues in ADF Pipelines.•Monitored, troubleshoot and alerting of SSIS, SSRS, Azure Data Factory pipelines.•Create custom calculations using DAX queries, Data analysis, creating and maintain SSIS packages, Row Level Security in Power BI, maintaining data sets.•Guide the offshore team on technical issues and escalations with the client and field to mitigate issues.•Create internal Power BI reports to track and gather all metrics, SLA's, KPIs and present to Microsoft Leadership Team.

• Lead the incidents and TFS bugs Triage meetings with Dynamics 365 AX for Finance and Operations product features engineering teams. Drive best practices for incidents reduction.• Guide the offshore team on technical issues and which feature teams to reach out to mitigate issues. Monitoring alerts and Wiki's on-boarding from different feature teams.• Track and gather all metrics, SLA's, KPIs and present to Microsoft Leadership Team.• Analyze change requests and incidents trend and critical issues for the customers for mitigation of issues and escalate appropriately to management.• Constantly work with MS stake holders on Process and Service Improvement plans and strategies for rapid resolutions.• Work in collaboration with multiple Microsoft teams including Dynamics 365 AX feature engineering teams, SRE, Azure Support to drive resolutions of support tickets & VSTS service requests and reducing noisy alerts. Lead the critical Sev-0,1,2 bridge calls and security incidents.• Tracking progress against deliverables, adjusts plans as required and provides regular status reporting to senior leadership.• Created and reviewed technical documentation and troubleshooting wiki articles.Lead, motivate and mentor project team members. Lead Dynamics 365 AX support project from offshore.• Handled bridge calls on Sev-2 critical performance issues.• Investigating Azure SQL database DTU and other performance issues and escalating to features teams based on the issues. Batch performance and throttling issues.• Pro-actively monitoring the Azure status and Gomez alerts for Azure services outage and non-planned actives for live customers.• Worked on on-boarding new team members to the project. Worked on customer reported ICMs and service requests.• Troubleshoot VSTS task failures using Azure PowerShell runbook failures, package deployment failures in Sandbox and Production environment.

•Lead Rezopia Cloud Operations travel platform project and other AWS and Azure Cloud hosted projects and team under Cloud Business Group in Sonata•Pre-Sales support for Azure and AWS Cloud, SOW, RFI and RFP.•Lead the role of PCI DSS compliance and certification for Rezopia Travel platform customers.•Lead the AWS Infrastructure provisioning and Environment setup, SQL Server High Availability solutions automation.•Implemented Cloud infrastructure monitoring tools like Splunk, CloudWatch, Librato, Zabbix, and New Relic. •Assisted Sonata Cloud Competency team for new proposals on AWS and Azure Cloud Services and Tools and showcasing AWS to Azure migration.

•Joined as Oracle Database Solutions consultant and made significant contributions leading Oracle on Azure support project with a team of 10 members. •Oracle on Microsoft Azure support Tech Lead I was responsible for leading and supporting Oracle Database and Oracle WebLogic App server on Azure cases and recommending customers with solutions for Oracle on Azure.•Created a repository of case studies, KB articles and reference guides of Oracle database, Oracle Data Guard setup and best performance practices on Azure to present for customers and publish them on MSDN.•Presales support on Oracle on Azure and collaboration with Solution Architects for Oracle on Azure solutions.•Enable customers to migrate Oracle Apps to Azure by engaging in customer PoC’s, Pre-Sales and Scoping meetings. Lead Oracle Database performance tests on D-series images (SSD) using Orion tool. •Worked and lead the Oracle 11g/12c Add-On features implementation, testing and image development.•Lead and worked on IBM DB2 scenarios preparation, implementation, and documents preparation.SQL Server 2016 database installation and buffer pool extension configuration.•Proposed new images development for Oracle Database and WebLogic by guiding and testing the new Oracle software on Azure.•Worked on Linux administration for Oracle Database, storage configuration and troubleshoot platform issues in Azure Linux.•Responsible for hiring Oracle DBA, Azure DevOps for offshore and Azure Linux for Onsite positions.

•As a Systems Engineer in Oracle Database Solutions engineering team architected, planed, designed, deployed and supported Oracle 12c, 11g and 10g RAC and single instance databases on Dell Servers, Storage and Networking.•Lead author of Oracle 11gR2 database backup and recovery using Dell storage snapshot, RMAN and Oracle Data Guard and disaster recovery using Dell storage replication, Oracle database backup and recovery using Quest NetVault white papers, blogs and wikis on Dell hardware.•Lead the Test and validation program of Oracle 10g, 11g and 12c RAC and single instance databases on RHEL, OEL and Windows platform, deployment guide, wikis on Dell storage and servers.•Lead Oracle Validated Configuration program to validate and certify hardware, server, storage and network with OEL, Oracle VM and Oracle RAC/single instance databases.•Upgrade, migrate and consolidated Oracle 11gR2 RAC databases to Oracle 12c multitenant Pluggable databases from RHEL 5.5 to RHEL 6.4 using Dell storage snapshot.•Hands on experience in installing, configuring, and troubleshooting Dell x86 Servers and Dell storages for Oracle database configuration. Storage technologies SAN, DAS, FC and iSCSI storages•Worked on PoC on Oracle DB 12c, Infrastructure migration to Oracle DB 12c using Dell Shareplex and Oracle Golden Gate, Oracle database backup and recovery using Dell storage snapshot.•Handled many customer demos, trainings and presentations on Dell Storage and Server features for pre-sales. •Presented Oracle database solutions engineering review, technical forum to support pre-sales and team level presentations on Oracle Database 12c Features, AWS RDS Cloud services.•Tested and benchmarked Oracle RAC databases on Dell infrastructure using Quest benchmark factory, dstat and OS Watcher.•Identified and troubleshooted critical issues (IPv6 tunnel adapter, 32 core issue and multipath) during Oracle RAC implementation.•Has 3 Recognized Invention Disclosures on Dell hardware.

•As an Oracle Database Administrator planned, designed, data modelling, deployed and maintained 30+ 24x7 production- databases of Oracle 10g and 11g RAC/ASM environment.•Managed 4 node 11g RAC Production with ASM.Node eviction, Add or Remove Node from RAC. Backup and Recovery issues related to loss of OCR.•Managing database security as per the SOX Auditing and generating log for SOX Internal Audit, redo log files, control files, backups, performed Cloning, Migration and Upgradation of databases.•Prepared LLD for the new database design and ER Diagram. Managing redo log files, control files, backups, partition management, performed Cloning, Migration and Upgradation of databases.•Redesigning the partition tables to improve performance from List to Range-List using online redefinition. Written RMAN backup scripts and implemented RMAN backup and recovery strategies.•Automated release activities using cronjobs and shell script. SQL and PL/SQL programming.Created materialized views with automatic refresh. Oracle EM administration and SQL and PL/SQL Developer exposure.•SQL Optimization for reporting using SQL Advisor and Hints.CPU Utilization, physical memory usage and database capacity planning based on transaction volumes and growth. PGA, SGA memory and SQL tuning. Tuned slow running queries by analyzing tables,indexes and partitions and I/O tuning. Statspack installation and analyzing the report.•Monitoring hung jobs, locks, dead locks, broken dbms jobs, invalid objects.Applied quarterly CPU Patches, DST and Opatch on production & development databases.•Generating ADDM report and analyzing the report for queries which used maximum database time and resources and generating Explain Plan and tuning the queries accordingly. •Monitoring the backups of Standby and Disaster Recovery drill. Application performance tuning, query optimization and troubleshooting. Fine tuning Initialization parameters, I/O, Memory and Operating System kernel parameters.

•Installation and implementation of Oracle databases on Windows platform.•Maintenance of Users and Security. Configuration and Release management.•Logical and physical backups and monitoring Veritas Tape Backup.•Table refresh and Schema refresh and enabling/disabling Triggers.•Generating and analyzing reports using Statspack utility for optimizing the performance of the databases.•Reorganize tables and indexes. Generating Explain Plan and analyzing the performance of query.•Analysis of Server Performance and analysis of invalid objects and blocking sessions.