SUMMARY

• Confidential certified professional with six years of Service engineering experience with extensive knowledge on IIS Administration, MS SQL Server and Confidential Azure, programming in powershell, C#.
• Good experience in building and deploying the applications using Octopus and VSO
• Experience in continuous integration and delivery using tools like Maven for building JAVA applications, JIRA for project tracking, TFS, Artifactory and GIT for code repository, Jenkins for CI, CHEF and Puppet for CD, and Ansible
• Experinence in using Docker which is a container technology to create Linux machine.
• Expertize level of working experience in deployments, troubleshooting deployment issues, finding the root causes and writing trouble shooting guides/documentation for PPE and PROD.
• Analyze Telemetry data and feature specs and translate them into infrastructure needs using tools like SCOM, AppInsights and OMS
• Troubleshoot performance and stability issues using a wide variety of tools like Windbg, network monitor, Nagios, Perfmon, Wireshark, fiddler for debugging complex production issues.
• Experience in DBA activities like backup, restore, performance tuning, security management, capacity planning, standards development and enforcement.
• Troubleshoot performance issues in SQL using a wide variety of tools like Index Tuning Wizard, SQL profiler, DBCC utilities
• Experience in configuring and setting up high availability and DR solutions like SQL Clusters, Database Mirroring, SQL Log Shipping, SQL Replication and HADRON.
• Experience on Analysis Services, Reporting Services and Integration Services
• Responsible for timely and effective delivery of Infrastructure projects in Azure.
• Experience in DevOps including the design and automation of IAAS and PAAS solutions including virtual networks, virtual machines, cloud services, web sites, data services, service bus, CDN and AAD etc.
• Working with Confidential Active Directory group for SAML 2.0 integrations with various apps.
• Experience in setting up trust between on premise and cloud server using ACS and ADFS in Azure and updating the expiring certs and keys in service indentities in ACS.
• Configured LDAP server for Single sing on user authentications to the application and also Configured SSO crtificates to the applications for authentication.
• Experience in the design and development REST APIs, API Gateways, relational and NoSQL
• Experience in PowerShell.
• Knowledgeable and implemented ITIL.
• Involved in complete lifecycle of SDLC process.
• Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.
• Multi - tasking team player with strong analytical skills and ability to communicate with non-technical audience.

TECHNICAL SKILLS

Database: SQL Server 2005/2008/2008 R2/2012/2014 OLTP, OLAP

Tools: SSMS,Visual Studio 2008/2010/2012/2013 , BIDS, Confidential Office

Programming Languages: C, C++, C#, ASP.NET

Scripting: Windows PowerShell

Operating Systems: Windows 2000 through 2012 R2, Windows 98/2000/XP/VISTA/7/8

Web Servers: IIS 6.0/7.0/7.5/8.0

Monitoring Systems: SCOM 2007 R2/2012,OMS, Appinsights, Nagios

CI\CD tools: VSO,GIT, Jenkins, Puppet, Ansible

PROFESSIONAL EXPERIENCE

Confidential, WA

DevOps Engineer/Systems Engineer

Responsibilities:

• Worked on continuous integration and delivery using tools like VSO, GIT, Jenkins and Puppet
• Experience with developing branching Strategy forGIT, TFS Source Control Managementtools
• Designed and managed build and release methodologies using TFS for .NET Applications
• Worked on Configuration management and automating the tasks involved in rolling out, tracking, and controlling changes to apps, and hardware using Puppet and Powershell DSC.
• Responsible for creating automation tasks for IaaS and PaaS using PowerShell
• Worked on Telimetry Data from Appinsights using Kusto
• Created Power BI reports for the application metrics and Live site review of the applications.
• Responsible for creating Azure VMs, Azure Virtual Network and Azure websites using JSON templates and deploying VMs and encrypting the disks with bitlocker using Powershell DSC
• Responsible for managing post provisioning, installing application components on VMs
• Implement storage related to blobs/Azurefiles, SQL/Recovery Services, Managing the storage access, Implement, IntegrateAzureActive Directory with AD Migration, Configure Application Access Panel.
• Good in Integrating an application withAzureAD, Design/Implement a multi-site or hybrid network, Design/ImplementAzureSite Recovery/AzureBackup, ImplementAzureRMS and EMS.
• Active Directory Services -- Managing Users & Other Resource objects.
• Managed Group Policy Objects (GPOs) throughout the Active Directory (AD) enterprise
• Worked on storage accounts, CDN, and service bus for the data availability in global level.
• Acquired Secured environment in Azure by using Express route to web applications
• Developed project plan, served as primary task resource, implemented and migrated domain from Windows 2003 to Windows 2008
• Developed PowerShell scripts for IIS app pool recovery, log management, application deployment and general administrative tasks.
• Configured ASP.NET applications authentication and authorization properties to maintain ASP.NET web applications security.
• Installing, configuring and managing Hyper-V machines in web farms
• Configured and managed cluster environment for load balancing the traffic using NLB and F5BigIP.
• Responsible for writing PowerShell scripting.
• Debugged IIS issues like memory leakage, security issues, and IIS logs using LogParser tool.
• Used SQL Server Dynamic Management Views (DMVs) to track performance and usage.
• Creation of Clustered and Non-Clustered Indexes for Query Performance performing index maintenances and updating the statistics on databases.
• Setup high availability using Always on technology in SQL Server 2012. Setup and configure Always On in SQL Server 2012.
• Perform tasks related to Incident, request, and change management functions. Perform changes in configuration management databases
• Extensively collaborated with product development & engineering teams

Confidential, WA

Systems Analyst

Responsibilities:

• Responsible for deploying and configuring Virtual Machine, cloud services in Azure
• Responsible for Managing post provisioning, installing application components on VMs.
• Worked closely with PAAS and IAAS JSON templates
• Creating Cache Memory on Windows Azure to improve the performance of data transfer between SQL Azure and WCF services.
• Worked on storage accounts, CDN, and service bus for the data availability in global level.
• Worked on expiring object renewals, cert renewals in Azure
• Worked on AAD by configuring other applications client IDs in our application AAD.
• Responsible for troubleshooting the data sync issues between the databases in SQL Azure.
• Worked on expiring object renewals, cert renewals in Azure
• Responsible for configuring IIS security and windows firewall rules
• Performance monitoring, troubleshoot App/Server issues and work with support teams.
• Extensively managed and administered SQL Server 2008 and 2012 servers
• Migrated SQL server 2008 databases into SQL server 2012/2008R2 databases
• Configured Reporting Server Using Reporting Services Configuration Tool.
• Worked with SQL server Profiler to generate traces and fine-tuned databases and T-SQL
• Rebuilding the indexes at regular intervals for better performance and updated statistics
• Planned the complete backing up of Databases and Disaster Recovery /Restore procedures
• Installed, authored, and managed reports using SQL Server 2008 R2 Reporting Services.
• Setting up and Monitored transactional replication, Database mirroring on Production, servers.
• Worked on database design for Query optimization, performance tuning and Indexing.
• Wrote powershell scripts to verify the SQL server resource utilization during the Index maintainance of tables in DB
• Coordinate with Infra team to keep servers updated with security patches, maintaining service accounts and hardware requirements.
• Played key role in L3 in providing KTs for the Lower Level and created KBs for their reference to resolve the user issues.
• Attended day to day sync up calls of the team to discuss the progress of the project.

Confidential, WA

Service Build Engineer

Responsibilities:

• Responsible for deploying and configuring Virtual Machine, cloud services in Azure
• Responsible for designing and implementing Azure architecture
• Application deployment based on SQL Server 2008/2012 and IIS 7.5/8/8.5, Windows server 2008/2012, Web Service configuration.
• Designed and managed build and release methodologies using TFS for .NET Applications
• Created and executed build plans and deploy artifacts for specified products in various environments (User testing to Prod)
• Collaborated with Engineering and Operations teams for release management creation.
• Have diverse experience with software release engineering, developing packaged applications.
• Have Familiarity with software product lifecycle and release engineering processes
• Deployed services and code through Octopus configuration tool.
• Taken responsibility for developing processes, tools, automation for TFS based Software / Firmware build system and delivering SW/FW Builds for surface projects.
• Product documentation creation and upkeep Security Compliance with up to date Security Patching and vulnerability
• Installing security patches and scheduling regular maintenance to ensure the health and security on the servers.
• Deploy the changes effectively to controlled environments and includes all aspects of the end-to-end release process.
• Work on management/engineering requirements. Manage operational change control and schedule as per the MOF/ITIL Process.
• Ensure appropriate environments are available and setup and schedule to implement the release in production/pre production environments as well as performing release activities.
• Responsible for configuring IIS security and windows firewall rules
• Implement and maintain SQL Replication, mirroring and Windows/SQL cluster.
• Maintain the database consistency with DBCC, DMF and DMV’s at regular intervals.
• Troubleshoot and fine-tune databases for performance and concurrency.
• Update deployment guides, TSGs and monthly service reporting.
• Coordinate with Infra team to keep servers updated with security patches, maintaining service accounts and hardware requirements.
• Attended day to day sync up calls of the team to discuss the progress of the project.

Confidential, WA

Systems Analyst

Responsibilities:

• Install, configure and maintain servers for Web applications like ASP, ASP.NET, and HTML on IIS 5.0/6.0/7.0 on Windows Servers 2000/2003/2008.
• Responsible for configuring IIS security and windows firewall rules
• Installed and configured SSL certificates to ensure web site security
• Worked on High Availability like Log shipping, Clustering, Mirroring and Replication and AlwaysOn on 2012.
• Planned the complete backing up of Databases and Disaster Recovery /Restore procedures
• Creation of Clustered and Non-Clustered Indexes for Query Performance performing index maintenances and updating the statistics on databases.
• Installed, authored, and managed reports using SQL Server 2008 R2 Reporting Services.
• Worked with SQL server Profiler to generate traces and fine-tuned databases and T-SQL
• Integrated SQL traces with Performance Monitor to have better graphical analysis to find system bottlenecks to analyze CPU, Memory and Disk usage patterns
• Maintained the consistency of the OLTP databases by performing weekly activities like DBCC Check DB for consistency, index rebuilding, updating statistics.
• Extensively used SSIS Import/Export Wizard for performing the ETL operations.
• Deployed the generated reports on to the server and fine-tuned the database objects and server to ensure efficient data retrieval.
• Worked with ETL, Data Warehousing & OLAP Technologies.
• Monitor infrastructure for CPU, Memory and disk bottlenecks through daily SONAR reports to identify potential infrastructure problems and drive to resolve them before impacting the availability of the relevant applications.
• Primary point of contact for BCDR activities. Provide plan for updating documents and implementing BCDR failovers.
• Worked on storage accounts, CDN, and service bus for the data availability in global level.
• Responsible for troubleshooting the data sync issues between the databases in SQL Azure.
• Notify and communicate with customers and stakeholders about planned and unplanned downtime windows.
• Maintained the database consistency with DBCC at regular intervals.
• Provided 24x7 Production Database on-call support.

Confidential

Junior Database Administrator

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 disaster recovery plans in SQL 2005.
• Implemented MS Analysis Services setup, tuning, cube partitioning, and dimension design, including hierarchical and slowly changing dimensions.
• Wrote T-SQL code for creating cursor and handling the data validations.
• Designed and implemented stored procedures and triggers for automating tasks.
• Worked on 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.