Summary
Over 8 + years of expertise as results-driven project and database management professional with first-rate skill in directing full cycles for complex, multi site programs. Expertise in Database Administration, System Analysis, Design, Development and Support of MS SQL Server 2008 R2, 2008, 2005, 2000 in Production, Staging and Development Environments.

Technical Summary:

• Extensive experience in Installation and configuration of SQL Server 2008 R2, 2008, 2005 and 2000.
• Configured Active/Active and Active/Passive clustering for failover.
• Performed Capacity Planning, data modeling and Logical/Physical database Design.
• Experience in Database Backup, Recovery and High Availability (Clustering, Log Shipping, Replication and Mirroring).
• Configured and maintained Transactional and Snapshot replication.
• Experience in setting up Database Mirroring with witness Server in SQL server 2008 R2 (Manual / Automatic fail-Over).
• Hands on experience in Migration of SQL Server 2005 to SQL Server 2008 and SQL Server 2000 to SQL Server 2005 (side by side and in place).
• Involved in migration of DTS Packages (2000) to SSIS (2005) and troubleshoot migration issues
• Extensively worked on Integration (SSIS) and Reporting Services (SSRS), Analysis Services (SSAS), Business Intelligence and good experience in data migration from Oracle/MS-Access/MS-Excel Sheets/MYSQL to SQL Server 2008/2005.
• Creating and Maintaining Trace Audits for Security events and generating Reports to analyze the Events.
• Administering the MS SQL Server 2005 & 2008 Security 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.
• Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, PerfMon and DB Engine Tuning Advisor.
• Experience in solving Database issues with Index fragmentation, DBCC checks, Optimization of Query, Data Integrity, Index tuning, Update Statistics, Error and Event Handling.
• Experienced in writing T-SQL (DDL, DML, and DCL). Expert in implementing business logic in backend. Reviewing T-SQL code, maintaining coding standards in all SQL Server environments.
• Experienced in programming tasks Stored Procedures, Triggers and Cursors using SQL Server 2008/2005/2000 with T-SQL.
• Extensively used tools like SQL Profiler, Index Tuning Wizard, I3 Precise, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance
• Expertise in SQL Server Storage Structures and Security Architecture for databases residing on SAN storage on distributed systems.
• Expertise in Scheduling Database tasks – Jobs, Alerts, Emails, Notification.
• Worked with Popular monitoring solutions like Quest Enterprise edition, Spot lights.
• Working knowledge of .Net Framework (VB.Net, ASP.Net, ADO.Net) and IIS.
• Testing methodologies and tools - Automation and Performance testing.
• Strong Communication & Management skills and Excellent Team player.

Certificate of Excellence (Microsoft.)

Microsoft SQL Server 2005: MCITP – Database Administrator
Microsoft SQL Server 2008: Implementation and Maintenance

• Bachelor of Engineering in Computer Science

TECHNICAL SKILLS:

Languages C, C++, T-SQL, XML, HTML Script, VB script, JAVA
RDBMS MS SQL Server 2008, 2005, 2000, Oracle, Sybase, MS-Access
OLAP Tools SQL Server Analysis Server 2008, 2005, SSIS (as ETL)
Operating Systems Windows 2008/2003/2000/Professional/ NT 4.0 Advanced Server
Other Tools Compaq Insight Manager, Idera Diagnostic Manager, NetIQ,
Red Gate, SQL Safe, light speed, ERWIN 4.0, Toad, Crystal Reports.

PROFESSIONAL EXPERIENCE:

Responsibilities:

• Involved in Data center Migration project for moving databases across the location.
• Implemented backup strategy for the new data center environment.
• Restored the database on Staging servers and development servers as per requirement.
• Configured high availability methods such as Replication with mirroring.
• Experience in Maintaining SQL Server Security, creation of logins and users, configuring permissions and assigning roles to users.
• Implemented customized alert monitoring setup based on application perspective.
• Applied patches for the SQL server environment after the Migration.
• Had experience working on APEX SQL tool for comparing database objects.
• Worked on Precise Toll (i3) for Monitoring the server performance and added events to monitor.
• Worked on User service cases for deploying scripts/ creating jobs / packages.

Environment: .NET Framework, ASP .NET, ADO.NET,AJAX, Visual Studio .NET, HTML, XML, XSLT, Windows server 2003, 2008, QUEST, Precise, ApexSQL, SQL Server 2008 R2, 2005, SSIS and SSRS.

Sr. SQL Server System Administrator/DBA

Responsibilities:

• Installed SQL Server 2008 R2 on standalone and cluster environments.
• Involved in Migration of SQL 2005 to SQL server 2008 R2.
• Configured and administered SQL Clusters (Active/Passive, Active/Active).
• Experience in Understanding structured data analysis, data models and data normalization.
• Involved in rewriting of all the functionality of SQL server 2005 to SQL server 2008 R2.
• Experience in setting up Database Mirroring with witness Server in SQL server 2008 R2 (Manual / Automatic fail-Over).
• Configuring SSIS (SQL Server Integration Services) for named instances, remote access enabling for Users.
• Creating maintenance plan for consistency checks, maintaining indexes and statistics, performing fine Tuning of Database Application.
• Analyzed Performance using Performance monitor in order to identify the bottleneck such as CPU, memory, IO, paging and SQL Server and also bottleneck of SQL Server such as buffer cache hit, memory, transaction, procedure cache, paging etc.
• Solid experience with SQL 2008 R2 backup and recovery procedures.
• Creating and Maintaining Trace Audits for Security events and generating Reports to analyze the Events.
• Successfully Implemented Multi–Server Administration in SQL Server 2008 R2 and developed scripts to use in Multi–Server Administration.
• Involved in Performance Repository Project, where we collect data and generate report to Proactively Monitor the Servers and try to avoid any kind of Server and database related issues.
• Implemented QUEST Management solution at Enterprise Level and configured for performance analysis of the Databases.
• Exporting the Database from Local Server to the Remote Server and Importing the Current running database from remote server to the Local DB Server using SSIS.
• Developed SQL data migration scripts for application conversion or integration.
• Given proposal for servers and hardware RAID configuration solutions for Enterprise Solutions.
• Applied hot patches on MSCS (Microsoft Clusters) and Fixed few bugs in Microsoft Cluster and SQL Virtual Servers.
• Created various Jobs, scheduled & ran jobs and troubleshooted the failed jobs.
• Had good experience in 24/7 production support.
• Good understanding of developing Data Ware house applications using star schema approach.

Environment: .NET Framework, ASP .NET, ADO.NET,AJAX, Visual Studio .NET, HTML, XML, XSLT, Windows server 2003, 2008, QUEST, SSL, IIS 6.0, SQL Server 2008 R2, 2005, SSIS and SSRS.

Confidential,OH Oct’09–Feb’11 Sr. SQL Server Administrator

Responsibilities:

• Installed and configured the Windows NT/2008, SQL Server 2008.
• Providing 24/7 on call support for all the Production servers.
• Used upgrade advisor tool to check any prerequisites steps to be taken before migrating the Databases.
• Involved in Migration of SQL Server 2005 to SQL server 2008.
• Restored the database on production server or development servers as per requirement.
• Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments across entire system.
• Experience in Maintaining SQL Server Security, creation of logins and users, configuring permissions and assigning roles to users.
• Migrated SSIS (2005) packages to SSIS (2008) packages.
• Involved in Capacity Planning, data modeling and Logical/Physical database Design.
• Created and Managed SQL Server Logins and Users as per the requirement with specific roles and permissions on production servers.
• Configured and maintained Transactional and Snapshot replication.
• Involved in Change Control Management is the discipline of systematically identifying and controlling change requests to a project from both internal and external sources.
• Designed and implemented comprehensive Backup and Recovery plan and disaster recovery strategies Implemented.
• Configured Database alert scripts like database size increase, log size full, maintenance script for all SQL Server versions..
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Worked on Site Scopes Monitoring tool and SQL Safe Backups tool.
• Database Refresh from Production backup to Stage and Development environments
• Working with ITSM Tickets (Any changes on Production, staging and development environment need to Create ITSM Tickets).
• Developed few reports using MS SQL Reporting Services.
• Maintained the Tax System databases.
• Worked on critical issues on production servers with the help of Microsoft tech support.
• Extensive experience on VMware machines.

Environment: Windows 2008/2003/2000/NT, MS-SQL Server 2008/2005, SSIS, SSRS and MOSS 2007, Site Scopes monitoring tool and SQL Safe Backups tool, Clustering, VMware machines.

Confidential,OH Oct’ 08 – Oct’ 09
SQL Server Administrator

Responsibilities

• Installed, Configured and Maintained SQL Server 2008 in multiple database environments, namely development, QA and Staging..
• Provided Primary support DBA to various business critical SQL Server applications hosted over 300 servers (SQL 2008/2005).
• Upgraded to SQL Server 2008 and guiding the development and application team to fully utilize SQL Server 2008 enhancements.
• Created Merge Replication between different data centers. Resolved issues; designed and managed database security.
• Monitored Databases for Dead Lock, Capturing long running SQL queries, used HINTS for fine-tuning SQL statements.
• Used SQL Server Profiler to monitor the server by running traces on various events like User connections, stored procedure execution time etc.
• Evaluated the Database Performance of Index tuning with using DTA to resolve Performance issues.
• Setup and configured SQL Server for other business functions. Index Data Management to determine Defragmentation level; whether to Update Statistics or Rebuild Indexes.
• Scripted the Database Consistency Checks (DBCC), scheduled the scripts to run daily and weekly basis.
• Monitored via SQL modules like Idera Diagnostic manager, Tivoli etc for performance issues like excessive locking, table scans, deadlocks, fragmentation and other bottlenecks.
• Responsible for SQL Server tuning, performance evaluation, optimization and utilized new features like SQL Dynamic Management Views for the same.
• Used Visual Source Safe 2008 for version control. Created various Stored Procedures to enforce the business logic.
• Created Database Diagram using Erwin Data Modeler, Data Dictionary Document, Database Installation and Configuration Document and Merge Replication Setup Document.
• Extracted data from various sources like SQL Server 2005/2008, Oracle, Teradata, .CSV, Excel and Text file from Client servers and through FTP.
• Handled Performance Tuning and Optimization, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• The SSIS packages created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy Lookup, Multicast, and Data Conversion.
• Responsible for identifying and defining Data Source and Data Source views mappings for ETL.
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
• Monitored Full/Incremental/Daily Loads and support all scheduled ETL jobs for batch processing.
• Provided primary pager support on rotation basis.

Environment: MS SQL Server 2005/2008, T-SQL, DTS, Replication, MS Access, Windows 2008 server, Windows NT 4.0,SSIS

Confidential,Chicago,IL May’ 07 – Oct’ 08
SQL Server DBA

Responsibilities

• Providing 24/7 On-Call support for critical production databases of GE Health Care and GEASP Datacenters
• Proactive monitoring of production databases
• Responsible for General Database Administration, Query Performance tuning, and validated some of the existing schema.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Loaded the data from multiple systems to the Reporting Data warehouse database.
• Expertise on SQL Diagnostic Manager Tool which can be configured for all production databases
• Reporting and resolving serious SQL Server alerts.
• Refreshes from Production backup to Stage and Development environments
• Working with workflows (Any changes on staging and development environment need to assign workflow this is GEHC Standards)
• Working with Change Controls (Any changes in Production database need to assign Change control this should be approved by Global DBA team after changes made in stage and development environment)
• Generated different reports using MS SQL Reporting Services.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation.
• Worked on DTS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Using SSIS, Experience in data transformation domain.
• Worked Windows2005 Cluster environment (Active/Active and Active/Passive).
• Verifying all instances are up and Running.
• Verifying all error log files for any new entries.
• Login creations and assigning roles

Confidential,India Aug\' 05 – Apr\' 07
SQL Server DBA /Developer

Responsibilities:

• Installed and maintained MS SQL Server 2005 on Windows 2003 Server.
• Worked on SQL Server 2005 failover clustering which is built on top of a Windows 2003 server cluster.
• Responsible for integrating data into a centralized database with dynamic design and user friendly web application, to keep track of Direct Bill Payments and Commissions from various Clients across the nation.
• Modeled and designed the architecture of the SQL Server 2005 database.
• Successfully Installed the Service Pack 1 and Hot-fix for SQL Server 2005 in all the Development and Production Environments.
• Responsible for MS SQL Server 2000/2005, configuration, tuning and provide 24 X 7 dedicated support to all Production/staging/development servers.
• Tuned Complex SQL Queries as a part of Query optimization.
• Configured Log shipping from one production server to the staging server.
• Creating DTS Packages for data import/export, scrubbing and scheduled jobs for backups.
• Data migration using bulk copy program and DTS from Oracle Databases and Flat files.
• Ensure the database consistency and integrity through various database maintenance plans.
• Assign permission to user(s), role(s), and object. Support column level permission. Administrate security for server’s logins.
• Job Monitoring and making sure all jobs run successfully every night.
• Used third party tool, LITESPEED to speed up backup operations.
• Monitor SQL Error Logs, Schedule tasks, database activity.

Environment: T-SQL, SQL Server 2000/2005, Windows 2003/NT, Log shipping, Clustering, DTS, LITESPEED.