SUMMARY

• Over 8 years of experience in Implementation, Administration and Support of MS SQL Server 2000/2005/2008/2008 R2/2012 and 2014 wif Health Care, Manufacturing and IT sectors.
• Installation configuration and upgrade of SQL server 2014/2012/2008 R 2/2008/2005/2000 in Development, Test, UAT and Production Environments.
• Migrating\Upgrading lower versions of SQL Server to SQL Server 2012 and 2014 by In - Place Upgrade Process and as well as Side-By-Side Upgrade Process.
• Extensively worked on Active-Active and Active-Passive Clustered environment of SQL Server Versions 2014/2012/2008 R 2/ 2008/2005/2000 as High Availability Techniques.
• Implemented Database Mirroring on 2008/2008R2/2012 and Setting Always On Availability Groups on SQL Server 2012
• Specific hands on experience include administering large and complex Databases, Database Design.
• Expertise in setting up other High availability environments Replication and Log shipping.
• Extensively worked on SSIS Implementations, configuring and deploying ETL pakages through SSIS and troubleshooting SSIS jobs.
• Migrated DTS packages into SSIS packages using Upgrade Advisor Tool and SSIS wizard, BI tools.
• Good Handling Capability In Space Managements.
• Installation and configuration of SSRS and deploying reports.
• Backup, Restoration of Production\QA\DEV\Test databases using backup tools like Netbacup,Avamar,Trivoli,Avamar,Litespeed and MS SSMS
• Created custom-tailored database backup/restore scripts for Full, Differential and Transactional backups and scheduled jobs for DBA automation task. Upgraded/migrated databases from lower version of database to higher version. Experienced in Migrating data between servers.
• Experience wif concepts like data partitioning, online indexing, DDL triggers and DMV’s,Data Auditing, and Policy based management system.
• Experience in extracting and transforming data using SSIS, DTS Import/Export Data, Bulk Insert, BCP and DTS Packages.
• Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC utilities and Index Tuning Wizard.
• Intensive experience in monitoring database performance using SQL Profiler, and teh DB’s percent log space for all database servers using SCOM and Windows Performance counters.
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Excellent communication, analytical and inter personal skills and ability to learn new concepts and supported 24/7 on call in production and development environment.
• Excellent Communication Skills and Presentation Skills, Comprehensive problem solving abilities
• Installing and configuring Active Directory on windows 2008 & 2003.
• Configuring IIS 5.5 and IIS 6.0.
• Configuring and administrating MOSS 2007.
• Managing Microsoft Forefront.
• Installing & configuring HyperV on windows 2008 servers.
• Managing WSUS.
• Managing Microsoft System Centre Operation Manager 2007 & MOM 2005.
• Contributing to teh ongoing development of technology infrastructure such that they develop in line wif company organizational, technical and commercial requirements.
• Microsoft ISA server Administration.
• Creation of teh various policies on teh ISA server.
• Create Users & Groups and Applying Security.
• Designed Organizational Unit Structure (OU’s) in Active Directory.
• Configured and Implemented Group Policy Objects in Active Directory.

TECHNICAL SKILLS

Databases: MS SQL Server 2000/2005/2008 R2/2012 and 2014

Tools: /Utilities SSMS,SQL Server Enterprise Manager, Profiler, SQL Navigator BCP, Query Analyzer, SSIS, DTS, SSRS, NETBACKUP,SCOM,AVAMAR,TRIVOLI and LITESPEED. /Database MAIL and SQL Agent

Programming: T-SQL

Ticketing system: ServiceNow and Remedy

Operating Systems: Windows NT/2000/2003 and 2008.

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

MSSQL DBA (Tech Lead)

Responsibilities:

• Installed and configured SQL Server 2014/2012/2008 R2 on standalone and windows clustered servers.
• Backup, restoration of production databases using Netbackup and scheduling them through ESP.
• Involved and set up of SQL Server 2012 availability groups and SQL Server 2012 SSIS Catalog.
• Involved in Migration\Upgrade of teh Server SQL Server, SQL Server 2008R2 to 2012/SQL 2014 and DTS to SSIS, and involved in SAN Migration for teh SQL Server 2014/ 2012 and 2008R2 Servers.
• Setup high availability schemes like Mirroring,Logshipping and Replication.
• Extensively worked SSIS Implementations, configuring and deploying SSIS packages and troubleshooting SSIS jobs, SSRS reports deployments.
• Managed security by defining roles and rights.
• Set up security and access profiles and procedures for database system administrators.
• Requested refreshes pre or post restore activities.
• Proven ability to handle Database of more TEMPthan 1 TB in Size.
• Database recoveries as per requirements.
• Installed & configured database software, associated database tools and performance monitoring software
• Troubleshooting pertaining to Performance, Application management.
• Set up MSSQL Mail, SMTP.
• Provided overall configuration and change control management for data base components.
• Provided appropriate access to client except system databases owner’s and Client will have access to their respective needed application schema owners.
• Experience in Constructing Server Baselines and Performance Tuning using tools like Windows System Monitor, SQL Profiler, DMV's, and SQL Query Analyzer and performed Query Optimization.
• To analyze long running slow queries and tune teh same to optimize application and system performance.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Monitored and modified Performance using execution plans and Index tuning.
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Managed Disk space, memory and User connections.
• Rebuilding teh indexes at regular intervals for better performance
• Monitoring teh servers using spot light third party Quest software.

Environment: Windows Server 2008 and 2012 Enterprise Edition, MS-SQL Server 2 R2 / 2005, 2000,Clustering,Logshipping,Mirroring, SSIS, SSRS, T-SQL, backup/restore,IIS,SCOM and Sharepoint.

Confidential, IRVINE,CA

MS SQL DBA

Responsibilities:

• Handled Administration of SQL Server 2012, SQL 2008, SQL 2005 and SQL 2000.
• Handled Datacenter Migration of all teh SQL Servers from Confidential Datacenter to TCS Datacenter.
• Backup, restoration of production databases using Netbackup tool and Avamar.
• Up gradation of Database from SQL Server and 2008.
• Installation and configuration of SQL Clusters.
• SQL server 2012 Always On experience.
• Setup high availability schemes like Mirroring, Logshipping and Replication.
• Creating teh ETL packages through SSIS.
• Managed security by defining roles and rights.
• Requested refreshes pre or post restore activities.
• Proven ability to handle Database of more TEMPthan 1 TB in Size.
• Database recoveries as per requirements.
• Installed & configured database software, associated database tools and performance monitoring software.
• Troubleshooting pertaining to Performance, Application management.
• Configured teh RAID levels for data files, log files and tempdb at server level.
• Reconfigured teh default locations of teh data files, log files and error log files onto teh SAN environment for all teh servers.
• Monitored and modified Performance using execution plans and Index tuning.
• Rebuilding teh indexes at regular intervals for better performance.
• Worked on key performance indicators for customizable metrics. To set up SQL Server configuration settings.
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Managed Disk space, memory and User connections.
• Rebuilding teh indexes at regular intervals for better performance
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Using log shipping for synchronization of database.
• To setup, implement, and maintain industry standards in database management.
• Monitoring teh servers using spot light third party Quest software.

Environment: Windows Server 2008 Enterprise Edition, MS-SQL Server R2 / 2005, 2000,Clustering,Logshipping,Mirroring, SSIS, SSRS, T-SQL, backup/restore,IIS,SCOM and Sharepoint.

Confidential, Medco, NJ

MS SQL DBA

Responsibilities:

• Involved in updating existing databases of SQL server 2008. Managed database security policy login using Windows and SQL server authentication mode.
• Managing databases spread across multiple servers in Production, Development, Staging and Testing environments using SQL 2008 and SQL 2005 on Windows Active- Active Clustered Environment
• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions implement best practices to maintain optimal performance.
• Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques. Worked on SQL2008 Data compression and Table Partitioning.
• Replicate data from acceptance to QA and production phase.
• Checked database upgrade advisor for compatibility check for databases before updates. Performed in place and side by side migration of existing SQL server 2005 user’s client critical databases. Also changed configuration of databases, increased physical memory, and enabled text indexes. Migrated database from SQL server 2005 to SQL server 2008 using utilities me.e. export / import and attach/detach for SQL servers 2008 features.
• Created, altered, maintained system roles, Logins and permissions to users on various database objects. Designed role based security to managed users activities, Identified and created constraints on table columns.
• Audited database user’s using SQL profiler tool and costumed stored procedures and packages. Hide tables columns from teh developers and non - technical staff member using views.
• Created maintenance plans for database for scheduling rebuild\Reorganizing indexes, update statistic and check integrity. Performed restore operation and Point in Time recovery for mission critical databases.
• Generated reports by using SSRS and provided them on Share point 2010 Report manager.
• Enabled email notification, linked servers, certificates, symmetric keys for advance database use.
• Used DBCC commands, System monitor, Dynamic views, Actual Execution plans as part of trouble shooting and performance tuning.

Environment: Windows Server 2008,2003 and 2000, MS-SQL Server R2 / 2005, 2000, Clustering, Logshipping, Mirroring, SSIS, SSRS, T-SQL, backup/restore, IIS,SCOM and SharePoint

Confidential NJ

SQL Server Developer / DBA

Responsibilities:

• Involved in updating existing databases of SQL server 2008. Managed database security policy login using Windows and SQL server authentication mode.
• Managing databases spread across multiple servers in Production, Development, Staging and Testing environments using SQL 2008 and SQL 2005 on Windows Active- Active Clustered Environment
• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions implement best practices to maintain optimal performance.
• Optimizing Stored Procedures and long running queries using indexing strategies and query-optimization techniques. Worked on SQL2008 Data compression and Table Partitioning.
• Replicate data from acceptance to QA and production phase.
• Checked database upgrade advisor for compatibility check for databases before updates. Performed in place and side by side migration of existing SQL server 2005 user’s client critical databases. Also changed configuration of databases, increased physical memory, and enabled text indexes. Migrated database from SQL server 2005 to SQL server 2008 using utilities me.e. export / import and attach/detach for SQL servers 2008 features.
• Created, altered, maintained system roles, Logins and permissions to users on various database objects. Designed role based security to managed users activities, Identified and created constraints on table columns.
• Audited database user’s using SQL profiler tool and costumed stored procedures and packages. Hide tables columns from teh developers and non - technical staff member using views.
• Created maintenance plans for database for scheduling rebuild\Reorganizing indexes, update statistic and check integrity. Performed restore operation and Point in Time recovery for mission critical databases.
• Generated reports by using SSRS and provided them on Share point 2010 Report manager.
• Enabled email notification, linked servers, certificates, symmetric keys for advance database use.
• Used DBCC commands, System monitor, Dynamic views, Actual Execution plans as part of trouble shooting and performance tuning.

Environment: Windows Server 2008, 2003, 2000, MS-SQL Server 2008 R2 / 2005, 2000, Clustering, Logshipping, Mirroring, SSIS, SSRS, T-SQL, backup/restore,IIS,SCOM and Sharepoint

Confidential

MS SQL DBA

Responsibilities:

• Managing hosting environment for maintaining uptime of all teh production websites.
• Administrating SQL Server 2005 databases.
• Backup, restoration of production databases.
• Troubleshooting pertaining to Performance, Application management.
• Addressing queries regarding teh Information System / Software & extending onsite support to teh developers regarding SQL server 2005 databases, IIS and Microsoft share point server 2007.
• Installation Configuration of SQL server reporting services.
• Troubleshooting SQL Server performance issues.
• Configuring and monitoring SQL Replication.
• Configuring and maintaining SQL server 2005 Cluster.
• Troubleshooting IIS 6.0 problems, analyzing web logs using websolite tool.
• Installing and configuring Active Directory on windows 2008 & 2003.
• Configuring and administrating MOSS 2007.
• Managing Microsoft Forefront.
• Installing & configuring HyperV on windows 2008 servers.
• Managing WSUS.
• Managing Microsoft System Centre Operation Manager 2007 & MOM 2005.
• Microsoft ISA server Administration.
• Creation of teh various policies on teh ISA server.
• Create Users & Groups and Applying Security.
• Designed Organizational Unit Structure (OU’s) in Active Directory.
• Configured and Implemented Group Policy Objects in Active Directory.
• Published resources in Active Directory and control access to them.
• Applied Security Policies and Audit policies by using AD Group Policy Objects
• Implementation and administration of DNS, DHCP.
• Troubleshooting pertaining to Performance, Network Administration, Application Conflicts and system Bugs.
• Administering users, profiles, group accounts
• Create Users, Groups, Roaming profile and applying Security.
• Network Infra-Structure Management on Microsoft 2008 & 2003 domain.
• Commissioning of Routers / Switches / Hubs/ hardware devices and software, ensuring maximum uptime
• Configuring access limit for teh Routers.

Environment: Windows Server 2008,2003 and 2000, MS-SQL Server 2008 R2 / 2005, 2000,Clustering,Logshipping,Mirroring, SSIS, SSRS, T-SQL, backup/restore,IIS,SCOM and Sharepoint.