SUMMARY

• Over 7 years of working experience in SQL Server Database Administration, Performance Analysis, Database Design, Development and Support of SQL Server 2012/2008/2005/2000 in Production, Development, Test, Cluster and HA/DA Server Environment.
• Expertise in Installation, Upgrade, Configuration and Migration of MS SQL Server in clustered and non - clustered environments.
• Well versed with Backups and Restores using jobs to schedule full, differential, and transaction log backups to use in full, simple and bulk-logged restoring as well as experience with disaster recovery planning and execution.
• Adequate knowledge of SDLC and ITIL Methodologies in regards to IT Infrastructure Management.
• Address and resolve technical issues related to databases and provide 24*7 supports.
• Experienced in Migration from SQL server 2000, 2008R2 by using In-Place and side-by-side upgrade process and documented Pre-Migration and Post-Migration Steps
• Worked with the databases of the size ranging from 100 GB to 1TB.
• Experience in query optimization & performance tuning and Used SQL Profiler, Performance Monitor and DBCC Commands, trace.
• Created and managed the Database Users, Login and Security.
• Developing SQL scripts for maintaining administration tasks.
• Experience in applying patches and service packs to keep the database at current patch level.
• Experience in High availability configuration and Disaster Recovery setup, Server clustering, log shipping, Database Mirroring.
• Experienced in working with SQL server in a clustered server environment (active/passive) on windows 2003 and windows 2008 server.
• Expert in Database Normalization, De-Normalization, Backup/Restore, Data Import/Export, Troubleshooting, and Objects Creation such as Tables, Views, and User created Data Types, Index Optimization, Stored Procedures, Cursors, Triggers and Partitioning.
• Experience in Microsoft SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS).

TECHNICAL SKILLS

Operating Systems: Windows Server 2012, 2008R2, 2008, 2003

Databases: SQL Server 2012/2008/2008 R2/2005/2000

Programing Languages: T-SQL, SQL, PL/SQL, PowerShell, HTML, C#, C/C++ &XML

Database / ETL Tools: SQL Server Integration Services (SSIS), SSAS, DTS, Query Analyzer, SQL Profiler, TOAD

Reporting Tolls: SQL Server Reporting Services (SSRS) and Report Builder

Third Party Tools: NetBackup, SQL Sentry, ERwin Data Modeler and SQL Compare, BMC remedy

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

SQL Server Database Administrator

Responsibilities:

• Supporting servers in theDev/UAT/Prod environment forSQLServer 2012, 2008R2, 2008 and2005Databases.
• Deployment ofSQLDBand project codes using TFS Server 2005/2010/2012.
• Successfully Migrated/Upgraded SQL Server 2008 to SQL Server 2012 on Development, Testing Production Environments for various mission critical applications
• Configuring Log shipping for database in Dev/ SIT/ UAT/Prod environment
• ImplementSQLServer Failover Clustering for High Availability UAT & production server
• Monitoring the Database Server's Health, Tuning, and using Profiler whenever required.
• Managing AccessPermissions to users onSQLdatabase Servers.
• Consolidation of SQL server and databases based on physical memory, server memory, I/O waits, linked servers, active servers, and offline database.
• Monitoring the databases on a daily basis and checking the Event logs and Error logs.
• Experience in database redundancy strategies, and disaster recovery (Data Mirroring, Replication, Log Shipping, and Clustering).
• Setting up logical/physical backups for the databases.
• Involved in daily loads (Full & Incremental) into Staging and ODS areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2008.
• Effectively using DBCC commands, Dynamic Management Views (DMV), SQL Profiler, Performance Monitor, SQL Server Management Studio, Trace Analysis and Execution plans as part of troubleshooting and performance tuning.
• Involved in Performance tuning and Query Optimization.
• Resolving blocking and deadlock issues using activity monitor and system stored procedures.
• Applying required Service Packs, Hotfixes and any Critical Security Updates in clustered and standalone servers.
• Configured SNAPSHOT Replication using Snapshot agent. (Creating Distribution Databases, creating & managing Publications, managing Replication monitors)
• Implemented in new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through Common Table Expression (CTE) Implemented Snapshot replication.
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Analyzed long running slow queries and tune the same to optimize application and system performance.

Environment: MicrosoftSQLServer 2012/2008 R2/2008/2005,Windows2008, SSIS,TFS, Oracle Streams, Data Guard, TOAD,T-SQL,SQL Loader.

Confidential, Minneapolis, MN

SQL Server Database Administrator

Responsibilities:

• Installing, Applying patches to the existing SQL servers and Upgrading SQL servers.
• Installing SQL Server Active-Active and Active-Passive clusters.
• Configuring SQL Server jobs for Index maintenance, Database Consistency jobs, Database backup jobs and Alerts.
• Ensure regular database backups and recommend the appropriate recovery models for the production databases as per the database usage.
• Automating weekly and monthly non-production database refreshes.
• Configuring High Availability practices like Log Shipping, Database Mirroring and Replication.
• Setting up database snapshots on the secondary mirror database for reporting purpose.
• Responsible for maintaining SQL Server security and granting access to users as per requirement.
• Optimizing SQL Server long running stored procedures and queries.
• Used ERwin data model tool to develop the Data model of the Database objects in Oracle database before migrating to SQL Server.
• Built SSIS packages to extract, transform and load DBA metrics data to monitor the database growth, huge tables and wait stats.
• Developed SSRS reports on the DBA metrics data.
• Worked closely with developers to fix the performance issues during production hours.
• Maintain and up to date inventory of the SQL Servers.
• Configured schedules to capture counters on regular basis to bench mark the SQL server performance.

Environment: SQL Server 2012/2008R2, Windows Server 2008, SSIS, SSRS, Report Builder 2.0 SQL Sentry, NetBackup, Idera, ERwin Data Modeler

Confidential, Radnor, PA

SQL Server Database Admin

Responsibilities:

• Installed SQL Server in production, test and development environments.
• Managed servers in Clustered, Mirrored and Log Shipping environment
• Managed SQL Servers in Virtual and Standalone environments for OLTP and DSS systems
• Provided technical support for the database environment including overseeing the development and organization of the databases, assessment and implementation of new technologies.
• Worked with architecture, application development and operations to help achieve a state-of-the-art environment that meets current and future business objectives.
• Help in-house developers improve performance of their stored procedures, TSQL codes and database design.
• Managed health of SQL Servers including backups, restores and monitoring.
• Configuration and trouble shooting of maintenance plans, backup remediation, job failures.
• Provide a working model of transaction processing environment for capacity assessment and planning.
• Develop a security scheme for the database environment, as well as assisting in set up of disaster recovery.
• Provided technical support during the development, design enhancement and implementation of production databases.
• Worked with the transaction processing area to develop both the physical and the logical database administration functions.
• Reviewed and tune up SQL queries, stored procedures, views and triggers.
• Work with others in IT to build the logical database area and provide technical guidance during all phases of the development process.
• Worked with the implementation team in the installation of the new servers, migration and documentation.

Environment: Microsoft SQL Server 2008, Windows Server 2008, SSIS, SSRS, TSQL.

Confidential, Cincinnati, OH

SQL Server Database Admin

Responsibilities:

• Installed and configured SQL Server Enterprise/Standard edition in the production/DR/Test/Dev environment.
• Monitored the Daily Full Back-up and Transactional log backup jobs.
• Involved in the configuration and maintenance ACTIVE/PASSIVE Cluster Environments for the production servers
• Involved in Database and SQL Query Tuning to improve performance, identifying locking and blocking issues by utilizing DBCC commands, DMV’s and DMF’s for monitoring.
• Implemented and maintain database security (create and maintain users and roles, assign privileges).
• Perform general technical trouble shooting and give consultation to development teams.
• Identified issues related to poor performance of complex SQL queries by analyzing missing indexes and unused indexes.
• Reduced the deadlocks by using the SQL Server Profiler and setting up Trace flags for every day monitoring.
• Troubleshoot and Resolved issued problems with the production server via the ticketing system BMC remedy.
• Involved in taking backups of database and restoring and validating them when needed.
• Experience in working in Change Data Capture (CDC) for auditing data objects in SQL Database.
• Analyzed values of performance monitor counters to identify potential disk, I/O subsystem issues.
• Created and Deployed RDL in SSRS server to maintain Disk space monitoring of all servers including Stage Environment.
• Actively involved in development of automated daily, weekly and monthly maintenance tasks such as backups, verifying database integrity and re-indexing.
• Provided dedicated supports for SQL Server production server 24/7 shifts.

Environment: Windows server 2008/2008R2, Microsoft SQL 2008R2/2008, SQL, SSRS, BMC remedy

Confidential, Camp hill, PA

SQL Server Database Administrator / Developer

Responsibilities:

• Administering the MS SQL Server by Creating User Logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of groups, granting the privileges to users and groups.
• Perform Full Backups and Transaction Log Backups. Restore them whenever necessary. Creating back up strategies and scheduling them for execution.
• Managing of database objects like Tables, views, indexes.
• Worked with stored procedures for data set results for use in Reporting Services to reduce report complexity and to optimize the run time. Exported reports into various formats and resolved formatting issues.
• Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary.
• Created views for easier implementation on web pages, and wrote triggers on those views to provide efficient data manipulation.
• Backing up entire user’s database and scheduling backup process.
• Successfully resolved deadlock issues by creating traces on objects using SQL Server Profiler.
• Worked with DTS to load text files to SQL Server.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server and develop Distributed Queries.
• Created logical and physical design of new database to fit new business requirements and implemented new design into SQL Server 2005.
• Actively participated in gathering of User Requirement and System Specification.
• Used DDL and DML to writing triggers, developed stored procedure, functions, views and triggers.

Environment: SQL Server 2005, SQL Server 2008, T-SQL, Windows Server, HTML, VBScript, JavaScript, MS Access