EXPERIENCE SUMMARY:

• Total 15+ years of Experience in the IT Industry, currently working with Confidential . as a Project Lead - Azure Cloud Architect
• Technical Project lead with overall 15+ years of experience in Requirement, Analysis, design and execution using Microsoft technologies.
• Azure Cloud Architect with extensive experience in migration strategy planning of Microsoft SQL databases with spearheading Design, development, implementation of IT Cloud solutions on Azure cloud.
• Experience in Azure AD, Web jobs updating user profiles using Graph API.
• Good Knowledge and Experience on Azure Networking, ARM, Resource Groups, Azure Site Recovery, Azure Back Up, Storage, Azure Serverless
• Expertise on Microsoft Database Architecture and Administration support.
• Strong Skills with SSIS, SSRS. Worked extensively in database design & ER diagram implementation.
• A Skilled at progressing from problem statement to well documented design. Managed complete life cycle of multiple projects including project plan / timeline setup, maintaining project deliverables, creating status reports, managing development teams, business development and change management implementation.
• More than 10 years’ experience in financial domain experience.
• MSBI (SSIS, SSRS - PowerBI and MDS servers)-Experience in development, managing & debugging of SSIS/SSRS, migration, deployment & Batch support.
• Good command over commercial RDBMS such as MS SQL Server & Overview of business intelligence technologies like SSIS, SSRS and SSAS.
• Looked data warehousing project independently. Played a major role in implementing query optimization techniques in project.
• Expert in Performance tuning of SQL Server using Execution plan. Expert on index optimizations.
• Implemented new Technology features like SQL Server memory configuration in SQL Server 2016, 2017, Column Store index, Backup compression.
• Application administration including Ektron, REVPORT, Vermillion, SVN, B-ONE, SYLVAN, Coric etc.
• Manage Logins across the servers. And Assigning SQL server roles and granting permissions to the users.
• Managing system databases with high availability and best performance.
• Microsoft certified Technology Specialist SQL Server 2012
• Oracle Architecture & Oracle Enterprise Manager (OEM) tool - Monitoring
• CADIS Version 8.0 & MarkitEDM Version 10.5.3.7 Administrations & Maintenance.
• MQ Administration (Worked on MQ Server Migration & Creation of new queues and troubleshooting)
• MQ Administration & FTP/SFTP Administration, and PowerShell scripts for housekeeping and admin tasks like backup
• Strong analytical, problem solving & organizational abilities. Excellent communication and interpersonal skills with a keen understanding of business applications, their Integration and a proven ability to adapt to new areas.
• Service Now, BMC Remedy, Cherwell & Jira ticketing tool
• Share Point Administration
• ITIL Foundation certified.

PROFESSIONAL EXPERIENCE:

Confidential

PowerBI, Azure Cloud migration

Responsibilities:

• Migration Panning MS SQL2008 on Azure cloud - more than 300+ SQL instances.
• Capacity planning and migration strategy and planning.
• Azure AD, Web jobs updating user profiles using Graph API.
• Working on Azure PARK & Python
• Working on Azure Networking, ARM, Resource Groups, Azure Site Recovery, Azure Back Up, Storage, Azure Serverless
• Deployment (scripts execution/rollouts/rollback/ SSIS packages).
• Modification in SSIS packages and deployment.
• Creating and managing SSRS reports for database team.
• Managing Team - Coordinating with offshore.
• PowerBI Dashboard
• New Server Builds - 2012, 2016 & 2017 and Power BI & MDS servers
• SQL Server Migrations from old versions to and 2017
• Worked on Epic related activity with BDE builds.

Confidential

Sr. Technical Analyst

Responsibilities:

• Log-Shipping issues - Fixing failures due to LSN and other reasons.
• Deployment (scripts execution/rollouts/rollback/ SSIS packages).
• Database mail alert configuration.
• Performance & disk usage issues
• Debugging of SSIS packages for any issues and managing SSRS like creation of Subscriptions and troubleshooting for any issues.
• Modification in SSIS packages and deployment.
• Handling database Log size issues.
• Database maintenance activities (database Integrity checks and Index Optimization)
• Memory management & CPU utilizations
• MarkitEDM (CADIS) Administration & Maintenance
• Batch Processing
• MQ Administration - Creation of queue and troubleshooting for any issues.
• SharePoint Administration
• Application administration like user creation and providing permission and configuration - Ektron, REVPORT, Vermillion, SVN, B-ONE, SYLVAN etc.
• FTP / SFTP Administration

Confidential

Sr. SQL DBA

Responsibilities:

• Troubleshooting clusters issues (Always-ON & Failover Cluster) - Monitoring and fixing the always on cluster DB accessible issue.
• Database encryption & decryption - Restoration of encrypted database backup file.
• Database refreshes activities - Frequent restore from production to test.
• Deployment (scripts execution/rollouts/rollback/deployment of SSIS packages).
• Database mail alert configuration – For new DB server database mail setup.
• Performance tuning – memory configuration checks & capacity planning.
• SSIS/SSRS managing and support & Migration
• Modification in SSIS packages and deployment.
• Handling database Log size issues – For large DB monitoring and shrinking the database transaction log.
• Database maintenance activities (database Integrity checks and Index Optimization) – Creating and maintaining Indexes.
• Memory management & CPU utilizations CPU allocation to SQL Server)
• Monitoring DB servers

Confidential

Project Lead (Sr. SQL DBA)

Responsibilities:

• Log-Shipping & Replication setup and maintenance – Fixing LSN mismatches or network failures.
• Troubleshooting & maintaining failover cluster issues.
• Database refreshes activities – DB restore on request basis from Production to test.
• Deployment (scripts execution/rollouts/rollback/deployment of SSIS packages).
• SSIS packages debug for package failures.
• Performance & Memory configuration & CPU utilizations (CPU Allocations)
• Database Log - maintaining and monitoring transaction logs.
• Building & configuring SQL 2005/2008 R2/2012 database servers
• Capacity planning & backup strategy.
• Monitoring the alerts

Confidential

Project Lead (DBA)

Responsibilities:

• Planning & analysis of production server (MS SQL Server) migration.
• MS SQL Server migration & risk analysis with PLAT-SPIN.
• Synching of DB with Plate spin
• Check server accessible from isolated network.
• Configure and Monitoring Plat-spin for Full replication and Incremental Sync.
• Run test failover and Incremental replication.
• DB Hardening policy as per standard policy & Orphan users sync.
• Configuration and checks on DB linked servers.
• Setup & configuration of DB HA solutions as per old servers.
• Check OS/DB patch level and hardening as per standard.
• Update the tasks completion report to Onsite team.
• Prepared DB server for Production Cutover.

Confidential

Team lead(DBA)

Responsibilities:

• Provide technical planning & implementation of new production server (MS SQL based application) & application server as well.
• Installation & Managing Users.
• Provided various possible plans for EON interfaces to Project team.
• Deployment - New releases
• Performance Tuning & Monitoring.
• Backup strategy on production (Full, Differential & Transaction Log)
• Monitoring Log status of Production server.
• Troubleshooting L2/L3 level tasks
• Managing DBA team.

Confidential

Sr. SQL DBA

Responsibilities:

• Planning & Implementation of new production server (MS SQL based application).
• SQL Server Installation & Users Management.
• Deployment - New releases
• Provided various database architectural solutions for EON interfaces to Project team.
• Database Up gradation/Migration strategy & execution.
• Backup strategy on production (Full, Differential & Transaction Log)
• Monitoring Log status of Production server.
• Creating Packages in MSBI (SSIS, SSAS & SSRS) as client requirement.
• Troubleshooting L2/L3 level tasks

Confidential

Sr. Implementation Engineer

Responsibilities:

• Installation & Managing Users.
• Performance Tuning & Monitoring.
• Created High availability solution – Peer-to-Peer Replication
• Monitoring Replication
• Backup strategy on production (Full, Differential & Transaction Log)
• Monitoring Log status of Production server.
• Deployment - New releases
• Managing DBA team

Confidential

Implementation Engineer

Responsibilities:

• Managing Logins & DB-users.
• Monitoring of production servers.
• Monitoring High availability solutions - Peer to Peer Replication (Monitoring).
• Deployment - New releases
• Monitoring Log status of databases.
• Installation (New SQL Server Build)
• Monitoring database alters.
• Performing DB maintenance activities