SUMMARY

• 8 years of experience in Implementation, Administration and Support of MS SQL Server 2000/2005/2008/2008 R2/2012 in Development, Test, UAT and Production Environments.
• Installation and configuration of SQL server 2012/2008R 2/2008/2005/2000 with Health Care, Manufacturing and IT sectors.
• Specific hands on experience include administering large and complex Databases, Database Design.
• Expertise in setting up High availability environments likeactive - active and active-passive clustering,Database Mirroring,Replication and Log shipping.
• Good Handling Capability in Space Managements.
• Backup, restoration of production\DEV\TEST databases using NETBACKUP, Litespeed, AVAMAR and Trivoli Storage Manager.
• 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 in supporting Very Large databases upto 2TB and troubleshooting the problems.
• Experience with 2008 new concepts like Data Auditing, and Policy based management system.
• Experience with 2005/2008 concepts like data partitioning, online indexing, DDL triggers and DMV’s.
• Experience with T-SQL in writing triggers, tables, user defined views and experience in migrating SQL Server 2000 to SQL Server 2005/2008/R2.
• Experience in extracting and transforming data using SSIS, DTS Import/Export Data, Bulk Insert, BCP and DTS Packages.
• Experience in configure server and client network protocols like SQL Server and SQL Extensions in SQL 2005 using configuration manager.
• 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 the 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 the ongoing development of technology infrastructure such that they develop in line with company organizational, technical and commercial requirements.
• Microsoft ISA server Administration.
• Creation of the various policies on the 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 and 2012

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, IRVINE,CA

MSSQL DBA

Responsibilities:

• Handled Administration of SQL Server 2012, SQL 2008, SQL 2005 and SQL 2000.
• Handled Datacenter Migration of all the 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.
• Setup high availability schemes like Mirroring, Logshipping and Replication.
• Managed security by defining roles and rights.
• Requested refreshes pre or post restore activities.
• Proven ability to handle Database of more than 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 appropriate access to client except system databases owner’s and Client will have access to their respective needed application schema owners.

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, NJ

MSSQL 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 i.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 the 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 i.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 the 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

MSSQL DBA

Responsibilities:

• Managing hosting environment for maintaining uptime of all the production websites.
• Administrating SQL Server 2005 databases.
• Backup, restoration of production databases.
• Troubleshooting pertaining to Performance, Application management.
• Addressing queries regarding the Information System / Software & extending onsite support to the 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 the various policies on the 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 the 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