SUMMARY

• Over 10 + yearsof IT Experience inSQL Server database admin, System Analysis, Design and Development and Support of Microsoft SQL Server 2012/2008 R /2000 in Development, Test and Production Environments.
• Expertise in Installation, Upgrade, Configuration and Migration of MS SQL Server in clustered and non - clustered environments.
• Experience in installation and working with Windows 2008/2003, Windows Vista, Windows XP and Windows 7 and packages & patches.
• Experience in migration of databases from lower version to the latest versions.
• Hands on Experience in installation of QUEST SQL server performance analyzer and monitoring server and database performance using QUEST.
• Experience in migration of Data from Excel, Flat file, MS Access and Oracle to MS SQL Server by using BCP and DTS utility. Extracting, Transforming and Loading of data using MS SQL Server SSIS and DTS.
• Developed and documented backup, recovery strategies, disaster recovery plans and participated disaster recovery drills for various environment.
• Experience in implementing and monitoring different typesHAandDRscenarios likeReplication, Always ON, log shippingand Configure DatabaseMirroring in Cluster environment on Production, QA and Dev environments.
• Experience in Performance monitoring & Tuning, Query Optimization, Client/Server Connectivity and Database Consistency Checks using DBCC Utilities.
• Good knowledge in Performance tuning using various MS SQL Server Commands and Database Tuning Adviser.
• Experience on identifying different bottlenecks and their mitigation for better performance.
• Experience in using tools like MS SQL Profiler, Windows Performance Monitoring utility and perfmon for monitoring and Tuning MS SQL Server Performance, Quest performance analyzer.
• Design and document Logical and Physical data models using various tools like MS Visio and MS Excel.
• Worked on SAN (EMC, IBM and HP Arrays) for MS SQL Server Databases and good understanding in capacity planning. Comprehensive knowledge in providing suggestions of using best RAID Technologies based on application requirement.
• Security emphasized by creating security model which was structured by windows and/or server authentication modes, logins, roles and appropriate permissions for those accordingly their needs.
• Expert in Database Normalization, De-Normalization, Backup/Restore, Data Import/Export, Troubleshooting, and Objects Creation such as Tables, Views, and User created Data Types, Index Optimization, Stored Procedures, Cursors, Triggers and Partitioning.
• Hands-on working experience with analyzing query plans, using extended Stored Procedures, managing indexes and locks, troubleshooting query performance and MS SQL server bottle necks including Network Traffic, Hardware usage and Blocking and using trace flags.
• Experience in MS SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS).
• Expert in transforming complex business logic into Database design and maintaining it by using SQL tools such as Stored Procedures, User Defined Functions, Views and DTS.
• MonitoringEvent Viewer, SQL Error logsandLog File Viewerfor Software and hardware related errors.
• Experience inmanaging Alerts, Operators and Jobsthrough SQL Server Agent.
• Ability to gather business and technical requirements from both formal and informal sessions, documented As Is and To Be Processes and prepared Business Workflow Models
• Moderate knowledge in Risk Identification, Risk Analysis, Risk Management. Derived and documented the root cause analysis for production issues
• Flexible, Enthusiastic and Project oriented Team player with solid communication and leadership skills to lead tasks to meet the SLA and beyond that to develop creative business continuity solutions.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2000\2005\2008\2012, MS Access.

Tools: Source Gear - Vault, ca spectrum, ca Harvest.

Primary Skills: Database Administration, Development & MaintenanceDesigning SSIS Packages, SSRS.

Operating Systems: Windows 2000, Windows 2003\2008R2 Server, Windows XP

Languages: C, T-SQL

Tools: for SQL server: SQL LiteSpeed and QUEST Performance Analyzer, SQL OptimizerPerfmon.

Microsoft Development Tools: SQL Query Analyzer, DTS, SQL Profiler, BIDS, DTA, BCPSQL Server Management Studio, SSRS, Import/Export Wizard.

PROFESSIONAL EXPERIENCE

Confidential, Carmel, IN

MS SQL Server DBA \ Developer

Environment: SQL Server 2012\2008R2\2005, Widows Server 2003\2008R2QUEST Performance analyzer, QUEST SQL Optimizer, SQL Litespeed.

Responsibilities:

• Involved in installing SQL Server 2008R2/2012 on Development, Production and UAT environments.
• Installation and configuration of Cluster SQL Server in Active/Passive and Active/Active nodes in MS SQL Server 2008R2.
• Involved in database migration from SQL Server R R2 and 2008R2 to 2012.
• Involved in migration of DTS packages to SSIS, and provided support to the development team in resolving the issues during migration.
• Planning and installation of Quest performance analyzer across all the production and development environments.
• Creating and maintaining various databases on production/development servers and provide 24x7 support
• Involved in migrating SQL Server Databases from Development to Production Server.
• Configured Log shipping from Production to Disaster Recovery server as part of the disaster recovery plan.
• Involved in development of automated daily, weekly and monthly system maintenance tasks such as database backup, integrity verification and replication verification and indexing updates.
• Involved in designing and creating Databases, Tables, Views, Stored Procedures and Triggers.
• Identified, tested and resolved database performance issues to ensure data optimization.
• Used tools like SQL Server profiler, Performance Monitor to identify bottlenecks.
• Implementation of system wide security policies and trouble shooting.
• Troubleshooting high availability and disaster recovery scenarios involving Clustering, Database Mirroring, Log Shipping and Replication.
• Deployed and scheduled SSIS packages.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Maintained security policies. Managed Logins and User: adding logins roles, groups to the Windows Server and MS SQL Server and maintaining proper security procedures.
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environments.
• Tuning queries which are running slow using Profiler, Perfmon and Statistics IO by using different Methods in terms of evaluating joins, indexes, updating Statistics and code modifications.
• Expert in Performance Tuning of the Stored Procedures.
• Checking Database Health by using DBCC Commands and DMVS
• Monitored and modified Performance using execution plans and Index tuning.
• Experience in Database security and integrity planning
• Prepared Documentation for theDisaster Recovery plan
• Designed Data Integrator jobs with Error Handling and email notifications.
• Managing Databases spread across multiple servers in Production, Development, staging & testing environments.
• 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.
• Routine DBA jobs like Backups and Restores.

Confidential

MS SQL Server DBA\Developer

Environment: SQL Server 2000/2005/2008 R2, Windows server 2000/2003/2008 R2.

Responsibilities:

• Installation of SQL server 2000, 2005 and 2008R2 across all tiers.
• Performed the migration of SQL Server 2000 to SQL Server 2005 and .
• Verify, maintain & troubleshoot database backups, integrity checks, and scheduled jobs.
• Troubleshoot and monitor SQL performance issues.
• Created stored procedures, scripts, cursors for the Bulk application, tested them on the test servers and moved them to production.
• Developed SSIS packages to extract, transform and load data into the destination MS SQL database from Excel\Access\SQL databases. Also, created the T-SQL stored procedures/functions to process the data and populate them in to appropriate destination tables.
• Assist developers on database related issues. Implement the changes required by development teams as well as resolve production data issues.
• Installed and maintained 2-Node (Active-Active) Clustering as a High availability solution.
• Responsible to Monitor and troubleshooting Log Shipping.
• Involved in Source Data Analysis, analysis and designing mappings for data extraction also responsible for Design and Development of SSIS Packages to load the Data from various Databases and Files.
• Implemented and maintained Database mirroring as a Disaster Recovery Solution.
• Setting up and Monitored transactional replication, Database mirroring on Production and QA servers.
• Experience in trouble shooting Client connections, viewing error logs and application logs.
• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler,Perfmon, SQL Server Agent, and Database Engine Tuning Advisor.
• Responsible for monitoring and making recommendations for performance improvement in hosted databases. This involved index creation, index removal, index modification, file group modifications, and adding scheduled jobs to re-index and update statistics in databases.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Experience in implementing and maintaining new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Analyze long running queries and tune the same to optimize application and system performance.
• Maintaining the database consistency with DBCC at regular intervals.

Confidential

MS SQL Server DBA

Environment: SQL Server 2000/2005, Windows server 2000/2003.

Responsibilities:

• Installation, configuration and upgrading of Microsoft SQL Server software and related products.
• Perform Back-ups, Restores, Scheduling, Maintenance and Disaster Recovery planning for SQL.
• Maintenance of different application databases, to avoid blockings and improve the performance.
• Import and Export data using DTS.
• Applying software upgrades and patches
• Retrieving data from SQL Server 2000 for various purposes and creating stored procedures etc.
• Responsible for space allocation, backup strategies, table maintenance
• Maintained scripts for monitoring the database thresholds and backup success.
• Implement and maintain database security (create and maintain users and roles, assign privileges).
• Performance monitoring.