Sql Server Active Directory
Resume:
ANNAPURNA
Mobile: 206-***-****
Email: *****@****.***
PROFESSIONAL SUMMARY:
Around 7 years of experience in IT industry in deploying, configuring and troubleshooting runtime errors on SQL Server 2008/2008R2/2012/2014, Windows server 2008/2008R2/2012/2012R2 and IIS web server 6.0/7.0/7.5/8.
Expertise in Administering SQL 2008, 2008R2, 2012, 2014 on standalone systems and clustered servers.
Experience in creating jobs for database backup, restores and other maintenance tasks
Experience in High Availability (HA), Fail-Over, and Disaster Recovery (DR) options for SQL
Server across multiple data centers
Troubleshooting and detecting different types of SQL issues through SQL Profiler
Monitoring and analyzing system performance with SQL Profiler traces and fine tuning them in the production environment with the help of SQL Tuning Advisor.
Experience in writing T-SQL Queries and fine tuning Stored procedures.
Experience in migrating of databases to an upgraded platform (from SQL 2005 to SQL 2008, SQL 2008 to SQL 2008R2, SQL 2008R2 to SQL 2012, SQL 2012 to SQL 2014)
Maintaining multiple Internal/External websites on IIS 6.0/7.0/7.5 on multiple server environments using various techniques (Multiple IP’s, Ports, Host headers)
Experience in configuring Application Pools and assigning application pools to different websites.
Experience in migrating applications between windows servers and to an upgraded platform (from IIS 6.0 to IIS 7.0 and including IIS 7.0 to IIS 7.5)
Experience in Deployment in PPE and Production environments.
Installed and Configured SSL certificates as a part of maintaining security with respect to the servers as well as the client side.
Experience in monitoring network and other connectivity issues and troubleshooting client side and server side errors with the help of different types of troubleshooting tools.
Good experience in debugging ASP.NET both client side and server side issues.
Worked on troubleshooting connectivity errors between SQL and IIS.
Monitoring and Maintaining Servers for CPU health and Disk space through Perfmon tool.
Experience in creating and managing different virtual machines (VM’s) in physical machine using Hyper-V, SCVMM and VMware.
Experience in writing simple PowerShell Scripting tools for debugging daily production issues and automation for the VM’s.
Expertise in creating a Test environment for Production team to test their applications.
Extensive knowledge on AD, DNS, DHCP and ADLDS services.
Experience in Creating AD computer objects, OU’s, Users and creating GPOs and applying to OUs.
Experience in using SCOM tool for monitoring the health and performance of the servers.
TECHNICAL SUMMARY:
WEB/APP Servers
IIS 7.0/7.5/8.0/8.5
Operating Systems
Windows 2008/2008R2/2012/2012R2 servers
Languages
TSQL, C#
Databases
SQL 2008R2/2012/2014
Load Balancers
Network load balancer (NLB), F5 Big IP
Scripting
PowerShell Scripting
Monitoring tools
Event viewer, Performance monitor, HTTP Watch, Fiddler, SQL Profiler, Netmon, Telnet, Nslookup, PSExec.
Ticketing System
Remedy, Team Foundation System (TFS), MS ticketing, MS interface, ICM
Virtualization Technologies
Hyper-V, SCVMM, VM Ware.
Cloud Computing
Microsoft Azure (IAAS, PAAS)
High Availability/ DR techniques
Mirroring, Logshipping, AlwaysOn and clustering
Active Directory Services
ADLDS (Active Directory Lightweight Directory Services)
PROFESSIONAL EXPERIENCE:
Client: Microsoft
Project: Azure Engineering Systems
Duration: August 2015 – till date
Vendor: TCS
Role: Service Engineer, SQL Database Administrator and Windows Administrator
RESPONSIBILITIES:
Develop and maintain automation suite using technologies like PowerShell, SQL and XML
Monitor SQL databases & maintenance jobs
Participate as a team-member in data management strategies.
Uphold enterprise policy guidelines and recommend new/improved guidelines.
Maintain database availability during operating windows
Install, configure, and administer databases in a multiple database server, high availability environments and work on Disaster Recovery Scenarios
Design, automate and document backup, archival, and cleanup tasks
Prepare and maintain documentation on all database installations and configurations
Install, configure and administer databases in all environments including load/hardware analysis mapping, fault tolerance, and security
Proactively monitor the database systems to ensure secure services with minimum downtime
Troubleshoot SQL development problems.
Implement SQL Server Mirroring, Replication, Clustering, Log Shipping and AlwaysOn on 2012, 2014
Responsible for writing trouble shooting guides and documenting day to day activities
Develop PowerShell scripts to automate investigation methodologies
Working knowledge on ADLDS and creating users, groups and services in ADLDS.
Experience in Creating AD computer objects, OU’s, Users and creating GPOs and applying to OUs.
Responsible for Windows Administration, IIS, Load balancing tasks
Creating and maintaining VMs in Windows Azure using IAAS.
Experience in writing simple PowerShell Scripting tools for debugging daily production issues and automation for the VM’s.
Expertise in creating a Test environment for Production team to test their applications.
Experience in monitoring network and other connectivity issues and troubleshooting client side and server side errors with the help of different types of troubleshooting tools.
Monitoring and Maintaining Servers for CPU health and Disk space through Perfmon tool.
Experience in Deployment in PPE and Production environments and maintaining multiple websites.
Working knowledge of Active Directory, DNS, DHCP and basic networking concepts
Troubleshooting client connectivity issues.
Responsible for writing trouble shooting guides and documenting day to day activities
Develop PowerShell scripts to automate investigation methodologies
Knowledge on changing servers from one VLAN to another
Knowledge on troubleshooting network related issues.
Client: Microsoft
Project: C+E Security Engineering
Duration: July 2013 – July 2015
Vendor: TCS
Role: Service Engineer, SQL Database Administrator and Windows Administrator
RESPONSIBILITIES:
Develop and maintain automation suite using technologies like PowerShell, SQL and XML
Created stored Proc to monitor the databases growth.
Created DIP monitoring for web servers
Created PowerShell script to Configured Virtual servers by using Hyper-V technology.
Configured Automatic failover for SQL server to run the maintenance works without downtime
Implemented AlwaysOn on SQL server 2012 and SQL Server 2014.
Periodical Database maintenance tasks (cleaning up VLFs, Indexes creation etc.)
Building SQL Environment from scratch with appropriate raid configuration to protect the data from hardware issues.
Worked with Load Balancers and virtual IP's (VIP's) in clustered and non-clustered environments.
Supporting Tier2 Team in writing TSGs
Experience in Creating AD computer objects, OU’s, Users and creating GPOs and applying to OUs.
Involved in all Product version upgrades
Develop test plan, test cases and execute test cases for every release
Involved in BCP (Business Continuance Plan) testing
Interacting with product Dev team to resolve various issues.
Develop and maintain complex SQL databases, stored procedures
Install, configure and maintain Microsoft SQL Server 2008R2, SQL Server 2012, SQL Server 2014
Implement SQL Server Mirroring, Replication, Clustering, Log Shipping and AlwaysOn on 2012 and 2014
Monitoring and troubleshooting database performance and performance tuning
Responsible for Deploying, Scaling and providing support for Internal Security tools
Monitor application database size and growth patterns
Installing and configuring SSL certificates for the particular websites for the security purpose.
Interact with customers as needed, to collect business requirements for capacity planning of SQL Servers, in root cause analysis and troubleshooting problems
Provide production support for all database applications, on-call on rotational basis
Perform problem resolution and root cause analysis along with recommending and implementing preventive techniques
Prioritize and execute tasks in a high-pressure environment
Work in a team-oriented, collaborative environment
Responsible for writing trouble shooting guides and documenting day to day activities
Develop PowerShell scripts to automate investigation methodologies
Responsible for Windows Administration, IIS, Load balancing tasks
Responsible for Installing, configuring, and supporting IIS 7.0/7.5 web servers on windows server 2008/2008R2.
Creating and configuring different websites using different IP addresses, port numbers and host headers in IIS manager.
Deploying ASP.Net and web applications on IIS 7.0 and IIS 7.5
Experienced in configuring the application pool recycling for greater reliability.
Client: Microsoft
Project: MSG
Duration: Mar 2012 - July 2013
Vendor: TCS
Role: Service Engineer, SQL Database Administrator and Windows Administrator
RESPONSIBILITIES:
Worked extensively on installation, upgrade and configuration of SQL Server 2008 and SQL Server 2008R2 on standalone systems as well as cluster servers.
Responsible for maintaining databases, configuring permissions, and performing backup and restore jobs.
Responsible for setting up, and troubleshoot SQL Server log shipping issues.
Resolved SQL Server software and database performance level issues
Worked on setting up, monitoring and troubleshooting SQL Agent job involved in different types of Replication
Worked extensively on building high availability systems by using clustering and mirroring.
Responsible for Installing, configuring, and supporting IIS 7.0/7.5 web servers on windows server 2008/2008R2.
Creating and configuring different websites using different IP addresses, port numbers and host headers in IIS manager.
Deploying ASP.Net and web applications on IIS 7.0 and IIS 7.5
Experienced in configuring the application pool recycling for greater reliability.
Manipulating PowerShell scripts for debugging purposes.
Monitoring IIS application logs, ASP.Net, system logs and security logs by using Event Viewer for troubleshooting application related and windows server related issues.
Involved in Performance tuning and optimizations of web applications using tools like PERFMON and Task Manager.
Supporting and participating in the on call rotation for maintenance and troubleshooting of IIS websites and windows servers.
Worked on migrating applications and websites from IIS 7.0 to IIS 7.5 and from windows server from 2008 to 2008R2.
Installing and configuring SSL certificates for the particular websites for the security purpose.
Have good working experience in implementing different load balancing methodologies to ensure the High Availability of ASP.net web applications in the production environments.
Set up database connectivity and established connection pools.
Created and managed Active Directory, OU, GPO users and groups.
Worked with Load Balancers and virtual IP's (VIP's) in clustered and non-clustered environments.
Created and Configured Virtual servers by using Hyper-V technology, VMware ESX.
Knowledge on vulnerability management principles, patch management and deployment.
Experience in using SCOM tool for monitoring the health and performance of the servers.
Company: Accenture, Bangalore, India
Duration: May 2010 –Oct 2011.
Role: Systems Engineer
RESPONSIBILITIES:
Installed, upgraded, configured, compiled, support of various .NET applications on windows 2008 machines for Prod, QA, staging and on development
Configured ASP.net applications in IIS 7.0 on win 2008 servers in a clustered and Load Balanced Web Farm environment to achieve reliability.
Configured and maintained different application pool (AP) and assigned No. of worker process to the websites.
Created and configured virtual directories using IIS Manger to support new additional applications located in different place to the existing websites.
Experience in adding nodes and pools to Load balancers using the F5BigIP console
Participated in Disaster Recovery Planning discussions, configuration management and implementations.
Maintained Lab environments for testing server applications prior to production pushes or changes.
Debugged IIS issues like memory leakage, security issues, and IIS logs.
Involved in optimization of various IIS and .Net applications on different windows servers.
Configured DNS, WINS entries in windows, proxy in IIS 7.0.
Company: ADP CORPORATION, India
Duration: June 2009 – May 2010
Role: Systems Administrator
ROLES & RESPONSIBILITIES:
Installed, configured, administered and supported Windows based application on IIS 6.0.
Responsible for configuring, maintaining, upgrading, and supporting over IIS Servers, in both an Intranet and Extranet environment. Upgrading vendor application
Used Log Analyzer for performance tuning and troubleshooting.
Maintain Support and provide IIS administration for web intranet applications
Involved in trouble shooting and providing technical assistance for Web Hosting team on various Application and Web Servers including IIS, Windows Servers, Windows server space issues etc.
Configured multiple websites in IIS and installed Plug-ins to proxy requests to Application server.
Monitoring All Servers, shutdown and boot up, Network Support and Trouble Shooting.
EDUCATION: Bachelor’s Degree from Jawaharlal Nehru Technological University.
Contact this candidate