SUMMARY

• Over 10 years of IT experience in Analysis, Azure administration, Applications Support for various domains which consistes of Internet information Services and SQL server Databases.
• 10 years of SQL database administration experience by managing various SQL databases in different environments of different versions (SQL Server 2017/2016/2014/2012 /2008 R2/2005).
• 8 years experienced on Azure Admin and 2 years experience on AWS Admin
• 7 years experienced in Confidential ’s Enterprise Commerce Volume Licensing Applications
• 4 years of MSBI experience in troubleshooting SSIS Packages and SSRS reports of different versions (SQL Server 2016/2012/2008 R2)
• Expertise in SQL development activities like writing queries, creating packages and reports etc.
• Experienced on AWS EC3, S3, Route53, EBS, EFS, IAM, VPC, CloudFront, RDS and Cloud Migrations.
• Expertise in application Support and managing pre - prod/production environments based on defined SLA.
• Expertise in SQL Azure Admin. Migrated SQL DBs from on-prem to Windows/SQL Azure environment.
• Proficient in dealing with Windows Azure - Compute, Networking, Storage, Security, Identity, Developer Services, Monitoring and Management.
• Expertise in Virtual Networks, Virtual Machines, Cloud Services, VPN, Load Balancing, Auto Scaling.
• Experience in Provisioning, Configuring and Publishing Web and Worker Roles in Azure PAAS.
• Experienced in developing tools & automation for reducing manual efforts, pro-active monitoring using scripting technologies as per identified requirements
• Experienced in Installation, Patching, Configuration and Administration of SQL Server 2016, 2012, 2008 R2.
• Experienced in Downgrades, Upgrades & Migrations of legacy servers to the latest SQL Versions.
• Extensive knowledge on SQL, IIS, Confidential Azure (IAAS and PAAS) administration.
• Worked with Project Stakeholders, SMEs, external teams, Release management and IT Team during Project Life Cycle.Experienced with Confidential Azure Cloud hands on IaaS service & deliver models.
• Experienced with both IaaS and PaaS Cloud service provision via Cloud portal, PowerShell & JSON scripts.
• TFS experience in administration, Build and release, DevOps experience, TFS branching, Source code management, setting up CI/CD pipeline, Build and deployments to on premise and Cloud
• Expertise in CMMI process work item types and workflow.
• Hands on experiences of cloud computing based services architecture analysis and build on Azure Regions.
• Experienced with hands-on implementing cloud based Azure Active Directory, ADFS, LADP solutions.
• Proficiency in Service Management Framework - Incident, Change, Release, Problem Managements. SLA maintenance, Key Performance Area measurements.
• Experienced on supporting mission critical and multi billion revenue enabling applications from Confidential as a L3 Production support specialist/service engineer.
• Troubleshooting issues on Database performance tuning and improve SQL performance, developing SQL Stored procedures coding and tuning
• Implementing automation to reduce manual administrative tasks through use of jobs, Power shell scripts, T-SQL, SSIS, and other techniques
• SQL Server RDBMS installation/configuration, patching, troubleshooting, performance tracking/tuning, back-up recovery, remote monitoring.
• Investigating problems and triage/resolve issues across application, network, database, server, or storage.

TECHNICAL SKILLS

Languages: T-SQL

RDBMS: SQL Server 2017/2016/2014/2012

Cloud Technologies: Azure IAAS, PAAS, AWS

Operating Systems: Windows Server 2016/2012, Windows 10, Linux

SQL Server Tools: Profiler, Import/Export, Performance Dashboard, Solar Winds DPM

Monitoring Tools: AppInsights, Kusto, SCOM

Development Tools: PS Scripting, TFS 2017, Visual Stuido 2017, .Net, C#

High Availability: Always On, Log Shipping, Replication, DB Mirroring and Clustering

PROFESSIONAL EXPERIENCE

Confidential, New Castle, DE

DevOps/TFS Administrator

Responsibilities:

• Handling Team Foundation Server 2017 administration activities with build and deployment process.
• Work as part of a Dev team to coordinate database development and determine project scope.
• Approve, schedule, plan, and supervise the installation and testing of new products.
• Review project requests describing database user needs to estimate time and cost required.
• Architect Build and maintain Modern Data pipelines on Azure platform.
• TFS Installation, Migration to 2017 /2018 and handling data ware house.
• Build and deployment automation through CI/CD. CMMI process work item types and workflow.
• Respond to TFS break/fix issues, troubleshoot and make recommendations for corrective action.
• Close interaction with .Net developers to implement Business rules, support UI features.
• Provide in - depth technical incident investigation, diagnosis, and resolution expertise resolves.
• Detection of possible problems and complex issues, SQL DB performance debugging and tuning.

Environment: TFS 2017, Azure IAAS, Powershell, Confidential SQL Server 2016

Confidential, Redmond, WA

Cloud Support Engineer

Responsibilities:

• Bringing up efficiency/value add by implementing service improvements, excelling operations and creating efficiency with technical solutions.
• Build & Migration of existing systems to Cloud (Windows Azure) as per business need & technology up-gradation without interrupting service availability
• Analyze resource utilization and consumption and Manage resource groups
• Manage Azure subscriptions: assign administrator permissions; configure cost center quotas and tagging. Configure Azure subscription policies at Azure subscription level
• Create and configure storage accounts and Import and export data to Azure
• Manage Azure VM ; Automate deployment of VMs and Manage VM backups
• Manage Azure Active Directory (AD) and Manage Azure AD objects (users, groups, and devices)
• Evaluate migration scenarios by using Azure Migrate and Migrate servers to Azure.
• Manage App Services and Plans. Implement application load balancing.
• DevOps to modernize infrastructure as a service (IaaS) applications to Platform as a Service (PaaS).
• Create solutions that support a DevOps approach for Azure Cloud delivery and operations of services.
• Create proof-of-concepts to demonstrate viability of solutions under consideration.
• Develop enterprise level conceptual solutions and sponsor consensus/approval for global applications. Provide consultative support to the DevOps team for production incidents.
• Drive and support system reliability, availability, scale, and performance activities.

Environment: Azure IAAS, PAAS, SSIS, Powershell, Confidential SQL Server 2016

Confidential

Cloud Engineer

Responsibilities:

• Administration and Troubleshooting of Azure IAAS Components (VM, Storage, VNET, OMS, NSG, Site to Site VPN, RBAC, Load Balancers, Availability Sets, etc)
• Manage Network Security Groups for both Classic and ARM networks
• Proactive Monitoring and Patch Management of Azure virtual machines using SCCM, SCOM or OMS
• Identity Access management of Azure Subscriptions, Azure AD, Azure AD Application Proxy, Azure AD Connect, Azure AD Pass Through Authentication
• Express Route configuration, Site to Site VPN, Point to Site VPN
• Configure Network Security Groups (NSG) in Azure as Firewall, implement and manage WAF
• Administration and management of Azure Security Center, Managing Network ACL's on Azure VMs
• Administration and management of Windows Firewall
• Monitoring and Analyzing Azure Diagnostic Logs/Audits
• Azure SQL Database Administration activities
• Identifying automation needs and work with the appropriate teams to create and improve the existing tools for automation for self-healing

Environment: Azure IAAS, PAAS, SSIS, Powershell, SQL Server

Confidential

Sr Application Support Engineer

Responsibilities:

• Monthly Patch management of nearly 100 Confidential data center servers.
• Maintenance of 50+ Window 2003/2008 Servers with IIS and SQL 2005/2008.
• Monitoring MOM/ SCOM Console for any server issues and resolving them.
• Investigating performance related issues. Drive Space Monitoring of all the servers (WEB & SQL)
• Migrating Outdated servers to the new Virtual Machines/ Hyper Vs.
• IIS - Setup, App pools, Site Creation, SMTP and Administration.
• Managing SQL Jobs and Backups; monitoring the service down alerts
• Evaluating existing KB’s and modifying the content; creating new KBs if required.
• Notifying the application users when there is maintenance on the servers.
• Troubleshooting failed indexing & archiving requests of MS clients for their builds.
• Performing regular Backups and restore operations whenever required.
• Monitoring Database Mirroring with High Availability Mode in MS SQL.
• Monitoring Log shipping and troubleshooting of errors. Replication; monitoring clustered nodes.
• Check the Performance Tuning, Query Optimization, and Database. Administrator tasks like managing users, roles, granting permissions. Scheduling jobs in SQL server.

Environment: MS SQL Server 2008 R2, Windows server 2008

Confidential

Application support Analyst

Responsibilities:

• Patch/Anti-Virus Management, Incident Management - Risk Assessment, IT Security Policies/Procedures, Implementation of IT Audit Recommendations, Standard Operating Procedures, Operational Reviews Change
• Maintenance of 50 servers, which includes Domain Controllers, File Servers, DNS, DHCP, Blue Coat Proxy, Lotus Domino Mail Servers, 14 TB SAN with LUNs configuration, Confidential Application Server, etc.
• Worked on LDAP and Confidential Active Directory Administration and Maintenance, Group Policy Design and implementation .
• Worked on Server certificates, public and private keys, Encryption
• Managing Replication between different sites and scheduling Replications in Lotus Domino.
• Monitoring Event Logs, Services Status, and Security patches updating.
• Monitoring Server Performance by using Performance Counters
• Managing Print, DC, File, DNS, DHCP, Blue Coat Proxy, Lotus Domino Servers, 14 TB SAN.
• IIS Administration and configuration, networking protocols, Azure load balancing and storage.

Environment: MS SQL Server 2005/2008, windows Server 2008, Windows XP, 2000, NT