SUMMARY

• 7+ years of IT experience as SQL Server Database Administrator.
• Experienced in Security and Support of MS SQL Server 2012, 2008, 2008r2, 2005 in Production, Testing, Development Environments.
• Excellent skills in database Back Up, Restore, Recovery, Updating statistics, Rebuilding and Reorganizing indexes, Linked Servers and Database Maintenance Plans
• Experience in configuring and using SQL Server Agent to Automate Administrative tasks.
• Implemented the new SQL Server concepts like database mirroring, database snapshot, DDL triggers, views, online indexing, DMV’s, Mail Setup, Jobs, and Alerts.
• Administering SQL Server High Availability.
• Creation of Jobs Schedules, Alerts using SQL Server Agent and Notifications using SQL Mail and Database Mail.
• Recommended the Different backup strategies for the critical applications.
• Experience in data migration from Access/Excel Sheets using import/export and BCP utilities.
• Experience in Replication - Transactional, Peer-to-Peer, Snapshot and extensive knowledge in Merge replication
• Experience in maintaining the security for databases (creating logins for users, roles, and assigning permissions to them).
• Extensively Monitored Performance with multiple tools like Performance Monitor, SQL Profiler, and Event Viewer resolve Dead Locks/Long Running Queries, accessibility and efficiency.
• Experience in implementation of high availability and Disaster Recovery solutions, including Replication, Database Mirroring, and Log Shipping.
• Worked on Active-Active and Active-Passive Clustering
• Expertise in T-SQL writing stored procedures, triggers and Joins.
• Strong technical background along with the ability to perform business analysis and write effective documentation and specifications.
• Monitoring Lite Speed Backups.
• Review the Objects code for the deployment.
• Creating different documents related to process and DBA activities.
• In Depth knowledge on Extended Stored Procedures and improving efficiency by re-indexing, update statistics, Recompiling stored procedures, Troubleshooting Dead Locks and capture data using SQL Profiler, Performance Monitor and DBCC Commands.
• Excellent communication, presentation and interpersonal skills. Strong troubleshooting and organizational skills.
• 24 X 7 Production Database on Call Support

TECHNICAL SKILLS

Databases: MS SQL Server 2005/2008/2008 R2/2012, MS SQL Server2000/7.0.

Programming: Visual Basic 6, Visual Basic 5, C, C++ & SQL

Operating System: Windows 2003/2000 Advanced Server, NT & Windows 9x., UNIXWindows Server 2012, 2008 and 2003

Other Software: Active X, IIS, Microsoft Transaction Server, VBScripts, HTML, XML

Tools: SQL DB Access, Performance Monitor, Backup Utility, Lite Speed.

PROFESSIONAL EXPERIENCE

Confidential

SQL Server DBA

Responsibilities:

• Installed, Configured and Administered SQL Server 2008R2/2008/2005 Servers in Production.
• Created and maintained various databases for Production, Development and Testing environments using SQL Server 2008r2, 2005.
• Created databases, Logins, Roles and granted appropriate permissions.
• Configured Database Mail to send out notifications
• Extensive experience in setting up and troubleshooting Mirroring, Log shipping and transactional replication
• Daily task to verify the backup jobs and troubleshoot them if the jobs are failed.
• Managing & maintaining security of the Database in terms of Users, Privileges and Roles
• Proactively involved in KT sessions for the team members.
• Experienced in performance tuning using windows performance monitor and SQL profiler of SQL server. Used SQL Server error logs and event viewer to troubleshoot issues.
• Responsible for ETL Operation which extracts and transforms the data to Data Warehouse using SQL Server Integration Services (SSIS)
• Performance tuned SSAS Packages.
• Designed and implemented comprehensive Backup plan and disaster recovery
• Implemented and configured database monitoring tools and focused on providing a high availability database.
• Configure and manage database maintenance plans for update statistics, database integrity check and indexing updates
• Created jobs, alerts, activity logs, error logs to capture any possible errors.
• Experience in providing excellent 24X7 Production support.

Environment: Microsoft Windows Server 20 /64 bit, MS SQL Server 2008 R2/2005,SSIS,SSAS

Confidential, TEXAS

SQL Server DBA

Responsibilities:

• Installed SQL Server 2012/2008r2 on Standalone and Clustered Environments.
• Upgraded /Migrated of SQL Server from version 2005, 2008,2012.
• Installed Microsoft Service Packs/Patches/Hotfixes.
• Configured and administered SQL Clusters (Active/Passive, Active/Active), Database Mirroring, Replication and Log shipping.
• Conducted Backup and Restore of Databases and Schedule Maintenance plans to perform regular Backups.
• Performed Attach/ Detach, BCP, Import & Exports and Copy Database Wizard.
• Analyzed Performance using Performance monitor in order to identify the bottleneck such as CPU, memory, IO, paging and SQL Server and also bottleneck of SQL Server such as buffer cache hit, memory, transaction, procedure cache, paging etc.
• Troubleshooted Memory Errors/Query Processing and usage of Memory and resolving errors pertaining to insufficient Memory.
• Troubleshooted and resolved Blocking, Deadlocks and Long Running Queries.
• Utilized DMV’s, Data partitioning and Performance Dashboards reports with SQL Server2005.
• Configured Snapshot, Transactional Replication of SQL Server databases and Troubleshooted Replication Problems.
• Extensively worked on SQL Server Integration Services (SSIS),SSRS
• Recommended the Different backup strategies for the critical applications.
• Created and Managed SQL Server Logins and Users as per the requirement with specific roles and permissions on production servers.
• Created various Jobs, scheduled & ran jobs and troubleshooted the failed jobs.
• Provide 24X7 support for the Critical issues like Server Failures and Database inconsistencies like Database Log File full, Suspect, Offline, Missing log files etc.

Environment: Windows 2003, MS SQL Server 2012/2008R2, T-SQL, Visual Studio.Net 2003, Crystal Reports, LITESPEED, MS Access, DTS, BCP, SSIS, SSRS,SQL Profiler.

Confidential, NJ

SQL Server DBA

Responsibilities:

• Create and maintain various databases for Production, Development and Testing Servers using MS SQL Server 2005/2008. Planning the location of data, indexes, and Transaction log files on the disk.
• Install and configure SQL Server 2005/2008 on the server and client machines, provide connections and manage databases.
• Assisted in Upgrading SQL Server 2005 databases to SQL Server 2008.
• Planning, Implementing and troubleshooting Replication.
• Involved in planning and monitoring Log Shipping.
• Configured transactional Replication from multiple subscribers for reporting purpose.
• Involved in performance tuning, optimization of stored procedures and queries.
• Worked with customers to resolve the connectivity issues
• Set up linked servers in SQL 2005
• Working with SSRS,SSIS
• Monitoring and Troubleshoot Scom Alerts.
• Review the Objects code for the deployment.
• Estimated disk storage requirements for database software, database files.
• Use custom scripts so as to help automate routine tasks such as Maintain operators, Alerts, Notifications, Jobs, Job Steps and Schedules.
• Created automated procedure for daily, weekly and monthly system maintenance tasks such as database backup, replication verification, and database integrity verification and indexing updates.
• Worked with Application Developers to design databases and tables to support Development activities and achieve optimal efficiency.
• Tuned SQL statements and Stored Procedures.
• Extensively used DTS to load data from different data sources.
• Helped application teams in query analyzing and its optimization. Coordinated with users for downtime and maintained the system running 24X7.
• SQL server database backups/restoration and recovery of NT server/SQL Servers

Environment: MS SQL Server 2005 and 2008, T-SQL, SSRS,SSIS,DTS, Replication, MS Access, Windows 2008 server, Windows NT

Confidential, Pennsylvania

SQL Server DBA

Responsibilities:

• Monitoring SQL server performance using profiler to find performance, Dead locks, blockings and Capturing long running SQL queries for fine-tuning SQL statements that better result in efficient SQL statements processing
• Extensively worked on snapshot Replication.
• Extensively worked on Log Shipping and Database Mirroring for 2005 and 2008 Production servers and SQL server 2005 security Audit.
• Extracted data from various sources like SQL Server 2005/2008, Oracle, Teradata, .CSV, Excel and Text file from Client servers.
• Executing DBCC checks
• Managing & maintaining security of the Database in terms of Users, Privileges and Roles
• Implement and maintain database security standards, policies and procedures.
• Worked closely with development team for performance enhancements, code reviews and provided vital inputs in terms of index optimization, schema structures, data changes, file layouts etc.
• Shrinking of databases and keep the backup into tape drives.
• Working with SSIS (Integrated services),SSAS,ITIL
• Handled Performance Tuning and Optimization, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Experience in contacting Microsoft and other vendors for product and technical support.
• Successfully worked in 24x7 mission critical environment.

Environment: MS SQL Server 2005 and 2008, T-SQL, DTS, Replication, MS Access, Windows 2008 server,SSIS,SSAS,ITIL

Confidential

SQL Server DBA

Responsibilities:

• Installation of SQL Server 2005 with latest Service Packs.
• Worked in Active/Passive Clustered Environment.
• Writing stored procedures for report generation in migration process and replication.
• Implemented the migration of SQL Server 2005, 2008.
• Wrote several SQL Scripts such as finding long running queries, blocking sessions, archiving data from production to archive server and populating reporting data.
• Experience in monitoring software tools used to monitor the environment effectively.
• Successfully implemented Database Mirroring in SQL Server 2005 for high availability.
• Maintain both DEVELOPMENT and PRODUCTION server in sync.
• Involved in Log Shipping.
• Migrate Data from Sql 2005 to Sql 2008
• Monitoring various types of scheduled backups
• Extensively involved in replication and implemented Snapshot, Merge and Transactional Replications.
• Working with SSIS+
• Involved in Monitoring Performance of different production servers.
• Worked in 24x7 production environment.
• Working with the end user gathering requirements for the system.
• Disaster Recovery Plan, Testing and analyzing and continuous update of documentation.
• Creating Logins and Roles with appropriate permissions.
• Prepared and documented Backup & Restore Plans.
• Worked on creating and Maintaining Database Maintenance Plans.

Environment: Windows 2003, MS SQL Server 2005/2008, T-SQL, MS Access, SQL Profiler,SSIS.