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 2012, 2008 R2, 2008, 2005, 2000 in Production, Staging and Development Environments.

TECHNICAL SUMMARY:

• Extensive experience in Installation and configuration of SQL Server 2012, 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 .
• Expertise in Scheduling Database tasks Jobs, Alerts, Emails, Notification.
• Expertise in SQL Server Storage Structures and Security Architecture for databases residing on SAN storage on distributed systems.
• Extensively used tools like SQL Profiler, Index Tuning Wizard, I3 Precise, and Windows Performance Monitor for monitoring and tuning MS SQL Server performance
• Managed 100 databases in SAP Environment.
• Experienced in programming tasks Stored Procedures, Triggers and Cursors using SQL Server 2012/2008/2005/2000 with T-SQL.
• Extensive experience with relational databases SQL , data mining and analysis.
• 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.
• Knowledgeable in creating PowerShell Cmdlets
• Experience in solving Database issues with Index fragmentation, DBCC checks, Optimization of Query, Data Integrity, Index tuning, Update Statistics, Error and Event Handling.
• Expertise in Performance tuning, Optimization, Data integrity and Statistics by using SQL Profiler, PerfMon and DB Engine Tuning Advisor.
• 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.
• Involved in migration of DTS Packages 2000 to SSIS 2005 and troubleshoot migration issues
• Experience with Change data Capture in SQL Server 2008.
• Hands on experience in Migration of SQL Server 2008 to SQL Server 2012 and SQL Server 2005 to SQL Server 2008 side by side and in place .
• Worked with Popular monitoring solutions like Quest Enterprise edition, Spot lights.
• Working knowledge of .Net Framework VB.Net, ASP.Net, and ADO.Net and IIS.
• Testing methodologies and tools - Automation and Performance testing.
• Strong Communication Management skills and Excellent Team player.

TECHNICAL SKILLS:

PROFESSIONAL EXPERIENCE:

Confidential

Sr.SQL Server Database Administrator

Responsibilities:

• Configured Change Data Capture in SQL Server 2008 to maintain the history of the changes in the tables.
• Involved in installation of SQL Server 2012 and 2008 R2 on Consolidated and Standalone environments and maintains development and production databases e.g., SQL Server databases .
• Involved in Installation of SQL Server with Multiple instances, Service packs and Hot Fixes
• Audits and maintains small-scale to large-scale databases.
• Responsible for General Database Administration, Query Performance tuning, and validated some of the existing schema.
• Worked on protocols like Kerberos, TCP/IP and NLTM.
• Involved in database system management functions e.g., software installs, version upgrades and configuration management .
• Managed SAP backend SQL Server databases which are in Terra bytes of size.
• Identifies tests and resolves complex database issues e.g., monitoring and tuning .
• Generating/Enhancing VBScripts, executing the test scripts, analyzing test results using QTP.
• Involved in migration of SSIS 2005 packages to SSIS 2008R2 packages.
• Worked on DTS Packages, DTS Import/Export for transferring data from Database Oracle and Text format data to SQL Server.
• Worked on Performance Tuning and Optimization, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Involved in creating maintenance plan for consistency checks, maintaining indexes and statistics, performing fine Tuning of Database Application based on standard process.
• Responsible for verifying all data to be entered into database meets set standards and requirements.
• Involved in creating SQL Login accounts and Users with appropriate permissions on Production and development servers.
• Worked on Active/Active and Active/Passive Clustering.
• Worked on SQL Server 2008 failover clustering which is built on top of a Windows 2003 server cluster.
• Defined and provided recommendations database standards, procedures and architecture.
• Designs data models and Data Warehouse database designs.
• Participated in a 24x7 production support on-call rotation.
• Performed SQL Code Index Reviews.
• Extensive Relational Database RDBMS experience and advanced SQL Query skills
• Worked with Database tools IDERA, SQL Diagnostic manager, Sites cope for Multi Queries, Space analyzer, SQL alerts Disk space alerts, SQL Service alerts, CPU utilization alerts .
• Involved in Ensuring optimal performance and availability of databases.
• Involved in creating SQL jobs and troubleshoot failed jobs.

Environment: SQL Server 2012,2008 R2, 2005, SSIS and SSRS, Sites Scope monitoring tool, IDERA tool, VMware machines, .NET Framework, ASP .NET, ADO.NET,AJAX, Visual Studio .NET, HTML, XML, XSLT, Windows server 2003, 2008.

Confidential

Sr. SQL Server System Administrator

Responsibilities:

• Configuring SSIS SQL Server Integration Services for named instances, remote access enabling for Users.
• Experience in setting up Database Mirroring with witness Server in SQL server 2008 R2 Manual / Automatic fail-Over .
• Involved in rewriting of all the functionality of SQL server 2005 to SQL server 2008 R2.
• Experience in Understanding structured data analysis, data models and data normalization.
• Used Power Shell command to deploy web part package, activate features as well as install them.
• Configured and administered SQL Clusters Active/Passive, Active/Active .
• Involved in Migration of SQL 2005 to SQL server 2008 R2.
• Installed SQL Server 2008 R2 on standalone and cluster environments.
• 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.
• Experience working with relational databases like Oracle and Microsoft SQL Server.
• Well versed knowledge on SQL scripts on various Relational Databases.
• Experience working with relational databases like Oracle and Microsoft SQL server.
• 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.
• Generating/Enhancing VBScripts, executing the test scripts, analyzing test results using QTP.
• 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

Sr. SQL Server Administrator

Responsibilities:

• Well versed knowledge on SQL SCRIPTS on various Relational Databases.
• Designed and implemented comprehensive Backup and Recovery plan and disaster recovery strategies Implemented.
• Involved in Change Control Management is the discipline of systematically identifying and controlling change requests to a project from both internal and external sources.
• Configured and maintained Transactional and Snapshot replication.
• Created and Managed SQL Server Logins and Users as per the requirement with specific roles and permissions on production servers.
• Involved in Capacity Planning, data modeling and Logical/Physical database Design.
• Migrated SSIS 2005 packages to SSIS 2008 packages.
• Daily support, troubleshooting, monitoring, optimization and tuning of server and SQL server environments across entire system.
• Restored the database on production server or development servers as per requirement.
• Involved in Migration of SQL Server 2005 to SQL server 2008.
• Used upgrade advisor tool to check any prerequisites steps to be taken before migrating the Databases.
• Providing 24/7 on call support for all the Production servers.
• Installed and configured the Windows NT/2008, SQL Server 2008.
• 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
• Generated VBScripts, executing the test scripts, analyzing test results using QTP.
• 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

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.
• Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS excell,MS Access and Flat Files
• 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

Environment: MS SQL Server 2005/2000, Windows 2003 server, Windows NT 2.0, T-SQL, DTS, Clusters, IDERA Monitoring Tool SQLDM , SSRS.

Confidential

SQL Server DBA

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.