SUMMARY

• Over 6 years of experience in Microsoft SQL Server Database Administration & Development
• Experience in Data conversion, cleanup for application migration
• Creating Report SSRS
• Experience in SQL Server 2012/2008/2005 and Extensive experience in Migrating from SQL Server from R2/2012.
• Experience in Batch processes, SSIS (SQL Server Integration Services), DTS (Data Transformation Services), BCP (bulk copy), Import, Export
• Involved in all phases of Software Development Life Cycle (SDLC) from Analysis, Design, Development, Test, Implementation, Documentation and Support.
• Extensive experiences in developing Stored Procedures, Views, Triggers and Complex Queries on SQL Server 2005/2008/2012.
• Administering SQL Server High Availability and Disaster Recovery strategies including Log shipping and Database Mirroring
• Experience in implementing different types of Replication models like snapshot and Transactional replication
• Configured Log shipping from production to create standby Server (running as Reporting Server)
• Implemented the new SQL Server 2012 mechanisms like data compressions, online indexing, Contained Databases, security principals and Always - On AG.
• Involved on logical and physical data base modeling using ERWIN.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Experience in using tools like SQL Profiler, Windows Perfuming and Performance Counters including third party software Idera, Red Gate, SpotLight for finding out long running queries, Monitoring and Tuning MS SQL Server Performance bottleneck
• Extended experience in creating, scheduling Maintenance plans, creating alerts, monitoring and troubleshooting jobs in production support in a 24/7 environment.
• Worked on Linked and Remote servers to run queries between SQL server and other data sources using ODBC, OLDB Drivers.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Having Experience on Data center servers and handling 4 TB databases.
• Experience in supporting Very Large databases (VLDB) and troubleshooting the problems.
• Extended experience in applying necessary Service Packs and Hot fixes.
• Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS

Databases: MS SQL Server 2012/R2/R3, 2008 R2, 2008, 2005,2000

Programming: T-SQL

DBA: database administration of MS SQL Server 2012,2008, 2005

Operating System: Windows 2008/2003 Advanced Server

Tools: Backup Utility (Avamar), Spotlight, Idera, Red Gate, CommVault

Network Topologies: TCP/IP, DNS, FTP, SMTP

PROFESSIONAL EXPERIENCE

Confidential, Madison, WI

SQL Server DBA

Responsibilities:

• Developed set of administrative scripts to automate most daily operations. Recovery Plan by maintaining Backups of the system and user databases.
• Data Extraction, Cleanup and Conversion for application migration.
• Scheduled jobs to automate different database related activities including backup, monitoring database health, disk space, and backup verification.
• Monitored Server Activity, Error Log, space usage, and solving problem as needed.
• Created database objects such as creating indexes, schemas, views and stored procedures.
• Expert in Using DMVs, Performance dash board and tracking Performance Counters.
• Recovering the databases from backup in disasters. Implementing Point-In-Time Recovery solutions.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Exported and imported data from Flat file, CSV file to/from SQL Server Database using SSIS package.
• Generated various Reports for different divisions in the agency using SSRS (SQL Server Reporting Services)
• Experience in using SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor (DTA).
• Managed databases with effective Maintenance plan
• Monitoring and making recommendations for performance improvement in hosted databases. This includes index creation, index removal, index modification and adding scheduled jobs to re-index and update statistics in databases.

Environment: SQL Server 2000/ 2005/2008/2012 Windows Server 2003/2008/2012, Backup tool CommVault, MS Outlook, Management Studio, TFS, SharePoint, SSIS, SSRS,MS dynamic CRM 2011, System Center Service Manager 2012 R2 (SCSM)

Confidential, Houston, TX

SQL Server DBA

Responsibilities:

• Migrated SQL server 2008 to SQL Server 2012 in Microsoft Windows Server 2012 Enterprise Edition.
• Installed and administered Eight-Node cluster Active/Passive on Microsoft Windows Server 2012 Enterprise Edition on SAN environment.
• Configured Snapshot and Transactional Replication.
• Developed set of administrative scripts to automate most daily operations.
• Expert in Using DMVs, Performance dash board and tracking Performance Counters.
• Rebuilding / monitoring the indexes at regular intervals for better performance.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Involved in Source Data Analysis, designing and mapping for data extraction also responsible for Deployment and scheduling SSIS Packages to load the Data from various Databases and Files.
• Implemented the snapshot isolation and DDL triggers.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This includes 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 Service packs on 2012, 2008 R2 and 2005 SQL Server

Environment: SQL Server 2005/2008/2012 Enterprise, Windows Enterprise Server 2008/2012, Backup Utility (Avamar) MS Outlook, Management Studio, TFS, Spotlight, SSIS, Upgrade Advisor

Confidential, Irving, TX

Database Administrator

Responsibilities:

• Installed, Configured, and Managed SQL Server 2005, 2008/R2 in Development, Test, and Production environment
• Performed SQL Server’s health checks, fixing all environment issues regarding space issue, blocking, user’s connection problems, and replication issues.
• Monitored Data Load jobs and resolving data load issues.
• Product Change Request deployment on test servers followed by Data load completion.
• Prepared and loaded the Product Change Requests on Production servers and monitoring.
• Maintained and troubleshoot Replication issues (Transaction and Snapshot Replication).
• Used DBCC to check database conditions, fix database corruption, rebuild indexes and other database maintenance purposes
• Monitored jobs and resolving issues in SSIS packages and DTS packages
• Monitored SQL server, Application logs and analyzing the logs.
• Maintained both Dev. and Production servers in sync by deploying main release and off-cycle release.
• Created different user level groups, and assigned appropriate permission level to the database. This made sure that only the right person with enough authority would be able to see the Customer Information.
• Created Distributed Partitioned Views, Debugging / Troubleshooting Stored Procedures, upgrading existing ones.
• Working with various departments while developing their applications, assisting in Database design, phasing from development to QA and to Production environment.
• Involved in Performance Tuning for Source Databases, and Target Databases.
• Rebuilt indexes on various tables.
• Moved data from production to SIT for testing purposes with masking sensitive customer info.
• Applied Service packs on SQL Server 2008/R2 and 2005 SQL Server

Environment: Windows 2008/2003 Advanced Server, SQL Server 2005/ 2008, 2008R2 Management Studio, SSIS, Upgrade Advisor, Performance Monitor Idera, MS Outlook, Team foundation server (TFS)

Confidential, Manassas, VA

SQL Server DBA

Responsibilities:

• Installation of MS SQL enterprise servers on test, development and production environments servers.
• Performed Database Administration and Management activities in a safe, recoverable and professional manner that ensures the optimal operation of all database environments
• Restructuring the stored procedure, designing, coding and developing using the T SQL Programming.
• Good experience on configuring Replication, mirroring, and Log Shipping in SQL Server 2005/2008
• Managed migration of SQL Server 2000 databases to SQL Server 2005.
• Monitoring SQL server performance using SQL Profiler to find performance and dead locks.
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Used DBCC to check database conditions, fix database corruption, rebuild indexes and for other database maintenance purposes as well.
• Export or Import data from other data sources like flat files Import/Export through DTS, SSIS.
• Developed Database Maintenance Plan, Backup strategy for production and development environment.
• Monitoring the servers including backup using Spotlight third party software.

Environment: Windows Server 2008/2003, SQL Server 2005/ 2008, Management Studio, SQL Profiler, SQL Query Analyzer, MS SQL Server DTS, SSIS, Upgrade Advisor, Performance Monitoring Spotlight, MS-Access, MS Outlook.

Confidential, Atlanta, GA

Database Administrator

Responsibilities:

• Installed, configured and maintained SQL Server 2005/2000 in development, test and production environments.
• Involved in Analyzing and Upgrading SQL Server 2000 test servers to SQL Server 2005.
• Designed and implemented comprehensive Backup plan.
• Configured and Maintained Transactional Replication and Database Mirroring including automatic fail-over option
• Resolved and tweaked memory and CPU pressures
• Troubleshoot performance problems and fine-tuning of databases.
• Expertise in designing databases and capacity planning.
• Database and Log Backups & Restoration, Backup Strategies, Scheduling master & system databases and restoring them when necessary.
• Documented Disaster Recovery Plans and participated in disaster recovery.
• Configured and monitored transactional replication between two sites.
• Monitored and modified Performance using execution plans and Index tuning.
• Transferring the data (ETL) to Data ware house by SQL Server 2005 Integration Services.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Designed and created databases, tables, views, stored procedures and triggers.
• Perform SQL Server service pack and hot fixe upgrades.

Environment: SQL Server 2005, SQL Server 2000, Windows 2003/2002 Server, Enterprise Manager, Red Gate, SQL Query Analyzer, SQL Profiler.