SUMMARY

• Microsoft Certified Professional in Administering SQL Server 2012 and 2014.
• Over 8+ years of experience in database administration, implementation, analysis, modeling, monitoring and performance tuning SQL Servers.
• Proficient in Installing, Configuring, Managing and Troubleshooting SQL Server.
• Expertise in upgrading SQL Server to new versions, applying servicepacks and hotfixes, and unattended Installation.
• Experience in Migration from SQL Server 2005/2000 to SQL Server 2008 and 2012.
• Performed database and instance securityactivities 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, troubleshootingblockings and deadlocks.
• Expertise in query optimization and database consistency checks using DBCC commands.
• Deep Knowledge of using SSISin 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 process and help desk ticketing systems.
• Provided 24x7 on-call support to clients on a rotation basis.

TECHNICAL SKILLS

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

Database Tools: Profiler, Management Studio/Enterprise Manager, Query Analyzer, SSIS, SSRS

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

OLAPTools: SQL Server Reporting Server 2008/2005, SSIS (as ETL)

Third Party Tools: Spotlight and Redgate

PROFESSIONAL EXPERIENCE

Confidential, Allegan, MI

SQL Server DBA

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

Responsibilities:

• Installation and 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.
• Ensuring database systems are up-to date by reviewing, planning, testing, and installing database security patches and service packs.
• Migrationof 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 ofdatabases from SQL Server 20 /2014.
• Setup, test, and maintain Business Continuity Process /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 Process requirements using SQL Clustering, Load-balancing, etc.
• Setting up and monitoring transactional replication, Database mirroring on Production and QA servers.
• Responsible for monitoring and troubleshooting Log Shipping.
• 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.

Confidential, Marina Del Rey, CA

SQL SERVER DBA

Environment: Windows 2003/2007/2008 , SQL Server /2005/2000

Responsibilities:

• Installed SQL Server 2005/2008R2/2012 Servers on windows 2003/7/8/8.1 Platform.
• Created jobs and monitored job history for maximum availability of data and to ensure consistency of the databases.
• Managed database backup and recovery, created database objects including tables, triggers, views, stored procedures, indexes, defaults and rule.
• Optimized quarries 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 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.
• Performed database consistency checks at regular intervals.
• Monitored SQL Server activities through profiler.
• Developed backup & restore scripts for SQL Server as needed.
• Deployed database mirroring and Replication.
• Deployed SSRS packages.
• Monitored server space usage and generate reports.
• Developed standards for SQL Server maintenance/updates.
• Designed and implemented database maintenance plan.
• 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.
• Configured Email notifications for Jobs, Schedules, batches, and alerts.
• Maintained Disaster recovery strategies for the database and fail-over methods.
• Monitor SQL Server log files.

Confidential - Chattanooga,TN

SQL Server DBA

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

Responsibilities:

• Managed the migration of SQL Server 2000 databases to SQL Server 2005/2008.
• Implemented new SQL Server 2005 concepts like Data partitioning, Snapshot isolation.
• Documented the steps to be followed while upgrading the SQL server 2000 to SQL server 2005.
• Installed and Scheduled package execution in SSIS on multiple servers.
• 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.
• Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans.
• Monitored & modified Performance using execution plans and Index tuning.
• Rebuild indexes at regular intervals for better performance.
• Used log shipping for synchronization of databases.
• Worked in Active passive cluster environment.
• Prepared Documentation for the Disaster Recovery plan.
• Wrote and debugged Stored Procedures, (DDL) triggers, and functions as per client requirements.
• Designed and implemented comprehensive Backup plan and disaster recovery.
• 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 , SSISand SSRS.

Responsibilities:

• As a Production and development DBA managed several SQL Servers with size ranging 20 GB to 1 Terabyte in a 24x7 Production environment.
• Installed SQL Server 2008 and SQL Server 2005 on Windows 2003 and 2008 servers, applied service packs and security fixes for all servers.
• Successfully Upgraded most of the SQL Server from SQL 2000/2005SQL Server 2008
• 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.
• 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.

Confidential, Colorado

SQL Server DBA

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

Responsibilities:

• Responsible for the Installation, daily monitoring, maintenance of SQL Server 2005 installations in both the production and development Environments and also upgrades to SQL server 2005.
• Participated in the migration of the databases and managed the location of database files, log files and their sizes.
• Migrated and validated users and logins in the new environment.
• Granted roles and permissions to SQL server users.
• Developed, implemented, and maintained procedures for ensuring security and integrity of SQL Server.
• Created tables, Views, Indexes, Functions, and advanced queries for databases by using SSMS.
• Generated database SQL scripts and deployed databases including installation and configuration.
• Automated and enhanced daily administrative tasks including space management, database backup and recovery.
• Involved in setting up SQL Server Agent Jobs for periodic backups with backup devices, Database maintenance Plans. Configured Database Mirroring.
• Managed the production and development databases for performance tuning, capacity planning and database security configuration.
• 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/200, Create and maintain databases after logical and physical database design.

Responsibilities:

• 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.
• Monitor server space usage and generate reports.
• Developed standards for SQL Server maintenance / updates.
• Performance optimization and normalization of database.
• Job, Scheduling, batch, alert and E-mail notification setting using maintenance plan.