SUMMARY

• Microsoft Certified Professional in Administering SQL Server 2012 and 2014.
• Over 7 years of experience in database administration, implementation, analysis, modeling, monitoring and performance tuning SQL Servers.
• Expert in installing, configuring, managing, monitoring and troubleshooting SQL Server 2000/2005/2008/2008 R2/2012/2014 on production boxes and virtualized environment using VMWARE / Hyper - V.
• Experience in Migration from SQL Server 2005/2000 to SQL Server 2008, 2012 and 2014.
• Performed database and instance security activities like creating user login with appropriate role, monitoring the user accounts granting login privileges, creating groups and granting database application roles to users for groups.
• Hands-on experience with analyzing query plans, using extended Stored Procedures, troubleshooting blockings and deadlocks.
• Expertise in query optimization and database consistency checks using DBCC commands.
• Deep Knowledge of using SSIS/SSRS in ETL (Extract Transform Load) development.
• Expert in performing root cause analysis and using SQL Profiler for troubleshooting.
• Highly proficient in implementing efficient Disaster prevention and Recovery Strategies and High availability features such as: Always On, Database Mirroring, Database Backup and Restore, Database Replication, Log shipping, and Clustering (Active/Passive).
• Worked on several server and data center consolidation projects.
• Worked with several groups in implementing and managing database projects.
• Experience with change management, help desk ticketing, QA and other compliance processes
• Provided 24x7 on-call support to clients on a rotation basis.

TECHNICAL SKILLS

Operating Systems: Windows Server 2012/2008/2003/2000 , Advanced Server, XP/Vista/7/8,8.1

Database Tools: SQL Profiler, Management Studio/Enterprise Manager, Query Analyzer, SSIS, SSRS, Data Transformation Services (DTS), Performance Monitor, Bulk Insert and BCP

Databases: SQL Server 2014/2012/2008 R 2/ 2008/2005/2000

OLAP Tools: SQL Server Reporting Server 2008/2005, SSAS, SSIS (as ETL)

Languages: SQL, T-SQL

Third Party Tools: Redgate, Idera, Foglight

PROFESSIONAL EXPERIENCE

Confidential, Allegan, MI

SQL Server DBA

Environment: Windows 2007, Windows server 2008, 2012, MS SQL Server 2014/2, VMware, ERwin

Responsibilities:

• Installation, maintenance of SQL Server database systems. Maintaining the database systems includes ensuring successful backups, resolving system issues, opening cases with technical support to resolve issues, monitoring success and failure of automated jobs, monitoring system availabilities, updating system documentation, system and database recovery, etc.
• Create and document SQL Server policies, procedures, database standards and service level agreements.
• Involved in database/infrastructure physical design, database upgrades and applied software patches to the databases as per application/client requirements.
• Involved in Data mapping, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data within the legacy database.
• Migration of application code and objects from development/test environments to production.
• Working with development teams to perform application and database tuning.
• Defining and maintaining database and code standards and naming conventions for the organization to ensure consistency in database and code development.
• Migration of databases from SQL Server 20 /2014.
• Migrated 600+ databases with mission critical data from Chicago, IL data center to Dallas, TX.
• Set up, test, and maintain business continuity/disaster recovery infrastructure for databases and applications including documentation of Disaster Recovery Plan (DRP).
• Providing highly available database and application infrastructure according to business continuity requirements using SQL Clustering, Load-balancing, etc.
• Setting up and monitoring transactional replication, Database mirroring on Production and QA servers.
• Creating processes and procedures for application code and database object migrations to support an efficient and reliable system development lifecycle (SDLC).
• Extract Transform Load (ETL) deployment using SQL Server Integration Services (SSIS).
• Creating new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment.
• Tuning queries which are running slow using Profiler and Statistics by using different methods in terms of evaluating joins, indexes, updating statistics and code modifications.
• Checking Database Health by using DBCC commands and DMVs.
• Daily routine Database Administrator (DBA) tasks like handling user's permissions and space issues on production and semi-production Servers and handling maintenance Jobs.
• Monitoring & troubleshooting database performance using various third party tools.

Confidential - Chattanooga, TN

SQL Server DBA

Environment: Windows 2003/2007/2008 , SQL Server /2005/2000, T-SQL, Replication, SSIS, SSRS, LiteSpeed, BMC (Ticketing).

Responsibilities:

• Installed SQL Server 2005/2008R2/2012 Servers on windows 2003/7/8 Platform.
• Managed the migration of SQL Server 2000/2005 databases to SQL Server 2008/2012
• Extensively worked on SSIS for data manipulation and data extraction, ETL Load.
• Created extensive reports using SSRS (Tabular, Matrix).
• Installed, configured and maintained SQL Fail over clustering to provide server level high availability solution for different environments.
• Monitored & modified Performance using execution plans and Index tuning.
• Rebuild indexes at regular intervals for better performance.
• Worked in Active passive cluster environment.
• Designed and implemented comprehensive Backup plan and disaster recovery. Prepared Documentation for the Disaster Recovery plan.
• Deployed database mirroring and Replication.
• Developed and deployed DTS, SSIS packages to transform data from Excel file to SQL Server database.
• Creating complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and statements for applications by using T-SQL.
• Optimized queries which includes: performance tuning, query tuning, and index tuning using DBCC commands, Wizards and SQL Profiler.
• Granted database access privileges for different users and user groups.
• Developed backup & restore scripts for SQL Server as needed.
• Deployed SSRS packages.
• Monitored server space usage and generated reports.
• Configuring SQL agent, Email notifications for Jobs, Schedules, batches, and alerts.
• Handled monthly database refresh in QA-Test environment for testing of new deployments and build.
• Evaluated data modeling, database administration, and database backup and recovery tools and made recommendations.
• Developed standards for SQL Server maintenance/updates.
• Monitored SQL Server activities through profiler and third party tools.
• Worked on call 24/7 Support on weekly basis.

Confidential, Bedminster, NJ

SQL Server DBA

Environment: SQL Server 2008/2005/2000 , Windows server 2000/2003/2008 , SSIS, SSRS, VW Ware

Responsibilities:

• As a Production and development DBA managed several SQL Servers with size ranging 20 GB to 1 Terabyte in a 24x7 Production environment.
• Successfully Upgraded most of SQL Server from SQL 2000/2005 to SQL Server 2008/2008R2
• Installed SQL Server 2008 and SQL Server 2005 on windows 2003 and 2008 servers on VIRTUAL Servers, applied service packs and security fixes for all servers.
• Extensively used VMware for Virtual environment.
• Configured and maintained Log shipping architecture to provide backup server solution.
• Installed, configured, and maintained SQL Fail over clustering to provide server high availability solution for six different environments.
• Implemented new SQL Server 2005 concepts like Data partitioning, Snapshot isolation.
• Created DTS and SSIS packages to Extract and Load data on SQL Server from diverse source (flat file, excel, xml and oracle)
• Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in SSIS
• Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS
• Involved in securing the SQL Server environment and setting up the user permissions.
• Created the backup schedule for production, test and development servers.
• Involved in restore operations to refresh the data from production to test servers.
• Monitored database status including CPU, memory, I/O, space, and deadlocks using SQL Server utilities.
• Performed Root cause analysis to track down problems and used SQL profiler for troubleshooting.

Confidential

SQL Server DBA/Developer

Environment: SQL Server 7.0/2000/2005 , Windows 2000/2005

Responsibilities:

• Created and maintained databases after logical and physical database design.
• Installed multi instances of SQL Server 2005 and service packs for existing 7.0/2000 servers.
• Implemented database backup and disaster recovery plans, create database objects including tables, triggers, views, stored procedures and indexes.
• Granted database access privileges for different users and user groups.
• Maintenance of clustered and non-clustered indexes. Created jobs and monitored job history for maximum availability of data and to ensure consistency of the databases.
• Deployed SSIS and SSRS Packages to transform data from excel file to SQL Server database.
• Perform database consistency checks at regular intervals.
• Monitoring server space usage and generating reports.
• Developed standards for SQL Server maintenance / updates.
• Performance optimization and normalization of databases.
• Job, Scheduling, batch, alerts and E-mail notification setting using maintenance plan.