SUMMARY

• 9+ years of IT experience in Database Administration, Design Development and Support of MSSQL Server2012/2008R 2/2008/2005/2000 in Production, Test, Development and ClusterServer Environments.
• Experience in RDBMS database design, performance tuning, optimization, backup and recovery in SQLServer2000 andSQLServer 2005/2008/2012.
• Experience in Disaster Recovery Planning, Execution and Testing at remote side.
• Experience in usingSQLServerTools like DTS, Import/Export Wizard,SQLServerEnterprise Manager,SQL Server Management Studio, SQLProfiler andSQLQuery Analyzer.
• Migration experience from MSSQLServer2000 to MSSQLServer2005/2008, MSSQLServer2005 to MSSQLServer2008 & SQL Server .
• Provided expertise in Data warehouse and Data Marts methodologies as well as extensive noledge of OLTP/OLAP technologies.
• Experience in Database administration activities for DB Security (creating logins, users, roles, and assigning permission to them).
• Master in performing administrative tasks: database files management, backup/restore, security management, Database Mirroring, data integration and synchronization.
• Extensive use of DTS/SSIS inSQLServer, Performance Tuning & Index Tuning, Disaster Recovery Planning, Security Management, Managingserverand clients.
• Good noledge on Advanced features like MSDTC, and Full Text Indexing etc. Experience in implementing high availability using Log shipping, and noledge of DB mirroring in SQLServer.
• Good experience withSQLServer2005/2008 Online Database Indexing and Recovery. Solid experience on high availabilitySQLServersolutions, including Replication Models (Snapshot/Transactional) andSQLServerclustering (Active - Active, Active-Passive).
• Expert in using Bulk Copy Program (BCP), Data Transformation Services (DTS) packages and SSIS (integration services) with MSSQLServer2000/2005.
• Experience in creating SSIS packages. Experience in DTS Migration and Metadata Management: Migrating DTS Packages to SSIS, Package Migration Wizard, and Storage Management.
• Successfully MigratedSQL2000 DTS packages to SSIS using DTS Xchange tool.
• Written Windows batch script to automate jobs.
• Made someserverlevel changes for SSAS project.
• Production Support Experience in Administration of Sybase/MSSQL Servers.
• Experience in using SSIS (SQLServerIntegration Services) for data extraction, transformation and loading across different databases like Oracle, MS Access and flat files using tools like Import and Export Wizard, Package Installation and SSIS Package Designer.
• Used IderaSQLsafe backup which provides a high-performance backup and recovery solution.
• Experience in designing/generating/using/deploying Visual Studio 2005 Business Intelligence Reports,SQLServer2005 Reporting Services (SSRS).
• Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).

TECHNICAL SKILLS

Databases: MS-SQL Server 2005/2008R2, MS Access 2003

Languages: C, C+, VB Script, Windows Batch Script, Java Script, HTML, XML

SQL Server Tools: Management Studio, Enterprise Manager, Index Tuning Wizard, Database Tuning Wizard, Profiler, Query Analyser, Export & Import, Precise i3 for SQL Server

Operating systems: Windows 2008\2003

Software Packages: MS Office 97/2000/XP,2003,2007, MS Outlook 2003,2007,Visio

PROFESSIONAL EXPERIENCE

Confidential, Lincolnshire, IL

Sr. SQL Server DBA

Responsibilities:

• Working with Project teams to identify database changes and modeling initiatives to implement project objectives.
• Implement data models, database structure design, backup and recovery processes.
• Identify, test and resolve complex database issues (e.g., monitoring and tuning).
• Solved Issues related to Orphaned Users and Managed Logins, Users, Roles and User permissions
• Define, recommend and develop database standards, procedures and architecture.
• Provide technical troubleshooting & Support for application and database systems during major and minor incidents.
• Involved in scheduling Jobs, Alerts using SQL Server Agent as required.
• Developed and implemented backup and recovery strategies involving complete database backup/Restore, transaction log backup/restore.
• Worked in Active, Active Passive Cluster environment as a High availability solution.
• Designed and Implemented Disaster Recovery Procedures Log Shipping, Mirroring as well as Backup and Restore Strategies.
• Resolved issues in Mirroring setup.
• Administering Production, Development and UAT databases and provide 24X7 Support for production databases.
• Use FogLight, Spotlight Monitoring Tool, Performance Analyzer, Activity monitor, Perfmon, and SQL profiler tools for Database Monitoring and Tuning.
• Perform database capacity planning, data restore and recovery as required.
• Used SSIS, Import/Export to Copy, move Data from one server to another, Excel to SQL Server
• Received Certificate of excellence and dedication.

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

Confidential, Cincinnati, OH

Sr. SQL Server DBA

Responsibilities:

• Implemented data models, database structure design, backup and recovery processes.
• Configured Change Data Capture in SQL Server 2008 to maintain teh history of teh changes in teh 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.
• Worked on SQL Server 2008 failover clustering which is built on top of a Windows 2003 server cluster.
• Worked on Active/Active and Active/Passive Clustering.
• Involved in creating SQL Login accounts and Users with appropriate permissions on Production and development servers.
• Responsible for verifying all data to be entered into database meets set standards and requirements.
• Involved in creating maintenance plan for consistency checks, maintaining indexes and statistics, performing fine Tuning of Database Application based on standard process.
• Worked on Performance Tuning and Optimization, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Worked on DTS Packages, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Involved in migration of SSIS (2005) packages to SSIS (2008R2) packages.
• Identifies tests and resolves complex database issues (e.g., monitoring and tuning).
• Managed SAP backend SQL Server databases which are in Tera bytes of size.
• Involved in database system management functions (e.g., software installs, version upgrades and configuration management).
• Worked on protocols like Kerberos, TCP/IP and NLTM.
• 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.
• 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, KS

Sr. SQL Server DBA

Responsibilities:

• Installed and Configured SQL Server 2008 R2 Servers.
• Managed 2005 SQL Servers
• Upgraded SQL Server 2000/ R2 using In-place and Side by Side Upgrade in Prod, PPE and lab environments.
• Migrating databases from MSSQLServer2000 to SQLServer2005/2008, MSSQLServer2005 to MSSQLServer2008 & SQL Server .
• Performed troubleshooting of database related issues during upgrading and migration process.
• Solved Issues related to Orphaned Users and Managed Logins, Users, Roles and User permissions.
• Performance tune and Optimize frequently used SQL Queries, Indexes and Stored Procedures.
• Designed and Implemented Disaster Recovery Procedures Log Shipping, Mirroring as well as Backup and Restore Strategies.
• Implemented high availability and disaster recovery using database mirroring with log shipping and Clustering.
• Resolved issues in Mirroring setup.
• Solved backup, copy, restore job failure, space, network, latency Issues related to Log Shipping.
• Handled various issues related to setup and configuration of Database Mirroring, log shipping and replication.
• Implemented Transactional replication to Admin and Report databases and resolved teh issues.
• Solved latency, agent job failure, Synchronization issues related to Replication,
• Involved in scheduling Jobs, Alerts using SQL Server Agent as required.
• Created automation procedure for patching production servers.
• Involved in deploying changes to production and PPE environments.
• Involved in creating and renewal of SSL certificates.
• Developed and implemented backup and recovery strategies involving complete database backup/Restore, transaction log backup/restore.
• Created Sybase tables based on user requirement, creating stored procedure to capture and aggregate data from OLTP system into a staging database and finally copy these data to teh reporting database.
• Create, test, and conduct performance tuning on SQL Server databases using Windows Performance Monitor and SQL Server Profiler and also used Microsoft tools perf insight and perf analyzer.
• Did perform Administrative functions which are Update Statistics, Re-indexing.
• Developed windows batch script to run jobs.
• Involved in solving production issues on web servers and biz talk servers administration.
• Have Knowledge on power shell scripts to automate few tasks on production servers.
• Used SQL Profiler and Database engine tuning advisor for solving Deadlock, Performance Issues.
• Experience in migrating data from Reporting app server to SQL Server.
• Experience in writing Stored Procedures and Views.
• Worked with developers to tune teh SQL queries and improve teh Performance.
• Solved Issues related to Synchronization of Data in Development, Test, Smoke, Production Environments
• Created reports using SSRS, Windows Batch Scripts.
• Used SSIS, Import/Export to Copy, move Data from one server to another, Excel to SQL Server.
• Provided 24 x 7 on call support for all teh SQL application on production server.

Environment: SQL Server 2008 R2 Enterprise Edition with Clustering, OLTP & OLAP environment that includes Production (24x7), Replication, Migration, SSAS, ETL, databases in SQL Server, Microsoft, Windows 2003/ 2008R2 Server, SSIS, SSRS, Erwin, Oracle 11g, Sybase, DB2 UDB

Confidential, KS

Sr. SQL Server DBA

Responsibilities:

• Installing and maintaining SQL Server database systems. Maintaining teh database systems includes but is not limited to ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitor system availability, updating system documentation, system and database recovery, etc.
• Updating database systems by reviewing, planning, testing and installing database security patches and service packs.
• Design, document, and promote security "best practices", policies, standards and protocols.
• Migrating application code and objects from development/test environments to production.
• Working with development and systems teams to perform application and database tuning.
• In conjunction with development teams, define and maintain database and code standards and naming conventions for teh organization to ensure consistency in database and code development.
• Migrating Databases from SQL Server 2005 to SQL Server 2008R2.
• Setup and maintenance of appropriate database and application monitoring.
• Setup, test and maintain business continuity/disaster recovery infrastructure database and applications.
• Providing highly available database and application infrastructure according to Business Continuity requirements using SQL clustering, load-balancing, etc.
• Evaluating data modeling, database administration, and database backup and recovery tools and make recommendations.
• Setting up and Monitoredtransactional replication, Database mirroring on Production and QA servers.
• Extensively involved in teh SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Responsible to Monitor and troubleshooting Log Shipping.
• Review of physical and logical database design; Promote teh reliability of database design by ensuring appropriate referential data integrity is implemented and appropriate data types are used.
• Create processes and procedures for application code and database object migrations to support an efficient and reliable system development lifecycle.
• Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008.
• Worked in Active, Active Passive Cluster environment as a High availability solution.
• Failover cluster testing and resolution on servers as well as monitoring and backup reporting setup with Microsoft Operations Manager and backup teams.
• Tuning queries which are running slow using Profiler and Statistics Io by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Checking Database Health by using DBCC Commands.
• Monitored and modified Performance using execution plans and Index tuning.
• Prepared Documentation for teh Disaster Recovery plan
• Daily routine DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Responsible routine DBA jobs like Backups and Restores.
• Good experience in data modeling and metadata services.

Environment: MS SQL Server 2012/2008R2/2005/2000,T-SQL,SSIS,SSRS, ReportBuilder, Lite Speed, BCP, SQL Profiler, Replication, Log shipping, Mirroring, Clustering, Windows XP/2000 and Windows 2003/2008 Server.

Confidential, OH

SQL Server DBA

Responsibilities:

• Installed SQL Server 2008r2 on Standalone and Clustered Environments.
• Upgraded /Migrated of SQL Server from version .
• Installed Microsoft Service Packs/Patches/Hotfixes.
• Configured and administered SQL Clusters (Active/Passive, Active/Active), Database Mirroring, Replication and Log shipping.
• Conducted Backup & Restore of Databases, Scheduled Maintenance plans to perform regular Backups.
• Performed Attach/ Detach, BCP, Import & Exports and Copy Database Wizard.
• Created Tables, Stored Procedures, Views, Triggers, Cursors and Complex Queries on SQL Server 2005/2008.
• Query Optimization and Performance tuning for optimization like maintaining/creating indexes, Create/Update Statistics, Tuning SQL queries.
• Analyzed Performance using Performance monitor in order to identify teh 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.
• Troubleshooted Memory Errors/Query Processing and usage of Memory and resolving errors pertaining to insufficient Memory.
• Collected data using PSSDIAG, MPS Reports, Profiler to analyze and tune for better optimization.
• Troubleshooted and resolved Blocking, Deadlocks and Long Running Queries.
• Performed Data Transfer/Migration using Export/Import and Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
• Developed, deployed and monitored SSIS Packages including upgrade from DTS to SSIS.
• Created Reports using VB Script, SSRS 2005/2008.
• Utilized DMV’s, Data partitioning and Performance Dashboards reports with SQL Server2005.
• Configured Snapshot, Transactional and Merge Replication of SQL Server databases and Troubleshooted Replication Problems.
• Created and Managed SQL Server Logins and Users as per teh requirement with specific roles and permissions on production servers.
• Created various Jobs, scheduled & ran jobs and troubleshooted teh failed jobs.
• Provide 24X7 support for teh Critical issues like Server Failures and Database inconsistencies like Database Log File full, Suspect, Offline, Missing log files etc.

Environment: Windows 2003, MS SQL Server 2005/2008/2008 r2, T-SQL, Visual Studio.Net 2003, Crystal Reports, LITESPEED, MS Access, DTS, BCP, SSIS, SSAS, SQL Profiler.

Confidential, IL

SQL Server DBA/ Developer

Responsibilities:

• Installation ofSQLServer2005 with latest Service Packs.
• Worked in Active/Passive Clustered Environment.
• Writing stored procedures for report generation in migration process and replication.
• Implemented teh migration ofSQLServer .
• Wrote severalSQLScripts such as finding long running queries, blocking sessions, archiving data from production to archiveserverand populating reporting data.
• Experience in monitoring software tools used to monitor teh environment TEMPeffectively.
• Successfully implemented Database Mirroring inSQLServer2005 for high availability.
• Maintain both DEVELOPMENT and PRODUCTIONserverin sync.
• Involved in Log Shipping.
• Extensively involved in replication and implemented Snapshot, Merge and Transactional Replications.
• Involved in Monitoring Performance of different productionservers.
• Worked in 24x7 production environment.
• Working with teh end user gathering requirements for teh system.
• Disaster Recovery Plan, Testing and analyzing and continuous update of documentation.
• Creating Logins and Roles with appropriate permissions.
• Prepared and documented Backup & Restore Plans.
• Creating and Maintaining Database Maintenance Plans.
• Requirements gathering from teh end-users.
• Extensively involved in designing teh SSIS packages to export data of flat file source toSQLServer database.
• Involved in analyzing teh system for setting up newserverandserverconfiguration.

Environment: Windows 2000/2003server, MSSQLServer2000/2005, Erwin, MS Excel, Dell/EMC CX3/CX Series SAN Arrays.

Confidential

SQL DBA

Responsibilities:

• Created database objects like tables, views, indexes, stored-procedures, triggers, cursors using T-SQL.
• Creation of Jobs Schedules, Alerts usingSQLServerAgent and Notifications usingSQLMail.
• DBAactivities like creating users, roles and granting and revoking privileges and Design and implement database backup and recovery procedures.
• Calculate disk space and table space requirements and Involved in capacity planning, estimating and sizing of tables.
• Migrated data to other databases and Created DTS Packages to import data from Excel spreadsheets and Implementing user training and providing technical support.
• Designed teh logical and physical databases and development ofSQLServerDatabase and Database testing, maintaining teh data and writing teh procedure.

Environment: SQLServer2000/2005 Enterprise Edition, Advanced Windows 2003Server,SQLQuery Analyzer, Enterprise Manager, IBM system x3650