SUMMARY

• Total 15+ years of Experience in the IT Industry, currently working with Atos - Confidential . as a Project Lead - Azure Cloud Architect and Current location - Nashville TN USA
• 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

Azure Architect

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 2008 to 2016 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