SUMMARY

• Almost 8 years of IT experience in SQL SERVER Database Development, System Analysis, Design, and Administration & Support in Production, QA, Replication and Cluster Server Environments.
• Experience in installation and configuration of MS SQL Server 2012/2008 R2/2005 versions.
• Experience in Migration from SQL Server 2000 to SQL Server 2005/2008 R2 as well as DTS Exchange tool for migrating DTS packages to SSIS packages.
• Experience in up gradation/Migration of MS SQL Server 6.5/7.0 to MS SQL Server 2000 and now and 2008 by in place upgrade process and Side by Side process
• Experience inmigration of Data from Excel, Flat file, Oracle to MS SQL Server by using BCP and DTS utility. Extracting, Transforming and loading of data using SQL Server DTS.
• Experience in IIS, MTS, and Windows NT administration.
• Experience with upgrades and service pack installations Tuning and normalization.
• Expertise in planning and implementing MS SQL server security and database permissions
• Experience in Database Backup, Recovery and Disaster Recovery procedures.
• Extensive experience with Storage Capacity planning, including system storage allocation, on - going capacity analysis and planning future storage requirements.
• Hands on experience and outstanding knowledge in high availability solutions, including SQL Server Always on, Clustering, Replication and Log shipping.
• Managed the multiple databases (DB) under clustered (active/active, active/passive) and implementing RAID technology.
• High level proficiency with various types of Replication Models such as Snapshot, Transactional and Merge Replication (Planning, Replication Tools, Implementing Replication).
• Extensive knowledge of Relational Database Management Systems.
• Experience in Extraction Transformations and Loading (ETL) tools like Data Transformation Services (DTS), Bulk Insert, and BCP for OLTP and DSS (Data Mart/Data Warehouse) environment.
• Proficient in monitoring SQL Server Performance using SQL Profiler (Dead Locks/Long running queries), Query Analyzer, Index Tuning Wizard, Database Engine Tuning Wizard and Windows Performance Monitor.
• Good experience in monitoring Windows and SQL Server error logs.
• Experiences in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC, resolve Dead Locks/Long running queries.
• Design entity relationship diagrams and dimensional data models.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• In depth knowledge of developing complex stored procedures, views, efficient triggers, required functions, and creating indexes and indexed views using SSMS and SQLCMD.
• Proficiency in web-tier development using HTML -proficiency in middle-tier and back-end programming using SQL.
• Created and managed schema objects such as tables, views, clusters, indexes, procedures and triggers through query analyzer
• Experience in implementing business logic using Triggers, Views and Stored procedures.
• Managed day-to-day User activities like creating logins, granting permissions, applying security for new users and creating user Roles and Role Members to ensure Security.
• Supported the deployment of SQL Server 2005/2008 and SSIS (Integration Service for ETL activities).
• Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Log Shipping, DTS, Bulk Insert and BCP.
• Created DTS and SSIS Package designs for Import/Export from accesses, oracle to SQL Server.
• Self-motivated and Flexible to adapt to any new environment and work on any project.
• Worked as a team member to provide 24x7 on-call production database support.

TECHNICAL SKILLS

RDBMS: MS SQL Server 2000/20 R2 and 2012, MS Access, Oracle 10g/9i, SQL Azure

Database Technologies/Tools: SQL Management Studio, BIDS, T-SQL, SQL Profiler, Crystal Reports 9.0/10, SSIS (ETL), SSRS, SSAS

Programming Languages: SQL, PL/SQL, TSQL, C, C++, VB.Net

Scripts: JavaScript, VBScript, Power Shell, HTML, XML

Tuning Tools: Perfmon, SQL Profiler, Dell Quest and Foglight

Operating Systems: Windows Server 2003/2008/2012 , Linux

Web/App servers: IIS 5.0/6.0/7.0, Hyper-V, Share point

Backup Tools: Symantec NetBackup and LiteSpeed.

PROFESSIONAL EXPERIENCE

Confidential, Redmond, WA

Responsibilities:

• Managed and Administrated the SQL Server 2008 and 2012 production and Non-production servers.
• Installation of SQL Server 2012 on Windows Server Clustered environment.
• Prepared maintained and modified SQL server installation and configuration documents.
• Migrating SQL Server 2008 databases to SQL server 2012 databases
• Maintenance of database security by creating groups and logins and providing the necessary permission to the end users.
• MonitoredDB Mirroring/ Transactional Replicationand trouble shooting of errors.
• Subscribe SQL Server Azure Cloud Services.
• Create Database(s) on SQL AZURE.
• Create, manage SQL Server AZURE Databases
• Performing Database backups using PowerShell.
• Checking the status of the services on remote server using PowerShell.
• Finding out the list of DB’s using PowerShell.
• Optimized the query performance with modification inTSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins,creating usefulclustered indexandnon-clustered indexes.
• Performed backups and restoration when necessary. Testing the backup and restoration plans.
• Performed backup using backup compression and Data compression in SQL Server 2008 on clustered environment.
• CreatedDatabase Maintenance Plansfor the performance of SQL Server which coversDatabase Integrity checks, update database Statistics and Re-indexing.
• To set upSQL Server configuration settingsto resolve various resource allocation & memory issues for SQL Server databases and to setupideal memory, min/max server options.
• Handled numerous change management requests on production servers
• Supported24 X 7 Production environment

Confidential, Hoboken, NJ

SQL Server DBA

Responsibilities:

• Installation ofSQL Server 2012/08onStandalone and Windows Server Clustered environment.
• Prepared, maintained and modified SQL server installation and configuration documents.
• Upgraded/Migrated SQL Server 2005/2000 databasestoSQL Server 2008 databases.
• Perform capacity planning and/or management on system and database resources based on current applications and utilization rate.
• Provide Support to DR setup and testing.
• Experience in setting up the SQL Server Always on for high availability for Lab systems.
• Setting up and Monitored transactional replication, Database mirroring on Production, QA and Dev servers.
• CreatedSSIS packagesto load robust data from differentHeterogeneous data sourceslikeAccess, Excel to SQL server.
• CreatedDatabase Maintenance Plansfor the performance of SQL Server which coversDatabase Integrity checks, update database Statistics and Re-indexing.
• Used SQL Server profiler to troubleshoot the performance issue or monitoring a server in real time.
• Managed Security using SQL Logins, Roles and Security Modes for various users.
• Responsible for monitoring and makingrecommendationsforperformance improvementin hosted databases. dis involvedindex creation, index removal, index modification, file group modifications, and addingscheduled jobstore-indexandupdate statisticsin databases.
• Optimized the query performance with modification inTSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins,creating usefulclustered indexandnon-clustered indexes.
• Performed backups and restoration when necessary. Testing the backup and restoration plans.
• Performed backup using backup compression and Data compression in SQL Server 2008 on clustered environment.
• Involved in implementing the security patches to the database servers in order to main the appropriate security measures.
• Handled numerous change management requests on production servers.
• Provided 24/7 support in weekdays and weekends.

Confidential, Vienna, VA

SQL Server DBA

Responsibilities:

• Administered the SQL server 2012 by creating user logins, dropping and locking the logins, monitoring the user accounts, creating groups, granting privileges to users and groups.
• Plan, design, and implement application database code objects, such as stored procedures and views.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Involved in the Backup of the databases.
• Development of automated daily, weekly and monthly system maintenance tasks such as database upgrading and indexing updates and apply in development and Testing Environment.
• Involved in SQL server Cluster and Database Mirroring implementation.
• Involved in general Database administration, query performance tuning and validated some of the existing schemas.
• Deployed and monitoredthe snapshot and transactional replication on the testing and development servers.
• Refresh the database from production to development and staging environment on daily basis.
• Created permanent tables, temporary tables and table variables.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Using Activity Monitor to identify and resolve Blocking and Deadlock issues.
• Worked on SSRS to generate drill-down, drill-through and ad-hoc reports.
• Work with business stakeholders, application developers, and production teams and across functional units to identify business needs and discuss solution options.
• Experience with dropping and recreate the tables for the damaged databases to avoid data loss.
• Conducted design reviews with users/team for development and production strategies.

Environment: MS SQL Server 2008/20012, T-SQL, SQL Profiler, DTS, XML, MS Office, Windows 2000/2003 and SSRS.

Confidential, Columbus, OH

SQL Server DBA\Developer

Responsibilities:

• Migrated Databases, DTS packages, from MS Access to SQL Server 2008.
• Involved in creating Schemas, Logins, Tables, Views, Functions and Stored Procedures.
• Involved in general Database administration, query performance tuning and validated some of the existing schemas
• Administered databases in Prod, Qual, Test and Development regions.
• Administered the SQL server 2000/20 by creating user logins, dropping and locking the logins, monitoring the user accounts, creating groups, granting privileges to users and groups.
• User management by assigning appropriate permissions to the database users.
• Monitored, Scheduled jobs and alerts and did troubleshooting when failed on daily basis.
• Expertise in Setting up database backup and recovery procedures for production, QA and development servers
• Implemented different types of Replication Models such as Transaction, Snapshot and Merge replication in SQL Server 2000 and SQL Server 2005 in OLTP Environments.
• Involved in setting up, managing and maintaining Log shipping and Database Mirroring.
• Development of automated daily, weekly and monthly system maintenance tasks such as database backup, replication verification and indexing updates and apply in development and Testing Environment.
• Experience with Dropping and recreate the tables for the damaged databases to avoid data loss.
• Refresh the database from production to development and staging environment on daily basis.
• Developed physical data models for database schema and objects.
• Responsible for developing, monitoring and deploying SSIS packages.
• Loaded data from various sources like excel files, to SQL Server database Using SSIS Package.
• Created permanent tables, temporary tables and table variables.
• Conducted design reviews with users/team for development and production strategies.
• Working with the Access database users in fixing the issues for day to day operations.
• Prepared the Flow diagrams by using MS Visio to indicate the dataflow between the tables in MS Access and SQL server databases.

Environment: MS SQL Server 2005/2008, SSIS, Active / Passive, T-SQL, DTS, XML, MS Office and Crystal Reports 9.0.

Confidential, St Louis, MO

SQL Server DBA

Responsibilities:

• Managed and Administrated theSQL Server 2008/2005/2000 production and Non-production servers.
• Installation ofSQL Server 2008/05onWindows Server Clustered environment.
• Prepared maintained and modified SQL server installation and configuration documents
• Upgraded/Migrated SQL Server 2005/2000 databasestoSQL Server 2008 databasesand mentored Jr.DBAs and other technical staff.
• Migrated SQL Server 2000 databasestoSQL Server 2005 databasesincludingDTS to SSIS packages.
• Performedbackup using backup compression and Data compression in SQL Server 2008 on clustered environment
• Handled upto 2.5 TB Size databases with clustered environment.
• Application support for front end feeds.
• Good knowledge in developing and designing reports throughSSRSandExcel.
• Setting up and Monitoredtransactional replication, Database mirroring on Production, QA and Dev servers.
• MonitoredDB Mirroring/ Transactional Replicationand trouble shooting of errors.
• Involved in developing Cubes in Business Intelligence Development Studio using SSAS.
• Managed Security usingSQL Logins, Roles and Security Modesfor various users.
• Optimized the query performance with modification inTSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins,creating usefulclustered indexandnon-clustered indexes.
• Developed and created the new database objects including tables,views, index, stored procedures and functions, advanced queriesand also updated statistics using Query Analyzer and Enterprise Manager on the existing servers.
• Analyze execution plans and generate suggestions for improvement.
• To set upSQL Server configuration settingsto resolve various resource allocation & memory issues for SQL Server databases and to setupideal memory, min/max server options.
• Configureddata partitioning/table partitioningon huge tables containing millions of rows for better performance.
• Monitoring SQL Server logs to ensure whether thebackup operations,batch commands, scriptshave completed successfully.
• Handled numerous change management requests on production servers
• Designed and developedSSIS packages using different control flow tasks, Transformations and dataflow tasks.
• CreatedSSIS packagesto load robust data from differentHeterogeneous data sourceslikeOracle, DB2 to SQL server.
• Created, scheduleddatabase maintenance planusingSSIS Maintenance plan task.
• Configured and deployedSSIS PackagesfromTest to Production Environments.
• Created, deployed and managed reports usingSQL Server Reporting Services(SSRS)
• UsedOnline Indexingandonline RestoringinSQL 2005.
• Extensively used Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas
• Supported24 X 7 Production environment

Environment: SQL Server 2000/2005/2008 (Enterprise Manager, Query Analyzer, SQL Profiler, Index Tuning Wizard, Data Transformation Services (DTS), MSSQL Server2000 Analysis Server)

Confidential, CA

SQL Server DBA\Developer

Responsibilities:

• Prepared maintained and modified SQL server installation and configuration documents.
• Installation ofSQL Server 2008 onWindows Server Clustered environment.
• Managed and Administrated theSQL Server 2008/2005 production servers.
• Handled upto 2.2 TB Size databases with clustered environment.
• Data Migration from Legacy system to SQL Server 2008 using SSIS packages
• Upgraded/Migrated SQL Server 2005 databasestoSQL Server 2008 databasesand mentored other technical staff.
• Performedbackup using backup compression and Data compression in SQL Server 2008 on clustered environment.
• Created complex SSAS cubes with multiple fact measure groups and multiple dimension hierarchies based on the OLAP Reporting needs.
• ResolvedApplication connectivity issues like connection timeouts, connection pooling issues and memory leaks.
• Monitoredtransactional replication on Production, UAT, QA and Dev servers.
• Used SQL Server 2008 Activity Monitor When troubleshooting a performance issue or monitoring a server in real time.
• Implemented new features inSQL 2008likePolicy based Management, Table Compression & backup compression, SQL Server Auditing, Resource GovernorandMERGE statement inT-SQL.
• Created SQL Server Audits in developing a risk mitigation plan to keep the environment secure.
• Designed a centralized data repository for storing performance data called management data warehouse and used the fully extensible performance data collection and warehouse tool the ‘data collector’.
• Responsible for monitoring and makingrecommendationsforperformance improvementin hosted databases. dis involvedindex creation, index removal, index modification, file group modifications, and addingscheduled jobstore-indexandupdate statisticsin databases.
• CreatedDatabase Maintenance Plansfor the performance of SQL Server which coversDatabase Integrity checks, update database Statistics and Re-indexing.
• Managed Security usingSQL Logins, Roles and Security Modesfor various users.
• Optimized the query performance with modification inTSQL queries, removing unnecessary columns, eliminating redundant and inconsistent data, normalizing database, establishing necessary joins,creating usefulclustered indexandnon-clustered indexes.
• Handled numerous change management requests on production and UAT servers
• Maintaining the databaseconsistencywithDBCCutility at regular intervals.
• Provided documentation for SQL configuration, and Performance measures.
• Designed Daily, Weekly and Monthly checklists for the database and server
• Developed and created the new database objects including tables,views, index, stored procedures and functions, advanced queries.
• Extensively used Red Gate SQL Compare and Data Compare tools to compare and synchronize SQL Database Schemas
• Involved in SourceData Analysis, analysis and designing mappings for data extraction
• Created, deployed and managed reports usingSQL Server Reporting Services(SSRS)
• Created and managed financial reports using SSRS
• Evaluated data storage considerations to store databases andtransaction logs.
• Review of Technical and Functional High Level Documents (HLDs).
• Developing Test cases for the Interfaces.
• Involved in Batch Processes

Environment: SQL Server 2008/2005 (SSMS, SQL Profiler, Index Tuning Wizard, Data Transformation Services (DTS), SSRS, SSIS), Snap Manager for SQL

Confidential

SQL Server DBA\Developer

Responsibilities:

• Installation and Configuring the MS SQL Server 2005.
• Involved in designing the data model for a normalized database.
• Designed database for implementing “Notification Services” in SQL Server 2005.
• Involved in Data Integration by identifying the information needs within and across functional areas of an enterprise database upgrade and scripting/data Migration with SQL server Export Utility.
• Involved in performing Extraction, Transformation and Loading using DTS.
• Developed all the required stored procedures, user defined functions, triggers using T-SQL.
• Involved in creating normalized Databases, creating objects, sizing temp databases.
• Designing, programming and managing data interfaces, data validation and providing with data modeling.
• Experience in performance tuning, backup and disaster recovery processes and tools.
• Performance and tuning of SQL servers and application issues related to migration.
• Testing of applications for performance, data integrity and validation issues.
• Data Transfers between various servers using BCP.
• Assisting developers with code enhancements, indexing the tables properly.
• Writing the stored procedures, checking the code for efficiency.
• Database monitoring using system tools.
• Administrative and Production support for various applications in all environments.
• Database Backup Procedures, Restoration Procedures, Disaster Recovery procedures, and Contingency plans. Testing and implementing these procedures.
• Routine backups and restoration when necessary. Testing the backup and restoration plans.

Environment: MS SQL Server 2000, Windows 95/98, Windows N.T 4.0.