SUMMARY

• Microsoft certified professional with over 8 years of experience as SQL Server Administrator and support of MS SQL Servers 2012/20 in Production, QA, and Development environments.
• Experience in working with Replication, Mirroring, Log shipping, MS clustering.
• Experience in SQL 2012 always on availability group feature.
• Experience in the installation and configuring of SQL Server 2005, 2008, 2008 R2 and 2012 Standalone and Clusters and also performing the upgrades by applying CU and SPs.
• Experience in creating and managing database maintenance plans. (Database consistencies, Index defrag/rebuild, update statistics, Log capacity Monitor, Database Growth and Backups etc.)
• Experience in on boarding the newly created servers with the required SQL Server maintenance jobs and optimal configurations changes (memory, Disk and Temp DB).
• Experience in the database and Query performance tuning using SQL Server Profiler, Dynamic Management Views, Systems Catalog Views, DBCC Commands, Metadata and Extended Events.
• Experience with Auditing, Policy based management, Resource governor, Performance data collector and transparent data encryption (TDE).
• Experience in troubleshooting SQL Server related CPU, memory, I/O, disk space and other resource contention issues.
• Good knowledge in writing Queries, Functions, Stored Procedures, Triggers, Cursors.
• Experience in creating the databases based on functional requirements and system design.
• Experience in managing the database security, logins, users, roles, and object permissions.
• Experience in reviewing the proposed schema changes and other database artifacts such as stored procedures and views and provide best practice and optimization feedback.
• Performing capacity monitoring and short and long - term capacity planning in collaboration with development resources, system administrators and system architects.
• Involved in troubleshooting, resolution, and root cause analysis for the database specific incidents.
• Experience in creating, building and deploying reports using 2005, 2008/R2 and 2012 SSRS (SQL Server Reporting Services).
• Experience in creating and implementing SSIS packages for various data integration projects and Maintenance tasks in 2005, 2008, 2008 R2 and 2012.
• Administered & Supported mission critical databases and provided 24*7 Production support.
• Experience in using the third party tools like Redgate and Litespeed.

TECHNICAL SKILLS

Databases: Microsoft SQL SERVER 2012/ 2008 R 2/ 2008/2005/2000, Oracle

Languages: SQL, HTML, XML, Asp.Net, C, C++, C#

Reporting Packages: SQL Server Reporting Services

Database Utilities: Profiler, Data Base Tuning Advisor, Business Intelligence Development Studio (BIDS), SQL Server Data tools,Perfmon,SQL Server Integration Services(SSIS)

Operating System: Windows 2012 R2/2008 R 2/2008/2003/2000/ XP, UNIX, Linux

Tools: MS Visual Studio, TFS,MS Visio,Erwin,Redgate, Litespeed

PROFESSIONAL EXPERIENCE

Confidential, PA

Senior SQL Server DBA

Responsibilities:

• Responsible for Installation, configuration and complete administration of MS SQL Server 2012/2008/2005 .
• SQL Server upgrade and migration from version 2005 to SQL Server 2008 and SQL Server 2012.
• ImplementedSQL2012 Always ON Availability Groups feature.
• Implemented the transactional replication from the client facing SQL instances to the processing SQL instances.
• Maintained server level,databaselevel and object level security best practices by creating logins and users, configuring permissions and assigning different roles to users.
• Managed database maintenance tasks such as Database consistencies, Index defrag/rebuild, update statistics, Log capacity Monitor.
• Used the log shipping methodology to migrate the VLDB’s.
• Daily review of SQL server errors, maintenance jobs and server health.
• Created DB objects like Tables, Stored procedures, Functions, Triggers and Views using T-SQL.
• Implemented Transparent Data Encryption (TDE) to encrypt the sensitive data.
• Installed and applied Service Packs (SP) on SQL Server 2005, 2008 and 2012.
• Implemented SQL server auditing for tracking and logging events that occur on the Database Engine.
• Implemented the Resource Governor to manage the SQL Server workload and resources.
• Used Performance Monitor, Profiler, and Database Engine Tuning Advisor to solve Dead Locks/Long running queries.
• Created operators, Alerts and Database Mail using SSMS.
• Created SSIS Packages to Extract, Transform and Load data into database.
• Created and deployed reports using SQL Server Reporting Services (SSRS).
• 24 X 7 Production Database on Call rotation Support.

Environment: SQL Server 2012/2008/2005, Windows 2012 R2/2008 R2/2008/2003, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), SQL Server Data tools, SQL Server Management Studio, Team Foundation Server (TFS)

Confidential, MI

Senior SQL Server DBA

Responsibilities:

• Responsible for Installation, configuration and complete administration of MS SQL Server 2008/2005.
• Migrateddatabases from SQL Server in Dev/QA/production environments.
• Installation & maintenance of SQL Clustering.
• Configured Log Shipping from Production to Standby Server (Running as Reporting Server).
• Configured and Maintained Replications (Transactional).
• Implemented database mirroring with High Availability Mode in SQL 2008.
• Assisted SQL developers in optimizing SQL queries and Stored Procedures.
• Created backup strategy for Dev/QA/Production environments.
• Setup and configureddatabasemail for notification purposes.
• Extensively used DBCC statements to check physical and logical consistency of thedatabase.
• Export & Import data from MySQL, and Access Database including flat files like text, excel, and into SQL Serverdatabases.
• Assisted in creating new SSRS 2008 reports as well as updating current reports to meet new requirements.
• Supported the database deployments for the new releases.
• Identified unused indexes; created missing indexes and regular reorg/rebuild Index maintenance.
• Worked on the capacity planning and benchmarking SQL Server hardware, CPU, Memory, cache, Disk IO, RAID, Network.
• Prepared and documented database backup’s and maintenance plans.
• Worked with the 3rd party tools like LiteSpeed and RedGate.

Environment: SQL Server 2008/2005, Windows 2008/2003, Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), RedGate, LiteSpeed

Confidential

SQL Server DBA

Responsibilities:

• Installation of SQL Server 2008 on Windows server clustered environment.
• Migrated/Upgraded SQL Server 2000 databases to SQL Server 2008 databases including DTS to SSIS migration.
• Managed the database security, logins, users, roles, and the object permissions.
• Monitored the database storage usage and participated in the capacity planning.
• Resolved the database problems (performance issues, database integrity issues, blocking and deadlocking issues).
• Installed the critical patches and cumulative updates on the SQL Servers.
• Created new database objects like tables, views, indexes, stored procedures, user defined functions and triggers.
• Configured the linked servers, operators, alerts, database mail and backups.
• Worked on disk, memory and CPU specific performance issues on high-volume OLTP servers.
• Supported several enterprise-wide high availability systems and services with SLA driven up-time requirements.
• Performed the data partitioning in SQL Server 2008.
• Enhanced poor performing SQL statements, procs, functions, triggers, SSIS packages and SSRS reports.
• Extensively used command prompt utilities like SQLCMD and OSQL.
• Responsible for creating, scheduling and monitoring SQL server agent jobs and alerts.
• Supported the database deployments.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP) and Data Transformation Services (DTS).
• Documenting and bug fixes and resolution of Tickets

Environment: SQL Server 2008/2000, Windows 2008/2000, Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Data Transformation Services (DTS)

Confidential

SQL Server DBA

Responsibilities:

• Involved in gathering user requirements, application design, and analysis of hardware requirements to meet business needs.
• Developed various T-SQL stored procedures/functions for the Application.
• Monitored the Event Viewer, Event Logs and Server Error Logs for troubleshooting purposes.
• Performed database consistency checks.
• Implemented database mirroring with High Availability Mode.
• Worked on rebuilding/reorganizing the indexes at regular intervals for better performance.
• Worked on configuring Linked Servers to execute commands against OLE DB data sources on different Servers.
• Proactively monitoring the CPU utilization, Disk performance issues, database growth, backups, long running transactions and critical jobs across all the DB servers.
• Created and deployed reports using SQL Server Reporting Services (SSRS).
• Created SSIS Packages to Extract, Transform and Load data into database.
• Enhanced poor performing SQL statements, procs, functions, triggers, SSIS packages and SSRS reports.
• Automated manual processes to avoid human error and increase turnaround time for requests.

Environment: SQL Server 2008/2005, Windows 2008/2003, Business Intelligence Development Studio (BIDS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)