SUMMARY

• Over 8plus years of IT Experience as SQL Server database admin, performing System Analysis, Design and Development and Support of Microsoft SQL Server R / 2000 on various business domains such as Health Care, Finance and Insurance.
• Experience in RDBMS database design,performance tuning, optimization, backupand recovery in SQL Server 2000 and SQL Server 2005/2008/2012.
• Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing, Contained Databases, security principals and Always on availability groups.
• Experience in implementing different types of High Availability techniques like Snapshot Replication, Transactional Replication, Log shipping, Database mirroring and clustering.
• Experience in supporting Very Large Databases (VLDB) around 5TB and troubleshooting issues with long running queries with huge tables.
• Configured Memory and Tempdb on various servers to match with the best recommended standards.
• Experienced with physical data modeling and logical data modeling using ERWIN and VISIO.
• Expertise in Database Backup and Recovery procedures using native, litespeed as well as SQL Safe.
• Proficient with Idera tools (SQLDM, SQL Safe) and Redgate tools.
• Extensively used tools like SQL Profiler, Index Tuning Wizard and Performance Monitor in order to monitor and improve SQL Server performance.
• Recorded baselines for various servers using Perfmon and Profiler also worked on fixing Dead locks/Long running queries.
• Extensively worked on Data and Backup compression with SQL Server 2008.
• Implemented data partitioning on huge tables to place files in different drives to control IOPS and to improve performance in the system.
• Worked on detailing steps to install various SQL server versions and editions, to setup replication and CDC.
• Experienced with optimizing queries, Client/Server Connectivity, and Database Consistency Checks using DBCC commands DMV’s and DMF’s.
• Expert level experience on physical storage configuration and optimization of SAN with different RAID levels.
• Performed various types of Installations, Silent installation on SQL2000, 2005, 2008 & 2008R2, Slipstream Installations on SQL 2008 and Decommissioned servers.
• Expertise in writing Stored Procedures, Functions and Triggers using T - SQL. Also worked with SQL Server 2008 new MERGE statement
• Created linked servers between SQL Server, Oracle 9i & 10g, DB2 and Teradata.
• Expertise using Business Intelligence Tools to Create SSRS, SSIS Packages and Cubes using SSAS.
• Expertise in implementation of security models; Database authentication modes, creation of users, configuring permissions and assigning roles to users.
• Administrating servers using Policy-Based management and Created groups, registered servers.
• Experience in managing Alerts, Operators and Jobs through SQL Server Agent.
• Expertise in performing data transformations between servers using BCP, DTS, SSIS, import export wizard and bulk insert.
• Good understanding in database and data warehousing concepts (OLTP & OLAP).
• 24 X 7 Production Database on Call Support.

TECHNICAL SKILLS

Databases: MS SQL Server 2012, 2008R2, 2008, 2005, 2000, Oracle

Programming: TSQL, Visual Basic 6, Visual Studio 8.

Operating System: Windows 2008/2005/2003/2000 Advanced Server, Windows 95/98/2000 XP

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

Tools: PerfMon, Backup Utility, Red gate, Lite Speed, Idera, Visio.

PROFESSIONAL EXPERIENCE

Confidential, Brentwood, TN

SQL Server DBA

Responsibilities:

• Managed, administered and got involved in troubleshooting performance issues in a server dense environment (450+ servers and over 4000 databases).
• Installed and Upgraded from SQL Server 2005 to SQL Server 2008 on Various Servers.
• Applied Patches and Service packs to update different versions of MS SQL SERVER.
• Worked extensively on Transactional Replication to keep Reporting servers in sync with live servers.
• Scheduled jobs to collect file stalls & wait type’s information to keep a track on System’s IOPS.
• Extensively used Idera tools (SQL Safe, SQL DM) and Red gate tools.
• Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.
• Created baselines and sampling intervals in the Perfmon considering threshold values of the counters.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases.
• This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Performed installation of SQL Enterprise 2012 SP1 CU 5 64bit version on Windows 2012 Sp1 Clusters (HP servers in enterprise Data Centers).
• Provided 24/7 On-Call support on rotational basis.

Confidential, Columbus, OH

SQL Server DBA

Responsibilities:

• Managed and Administrated theSQL Server 2008/2005/2000 production and Non-production servers.
• Installation of SQL Server 2008/05 and service packson Windows Server Clustered environment. prepared maintained and modified SQL server installation and configuration documents
• Upgraded/Migrated SQL Server 2005/2000 databasestoSQL Server 2008 databasesincludingDTS to SSIS packages and mentored Jr.DBA’s and other technical staff.
• Migration from Dev to QA to production environments.
• Performedbackup using backup compression and Data compression in SQL Server 2008 on clustered environment
• Handled over 4 TB Size databases in a clustered environment.
• Monitoredtransactional replication, Database mirroring on Production servers.
• Developed and created the new database objects including tables,views, indexes, stored procedures and functions, advanced queriesand also updated statistics using Query Analyzer and Enterprise Manager on the existing servers.
• Analyzed execution plans and recommended suggestions for improvement.
• Configured Min server and Max server memory for SQL server and also configured Tempdb to match with the best recommended practice.
• Partitioned huge tables and placed them in different filegroups/disks to provide best performance out of those tables for users.
• Designed and developedSSIS packages using different control flow tasks, Transformations and dataflow tasks.
• Created and processed Cubes using SSAS
• Created, scheduleddatabase maintenance plans.

Confidential, Southfield, MI

SQL Server DBA

Responsibilities:

• SQL Server 2005 Database Administration.
• Installed and configured more than 2GB RAM in SQL Server 2005.
• Performed the migration of SQL Server 2000 to SQL Server 2005.
• Configured the servers on 32 bit and 64 bit clustered and standalone server environments
• Installed and maintained 2-Node (Active-Active) Clustering as a High availability solution.
• Responsible to Monitor and troubleshooting Log Shipping.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Implemented and maintained Database mirroring as a Disaster Recovery Solution.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services
• Experience in trouble shooting Client connections, viewing error logs and application logs.
• 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.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Participated in the entire phase of Software Development Life Cycle process
• Experience in implementing and maintaining new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Transferred data (ETL) to Data ware house Environment using SSIS.
• Used Data Partitioning, Snapshot Isolation in SQL Server 2005.
• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 2.5 TB.
• Expertise in SQL Server Analysis Services.
• Expertise in creating and supporting in OLAP Cubes
• Managed VERITAS net backups and Litespeed backups.
• To analyze long running queries and tune the same to optimize application and system performance.
• Maintaining the database consistency with DBCC at regular intervals.
• Involved in creating and supporting in OLAP Cubes Involved in development activities included hardware and network specification, installation and configuration, and participation in database design, architecture and SQL scripting.

Confidential, Northbrook, IL

SQL Server DBA

Responsibilities:

• Involved in the migration of SQL Server 2000 databases to SQL Server 2005
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services
• Evaluated data storage considerations to store databases and transaction logs. Created databases using Transact SQL Statements, SQL Server Management Studio and Database Wizard.
• Managed trouble shooting of Client connections, viewing error log and applications.
• 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
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE), Data Partitioning, Snapshot Isolation
• Managed VERITAS net backups and Litespeed backups.
• Monitored servers using Spotlight third party software.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Maintaining the database consistency with DBCC utility at regular intervals.
• Using Log shipping for synchronization of database.

Confidential

SQL Server DBA/Developer

Responsibilities:

• Successfully managedExtraction Transformation and Loading (ETL) processby pulling large volume of data from various data sources usingDTS.
• Successfully migrated data between different heterogeneous sources such as flat file, Excel. Writing queries to generate reports for analysis of data usingSQL Server Reporting Services,Report Builder.
• Designed and createdReport templates, bar graphs and pie charts based on the financial data.
• Written and executedcomplex T-SQL queries using enterprise manager for back end data validation testing.
• We handled lot of production issues like data correction and resolves error handling
• Checked the configuration and performance of the existing databases including data file allocation, index fill factor, fragmentation and the impact on system performance. Analyzed potential problems (response delay, locking, server down time, etc) to avoid and optimize.
• Developed and created the new database objects including tables, views, index, stored procedures and functions, advanced queries and also updated statistics using Query Analyzer and Enterprise Manager on the existing servers.
• Loaded stored procedures and user defined functions implemented by developer teams into the databases.
• Configured the new servers using failover clustering and SAN technology.
• Migrated all the databases from old servers to new servers to test for a month.
• Generated test data and tested new databases consistency with existing databases to meet the functionalities requirements. Created jobs, alerts, activity logs, error logs to capture any possible errors.
• Monitored and tuned databases to meet the performance and availability requirements of on-line systems and multiple applications.
• Modified database structures including tables, dictionary, stored procedures, views, triggers, user-defined functions, as well as disk configuration and storage allocation to support application enhancements.
• Planned and co-coordinated database security measures.
• Writing and testing stored procedures.