SUMMARY

• Over 7 years of Experience in SQL Server Database Administration, System Analysis, production, QA and UAT environments and support of 32 - bit, 64-bit MS SQL Servers 2012, 2008 R2, 2008, 2005,
• Expertise in Installation, Upgrade, Configuration and Migration of MS SQL Server in clustered and non-clustered environments.
• Proficiency and expertise in SQL Server Replication, Backup/Recovery, Disaster recovery and planning.
• Experience in Database Modeling includes Logical and Physical Design of Databases using Microsoft-Visio.
• Experience in implementing Disaster Recovery (DR) and High Availability Solutions (HA) using Database Mirroring and Log Shipping.
• Expert in SQL Server database Performance Query Optimization, Client/Server connectivity, DB consistency checks using DBCC.
• Experienced in Design, Testing, Implementation and production of Client/Server, and Web based applications.
• Experience in Migrating from SQL server 2005 to 2008R2 and 2005/2008/ 2008R2 to 2012 by using side-by-side and in-place upgrade process, and documented the Upgrade Process.
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Log Shipping, DTS, Bulk Insert and BCP.
• Good at Data availability solutions like Online Restore, Online index Operation, Database Snapshot, and Fast Recovery.
• Expert in Performance Tuning by Index Defragmentation, optimizing execution plans, proper usage of indexes, horizontal and vertical partitioning.
• Experience in configuring and managing Linked Servers. Data transfer between SQL Server and other heterogeneous relational databases such as Oracle and DB2.
• Experience in trouble shooting SQL server jobs, and job monitoring tool.
• Good at Data availability solutions like Online Restore, Online index Operation, Database Snapshot, and Fast Recovery.
• Experience in creating Packages, Jobs, sending alerts using SQL Mail and custom extended procedures.
• Auditing of database for user transaction, login and database action and removing orphan users.
• Experienced in creating interactive reports using Crystal Reports and SQL Server Reporting Services (SSRS).
• Ability to work in a fast paced environment, Good team player. Helped the database and application developers on technical issues.
• 24 X 7 Production Database on Call Support.

TECHNICAL SKILLS

Databases: MS SQL Server 2014/2012/2008R2/2008/2005. Oracle 11g/10g

Languages: C# ASP. NET, T-SQL, My SQL, VB.NET, HTML, XML, C/C++, CSS, DHTML, Java Script

Technologies: .NET FRAMEWORK, ASP.NET, Microsoft Office Suite

Tools: Active X, IIS, MTS, Lite speed, Spotlight, Visual Studio 2003/2005, VSS, Visio 2003, Office Visio 2007, Erwin 4.0,SSIS,SSRS,SSAS,SCOM,Tivoli TSM, Toad 10.5, SSMA

Operating System: Windows 2000, Windows 95/98/XP/Vista/7/8.

Others: Microsoft office, Microsoft Project.

PROFESSIONAL EXPERIENCE

Confidential Tampa, FL

Sr. SQL Data Base Administrator.

Responsibilities:

• Highly worked on Administration, Database Design, and Performance Analysis on very large and highly transactional production databases.
• Installed and configured SQL Server 2014/2012 on new servers with service packs.
• Support and troubleshoot very large databases (VLDB) with 50 GB to 3 TB.
• Extensively worked on Snapshot and Transactional Replication.
• Migrated SQL Server 2008 R2 to 2012/2014.
• Implemented Always On, HA and worked with 2014 new concepts like Delayed Durability, Partition-Table Parallelism, Data Compression, Table and Index Partitioning, Buffer pool extension, Resource Governor for scalability and Performance enhancements.
• Work on i64 clustered and standalone server environments.
• Configure the RAID levels for data files, log files and tempdb at server level.
• Reconfigure the default locations of the data files, log files and error log files onto the SAN environment for all the servers.
• Work with tools like SQl Server Agent, SSCM, SMO, Database Tuning Advisor, SQL Server Dashboard, SQL Profiler and Activity Monitor for event monitoring and performance monitoring, and make recommendations based on the results.
• Involved in ETL process under development, testing and production support environments.
• Extensively use SSIS tool to load data from MS Access, Excel spreadsheets, and flat files into the target SQL Server database.
• Develop complex mappings and tune mappings for better performance.
• Implement various Data Flow Transformations, such as Copy Column, Row Count, Merge Join, Aggregator, Sort, and Lookup.
• Fix data issues and write various SQL scripts and procedures for migration process.
• Involved in Data Compression, Hot add CPU, Fact Table size reduction and improved performance using SQL Server 2008.
• Expert in using and implementing DMV’s, DMF’s, data partitioning, DDL triggers, Mirroring and Online indexing.
• Develop all the required stored procedures, user defined functions, and triggers using T-SQL and PL/SQL.
• Implement data availability solutions like online Restore, Online index Operation, Database Snapshot, and Fast Recovery.
• Optimize the performance of queries with modifications in T-SQL queries, remove unnecessary columns, eliminate redundant and inconsistent data, and normalize tables.
• Responsible for transferring packages using SSIS (ETL).

Environment: SQL Server 2008R2/2012/2014, T-SQL, Windows 64-bit, DTS, SSIS, Red Gate, Profiler, MOM, SQL Sentry, Share Point.

Confidential, Michigan

Sr. SQL DATABASE ADMINISTRATOR

Responsibilities

• Performed daily tasks including backup and restore by using SQL Server 2008 R2/2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Monitoring SQL server performance using SQL Profiler to find performance and dead locks.
• Extensively worked on Dynamic Management Views in SQL Server 2008.
• Extensively worked on Data Partitioning and Snapshot Isolation in SQL Server 2008.
• Prepared DFDs & Entity Relationship(ER) diagrams.
• Transferring the data (ETL) to Data warehouse (Informatics) by SSIS.
• Installed, authored, and managed reports using SQL Server 2008 Reporting Services.
• Managed the migration of SQL Server 2008 databases to SQL Server 2008 R2.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Perform business analysis, technical analysis, systems design, application software programming.
• Prepared the project management and technical documentation.
• Unit Testing the SSIS packages with respect to its flow and performance issues.
• Solving the Bugs Reflected by the Testing team.
• Rebuilding the indexes at regular intervals for better performance.
• Monitored and modified Performance using execution plans and Index tuning.
• Extensively worked on DBCC commands and Dynamic Management Objects.
• Involved in troubleshooting and fine-tuning of databases for its performance and concurrency.
• Complete documentation about the database. Recovering the databases from backup in disasters.
• Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• To set up SQL Server configuration settings for better server management.
• Worked on SQL Server tools Like Enterprise Manager and SQL Query Analyzer.

Environment: SQL Server 2008R2/2008 Enterprise, Windows Enterprise Server, IIS 6.0, IIS7.5,.NET, Microsoft Visio 2003, SFTP, Microsoft Reporting Service and ASP.

Confidential, Nashville, TN

SQL Data Base Administrator.

Responsibilities:

• Responsible for Query optimization and Performance tuning.
• Rebuilding of indexes to improve data retrieval performance
• Managed Microsoft Clustered SQL Server 2008 environment.
• Involved in Migration from SQL 2005 to SQL 2008.
• Managing server logins, database users and permissions.
• Created Clustered Indices and Non-Clustered Indices to increase the performance of database.
• Managing and scheduling daily jobs relating to data transfers, backup and recovery, transaction log dumps.
• Worked on Data Partitioning and Snapshot Isolation in SQL Server 2008.
• Used Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, created packages for different data loading operations for application.
• Used the SQL server integration services (SSIS) as a part top transfer logins from SQL server 2005 to 2008 and to move data from one server to another server.
• Configuration and Administration of IIS 6.0, Windows 2003 server.
• Created the Database Objects like Tables, Views, Functions, Stored Procedures and Triggers.
• Managing security tasks like granting and revoking permissions

Environment: TSQL, MS sql server 2005/2008, SSRS, Query analyzer, visual studio 2005, vb.net, c#, windows server 2008, iis, SSAS.

Confidential, New York, NY

SQL Database Administrator

Responsibilities:

• Installation, configuration and upgrading of MS SQL server 2000/ 2005.
• Plan, Configure and maintain, DTS/SSIS, Transactional Replication and Log Shipping.
• Configure database maintenance plans for backup and database optimization.
• Establish and maintain various backup and recovery policies and procedures.
• Implement and maintain database security (create and maintain users and roles, assign privileges).
• Perform database tuning and performance monitoring.
• Incorporate performance measurement by using tools like SQL Analyzer along with T- SQL and NT Performance Monitor.
• Development of T- SQL objects and writing Stored Procedures, Triggers, Views, Functions, Indexes, Constraints, Queries, Distributed Queries.
• Windows system administration on 1st level win2k3 server, user objects in Active directory and terminal services.
• Deploying Clustering in Microsoft cluster server 2005
• Worked with Oracle RAC team to understand cross platform complexities to migrate data for a new application using SQL server 2005 clustered servers.

Environment: Windows Server 2000/2005, VMware, SQL Server 2005, Windows 2003, DTS, T-SQL

Confidential,

SQL Server Database Administrator.

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.

Confidential

Jr. SQL Server DBA

Responsibilities:

• Created new tables, written stored procedures for Application Developers and some user defined functions.
• Created SQL scripts for tuning and scheduling.
• Involved in performed data conversions from flat files into a normalized database structure.
• Involved and managed users, roles and groups and handled database security.
• Created Triggers to enforce data and referential integrity.
• Involved in Performance of development support, document reviews, test plan, integration of the system.
• Involved in Maintenance of Indexes for fast and efficient reporting process.
• Analyzing the Database Growth and Space Requirement. Handling Users/Logins/User Rights
• Implement and maintain database security (create and maintain users and roles, assign privileges).
• Involved in Export or Import data from other data sources like flat files using Import/Export through DTS, SSIS.

Environment: Windows, SQL server, T-SQL, Query Analyzer, Data Transformation Service.