SUMMARY:

• 7 years of IT industry experience with professional experience in Installing, deploying, configuring, and troubleshooting runtime errors on windows server, IIS web server 8/7.5/7.0/6.0 and windows servers.
• Experience in migrating applications between windows servers and to an upgraded platforms
• Monitored system performance using various performances counters like Perfmon and Task Mgr.
• Deploying ASP.NET and web applications on Windows IIS 6.0, IIS 7.0 and IIS 8.0 with Octopus tool
• Configured SSL certificates for the web applications to ensure security transactions between client and server
• Implementing and Managing Network Load Balancing and windows load balancing in a Web Farm environment.
• Installing Monthly security patches and scheduling regular maintenance to ensure the health and security on the servers.
• Good experience in all phases of the software development lifecycle from feasibility study, requirements analysis, architecture, design, development, implementation, test to maintenance and software enhancements
• Participated in on - call rotation for trouble shooting IIS issues and server issue
• Involved in trouble shooting and fixing day-day issues in production environment.
• Installing security patches and scheduling regular maintenance of servers to ensure optimum performance and security.
• Experience in an operational environment providing support, involving coordination with release Management and Change management.
• Good knowledge in using IPCONFIG, NSLOOKUP, and PORTQUERY tools to debug network related issues.
• Excellent working knowledge on both Unix/Linux and Windows environments.
• Experience in basic LINUX administration tasks, Disk partition using fdisk utility. Experience in creating LVM.
• Created shell scripts and cron jobs that monitored and reported security issues
• Managed, monitored and tested individual and group user access privileges and security
• Monitored system performance and prevented resource exhaustion using ssh, sar, vmstat, iostat, netstat and nmon
• Good experience in virtualization and involved in planning and building virtual environment using Confidential Hyper-v
• Content copied and delivered to windows 2008/2008 R2 application servers using XCOPY, ROBOCOPY commands
• Develop scripts in Power Shell/Puppet and use them to automate daily tasks
• Worked in 24x7 production environment.

TECHNICAL SKILLS:

Operating Systems:: Windows server 2000/2003/2008/2008 R2/2012, RedHat.

Languages:: C, C#, T-SQL

WebServers:: IIS 5.0/6.0/7.0.

Databases:: MSSQL 2000/2005/2008/2012.

Load Balancers:: Network Load Balancers

Monitoring Tools:: SCOM

Virtualization Technologies:: Hyper-v, SCVMM, VMWare

Scripting:: VB Script, Puppet, PowerShell

PROFESSIONAL EXPERIENCE:

Confidential, WA

SR.CLOUD SYSTEM ENGINEER

Responsibilities:

• Create customer CRM sandboxes on request, troubleshoot the accessibility issues of the created CRM sandboxes.
• Troubleshoot the CRM user accessibility issues to their Orgs.
• Creating & Uploading Instance file as per customer based checklist in ACIS portal.
• Deploy the hotfixes into MDM and CRM on demand
• Created PowerShell scripts for getting Application and IIS logs from on-perm and Azure servers
• Updating the service account passwords using password updater
• Investing the Node failures in the Failover cluster manager.
• Attended the weekly meetings and created the MOM.
• Create the postmortem reports for the Major incidents caused in the Prod environment
• Communicating with client related to incident with proper channel of email updates as per severity levels.
• Troubleshooting the SQL connectivity, Always ON issues and debug the issues using the SQL tools.
• Worked on IcM incidents assigned to the CRM SRE queue and resolve them within the SLA
• Developed process to patch and support nearly 80,000 clients using Software Updates Management in SCCM
• Migrated applications from on-perm to Azure IaaS and PaaS based on code compatibility.
• Check the Jarvis logs for GEO level issues, SG issues
• Assisted DOC in approving the SQL scripts to be executed again the SG Org SQL servers.
• Troubleshoot the SSRS issues where customer aren’t able to render their reports from CRM
• Change the connection settings in CRM Azure subscription
• Providing 24/7 Support with On call in shift hour

Confidential, WA

Service Engineer

Responsibilities:

• Create Azure subscriptions, storage accounts in the accounts as and when required for the team.
• Creating Azure Storage accounts, deploying the builds in Azure subscriptions.
• Creating & Uploading Instance file as per customer based checklist in Windows Azure deployment dashboard portal.
• Renewing the SSL certificates for IIS websites.
• Excellent working knowledge on both Unix/Linux and Windows environments.
• Updating the service account passwords using password updater tool.
• Investing the Node failures in the Failover cluster manager.
• Attended the weekly meetings and created the MOM.
• Create the postmortem reports for the Major incidents caused in the Prod environment
• Communicating with client related to incident with proper channel of email updates as per severity levels.
• Attending Bridge calls with Operations managers/Support teams in case of Severity 1 /2 based on customer impact.
• Involved in SQL deployments and troubleshooting the issues that we came across
• Migrated the SQL 2008 R2 to SQL 2012 along with the user logins
• Played key role in onboarding the new customers to the CAP portal, whitelisting the IPs as per the request.
• Providing 24/7 Support with On call in shift hours

Confidential, WA

Responsibilities:

• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification, database integrity verification and indexing updates
• Responsible for implementing and supporting high availability solutions with SQL Server including SQL Mirroring/ Replication/Log Shipping.
• Implemented different types of Replication Models like Snapshot and Transactional.
• Extensively worked on Dynamic Management Views (DMV’s).
• Used SQL Profiler for troubleshooting, monitoring, tuning of SQL Server.
• Experience in debugging SQL locking, blocking and dead lock issue using SQL Profiler and Trace Flags.
• Experience in scheduling SQL Jobs in SSMS
• Prepare the KA, Wikis for the Customer Education purpose for the Customer reported INs.
• Monitoring System logs and security logs by using Event Viewer for troubleshooting application and windows \ SQL server related issues.
• Involved in Performance tuning and optimizations of web applications using administrative tools like PERFMON and Task Manager.
• Experience in PowerShell scripting to automate administrative tasks in an environment.
• Attend weekly sync up Meetings with the onsite team.

Confidential, WA

Service Engineer

Responsibilities:

• Monitoring around 250 servers and responsible for day-to-day operation and maintenance of production servers.
• Deployed several .NET applications on IIS 6.0/7.0/7.5 Web server in Windows 2003/2008/2012 server
• 24/7 technical support to various application that are a part of team
• Involved in application migrations from IIS6.0 to IIS 7.0
• All open issues and scheduled tasks to be completed as scheduled.
• Worked in 2- node Active/Passive Clustered Environment.
• Involved in migrating DTS packages from SQL Server 2000 to SSIS packages in SQL Server 2005
• Database.
• Successfully implemented Database Mirroring with High Availability Mode in SQL 2005.
• Implemented Log Shipping in SQL 2005 from Primary Server to Standby Server to support DR Solution.
• Prepared and documented database Backup & Maintenance Plans.
• Acted as a liaison between the offshore team and onshore team.
• Provided assistance and mentoring staff for developing conceptual, logical and physical database designs.
• Worked in 24x7 production environment.

Confidential, WA

Problem Management

Responsibilities:

• Created documentation for deployment process and patching process.
• Configured and monitored Transactional Replication for different clients for Reporting purpose
• Installed, configured and maintained virtual machines on window 2008 servers.
• Responsible for implementing and supporting high availability solutions with SQL Server including SQL Mirroring/ Replication/Log Shipping.
• Configured TCP/IP, DNS, WINS entries in windows, proxy in IIS 6.0.
• Configured SQL - Database connectivity parameters in the web.config and by using ODBC settings.
• Used SQL Profiler for troubleshooting, monitoring, tuning of SQL Server.
• Experience in Configuring Customized Rules, Alerts in SCOM console to monitor SQL, Windows and File Servers.
• Involved in performing the Root Cause Analysis for the MIs.
• Experience in designing SSRS Drill down Report to view IIS Error codes on all web servers in production
• Experience in creating the Post Mortem Report for the MIs by interacting with System Engineer and knowing the reasons that caused the outage.
• Attend the Daily sync calls with the offshore team

Confidential, NJ

Web administrator/ Application Support Engineer

Responsibilities:

• Experience in Aligning Servers in Rack, Installing OS onto the Raid configured Server.
• Experience in creating and cloning VMs in VMWare
• Responsible for maintaining, updating, and using full, differential and transaction log backups for multiple SQL Server databases
• Excellent experience in writing complex queries using joins, Stored Procedure, Triggers, Functions, Views, DTS and SSIS packages.
• Ability to work cooperatively in a team with strong oral and Written Communication skills.
• Good experience in working with remote team with different time zones.
• Experience in working with Production support (24/7) environment.

Confidential

Service Engineer

Roles & Responsibilities:

• Scheduled jobs and monitored job failures to diagnose the problems.
• Hands on experience with backup and restoring databases for large OLTP systems
• Dealt with database and table privileges and permissions in SQL 2005/2000.
• Dropped and recreated the tables for the damaged databases to avoid data loss.
• Responsible for data portioning and disaster recovery plans in SQL 2005.
• Designed Physical and Logical Modeling using Erwin Case Tool.
• Worked with integration services for transferring and reviewing data from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data).
• Wrote T-SQL code for creating cursor and handling the data validations.
• Designed and implemented stored procedures and triggers for automating tasks.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, cursors, tables, and views and other SQL joins and statements for applications.
• Provided 24x7 Production Database on-call support.