SUMMARY:

• 8 years of Database Administration and Development experience on MS SQL Server 2012/2008 R2/2008/2005/2000 in Very Large Data bases and Complex Databases. Experienced in Installing, Configuring, Managing, Monitoring, Troubleshooting, Upgrading and Migrating SQL Server 2012/2008/2005/2000 on VM Ware Clustered and Standby Environments. Experienced on Always on Availability Groups of SQL Server 2012 Extensive experienced with configuring high availability and Disaster recovery solutions like clustered environments, Set up different topologies in replication, Log shipping and mirroring. Extensively Worked on Transactional Replication and Snapshot Replication. Expertise in setting up Active/Passive and Active/Active Clusters for High availability. Implemented Data partitioning, Snap shot isolation, database mirroring, database snapshot, DDL triggers, try-catch blocks, online indexing, DMV's, DMF's, Mail Setup Expertise and Interest include Administration, Database Design, Performance Analysis, configured more than 2GB RAM, highly transactional servers and Production Support for VLDB Expertise in Database Backup and Recovery procedures by using Native backups with 3rd party tools like Lite Speed Experienced in Migration from SQL server 2000, 2005, 2008, 2008R2 to 2012 by using In-Place and side-by-side upgrade process and documented Pre-Migration and Post-Migration Steps
• Experienced in Performance Tuning, Query Optimization, and Database Consistency Checks using DBCC Commands, DMV's and DMF's, Re-indexing, Updating Statistics
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels
• Good experience in resolving SQL Server blocking and Dead Lock Issues.
• Expert in Performance Tuning by Index Defragmentation, optimizing execution plans, proper usage of indexes, horizontal and vertical partitioning.
• Expertise in T-SQL in writing stored procedures, granting permissions and avoiding recompilation triggers and functions.
• Good Experience using OSql language for DDL and DML commands
• Used Filtered Indexes for improving query performance, lower storage and maintenance cost.
• Extensive experience in Capacity Planning, Disaster Recovery Planning, Troubleshooting, Security Management, Backup and Restore Procedures.
• Used third party tools like Idera, Lite speed, Red gate, VERITAS net backup. Experience with IIS Manager configuring applications, web, FTP, SMTP, attaching certificates
• Experience working with TFS as source control and version control and worked in Agile methodology
• SQL Server Business Intelligence Development Studio expertise to create SSRS reports, SSIS packages and SSAS with OLAP.
• Expert in extracting from different sources like Oracle, SQL server, excel etc. transforming and loading data using data transformation services like Batch processes , Import/Export, SSIS, DTS, BCP and Bulk Insert.
• Extensively worked on SSRS building various types of reports and ad-hoc models.
• Good knowledge on new concepts of 2008 like PowerShell, Policy based management, Resource Governor Etc. Strong technical background along with the ability to perform business analysis and write effective documentation and specifications Strong experience in mentoring team members and writing documentation. Excellent communication, presentation and interpersonal skills. Strong troubleshooting and organizational skills. 24 X 7 Production Database on Call Support

TECHNICAL SKILLS:

Confidential

SQL DBA

Responsibilities:

• Managed and Administrated SQL SERVER 2012/2008R2/2008/2005 highly trans active Production Environment
• Worked On Incidence Management, Failed Jobs
• Worked On Backup and Restore, Data full and Log full issues
• Performance tuning and Index maintenance
• Worked on failed logins ,SA accounts
• Worked on Linked servers, Registered servers and distributed Queries and distributed transactions
• Involved in meetings and Knowledge share
• Good command on Profiler, Activity Monitor,Perfmon Counters, Standard reports
• Good experience looking for errors in Error logs and Windows event log
• Good experience working with DBCC Commands, DMVs, and System stored procedures etc.
• Good experience working with Execution plan, Query hints, Join hints
• Experience in partitioning, database Designing and normalization etc
• Confidential

SQL Server DBA

Responsibilities:

• Designed and implemented comprehensive Backup plan and disaster recovery and restore databases like point-in-time restore
• Worked on relational DBMS with Microsoft SQL Server with different versions
• Experienced in Memory configurations for SQL Servers 2005,2008,2008R2 and 2012 on Windows2003R2, Windows7, Windows 2008 and Windows 2008R2
• Managed and Administrated SQL SERVER 2012/2008R2/2008/2005 highly transitive Production Environment and Data Center with RDP.
• Installed, Configured, Monitored, Troubleshooting SQL server 2012/2008R2/2008/2005 on VMware and Standby Environments.
• Upgrading and Migrating SQL Server from 2005 to 2008 and 2008R2 to 2012 on VM ware Fail over Clustered and Standalone environment.
• Migrated databases and database objects like stored procedures from SQL Server 2005 to SQL Server 2008 and 2008 to 2012 and documented the process with Pre-Migration and Post-Migration steps.R2
• Implemented Data partitioning ,Snap shot isolation, database mirroring, database snapshot, CTE, try-cache blocks, online indexing, DMV's, DMF's, Mail Setup, Jobs, and Alerts
• Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Suggested Backup Strategies and scheduled the Backups Restoration for Databases and Transaction log.
• Monitoring backup jobs daily and run the jobs manually in case of failure depending upon the necessity and prepared daily report on the job failures, backup failures and disk space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Worked on Always on Availability Groups SQL Server 2012
• Prepared Documentation for the Disaster Recovery plan
• Monitored and respond to alerts from SCOM.
• Monitored and modified Performance using execution plans and Index tuning.
• Experienced in publishing and maintaining logical data models with exposure to and experienced in developing, validating, publishing and maintaining physical data models.
• Experienced working on SQL Server 2012 Always on Availability Groups.
• Checking Database Health by using DBCC Commands and DMV'S.
• Administrate security for server's logins Windows and SQL Accounts .
• Granted permission to user s , role s , and object s . Support column level permissions.
• Creating and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.
• Assisted developers in various problem resolutions, debugging and optimization of SQL queries and stored procedures, including connectivity, code efficiency and communication issues.
• Worked extensively in Query analyzer and profiler for tuning queries using variables for characteristics and query costs.
• Worked on CDC Change Data Capture .Captured the inserted, Updated and deleted data into SQL server tables by using CDC.
• Experienced working with BIDS/SSDT on SSIS,SSAS and SQL server Reporting Services SSRS
• Experienced in developing, maintaining and deploying complex SSIS packages. Implemented ETL for large datasets.
• Experienced in developing, maintaining and deploying complex SSRS reports.
• Responsible for managing and improving database performance and stability
• Monitoring SQL server performance using profiler to find the performance and dead locks.
• Experienced in using Linked Servers
• Able to estimate, plan, and organize tasks associated with the role with minimal assistance
• Oracle experience working with table spaces,objects,stored procedures and indexes and data type

Environment: Windows 2000,2003,2003R2,2008,2008R2 SQL Server 2012, 2008R2, 2008, 2005, 2000 and Lite speed, Red gate, Erwin, BIDS and SSDT, Share point Server,TFS, Ticketing tool ,Agile Methodology,HP Manager, Microsoft Outlook, MSOffice, Oracle, Sybase, DB2, .Net, My SQL,SCOM

Confidential

SQL Server DBA

Responsibilities:

• Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Implemented the new SQL Server 2008 concepts like Data partitioning ,Snap shot isolation, database mirroring, database snapshot, CTE, try-cache blocks, online indexing, DMV's, DMF's, Mail Setup, Jobs, and Alerts
• Experience in Using PowerShell Scripting
• Migrated databases from SQL Server 2005 to SQL Server and documented the process with Pre-Migration and Post-Migration steps.
• Upgrading and Migrating SQL Server from 2005 to 2008 on VM ware Fail over Clustered and Standalone environments with Active -passive clustered environment. Worked with the max database of size 5TB.
• Hands on experience in Installing, Configuring, Managing, Monitoring, Troubleshooting SQL Server 2008R2 on VM Ware Clustered and Standby Environments.
• Managed and Administrated SQL SERVER 2008R2/2008 highly transitive Production Environment
• Experienced in Memory configurations for SQL Servers 2008on Windows7 and Windows 2008.
• Checking Database Health by using DBCC Commands and DMV'S.
• Monitored and modified Performance using execution plans and Index tuning.
• Used log shipping for synchronization of databases.
• Prepared Documentation for the Disaster Recovery plan
• Extensively worked on trouble shooting and fine-tuning of databases for performance
• Designed and implemented comprehensive Backup plan and disaster recovery and restore databases like point-in-time restore
• Worked extensively in Query analyzer and profiler for tuning queries using variables for characteristics and query costs.
• Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Update statistics, database integrity check and Backup operations
• Worked on CDC Change Data Capture .Captured the inserted, Updated and deleted data into SQL server tables by using CDC.
• Monitored and respond to alerts from SCOM.
• Experienced working with BIDS/SSDT on SSIS,SSAS and SQL server Reporting Services SSRS
• Responsible for managing and improving database performance and stability
• Monitoring SQL server performance using profiler to find the performance and dead locks.
• Experience Using Linked Servers
• Extensively used Repositories like Team Foundation Server TFS
• Experience working in an agile development environment.
• Worked on call 24/7 Support on weekly basis.

Environment: MS SQL Server2008 R2, 2008, T-SQL, BIDS, Erwin, Lite Speed, Red gate , Oracle, ASP.Net 3.0, SharePoint Server 2007, Windows 2003R2, 2007,2008, Microsoft Outlook,SCOM

Confidential

SQL DBA

Responsibilities:

• SQL Server 2000/2005/2008/2008R2 Database Administration.
• Implemented the new SQL Server 2005 concepts like Data partitioning ,Snap shot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks, online indexing, DMV's, DMF's, Mail Setup, Jobs, and Alerts and Dedicated Admin Connection.
• Implemented the disaster recovery models like clustering, mirroring, log shipping and transactional replication.
• Migrated databases from SQL Server 2000 to 2005 and 2005 to SQL Server 2008/2008 R2
• Used to work on Installation, Configuring, Managing, Monitoring, Troubleshooting SQL Server 2008R2/2008/2005 on VM Ware Clustered and Standalone Environments
• Created Documentation for steps need to be taken while upgrading the SQL server 2000 to SQL server 2005 and SQL server2005 to 2008
• Experience in Database security and integrity planning.
• Created Maintenance Plans for Regular Backups and Rebuilding and Reorganizing of Indexes.
• Configured more than 2 GB ram on 32 bit Environment.
• Tuning queries which are running slow using Profiler and Statistics IO by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Successfully implemented the Capacity planning for different servers.
• Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression CTE .
• Checked Database Health and consistency by using DBCC Commands and DMVS
• Monitored and modified Performance using execution plans and Index tuning.
• Worked in Active -passive cluster environment.
• Recovered the System and User databases from suspect mode.
• Used log shipping for synchronization of databases.
• Prepared Documentation for the Disaster Recovery plan
• Experienced in writing Stored Procedures ,Triggers , Functions as per client requirements
• Extensively worked on trouble shooting and fine-tuning of databases for its performance
• Designed and implemented comprehensive Backup plan and disaster recovery
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Daily routine DBA tasks like handling user's permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs, Backups and restores
• Rebuilding the indexes at regular intervals for better performance
• Managing the VERITAS net backups and lite speed.
• In-depth knowledge of techniques for analyzing query execution plans and tuning queries and databases for optimal performance
• Scheduled and monitored all maintenance activities including database consistency check, index defragmentation.
• Routine DBA jobs like Backups and Restores. Hands on experience in trouble shooting database issues.
• Performed all basic Database activities like moving databases between servers, copy databases
• Used Update statistics, database integrity check and Backup operations
• Worked in creating SSIS packages Modify, Summarize and clean data to target tables and also experienced in creating packages to transfer data between OLTP and OLAP databases with BIDS.
• Experienced in Using Linked Servers
• Used SQL server Reporting Services SSRS to create reports.
• Involved in development and implementation of SSIS, SSRS and SSAS application solutions for various business units across the organization.
• Monitoring SQL server performance using profiler to find Blocking and dead locks.
• Worked on call 24/7 Support on weekly basis.

Environment: Windows 2003R2, 2007, 2008 MS SQL Server 2005/2008/2008R2, BIDS, Oracle, .net, Power designer, lite speed, Microsoft Outlook, Red gate, Team Foundation Server

Confidential

SQL DBA

Responsibilities:

• Database Administrator, Database Programming using SQL management studio
• Relocation of Databases from one server to another server using attach and detach databases.
• Involved in up gradation of Touch works Database.
• Touch works application was implemented in Active Passive clustered environment.
• Administered SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Rebuilt indexes at regular intervals for better performance
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Migrated DTS packages from Legacy system to SQL SERVER 2005. Using the Lite speed to take backups. Migrated data from Oracle to SQL Server Involved in Weekly Change Management, in which code developed by developers is run on production server. Implemented log shipping between two instances of servers using Database Maintenance Plan by creating a Monitor server and a shared Folder. Involved in trouble shooting and fine-tuning of databases for better performance and concurrency Monitored and modified Performance using execution plans and Index tuning. Recovered databases from backup in disasters Maintained database consistency with DBCC at regular intervals Transferred data ETL to Data ware house Environment using SSIS Administered SQL Server configuration settings. Implemented log shipping for synchronization of database. Excellent experience in data modeling and metadata services. 24 X 7 Production Database on Call Support. Expertise in SQL Server Analysis Services SSAS and SQL Server Reporting Services SSRS . Monitored SQL server performance using profiler to find performance and dead locks. Responsible for Maximum performance and uptime in production environment. Analyzed long running slow queries and tune the same to optimize application and system performance. Handled up to half TB Size databases with clustered and replication environment Administered SQL Server configuration settings to resolve various resource allocation memory issues for SQL Server databases and to setup ideal memory, min/max server options. Implemented database development enhancements to multiple SQL Server databases to ensure a flawless functioning of production environment. Performed installations performance tuning, manage capacity planning user accounts, and implement database security for multiple instances of development, certification, QA, and production SQL Servers databases. Designed developed data models and performed forward and reverse engineering using data modeling tools like ERWIN. Environment: Windows 2003, MS SQL Server 2000/2005, Access, Lite speed

Confidential

SQL Server DBA

Responsibilities:

• Used to work on Installation, Configuring, Managing, Monitoring, Trouble shooting SQL Server 2000, 2005 on VM Ware Clustered and Standalone Environments
• Installed and configured SQL Server 2000, 2005 on Windows server 2000, 2003, 2008R2.Involved in Database up gradation and Migration of SQL2000 to 2005 and documented Pre Post Migration activities.
• Designed T-SQL scripts to identify long running queries and blocking sessions
• Involved in Performance monitoring and performance tuning by implementing efficient schemas, Optimizing queries, Tuning indexes and Database Consistency Checks using DBCC Commands .
• Migration of database objects between databases and involved in monitoring SQL Server clustering.
• Exported and imported data from text files and Excel to SQL Server using bulk insert and BCP utility.
• Involved in troubleshooting dead lock issues and performance issues for optimal performance.
• Used the Index tuning wizard and rebuilt indexes for faster query response.
• Experienced in writing and Debugging T-SQL Scripts and stored procedures, Views and UDFs
• Installed and Configured SQL Server 2005 with latest service packs.
• Developed Backup and Restore scripts for SQL Server 2000and 2005
• Worked on Normalization and De-Normalization of tables
• Used to work on Error handling using Try-Catch Block
• Created database objects like tables, views, indexes, stored-procedures, triggers, and user defined functions.
• Made Estimates for Database, table size growth and prepared the reports for the day-to-day as well as weekly/monthly purposes.
• Worked on Index optimization, Performance, Disk management, Disk partitions and optimizing.
• Developed administrative tasks of SQL Server of performing daily Backups and Recovery procedures.
• Worked with the developing team in the Writing functions in Visual Basic 6.0 for Upload download functionality, Data transfer and migration.
• Migrated many DTS packages to SSIS packages.
• Worked on DTS/SSIS packages for transferring data from various data sources like SQL,Oracle,DB2, MS Access, Excel, .Txt file, .CSV files.
• I Used many transformations like Data Conversion, Derived Column, Conditional split, Multicast , Merge ,Union All , Fuzzy Lookup, Fuzzy Grouping and also used For loop, For each Loop, Sequence container FTP,SMTP and Execute SQL task etc.. Hands on experience with BIDS.
• Experienced in SSRS reporting .Generated different kinds of reports like Tabular, Matrix, Parameterized, Ad-hoc, and Drill down, Drill through, Sub reports, List Chart reports as well as interactive reports according to business requirements in time restricted environment. I created and executed the stored procedures and complex queries for reports.
• Created multidimensional optimized cubes using SSAS. Partitioned the cube for better query performance and involved in processing the cube using SSAS.

Environment: SQL Server 2000, 2005, Red gate, lite speed, fog light, SCOM 2007/2012, Fog light Performance Analysis T-SQL, BIDS, Windows 2K, 2003,2003R2,2007 platforms, lite speed, Erwin, Microsoft Outlook, HP Manager ticketing tool