SUMMARY

• Having 7 years of experience in working with MS SQL Server 2012, 2008R2, 2005, 2000 in Administration, Development, Production Servers maintenance in standalone and Clustered environments.
• Hands on experience working with SQL Server Installation, Version Upgrade and Architect Setup, SQL Server Consolidation and Virtualization.
• Performance tuning experience in using Execution plan, Profiler, PERFMON, Extended Events, Data Collector and Resource Governor.
• Extensively worked on Data and Backup compression in SQL Server 2008R2.
• Proficient in working with 32 bit and 64 bit server’s in handling Memory configurations for SQL Server 2000, 2005, 2008r2, 2012 on Windows 2003 and 2008 R2.
• Experience in Business Continuity Planning & DR Setup, Checking Hardware sizing and bottleneck tuning.
• Configuring and monitoring SQL Clustering, Replication, Log Shipping, and Mirroring.
• Design and Implement of Database Backup Restore Strategy using native method and using third part tools.
• Auditing SQL Server Security, Setting up Base lining and Capacity Planning.
• Hands on experience with SQL Server 2012 new features like High Availability Always on, Contained Databases, column - stored indexes, Throw(), Try Convert(),Format().
• Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing, and security principals.
• Worked on SQL Server 2012 migration from SQL Server 2008R2 / 2005.
• Data Transfer / Transformation experience using SQL methods, integration tools SSIS, Business objects data Integrator and Data staging.
• Experience in creating and managing reporting data using SSRS, Crystal reports
• Working experience using third party tools Net Vault LITESPEED, IDERA Diagnostic manager, IDERA SQL Safe Backup and restore, IDERA Compliance manger and Monitoring tool SCOM.
• Experience in SQL server load balancing, Database Archiving / Partitioning (Horizontal / Vertical).
• Implemented the SQL Server 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.
• Good Experience in managing DDL and DML changes through the SDLC.
• Hands on experience setting up SQL server Agent jobs using Windows Power shell.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels
• Strong technical background along with the ability to perform business analysis and write effective documentation and specifications
• Having Experience on Data center servers and handling Very Large volume databases.
• Experience in Batch processes, Import/ Export, Backup, Database Monitoring tools and Application support.
• Expertise in SQL Loader and Import/Export Utilities.
• SQL Development Experience in writing Complex T-SQL queries, SP's, Triggers using Joins, Functions.
• Data modeling Experience like Physical data modeling and logical data modeling by using ERWIN, MS Visio.
• Closely worked with development team to assist them in various problems solving and troubleshooting Web-based applications, which calls various Database objects like stored procedures, functions, triggers.
• Having good experience in configuring and troubleshooting IIS and XML.
• Supported on call as SQL Server DBA, Database Production Support 24*7*365 .

TECHNICAL SKILLS

Operating Systems: Windows Server 2000/2003/2008 R2, Windows NT 4.0, Windows XP/98/95, MS DOS.

Languages: C, C++, T-SQL, SQL plus, OSQL, VB Scripts, HTML, UNIX, .net SharePoint.

RDBMS: MS SQL Server 2012, 2008 R2, 2005, 2000, 7.0 and 6.5, Microsoft Access.

Front End: MS Visual Basic

Middle Tier: COM, DCOM, MSMQ

SQL Server Tools: Enterprise Manager, Profiler, Query Analyzer, Export & Import (DTS), SSIS, SSRS, Replication, Visio, Data Integrator (BODI),Power Shell.

Third Party Tools: Erwin, Red gate backup tool, Lite Speed backup tool, Quest’s Fog light, Net IQ.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

SQL Production DBA

Responsibilities:

• Installed SQL 2012, SQL 2008, SQL 2005 on Sandbox, Production and development environment.
• Installed and configured the thresholds in IDERA Diagnostic manager tool on Prod and test Servers.
• Involved in Storage Migration to VMAX, Played the DBA role in validating the services and testing the drivers for SQL Server.
• Installed SQL Server 2012 on both Standalone and Clustered environment (A/A and A/P).
• Involved in Scrum meetings to discuss the requirement and support needed for the Production updates.
• Monitored the TEMPDB growth and resized it by adding files in order to increase the performance by parallel process of data storage with in TEMPDB and also provided the best practices for TEMPDB configuration by providing the documentation.
• Monitoring SQL server using IDERA Diagnostic manager and also the native tool’s Profiler and PERFMON.
• Extensively used COSMOS ticketing software for working on RFC’s sent by the Database SME’s.
• Created custom scripts for monitoring the health of SQL server using DMV’s and DMF’s.
• On a daily basis proactively monitored Error Logs, SQL Servers Logs and Windows Event Viewer for any Unusual errors.
• Monitored clone environment for some of the Production databases for report users as well as Tivoli Storage manager to sweep out the backups.
• As a part of team member managed over 2000 databases by maintaining the security of data, fixing the failed Principals (logins), user permissions and security in Active Directory.
• Used Third party tools NETVAULT LITSPEED, IDERA Products in taking up the backups, for compression of the backup files and in setting up Log shipping, Replication.
• Monitored the daily maintenance, weakly maintenance and monitoring jobs.
• Worked extensively in maintaining the index fragmentation by regularly scheduling for the reorg/rebuild of indexes based on the fragmentation level and updated the stats.
• Proactively Managed the databases i.e. managed databases, tables, log file allocation and space utilization, identify table growth & file growth for table or index reorganization, fatal errors, failed jobs, integrity violations, performance issues and data abnormalities.
• Provided 24/7 support on call Production Support.

Environment: SQL Server 2000/2005/ 2008 /2012 , Sql DTA, Profiler, Windows Event Viewer, Perf Mon, Litespeed backup tool, IDERA Diagnostic Manager, COSMOS,TFS,SDMF, Replication, Log shipping, clustering(3node).

Confidential, Rochester, MN

SQL DBA

Responsibilities:

• Extensively Worked in Installation of SQL Server 2008 R2.
• I was responsible for monitoring around 20 nursing production servers. The maximum size of the DB I have worked on for this client is 8TB.
• Extensively worked in performance tuning the nursing DBs. I used tools PERFMON, PROFILER, ACTIVITY MONITOR, SQL internal dashboard reports, system stored procedures, DMVs, DMFs and task manager.
• Used third party tool IDERA Diagnostic Manager to monitor the CPU, IO, Memory usage of SQL instances.
• Worked expensively on transactional replication and periodically validated the data between publisher and subscribers and also regularly monitored replication jobs to ensure they are working.
• Played a Lead role in Gathering the Information from the RN’s, and validate the data with respect to the reports.
• Arranged meetings with the client i.e. nursing department to know the objects information to be created and the aggregated data they need for the reports.
• Extensively worked in analyzing the data coming from different sources and design the schema.
• Extensively used the ETL tool Data Integrator and SSIS to pull the data into the Mart from different sources.
• Scheduled the daily jobs to pull the Data from multiple sources into the Mart using the Business Objects data integrator (BODI).
• Worked in creating the Nursing Reports using SSRS.
• Extensively worked in extracting the DB2 Data, Python Code into SQL server using SSIS.
• Worked with IDERA monitoring tool for monitoring the health checks of SQL server Databases.
• Extensively worked in comparing the data pulled from different sources using SQL compare.
• Scheduled the maintenance plans to check the space utilized and also for database consistency checks.
• Involved in all tasks associated with daily operations such as database availability, monitoring activity, installations and back-up strategy.
• Performance tuned the Databases by consistently monitoring the job durations and also the type of execution plans used by the processes, Indexes used in order to maintain the data integrity.
• Extensively worked in code promotions from Development to QA and production Server and also checking in the code changes into TFS.
• Copied and Migrated DTS 2000 PACAKGES to SSIS packages and maintained the archival data using Control flow task.
• Worked in documenting the entire process of recovering the Databases of Nursing Database using Disaster Recovery Planning.
• Worked in taking the backups in regular intervals.
• Worked closely with the end users and the reporting team to meet there goals.

Environment: SQL Server 2000/2005/ 2008 R2/2012, SQL DTA, Profiler, Windows Event Viewer, PERFMON, BODI, BMC Remedy Ticketing, Visual Source Safe 6.0, Log shipping.

Confidential, Los Angeles CA

SQL Database Administrator

Responsibilities:

• Worked on Installation up-gradation and maintenance of SQL Server databases
• Extensively worked with our team members to schedule the change request for an outage in order to do any Database upgrades.
• Implemented Side By Side Migration of MS SQL SERVER 2000, 2005 to 2008 on Windows 2008 server.
• Copied and Migrated DTS 2000 PACAKGES to SSIS packages and maintained the archival data using Control flow task.
• Created some DTS packages, SSIS packages and Reports using SSRS.
• Migrated around 55 databases and installed around 25 servers and the max size of the database which I migrated is 2 Tb size using red gate lite speed backup and restore.
• Created the shared drives, used ROBOCOPY for the copy operation from one server to another.
• Installed the SQL server on windows server 2008 R2 and documented the process of doing it in different environments, replication server, clustered nodes.
• Managed over 200 Servers by maintaining the security of data, fixing the failed Principals (logins), user permissions and security in Active Directory and SQL Server level.
• Used Third party tools like red gate Lite speed, Quests lite speed in taking up the backups, for compression of the backup files and in setting up Log shipping, Replication.
• Monitored the daily maintenance, weakly maintenance and monitoring jobs.
• Took a lead role in troubleshooting the performance issues on the database as well as instance level using the native tools profiler, PERFMON and activity monitor.
• Worked extensively in maintaining the index fragmentation by regularly scheduling for the reorg/rebuild of indexes based on the fragmentation level and updated the stats.
• Used the new concepts of SQL server 2008 and also DMV’s for monitoring the fragmentation of indexes, blocks, memory page splits, Log space of all the databases.
• Monitored the TEMPDB growth and resized it by adding files in order to increase the performance by parallel process of data storage with in TEMPDB.
• Managed a wide range of relational databases and utilized proprietary DBA tools and utilities to monitor the health of production database systems.
• Proactively Managed the databases i.e. managed databases, tables, log file allocation and space utilization, identify table growth & file growth for table or index reorganization, fatal errors, failed jobs, integrity violations, performance issues and data abnormalities.
• Provided 24/7 support for the DSS customers by actively monitoring the job history, alerts.

Environment: SQL Server 2000/2005/ 2008 , Sql DTA, Profiler, Windows Event Viewer, PERFMON, LITESPEED backup tool, Advanced Windows 2008 R2 Server,2003, Visual Source Safe 6.0, SDMF, Replication, Log shipping, clustering(3node).

Confidential

SQL DBA

Responsibilities:

• Worked extensively on installation, upgrade and configuration of MS SQL Server 2005/2000 databases / servers.
• Involved in migrating SQL Server 2000 to SQL Server 2005.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• 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.
• Scheduled backups and performed restore operations for system test data depends on testers’ requirement.
• Created logins and maintained user permissions appropriately.
• Performed DBCC checks and fixing data corruption in Application databases
• Data transfer using BCP and DTS.
• Creating tables, views, indexes, stored procedures, triggers and constraints.
• Performance Tuning: Analyze, tuning and optimizing for SQL Server Applications by using performance monitor. Assist the SQL Developers in SQL tuning.
• Security Implementation: Administering the MS SQL server by creating users logins with appropriate roles, dropping and locking the logins, monitoring the user accounts, creation of Groups, Granting the Privileges to Users and Groups.
• Run DBCC consistency checks, rebuild indexes, and update statistics for databases on regular basis.
• Involved in writing T-SQL Programming for implement Stored Procedures and Functions for different tasks.

Environment: MS SQL 2000/2005, T-SQL, Windows 2000/2003, VB Script, ADO.Net.