SUMMARY

• 7+ years of administration and Development experience on Data Design using SQL server 7/2000/ 2005/2008/2012 systems in OLTP and OLAP environment
• Expertise and Interest include Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases.
• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities and DMVs and DMFs.
• Extensively used tools like SQL Profiler, Index Tuning Wizard, Windows Performance Monitor for monitoring and tuning MS SQL Server performance
• Excellent skills in database Backup, Restoration, Recovery, Replication, Linked servers, Database Maintenance Planning.
• Experience in migration and maintenance of data using various utilities like DTS, SSIS, Import and Export, ATTACH/DETACH Data Migration tools.
• Excellent SQL Server administration skills including user authorizations, Database creation, Tables, indexes creation.
• Expertise in planning and implementing Database Security by creating users, Roles, and assigning permissions to them
• Experience in creating and scheduling DTS and SSIS packages, SQL Mail Setup, Jobs, and Alerts.
• Strong T - SQL Developer skills including stored procedures, Indexed views, User Defined Functions (UDL), Triggers, and Distributed Queries and Common Table Expressions.
• Migrating SQL Server 2000 databases into SQL Server 2005 and SQL Server 2008.
• Expertise in writing complex MDX, DMX and XMLA queries.
• Creating SSIS Packages using Complex Tasks like ActiveX script task, Fuzzy Lookup And fuzzy Groupings.
• Creating SSIS Packages and involved in Package configurations and Deployments Between Development and QA and Production servers.
• Extensively worked on 32 bit and 64 bit clustered and standalone server environments.
• Implemented two Node Sqlserver clustering on Windows 2003 Environment.
• Configure Database Mirroring in Cluster Environment.
• Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) /Network Attached Storage (NAS).
• Management of schemas, Data modeling, objects & partitioning the tables & indexes.
• Creating different types of Complex Reports using SSRS.
• Experience in SSIS (SQL Server Integration Services), SSAS (Analysis Services) and SSRS (Reporting Services)
• Having good experience in configuring and troubleshooting IIS and XML.
• 24 X 7 Production Database on Call Support.
• Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.

TECHNICAL SKILLS

RDBMS: MS SQL Server 7.0/2000/ 2005/2008/2012 , Access,Oracle11.0

Database Tools: Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Transformation Services, Upgrade Wizard, Replication, Crystal Reports 9.0/10.

Programming Languages: SQL, TSQL, VB.NET, XML, C++, Java, VB 6.0.

Scripts: VBScript, HTML and XML.

Web Tools: MS-Front Page, Macromedia Suite, IIS, Outlook Express.

Applications: Microsoft Office, Visio, and Visual SourceSafe.

Operating systems: Windows 9x/NT/2000/XP/2003.

Reporting Tools: SSRS

PROFESSIONAL EXPERIENCE

Confidential, Cleveland,OH

SQL SERVER DBA

Responsibilities:

• SQL Server 2005/2008/2012 Database Administration.
• Implemented and documented TDE (Transparent Data Encryption) for databases more than 4TB.
• SQL 2005,2008,2012 - Performed installation of SQL Enterprise bit version on Windows 2008 servers on Enterprise systems of clustered and standalone Confidential servers in enterprise Data Centers. Patch applications.
• Installed and administered two node and three node cluster Active/passive on Microsoft Windows Server 2008 R2 Enterprise Edition SP2 on SAN environment
• Worked in Active\passive and active\active\passive cluster environments.
• Worked in Huge Replication Environment.
• Good experience with installing Database Mirroring.
• Expert in Using DMV’s, Performance dash board, Mirroring, database snapshot.
• Maintained the database consistency with DBCC at regular intervals
• Used 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.
• Implemented the Data Partitioning for large tables in SQL Sever 2008.
• Extensively worked on SQL Server Integration Services (SSIS)
• Implement Snapshot Isolation in SQL Server 2008.
• Used Online Indexing and online Restoring in SQL 2008
• Implemented new topics like CLR integration on Development server.
• Expert in implementing the DDL triggers.
• Solving the Bugs Reflected by the Testing team
• Analyzed long running /slow queries and tune the same to optimize application and system performance.
• Installed, authored, and managed reports using SQL Server 2008 Reporting Services.
• Evaluated data storage considerations to store databases and transaction logs.
• 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.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services.
• Worked on different third party tools like OEM (Oracle enterprise Manager)

Environment: MS SQL server 2005/2008, Windows 2003/2008, VB.Net, Enterprise manager, Query Analyzer, DTS, SQL profiler

Confidential, Sanfrancisco, CA

SQL SERVER DBA

Responsibilities:

• SQL Server 2000/2005/2008 Database Administration.
• Expert in setting more than 2GB ram servers on 32 Bit and 64 bit servers.
• SQL 2000, 2005 - Performed installation of SQL Enterprise bit version on Windows 2003 servers on Enterprise systems of clustered and standalone HP servers in enterprise Data Centers. Patch applications.
• Installed and administered two node cluster Active/passive on Microsoft Windows Server 2003 R2 Enterprise Edition SP2 on SAN environment
• Migrated SQL server 2000 to SQL Server 2005/SQL Server2008 in Microsoft Windows Server 2003 R2 Enterprise Edition SP2.
• Involved in the migration of SQL Server 2000 databases to SQL Server 2005 and SQL Server 2008.
• Worked in Active passive cluster environment.
• Worked in Huge Replication Environment.
• Good experience with installing Database Mirroring Environments
• Expert in Using DMV’s, Performance dash board, Mirroring, database snapshot.
• Implemented Peace Meal Restore.
• Managed VERITAS net backups and Litespeed backups.
• Maintained the database consistency with DBCC at regular intervals
• Used 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.
• Implemented the Data Partitioning for large tables in SQL Sever 2005.
• Implemented in new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Extensively worked on SQL Server Integration Services (SSIS)
• Implement Snapshot Isolation in SQL Server 2005.
• Used Online Indexing and online Restoring in SQL 2005
• Implemented new topics like CLR integration on Development server.
• Expert in implementing the DDL triggers.
• Solving the Bugs Reflected by the Testing team
• Migrated DTS and SSIS packages from SQL Server 2000 to SSIS SQL server 2005.
• Analyzed long running /slow queries and tune the same to optimize application and system performance.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services.
• Evaluated data storage considerations to store databases and transaction logs.
• 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.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services.
• Worked on different third party tools like Fog Light, Spotlight and Red gate.

Environment: MS SQL server 2000/2005, Windows 2000/2003, VB, .Net, Enterprise manager, Query Analyzer, DTS, SQL profiler

Confidential, NY

SQL SERVER DBA

Responsibilities:

• SQL Server 2000/2005 Database Administration.
• Analyzed long running /slow queries and tune the same to optimize application and system performance.
• Design, implement and maintain SQL Server Databases.
• Responsible to install & Configuring SQL Server software and apply patches/service packs as needed.
• Strong understanding of Software architectures and development life cycle. Developing and implementing Disaster recovery plans.
• Migration of Database from MS-Sql Server 2000 to MS-Sql Server 2005.
• Implemented two node Active Passive clustering in Sql server 2005.
• Create SQL scripts to automate the database processes
• Creating Packages to transform the data Using MS-SSIS and MS-DTS.
• Developing and Maintaining Cubes, Dimensions in MS-Analysis Services.
• Developing and maintaining Reports using MS-Reporting Services.
• Working with the application programmers to write stored procedures.
• Involved in logical and Physical Data Modeling.
• Created and managed File Groups, Jobs, DTS and SSIS Packages.
• Creating Logins, Users and Roles in context of SQL Server security.
• Creation of Database Objects includes: Tables, Store Procedure, Views, Triggers, Index, and Function.
• Responsible for setting security at OS level and Database level by creating users with appropriate privileges to access a database
• Database Backup and recovery/Restoration, Scheduling Jobs.
• Archiving the Data into Backup Servers.
• Good working knowledge of SAN.
• Restored database in case of failure or whenever required by applying full database backup, differential and transactional log backup.
• Replicating the SQL Server to transfer and update data at remote servers, Setting up of Transactional replication, created publisher database, distributor database and push & pull subscriber databases.
• Performance Tuning of the system by doing the Query/Stored procedures optimization, dropping poorly involved indexes with new indexes.
• Performance Monitoring using Query Profiler.
• Creating and maintaining Documentation including Data Dictionary.
• Interaction with client and internal management for new requirements and
• Good experience with installing Cluster Environment.

Environment: MS SQL server 2000, Windows 2000/2003, VB, .Net, ASP, Enterprise manager, Query Analyzer, PERL, UNIX, DTS, SQL profiler.

Confidential, Austin, Texas

SQL SERVER DBA

Responsibilities:

• Involved in the migration of SQL Server 2000 databases to SQL Server 2005
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services
• Evaluated data storage considerations to store databases and transaction logs. Created databases using Transact SQL Statements, SQL Server Management Studio and Database Wizard.
• Managed trouble shooting of Client connections, viewing error log and applications.
• 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.
• Implemented new T-SQL features added in SQL Server 2005 that are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE), Data Partitioning, Snapshot Isolation
• Transferred data (ETL) to Data warehouse Environment using SSIS.
• Managed VERITAS net backups and Litespeed backups.
• Monitored servers using Spotlight third party software.
• 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.
• Maintaining the database consistency with DBCC utility at regular intervals.
• Using Log shipping for synchronization of database.
• Worked in Cluster Environment.

Environment: SQL Server 2005/2000, C#., VB, VBA, ASP,.NET, Windows 2003

Confidential, Torrance, CA

SQL SERVER DBA

Responsibilities:

• Rebuilding the indexes at regular intervals for better performance
• Designed and implemented comprehensive Backup plan and disaster recovery strategies
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Monitored and modified Performance using execution plans and Index tuning.
• Managing the San backups.
• Managing the clustering environment.
• Monitoring SQL server performance using profiler to find performance and dead locks.
• Monitoring the servers using spot light third party Quest software.
• Export or Import data from other data sources like flat files using Import/Export of DTS
• Recovering the databases from backup in disasters
• Organized data from a data warehouse into multidimensional cubes with MS Analysis Services to allow the execution of sophisticated reports and complex queries.
• Maintaining the database consistency with DBCC at regular intervals
• 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.
• To set up SQL Server configuration settings.
• Monitoring the clustering environment.

Environment: SQL Server 2000/2005 with clustering, T-SQL, Windows 2000, VB and ASP.

Confidential

SQL Developer

Responsibilities:

• Created System Schema Diagram and Tables.
• Set up Replication once a day to a remote location using SQL Server Enterprise Manager.
• Set up Database Maintenance Plan using SQL Server Enterprise to update the statistics.
• Created complex stored procedures to make the report processing faster.
• Installed SQL Server 2000 and created Development Database for testing, upgrades and development.
• Managing the clustering environment.
• Using log shipping for synchronization of database.
• Maintaining the database consistency with DBCC at regular intervals. Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Complete documentation about the database. To analyze long running slow queries and tune the same to optimize application and system performance.
• To set up SQL Server configuration settings.
• Performed daily backup and created named backup devices to backup the servers regularly.
• Generated Script files of the databases whenever changes are made to stored procedures or views.
• Worked with developers to establish the first phase replication scheme for dif locations.
• Implementing and administering database replication between SQL Server databases as well as dissimilar databases.
• Setup the agents for replication and defined disaster recovery plan.
• Provided secondary support to the Local area network (LAN).
• Provided a robust back-up system that ensures data integrity.
• Configured PC Anywhere software to connect to other sites through DSL using TCP/IP.

ENVIRONMENT: Windows 2000,MS SQL Server 7/2000/2005, net, VB and ASP