SUMMARY

• Around 7 years of IT experience as SQL Server Database Administrator(SSDS).
• Working experience in different industries like Banking, Automobile, Financial and healthcare industries.
• Experience on working with production Servers and 24 x 7 On-Call environments.
• Involved in Migrating the SQL Server 2000 to SQL Server 2005.
• Involved in Migrating the SQL Server 2005 to SQL Server 2008 and 2008 R2.
• Involved in Migrating MYSQL to SQL Server 2008 databases.
• Experience in installing and configuring SQL Server 2008 R2/2008/2005/2000 clusters in Active/Active and Active/Passive.
• Handled very large databases (OLTP) which are in Terra Bytes(TBs).
• Experience with SQL Server 2000, 2005 & 2008 installation, configuration, SSAS, SSIS, SSRS and administration.
• Proficient with SQL Server tools, including Enterprise Manager, Management Studio, Query Analyzer, Profiler, SQL Server Agent, DTS, SSRS and SSIS.
• Experience in Replication – Transactional and Snapshot, troubleshooting the replication issues during any data inconsistency.
• Hands on experience and outstanding knowledge of high availability SQL Server solutions, including SQL Server Logshipping, Mirroring and SQL Server clustering.
• Proficient in SQL programming, physical database design, and SQL Performance tuning, replication.
• Experience in Maintaining SQL Server Security, creation of logins and users, configuring permissions and assigning roles to users.
• Proficient with database backup and recovery models.
• Managed a major Hardware Upgrade / Database Migration.
• Performed Capacity Planning, data modeling and Logical/Physical database Design.
• Created and Maintained Alerts, Notifications, Jobs, Job Steps and Schedules for system errors, insufficient resources, fatal database errors, hardware errors.
• Extensively Monitored Performance with multiple tools like Performance Monitor, SQL Profiler, Event Viewer, Index Tuning Wizard, and Database Tuning Wizard to achieve better performance, Resolve Dead Locks/Long Running Queries, Blocking, accessibility and efficiency.
• Experience in Troubleshooting all database related issues.
• In Depth knowledge in analyzing Query Plans, Extended Stored Procedures and improving efficiency by re-indexing, update statistics, Recompiling stored procedures and capture data using SQL Profiler, Performance Monitor and DBCC Commands.
• Expert in performing backup and restores, setting up log shipping using Quest LiteSpeed.
• Worked on different third party tools like foglight (Qwest), Argent Guardian, Ignite (CONFIO), Spotlight (Qwest), Opalis Robot, SQLDM(IDERA), SQLCM (IDERA).
• Worked on Backup tools BackupExec (Veritas), Commvault (Galaxy), SQLSafe(Idera) & Litespeed (Qwest)

Technical Skills:

Relational Databases(RDBMS): SQL Server 2008R2/2008/2005/2000/7.0, MS Access 2000

Operating Systems : Windows 2008 Server, Windows 2003 Server, Windows NT
4.0, Windows XP
Languages : C, C++, PL/SQL, Java, VB 6.0, VB.Net and T-SQL

EDUCATION: B.Tech in CSIT

MICROSOFT CERTIFICATIONS:

• Microsoft Certified IT Professional (MCITP)- Database Administrator 2008
• Microsoft Certified Technology Specialist (MCTS)- SQL Server 2008,Implementation and Maintenance

Company: Confidential,IL May 2011 to till date
Sr. SQL Server Database Administrator

• Installation of MS SQL Server 2008 R2, 2008 and 2005 on production, Test and Development boxes.
• Experience in installing and configuring SQL Server 2008 R2/2008/2005 clusters in Active/Active mode.
• Involved in Capacity Planning, data modeling and Logical/Physical database Design.
• Involved in upgrades of both Side-by-Side and In-Place from SQL Server 2000 and SQL Server 2005 to 2008 R2/2008.
• Migrated MYSQL databases to SQL Server 2008 databases using SSMA tool.
• Administrating few of MYSQL Servers.
• Involved in upgrading service packs for SQL 2005, 2008 and 2008 R2 to the latest version.
• Migrated SSIS packages from SQL 2005 to SQL 2008 R2 servers.
• Setting up the Transactional Replication in between SQL Server databases and also from SQL Server to Oracle databases.
• Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Involved in General Database Administration, Query Performance tuning, and validated some of the existing schema.
• Created maintenance plan for consistency checks, maintaining indexes and statistics, performing fine Tuning of Database Application, Cleansing and solving Database troubles.
• Daily support, troubleshooting, monitoring, optimization, tuning and blocking of servers and SQL server environments across entire system.
• Involved in working with Redgate tool for SQL compare & SQL Data compare between the databases and tables.
• Having experience in backup tools LiteSpeed and RedGate.
• Interacting with the application team members for scheduling the database migration during the non-production timings.
• Monitoring and Troubleshooting SQL Cluster, Mirroring, Log Shipping.
• Creating the Jobs using maintenance Plans for Full, Differential and transactional log backups.
• Recovered many Databases at the time of Database crashes or data loss.
• Performing SQL Server database performance analysis and ongoing maintenance/tuning to ensure maximum performance.
• Maintaining and Monitoring Production, Pre-Production and Development database server environment.
• Synchronizing Production and UAT environments.
• Involved in all ITIL process like Change management, Incident Management & Problem Management.

Environment: Windows 2008/2003/2000/NT4.0, MS-SQL Server 2008R2/2008/2005/2000, SSIS, SSRS, MYSQL5, System Monitor / Performance Monitor, Idera SQLDB, LiteSpeed.

Client: Confidential,CA Oct’ 2007 to April 2011
SQL Server Database Administrator

Responsibilities:

• Providing 24/7 support for critical production databases of Bank Of America Datacenters
• Providing Primary DBA responsibilities for around 100 applications.
• Installed SQL Server 2005 on hundreds of machines/clusters.
• Installed of MS SQL 2008 on production, Test and Development boxes.
• Working on Projects to provide DBA support for building SQL Servers for new applications ( begin to end support)
• Working with Foglight(Monitoring tool) and Litespeed(Backup tool)
• Administering the MS SQL Server 2008, 2005 & 2000 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.
• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client team, Development team, Capacity planning and upgrading of SQL Servers.
• Performed Physical and Logical Data Modeling for databases of varied sizes including VLDBs.
• Migrating the database from existing 2000 to 2005 servers and from existing 2005 to 20082/2008 servers.
• Involved in General Database Administration, Query Performance tuning,
• Created (with respect to standards) Logins, Users, groups, Roles, Jobs, Alerts, Mails confirmation upon tasks.
• Performed Database consistency checks with DBCC , Defrag, Index tuning and monitored error logs
• Developed few reports using MS SQL Reporting Services.
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Refreshes from Production backup to Stage and Development environments.
• Developed DR plans and automated failsafe backup remediation modules for accurate backup monitoring and reporting / Ad hoc reporting.
• Worked closely with development team for performance enhancements, code reviews and provided vital inputs in terms of index optimization, schema structures, data changes, file layouts etc.
• Extracted data from various sources like SQL Server 2005/2008, Oracle, Teradata, .CSV, Excel and Text file from Client servers and through FTP.
• Working with Techreq Ticktes (Any changes on staging and development environment need to Create Techreq Ticktes)
• Working with Peregrine Change Request(Any changes in Production database need to Create Peregrine Tickets this should be approved by Global DBA team after changes made in stage and development environment)

Environment: Windows 2008/2003/2000/NT4.0, MS-SQL Server 2008R2/2008/2005/2000, SSIS, SSRS, System Monitor / Performance Monitor, Foglight, LiteSpeed.

Company: Confidential,India June’ 06 to Oct 2007
Client: Confidential,
SQL Server Database Administrator

Confidential,is the most recognized and bestselling brand of motocross apparel in the world. Fox built its business by developing clothing for the high intensity, physically demanding motorsport of motocross. Fox has created the best motocross riding apparel in the world, which is able to withstand the elements and the tortuous racing conditions that are a major part of motocross.

Responsibilities:

• Installed and Configured SQL Server 2005 on Cluster (Activie\\Active).
• Supporting Applications with SQL Server 2000 & 2005 Databases across Many Locations all over United States.
• Installation of MS SQL 2005 & 2000 Enterprise servers on production, Test and Development boxes.
• Planned and Successfully Implemented SQL Server 2005 on the Production, Test and Development Servers.
• Successfully Installed the Service Pack 2 and Hot-fix for SQL Server 2005 in all the Dev and Prod Environments.
• Administering the MS SQL Server 2005 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.
• Involved in Migrating the existing 2000 databases to SQL Server 2005 (Side by Side).
• Day-to-day activities like taking backup (or schedule the backups daily for database and transaction log) on disk and restore the databases and transaction log on production/development servers as per requirement.
• Involved in creating Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures.
• Involved in General Database Administration, Query Performance tuning, and validated some of the existing schema.
• Involved in DTS Package, DTS Import/Export for transferring data.
• Involved in implementation of replications like Snapshot and Transactional.
• On call 24/7 support to databases on weekly rotation.
• Created SSIS Packages to migrate the data from database to Text files.
• Generated different reports using MS SQL Reporting Services.

Environment: Windows 2003/2000/NT4.0, MS-SQL Server 2005/2000, SSIS, SSRS, System Monitor / Performance Monitor, DTS, Performance Tuning, Clustering, Argent Guardian, Ignite, Opalis Robot, BackupExec.

Company: Confidential,India June ’05 – May’06
Client: Confidential,
SQL Server DBA
Confidential,has a broad range of products and services that include medical imaging and information technologies, medical diagnostics, patient monitoring systems, performance improvement solutions, drug discovery, and biopharmaceutical manufacturing technologies. These enable healthcare providers to better diagnose and treat cancer, heart disease, neurological diseases, and other conditions earlier. The company\'s vision for the future is to enable a new "early health" model of care focused on earlier diagnosis, pre-symptomatic disease detection and disease prevention.

Responsibilities

• Providing 24/7 On-Call support for critical production databases of GE Health Care and GEASP Datacenters
• Proactive monitoring of production databases
• 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 Windows2000 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