SUMMARY:

• 10+ years of experience in Database Administration and Developer for very large and complex databases in SQL Server 2016, SQL Server 2014, SQL Server 2012, SQL Server 2008 R2, 2008, 2005 and 2000 .
• Experience in Installing, Upgrading and Migrating databases in and from SQL Server 20016\2014\2012\2008R2\2008\2005\2000
• Implemented the mechanisms like backup/ data compressions , online indexing and Always ON .
• Expertise in installing Slipstreams, rolling patches, rolling upgrades in Clustered Environment.
• Good knowledge on new features Query Store, Live Query Statistics, Transparent Data Encryption (TDE).
• Expert in Disaster Recovery plans by configuring Clustering, Log - shipping, Mirroring and Replication (Snapshot and Transactional).
• Handled up to 24 TB databases in Clustered environment with good Physical storage configuration and Optimizing of SAN with different Raid Levels.
• Hands on experience in configuring Clustering in Active-Active and Active-Passive nodes.
• Expertise in automating the system by using System Center Operations Manager (SCOM).
• Experience in configuring Replication and troubleshooting the issues with transactional replication.
• Experience in query optimization and performance tuning. Used SQL Profiler, Execution Plan, Performance Monitor and DBCC Commands.
• Expert in tuning the long running Queries and Store Procedures by examining the execution plans.
• Expertise in using Performance Monitor/Profiler /Activity Monitor to resolve Dead Locks, Long Running Queries and Bottlenecks caused by complex Queries.
• Excellent skills in database Back Up, Restore, Recovery, Updating statistics, Rebuilding and Reorganizing indexes, Replication, Linked Servers and Database Maintenance Plan.
• Created Linked Servers between SQL Servers and also to Oracle Databases.
• Maintained User Permissions, Logins and Security Issues. Monitored Event Viewer’s, SQL Error logs and Log Files Viewer for S/W and H/W errors.
• Expertise in using DMVs and DMFs to finding and solving Performance Issue.
• Hands on experience in Planning and Scheduling Maintenance Tasks and Scheduling Jobs and Alerts using Database Mail.
• Explicitly used third party tools like Lite speed and Fog light.
• Expertise in performance tuning with Ignite tool (database Performance Analyzer).
• Documented Disaster recovery plans and participated in Disaster Recovery Drills by implementing Root Cause Analysis (RCA) for troubleshooting and resolving the issues.
• Involved in Change Control Management Process for maintaining the consistency of databases.
• Expert in creating and debugging Views, Functions, Indexes, Cursors, Store Procedures, Triggers, Optimizing code and improving Efficiency.
• Hands on experience in Batch Processes, Import, Export, Backup, BCP, DTS and SSIS.
• Expert in Creating, Implementing, Configuring and deploying the SSIS Packages from one server to other.
• Expert in migrating the DTS Packages to SSIS Packages by using Package migration Wizard.
• Expert in Deploying, Scheduling and running SSIS jobs by using Proxy Accounts.
• Experience in managing OLAP Database Warehouse by using services like Analysis Services (SSAS), Integration Services (SSIS) and Reporting Services (SSRS).
• Strong ability in Scheduling and deploying reports on Report manger.
• Extensively used repositories like Team Foundation Server (TFS), and Visual Source Safe.
• Good Team player, Strong Communication skills and interpersonal with Self-motivation.
• 24/7 on call production support.

TECHNICAL SKILLS:

RDBMS: MS SQL Server 2016/2014/2012/2008 R2/2005/2000 Oracle 10g/9i, And MS Access 2010/2007/2003.

Languages: T-SQL, C #, Perl, SQL, PL/SQL, XML, HTML, DHTML.

Web Technologies: ASP, ASP.Net, VB.Net, ADO.Net, CSS

GUI & Tools: VB 6.0, Developer 2000, TOAD.

OLAP & ETL tools: SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS)

Operating systems: Windows Server 2003 EE, Windows 2000 Server/Advanced Server and Windows Vista/XP/NT/2000

Data modeling tools: Erwin, MS Visio.

Monitoring Tools: Ignite, Idera, SQL Server Profiler and Performance Monitoring

Version control: MS Team Foundation Server (TFS), VSS, CVS, PVCS, Clear Case

Reporting tools: Business Objects/Crystal Reports, SSRS (Report Builder)

MS-Office: Word, Excel, Access, Outlook, Outlook Express and Power point.

Data migration: DTS, SSIS, BCP, SQL Loader, Import/Export Wizard.

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

Senior SQL Server DBA

Responsibilities:

• Migrated databases from SQL Server 2000 to SQL Server 2005 and R2 and SQL Server .
• Individually developed and implemented database maintenance strategy with code of 2500 line for database Reindex/Reorganize and Update Stats procedure and deployed in production successfully.
• Implemented the disaster recovery models like clustering, mirroring, log shipping and transactional replication.
• Performed Server builds with SQL 2008R 2// 2012/2014/2016.
• Created Maintenance Plans for Regular Backups and Rebuilding of Indexes .
• T uned 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 .
• Configured Always on SQL server 2012/2014/2016.
• Successfully implemented the Capacity planning for different servers.
• Migrated DTS packages to SSIS packages.
• Checked Database Health and consistency by using DBCC Commands and DMVS
• Monitored and modified Performance using execution plans and Index tuning.
• Worked in Active passive cluster environment.
• Recovered the System and User databases from suspect mode.
• Expert in sizing Temp database.
• Used log shipping for synchronization of databases.
• Prepared Documentation for the Disaster Recovery plan
• Wrote and debugged Stored Procedures and (DDL /DML)Triggers, Functions as per client requirements
• Extensively worked on trouble shooting and fine-tuning of databases for its performance
• Designed and implemented comprehensive Backup plan and disaster recovery
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Daily routine Developer/DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Performed Performance Tuning of the Stored Procedures.
• Rebuilding the indexes at regular intervals for better performance
• Managing the backups with lite speed tool and Native SQL.
• Performance tuning done with Ignite tool.
• In-depth knowledge of techniques for analyzing query execution plans and tuning queries and databases for optimal performance
• Scheduled and monitored all maintenance activities including database consistency check, index defragmentation.
• Routine Developer/DBA jobs like Backups and Restores
• Hands on experience in trouble shooting database issues.
• Responsible to Monitor and troubleshooting Log Shipping.
• Performed all basic Database activities like moving databases between servers, copy databases etc.
• Performed Update statistics, database integrity check and Backup operations
• Used SQL server Reporting Services (SSRS) to create reports.
• Monitoring SQL server performance using profiler to find the performance and dead locks.
• Worked on call 24/7 Support on weekly basis.

Environment: MS SQL Server 2016/2014/2012/2008 R2/2005/2000,T-SQL,SSIS, SSAS,BCP, SQL Profiler, Replication, Log shipping, Mirroring, Clustering, SMSQL, Windows XP/2000 and Windows 2003/2008 Server, Lite speed, Ignite

Confidential, Rochester, NY

SQL Server DBA

Responsibilities:

• Installed and configured SQL Server 2008R2 on new Servers, and Installed SQL Server 2008, 2005 and 2000 service packs with latest hot fixes.
• Involved in Implementing 2008, 2008 R2 active-passive clustering on Windows 2008 Operating system with consolidated environment of three SQL server versions 2008/2005 and 2000.
• Involved and set up of SQL Server 2008 Mirroring on production servers.
• Involved in Migration of the Server SQL Server 2000 to 2005, SQL Server and DTS to SSIS, and involved in SAN Migration for the SQL server 2000 and 2008 Servers.
• Maintained servers with multiple instance of SQL Server 2000, 2005 and 2008 with 24 CPU having 100 GB Memory.
• Configured Mirroring with Transaction Replication with principle and mirror at publisher.
• Implemented Snapshot, Transactional, and Performed mirroring as Disaster Recovery Solutions.
• Transactional replication, adding articles, and configuring with Mirroring.
• Involved developing and implementing jobs for SQL server, and involved in various production releases.
• Expert in using and implementing DMV’s, DMF’s, data partitioning, DDL triggers and Online indexing.
• Responsible for transferring packages using SSIS and transferring SQL Server Objects from QA to Production Using SSIS Packages.
• Deployed Reports on Report Server.
• Monitored and modified Performance using execution plans and Index tuning.
• Rebuilding the indexes at regular intervals for better performance.
• Day-to-day activities such as backups to the disk and restore the databases and transaction log on production/development servers as per business / IT needs.
• To setup, implement, and maintain industry standards in database management.
• Monitoring SQL server performance using profiler to find performance and dead locks.
• Integrated SQL traces with Performance Monitor to have better graphical analysis to find system bottlenecks.
• Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Trouble shooting SQL Server 2008, 2005 and 2000 Database connectivity issues from the web applications.
• Planned the Complete backing up of Database and Restoring the Database from Disaster Recovery.
• 24 X 7 Production Database on Call Support

Environment: Microsoft SQL Server 2000 Enterprise Edition on Windows Server 2003 Enterprise Edition, Management Studio, Query Analyzer, BCP, Profiler, T-SQL.

Confidential, Troy, MI

SQL Server DBA

Responsibilities:

• Installed and Upgraded from SQL Server 2005 to SQL server 2008 on Various Production Servers.
• Worked with table partitioning (SQL Server 2008) mechanism to allow the SQL Server engine to escalate locks to the partition level before the table level.
• Worked with Transparent Encryption, table compression, database compression and merge statements using SQL server 2008.
• Extract Transform Load (ETL) development using SQL Server Integration Services (SSIS).
• Used Policy Based Administration feature (SQL Server 2008).
• Worked with 'commands to programmatically INSERT data if it does not exist or UPDATE the data if it does all in 1 set of logic (SQL Server 2008).
• Created new database objects like Tables, Procedures, Functions, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005.
• Setting up and Monitored transactional replication, Database mirroring on Production and QA servers.
• Worked in Active Active Cluster environment as a High availability solution.
• T uning 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.
• Extensively used TSM lite speed backups
• Created complex stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
• Expert in Performance Tuning of the Stored Procedures.
• Checking Database Health by using DBCC Commands and DMVS.
• Prepared Documentation for the Disaster Recovery plan.
• Designed Data Integrator jobs with Error Handling and email notifications.
• Managing Databases spread across multiple servers in Production, Development, staging & testing environments.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• 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.

Environment: MS SQL Server 2008R2/2005/2000, T-SQL, SSIS, Composite Software 5.0.0, Report Builder, Lite Speed, BCP, SQL Profiler, Log Shipping, Replication, Mirroring, Clustering, Windows XP/2000 and Windows 2003 Server.

Confidential, Pittsburgh, PA

SQL Server DBA

Responsibilities:

• SQL Server 2005 Database Administration.
• Performed the migration of SQL Server 2000 to SQL Server 2005 .
• Configured the servers on 32 bit and 64 bit clustered and standalone server environments
• 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.
• 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, 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).
• Used Data Partitioning, Snapshot Isolation in SQL Server 2005.
• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 2.5 TB.
• Expertise in creating and supporting in OLAP Cubes
• Managed VERITAS net backups and Lite speed backups.
• To analyze long running queries and tune the same to optimize application and system performance.
• Maintaining the database consistency with DBCC at regular intervals.

Environment: MS SQL Server 2008 R2/2005/2000, SQL Server BI Suite (SSAS, SSIS, SSRS), Log Shipping, Replication, Clustering, T-SQL, Report Builder, DTS, MySQL, ASP.Net, C#, VSS, ADO.Net, SQL Profiler, OLAP, Windows XP/2000, BCP, Active Directory, Windows 2003 Server.

Confidential, Wilmington, DE

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.
• Installed and Upgraded from SQL Server 2005 to SQL server 2008 on Various Production Servers.
• Migrating Databases from SQL Server 2000, 2005 to SQL Server 2008.
• Worked with table partitioning (SQL Server 2008) mechanism to allow the SQL Server engine to escalate locks to the partition level before the table level.
• Worked in Active, Active Passive Cluster environment as a High availability solution.
• Configured the servers on 32 bit and 64 bit clustered and standalone server environments.
• 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.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Setting up and Monitored transactional replication, Database mirroring on Production and QA servers.
• Monitored and modified Performance using execution plans and Index tuning.
• Recovering the databases from backup in disasters.
• T uning 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.
• Extensively used SMSQL backups.
• Monitoring SQL server performance using profiler to find performance and dead-locks.
• To analyze long running slow queries and tune the same to optimize application and system performance.

Environment: Microsoft SQL Server 2000 Enterprise Edition on Windows Server 2003 Enterprise Edition, Management Studio, Query Analyzer, BCP, Profiler, T-SQL.

Confidential

SQL DBA/SQL Server Developer

Responsibilities:

• Involved in requirement gathering, analysis, design, development, change management, deployment and user training.
• Installed and configured SQL Server 2000 successfully.
• Login and user management: Adding logins, roles, groups to the Window NT and MS SQL Server and maintaining proper security procedure.
• Scheduling Jobs and Alerting using SQL Server Agent
• Created a Baseline for migrating from SQL Server 2000 to SQL Server 2005
• Written stored Procedures, Functions and Database Triggers
• Database creation, database tuning, and Performance planning, backup planning and database administration.
• Implemented Log Shipping
• Proactive and Reactive tuning of databases in every stage of the project
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery
• Creation/Modified complex stored procedures which are used for various reports
• Created/Maintained clustered/non clustered Indexes for fast and efficient reporting process
• Configured SNAPSHOT Replication using Snapshot agent. (Creating Distribution Databases, creating & managing Publications, managing Replication monitors).
• Used Performance Monitor and SQL Profiler to queries and enhance the performance of database servers.

Environment: MS SQL Server 2005/2000, T-SQL, DTS, SSIS, MySQL, VSS, Lite Speed, BCP, SQL Profiler, Windows XP/2000, Active Directory, Windows 2003 Server.