SUMMARY

• Over 7 years of professional experience in Microsoft SQL server database administration and development.
• Extensively involved in installation of MS SQL SERVER 2000,2005,2008,2008 R2, 2012, 2014.
• Experience in Database Administration on performance T - SQL tuning and optimization of queries for reports that take longer execution time using SQL Profiler, Database Design, Maintenance with outstanding troubleshooting capabilities, maintaining very large and complex databases.
• Configuring more than 2GB RAM for 32-bit and 64-bit systems using AWE switches.
• Experience in Setting up High availability solutions like Log shipping, Replication, Clustering and mirroring.
• Extensively worked on Merge Replication, Snapshot Replication and Implemented Transactional Replication as a part of Disaster Recovery (DR) solution.
• Extensively worked on Active-Active and Active-Passive Clustering.
• Assisted in configuring Database mirroring in SQL Server 2012 for multiple databases.
• Experience in SQL Server 2014 new features like In-Memory OLTP Engine, AlwaysOn Enhancement, Buffer Pool Extension, Updatable ColumnStore Indexes, Storage I/O Control, Power view for Multidimensional Models, Power BI for office 365 Integration, Backup Encryption.
• Experience in using Dynamic Management Views (DMV) and Dynamic Management Functions (DMF) for finding out long running queries.
• Experience in Extracting, Transforming and Loading data from various heterogeneous data sources like Access, Excel, CSV, Oracle, flat file, Text Format Data using OLE DB connection by creating various DTS & SSIS packages.
• SQL Server Business Intelligence Development Studio expertise to create SSRS reports, SSIS packages such as Conditional Split, Derived Column on the data retrieved, performed Data Validation Checks during Staging, and then loaded the data into the Data warehouse.
• Experience in using third party tools like LiteSpeed (Backup and Database Recovery), and data modeling tools like ERWIN.
• Expertise on physical storage SAN configuration on different RAID levels.
• Extensive experience in Disaster Recovery, Troubleshooting, Backup and Restore Procedures.
• Migrated SQL Server 2008 databases into SQL Server 2012 and SQL Server 2014.
• Experience in upgrading SQL Server software to new versions and applying Service packs and hot fixes.
• Excellent backend skills in creating SQL objects like tables, synonyms, stored procedures, views, Indexes, triggers, rules, defaults, user defined data types and functions.
• Experience in in Performance Tuning by Index Defragmentation, optimizing execution plans, proper usage of indexes, Index rebuild, reorg, horizontal and vertical partitioning.
• Rebuilding indexes with different fill factors and updating statistics.
• Experience in Linked Server setup, which allows access to the distributed, heterogeneous queries against OLE DB data sources for EXCEL, MS ACCESS and Text files and running the Batch Processes.
• Experience working with server side trace.
• Expertise in creating Packages, Jobs, sending alerts using SQL Mail and custom extended procedures.
• Good knowledge and Experience in dealing with Relational Database Management Systems, including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, Cursors.
• Experience in working with system administrators for creating/modifying/user/group accounts in Windows Active Directory in order to authenticate SQL server users through domain group/user accounts.
• Monitoring Event Viewer, SQL Error logs and Log File Viewer for Software and hardware related errors.
• Excellent verbal and written communication skills combined with interpersonal and conflict resolution skills and possess strong analytical skills.
• Provide 24x7 on-call production support in case it requires.

TECHNICAL SKILLS

Databases: MS SQL Server 2014/2012/2008 R 2/ 2008/2005/2000 /7.0 , Oracle, MYSQL.

Languages: T-SQL, C, C++, C#, vb.net, JAVA, ASP.NET, Visual studio2005/2003, XML, HTML.

Operating Systems: Windows Vista/XP/2000/NT, Server 2003, Linux, UNIX.

ETL Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Data Integrator, Data transformation services (DTS).

Third Party Tools: Erwin, Red gate, Litespeed, fog lite.

Database Tools: SQL profiler, SQL Query Analyzer, Index Analyzer, SQL Server Management Studio.

Applications: Microsoft Office Suite, Adobe Photoshop.

PROFESSIONAL EXPERIENCE

Confidential, Norcross, GA

SQL Server DBA

Environment: MS SQL Server 2012/2014, Windows 2003, SSRS, SSIS, MS Access, VB, C#, Erwin and Litespeed.

Responsibilities:

• Support and troubleshoot very large databases (VLDB).
• Implement and maintain routine DBA tasks like scheduling jobs, creating maintenance plans.
• Implemented high availability concepts like Database Mirroring and Transactional Replication as a part of DR plan.
• Use log shipping for synchronization of database.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Extensively use SSIS tool to load data from MS Access, Excel spreadsheets, and flat files into the target SQL Server database.
• Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Worked on moving database files, backup and database restores.
• Daily routine DBA tasks like handling user’s permissions and handling maintenance Jobs.
• Checking database health by using DBCC Commands and created maintenance plan.
• Reconfigure the default locations of the data files, log files and error log files onto the SAN environment for all the servers.
• Expert in using and implementing DMV’s, DMF’s, data partitioning, DDLtriggers, mirroring and online indexing.
• Develop all the required stored procedures, user defined functions, and triggers using T-SQL.
• Creating logins and roles with appropriate permissions.
• Creating and Maintaining Database Maintenance Plans.
• Monitoring SQL server performance using profiler to find performance and deadlocks.
• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
• Implement and manage the clustering environment like Active/Passive and Active/Active.
• Performed backup using backup compression and Data compression in SQL Server 2008R2 on clustered environment.
• Moved files between file groups and partitioned the tables to improve the performance.
• Configure the RAID levels for data files, log files and tempdb at server level.
• Migrated SQL Server 2008 to 2012 R2 and DTS to SSIS (ETL).
• Created tables, views, indexes, functions and advanced queries for databases by using SSMS.
• Involved in setting up SQL Server Agent Jobs for periodic backups with backup devices, database maintenance plans and recovery.
• Created custom reports using SSRS.
• Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breaches.

Confidential, Denver, CO

SQL Server DBA

Environment: MS SQL Server 2008/2005, Windows 2008, Excel, HTML, XML,VB and ASP.NET, LiteSpeed, MS Visio, C#, SSIS, Microsoft SQL server Visual Studio 2005/2008.

Responsibilities:

• Managed and Administrated SQL Server 2008/2005 production and non-production servers.
• Migrated servers from SQL SERVER 2005 to 2008 both in place and side by side.
• Installed SQL Server 2008/2005 on cluster environment.
• Implemented the disaster recovery models like clustering, mirroring, log shipping and transactional replication.
• 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, DTA,SQLCMD and dedicated admin connection.
• Daily routine DBA tasks like handling user’s permissions and handling maintenance jobs.
• Checked Database Health and consistency by using DBCC commands and DMVS.
• Extensively worked on trouble shooting dead locks and fine-tuning of databases for its performance using native SQL Server tools like profiler and performance monitor.
• Managing the Litespeed backups, restore the databases transaction log on Production/Development servers as per Business/IT needs using SQL safe.
• Hands on experience in trouble shooting database issues.
• Performed all basic Database activities like moving databases between servers, copy databases etc.
• Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Designed and developed SSIS packages for data migration.
• Implemented the SQL Server 2008 new features like Policy Based Management, Data Compression, Backup Compression Resource Governor, Performance Data Collector and Transparent Data Encryption (TDE).
• Implementation of SQL server logins, roles and authentication modes as a part of security policies.
• Configure the RAID levels for data files, log files and tempdb at server level.
• Implement data availability solutions like online Restore, Online index Operation, Database Snapshot, and Fast Recovery.
• Successfully implemented the capacity planning for different servers.
• Performed data partitioning for efficient management of database tables and indexes.
• Created and managed schema objects such as tables, views, clusters, indexes, procedures, and triggers and maintained Referential Integrity.
• Export or Import data from other data sources like flat files using Import/Export through SSIS.

Confidential, VA

SQL Server DBA

Environment: SQL Server 2008/2005/2000 , Windows 2003 server, C#.net, VB and ASP.NET, LiteSpeed, MS Visio, Microsoft SQL Server Visual Studio 2005/2008, ERWIN.

Responsibilities:

• Managed and Administrated the SQL Server 2008/2005/2000 production and Non-production servers.
• Performance metrics reports daily, weekly and monthly.
• Designed a report on the monitoring of SQL Server Performance. This report gives a detail report to the management on the Performance of the server.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Rebuilding the indexes at regular intervals for better performance based on level of Fragmentation.
• Extensively worked on performance issues like update statistics, Auto Stats.
• Extensively worked on extraction, transformation and loading of data from various data sources to SQL Server.
• Creating and Maintaining Database Maintenance Plans.
• Modify Stored Procedures and complex T-SQL Queries to improve query execution process.
• Wrote T-SQL Scripts for database backup jobs and daily/weekly jobs.
• Maintaining the database consistency with DBCC at regular intervals.
• Implemented the disaster recovery models like clustering, mirroring, log shipping and transactional replication.
• Expertise in setting up and troubleshooting Database mirroring, Log Shipping.
• Extensively worked on extraction, transformation and loading of data from various data sources to SQL Server.
• Solving Tickets on Daily Basis for Production Issues.
• Creating and Maintaining Database Maintenance Plans.
• Monitoring SQL Server logs to ensure whether the backup operations, batch commands, scripts have completed successfully.
• Experience in using ERWIN tool for designing the reporting databases.
• Created Database mail Profiles and used them for sending emails for the notification of completion of jobs and processes.
• Granting permissions to users on development servers.