PROFESSIONAL SUMMARY:

• Around 9 years of Experience as Database Administrator in MS SQL Server, Analysis and Support of MS SQL Server 2000/ 2005/20 .
• Experienced in Database Backup/Recovery, Performance tuning, Query Optimization, Disaster Recovery plans and configuring Alerts using SQL Mail.
• Migration from SQL Server & SQL Server and 2014.
• Proficient in SQL programming, Physical Database design, and Replication(Transactional, Merge, Snapshot).
• Experienced in Administering Clustered Environment.
• Used Power Shell scripts for SQL server Maintenance activities.
• Experience in Configuring and Maintenance Database Snapshots.
• Experience in Working with Huge Databases, Troubleshooting issues and documenting the causes.
• Extensive experience and proficiency on the design, construction and implementation of Business Intelligence tools(Star Schema, Data - Warehouses, OLAP cubes) ETL Process (Data Extraction, Transformation layer) with DTS/SSIS, Data Cleansing, MSSQL Databases, Analysis Services(SSAS), Reporting Services (SSRS), Notification Services (SSNS) and MDX ad-hoc Reporting.
• Expertise in Deployments, renewals, process job tickets & bugs.
• Hands on experience in working with system center operations manager(SCOM) 2007 R2.
• Administered and installed multiple VLDB Oracle 9i and 10g databases.
• Strong T-SQL Developer skills including stored procedures, Indexed views, User Defined Functions, Triggers, and Distributed Queries.
• Verifying and tuning stored procedures created by developers by using Execution plans, SQL Server Profiler, Data Tuning Advisor and maintenance tasks.

TECHNICAL SKILLS:

Databases: MS SQL Server 2012, 2008, 2005, 2000, MS Access, MS-Excel

Languages: T-SQL, PL\SQL, C, C++, JAVA

SQL Server DBA Tools: SQL Server Profiler, SQL Server Analysis Services, SSIS Tools, enterprise manager foglight

PROFESSIONAL EXPERIENCE:

Confidential, Detroit, MI

SQL SERVER DBA

Responsibilities:

• Installing and maintaining SQL Server database systems. Maintaining the 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.
• Created/altered/modified and tuned T-SQL Stored Procedures, Complex Queries, views, tables, and functions on OLTP and OLAP environments.
• Design, document, and promote security "best practices" policies, standards and protocols.
• Migrating application code and objects from development/test environments to production.
• Migrating Databases from SQL Server 2008 to SQL Server 2012, 2014
• Setup and maintenance of appropriate database and application monitoring.
• Setup, test and maintain business continuity/disaster recovery infrastructure database and application.
• 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 Monitored transactional replication, Database mirroring on Production server.

Environment: SQL Server 2014/2012/2008, SSIS, SSRS, Visual studio 2010/2008, MS Visio 2007, XML, VB.Net, Report Builder 3.

Confidential, Irving, TX

SQL Server DBA

Responsibilities:

• Installed and Configured Sql Server 2008/2008r2/2012 in multi-server environment.
• Involved in Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 1 Terabytes.
• Conducted Database mirroring in High Performance and High Availability mode and troubleshot issues with witness servers.
• Experienced in performance tuning using windows performance monitor and SQL profiler of SQL server. Used SQL Server error logs and event viewer to troubleshoot issues.
• Experienced Configuring, Managing and troubleshooting on SQL Server connection protocols like Kerberos and NTLM.
• Actively involved in setting up Active-Active/Active-Passive clustering in production and Testing Environments and also troubleshot issues with the same.
• Applied hot fixes and Service Packs in clustering environments.
• Created and maintained various databases for Production, Development and Testing environments using SQL Server 2012, 2008R2, 2005.
• Implemented Kerberos Delegation with SSRS.
• Performed daily backups and developed recovery procedures.
• Involved in the migration of the data across different databases and different servers using SSIS, BCP and Import/export tools.
• Involved in Capacity Planning, data modeling and Logical/Physical database Design.
• Involved in migration of SQL 2005 TO SQL 2008r2.
• Implemented and configured database monitoring tools and focused on providing a high availability database.
• Troubleshot issues with log file full and database size increasing beyond threshold.
• Provided support to the application developers on the application databases.
• Created various multi-dimensional cubes (SSAS), processed facts, dimensions and populated data for front end users.
• Creation of new database, planning the location of data, index, and transaction log files on the disks
• Performed Database consistency checks with DBCC, Defrag, Index tuning and monitored error logs
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Extracted data from various sources like SQL Server 2005/2008/2012, Oracle, Teradata, .CSV, Excel and Text file from Client servers and through FTP.
• Involved in all ITIL process like Change management, Incident Management & Problem Management.
• Developed and deployed stored procedures, created triggers and audits.
• Actively participated in determining the database schemas.
• Proactively monitored, determined and solved issues at SQL/database/server levels.
• Used DBCC commands, Activity Monitor, DMV’s, System Monitor and Sql Profiler to monitor SqlServer Performance issues.
• Managed SSIS packages by Monitoring and Troubleshooting the errors and configuration settings of packages.
• Created Perfmon reports in order to analyze the performance of servers in various environments.
• Worked with a multiple terabyte database applications.
• Involved in deploying patches on all the SQL Servers 2008/2012.

Environment: Windows 2003/2008, MS-SQL Server 2012/2008r2/2005, .NET Framework, Visual Studio, i3 performance toolSSIS and SSRS, Sites Scope monitoring tool, IDERA tool, VMware machines, DMV's, Visual Studio, HTMLXML, XSLT, Oracle 9i/10g.

Confidential, Indiana Polis, INDIANA

SQL Server DBA

Responsibilities:

• Installed and Configured Sql Server 2005/2008 in multi-server environment.
• Managed Daily/Weekly/Monthly database administration functions such as Backup/Recovery, Data Management, Performance Tuning and Monitoring, Data Archival, Update Statistics, Monitoring and Scheduling Jobs and Re-Indexing.
• Created users, roles and profiles and implemented scripts to automate daily DBA activities.
• Involved in upgrade of databases from Sql Server .
• Implemented Backup/Restore procedure using the Maintenance Plans.
• Deployed Microsoft sql server patching and operating system patches in cluster failover servers and standalone servers.
• Used DBCC commands, Activity Monitor, DMV’s, System Monitor and Sql Profiler to monitor Sql
• Server Performance issues.
• 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 the organization to ensure consistency in database and code development.
• Managed SSIS packages by Monitoring and Troubleshooting the errors and configuration settings of packages.
• Created SSIS packages to import and export data from to Sql Server to Access, Text and Excel files and exchange of data between different sources.
• Monitored and Performed ETL operations to support the data loads and transformations using SSIS to the
• Data warehouse Server.

Environment: Windows 2003 Server, SQL Server 2005/2008, SQL Server 2000,T-SQL, PL/SQL, SCOM, Erwin 4.1, JavaScript, MS IIS Server 5.0, SOAP, HTML/DHTML, XML.

Confidential, Santa Clara, CA

SQL Server DBA

Responsibilities:

• Installed and Configured SQL Server 2005, 2008 and Windows Cluster Services.
• Involved in performing database performance and query tuning and data verification.
• 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 Hardware usage and Blocking.
• Involved in developing stored procedures, functions, triggers using T-SQL for mission critical processes
• Involved in monitoring the proper usage of the disk space on the physical drives of the server and provide the management as of utilization.
• Automated various monitoring alerts in order to maintain smooth functioning of the databases in SQL Server 2005/2008.
• Worked with Active/Active and Active/Passive clusters on Windows Server 2003 and Windows Server
• 2008
• Worked with development team in the initial design of the databases for collecting user specifications.
• Created Perfmon reports in order to analyze the performance of servers in various environments.
• Migrated databases from
• Worked with a multiple terabyte database applications.
• Involved in documenting of all the processes.
• Worked with Compressed backup in SQL Server 2008
• Involved in deploying patches on all the SQL Servers 2005/2008.
• Involved on a 24/7 on call production support.

Environment: MS SQL Server 2005/2008, Windows Server 2003/2008, Clusters, Replications, TSQL, Visual Studio.

Confidential

SQL Server DBA

Responsibilities:

• Created, Scheduled and managed all the database maintenance plans using SSIS Packages in all the SQL Servers across the environment
• Involved in the migration of databases from SQL 2000 to SQL 2005
• Maintained Database Security on all the servers.
• Involved in creating and maintaining transactional replication.
• Maintained SQL Servers in an Active/Passive Cluster environment.
• Implemented and maintained all the production servers using an external tool for monitoring called Foglight.
• Involved in gathering requirements and specifications for migrating the SQL Server from
• Involved in maintaining reporting services in SQL Server 2005 in one of the Production Servers.
• Involved in Performance tuning of the databases in SQL Server 2000 and 2005
• Created Logical and Physical databases for various applications
• Involved in creating scheduled full and transactional log backups in all the test and Development environments
• Involved in monitoring the proper usage of the disk space on the physical drives of the server and provide the management as of utilization.
• Involved in creating and deploying SSIS Packages in SQL Server which are developed by the application which will load data in to SQL Server in a regular intervals of time.
• Used DBCC commands to check physical and logical consistency of the databases and to rebuild indexes.
• Worked with various application teams in order to create the applications on SQL Server
• Involved in monitoring the servers in a regular basis in order to check if there are any blocks that are occurring during the processes
• Involved in documenting various activities performed as DBA.

Environment: MS SQL Server 2000/2005, Windows 2000/2003, Foglight, TSQL, Visual Studio.

Confidential

SQL Server DBA/Developer

Responsibilities:

• Created and managed Schema objects such as tables, views, stored procedures and triggers to maintainReferential Integrity.
• Responsible for Database Backups & Restore, Backup Strategies and Scheduling Backups.
• Involved in planning and monitoring Log shipping.
• Created automated DTS packages for the database maintenance plans which are performed through out the production server.
• Running DBCC consistency Checks and fixing data corruption in user databases.
• Generated different reports using MS SQL Reporting Services.
• Implemented and troubleshooting transactional and snapshot replication.
• Monitor database growth activities and troubleshoot transactional log and space issues.
• Created and monitored Database maintenance plans for checking database integrity, data optimization, rebuilding indexes and updating statistics.
• Implemented SQL Login Security for developers and users.
• Monitoring the event logs and server error logs for troubleshooting purposes.

Environment: MS SQL Server 2000, MS Access, Windows 2000, TSQL, SQL Profiler.