OBJECTIVE:

Seeking a Challenging Position in the field of SQL Database Administration.

PROFESSIONAL SUMMARY:

• 8 Years of Experience as Database Administrator in MS SQL Server, Analysis and Support of MS SQL Server 2000/2005/2008/2012.
• Experienced in Database Backup/Recovery, Performance tuning, Query Optimization, Disaster Recovery plans and configuring Alerts using SQL Mail.
• Experienced in Data Migration from SQL Server 2008 to 2012.
• Experienced in Administering Clustered Environment.

TECHNICAL SKILLS:

• Databases: MS SQL Server 2012, 2008, 2005, 2000, MS Access, MS-Excel
• Languages: T-SQL, PL SQL, C, C , JAVA
• SQL Server DBA Tools: SQL Server Profiler, SQL Server Analysis Services, SSIS Tools, foglight

WORK EXPERIENCE:

Confidential

SQL Server DBA

Responsibilities:

• Installed and Configured Sql Server 2008/2008r2/2012 in multi-server environment.
• Managed Daily/Weekly/Monthly database administration functions such as Backup/Recovery, Data Management, Performance Tuning and Monitoring, Data Archival, Update Statistics, Monitoring and Scheduling Jobs and Re-Indexing.
• Worked on Database Mirroring, Partitioning, Replication, and Log Shipping in MS SQL Server
• Created users, roles and profiles and implemented scripts to automate daily DBA activities.
• Implemented Backup/Restore procedure using the Maintenance Plans.
• Deployed Microsoft sql server patching and operating system patches in cluster failover servers and standalone servers.
• Used DBCC commands, Activity Monitor, DMV's, System Monitor and Sql Profiler to monitor Sql Server Performance issues.
• Managed SSIS packages by Monitoring and Troubleshooting the errors and configuration settings of packages.
• Created Perfmon reports in order to analyze the performance of servers in various environments.
• Migrated databases from 2008 to 2012
• Worked with a multiple terabyte database applications.
• Involved in documenting of all the processes.
• Worked with Compressed backup in SQL Server 2008
• Involved in deploying patches on all the SQL Servers 2008/2012

Confidential

SQL Server DBA

Responsibilities:

• Installed and Configured Sql Server 2005/2008 in multi-server environment.
• Managed Daily/Weekly/Monthly database administration functions such as Backup/Recovery, Data Management, Performance Tuning and Monitoring, Data Archival, Update Statistics, Monitoring and Scheduling Jobs and Re-Indexing.
• Created users, roles and profiles and implemented scripts to automate daily DBA activities.
• Involved in upgrade of databases from Sql Server 2005 to 2008.
• Implemented Backup/Restore procedure using the Maintenance Plans.
• Deployed Microsoft sql server patching and operating system patches in cluster failover servers and standalone servers.
• Used DBCC commands, Activity Monitor, DMV's, System Monitor and Sql Profiler to monitor Sql Server Performance issues.
• Managed SSIS packages by Monitoring and Troubleshooting the errors and configuration settings of packages.
• Created SSIS packages to import and export data from to Sql Server to Access, Text and Excel files and exchange of data between different sources.
• Monitored and Performed ETL operations to support the data loads and transformations using SSIS to the Data warehouse Server.

Confidential

SQL Server DBA

Responsibilities:

• Installed and Configured SQL Server 2005, 2008 and Windows Cluster Services.
• Involved in performing database performance and query tuning and data verification.
• Hands on working experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting query performance and MS SQL Server bottle necks including Hardware usage and Blocking.
• Involved in developing stored procedures, functions, triggers using T-SQL for mission critical processes
• Involved in monitoring the proper usage of the disk space on the physical drives of the server and provide the management as of utilization.
• Automated various monitoring alerts in order to maintain smooth functioning of the databases in SQL Server 2005/2008.
• Worked with Active/Active and Active/Passive clusters on Windows Server 2003 and Windows Server 2008
• Worked with dev team in the initial design of the databases for collecting user specifications.
• Created Perfmon reports in order to analyze the performance of servers in various environments.
• Migrated databases from 2005 to 2008
• Worked with a multiple terabyte database applications.
• Involved in documenting of all the processes.
• Worked with Compressed backup in SQL Server 2008
• Involved in deploying patches on all the SQL Servers 2005/2008.
• Involved on a 24/7 on call production support.

Environment:

MS SQL Server 2005/2008, Windows Server 2003/2008, Clusters, Replications, TSQL, Visual Studio.

Confidential

SQL Server DBA

Responsibilities:

• Created, Scheduled and managed all the database maintenance plans using SSIS Packages in all the SQL Servers across the environment
• Involved in the migration of databases from SQL 2000 to SQL 2005
• Maintained Database Security on all the servers.
• Involved in creating and maintaining transactional replication.
• Maintained SQL Servers in an Active/Passive Cluster environment.
• Implemented and maintained all the production servers using an external tool for monitoring called Foglight.
• Involved in gathering requirements and specifications for migrating the SQL Server from 2005 to 2008
• Involved in maintaining reporting services in SQL Server 2005 in one of the Production Servers.
• Involved in Performance tuning of the databases in SQL Server 2000 and 2005
• Created Logical and Physical databases for various applications
• Involved in creating scheduled full and transactional log backups in all the test and Development environments
• Involved in monitoring the proper usage of the disk space on the physical drives of the server and provide the management as of utilization.
• Involved in creating and deploying SSIS Packages in SQL Server which are developed by the application which will load data in to SQL Server in a regular intervals of time.
• Used DBCC commands to check physical and logical consistency of the databases and to rebuild indexes.
• Worked with various application teams in order to create the applications on SQL Server
• Involved in monitoring the servers in a regular basis in order to check if there are any blocks that are occurring during the processes
• Involved in documenting various activities performed as DBA.

Environment:

MS SQL Server 2000/2005, Windows 2000/2003, Foglight, TSQL, Visual Studio.

Confidential

SQL Server DBA

Responsibilities:

• Implemented snapshot, transactional and merge replication.
• Managed and Scheduled daily jobs related to backup and recovery.
• Maintained database security on all the servers.
• Used DBCC commands to check physical and logical consistency of the database and to rebuild indexes.
• Created Clustered Indexes and Non-Clustered Indexes to increase the performance of the database.
• Setup profiler traces for slow running queries analyze load file through query tuning wizard.
• Created Entity Relational diagrams while designing the databases in the SQL Server according to the end-user specification.
• Involved in maintaining the proper usage of the disk space on the physical drives of the server as per the requirement.
• Involved in applied hot fixes to the production server.
• Automated process for data transfer from one database to another using DTS Package.
• Migrated databases to the SQL Servers at the data Center.

Environment:

MS SQL Server 2000/2005, Windows 2000/2003, TSQL, Replication.

Confidential

SQL Server DBA

Responsibilities:

• Database Administration for Development, Test and Production servers with SQL Server 2005.
• Created Linked Servers for data retrieval using OLE DB data sources and providers.
• Checked Performance tuning, indexing and query optimization.
• Automated process to export and import data from SQL Server to and from Access, text using DTS.
• Maintained Security on all the servers.
• Used SSRS for creating various reports in the company in a daily basis on the production databases.
• Involved in Analyzing and implementing of Indexing for large tables.
• Worked on Active-Passive environment and maintained the databases in high availability mode.
• Involved in SQL Server recovery.

Environment:

MS SQL Server 2005, Windows 2003, TSQL, Visual Studio, Reporting services.