SUMMARY

• Over 8 years of experience in Database Administration, Development and Design.
• Extensive experience in maintaining Very large databases (VLDB) and highly transactive production servers in SQL Server 2008R 2/2008/2005/2000/ environments.
• Worked on features like Data and Backup compression, Policy based Management, Resource Governor, Transparent Data Encryption and Performance Data Collection in SQL 2008.
• Experience wif SQL Server 2008, 2005 installation, Migration, configuration, SSIS, SSRS and administration.
• Experience in Replication - Snapshot and Transactional and extensive knowledge in Merge replication, Peer to Peer Replication.
• Experience wif analyzing query plans, writing stored procedures, try-catch blocks using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks and blocking.
• Having experience and outstanding knowledge of high availability and disaster recovery SQL Server solutions, including SQL Server Log shipping, Mirroring and SQL Server clustering.
• Expertise in Database Backup and Recovery procedures for Disaster Recovery.
• Extensively worked on 32 bit and 64 bit clustered and standalone server environments and creating linked servers between SQL servers 2000/2005/2008 environments.
• Experience in installing MS SQL SERVER 2000/2005/2008 , updating wif the hot fix and service packs
• Experience in Data Partitioning, Separating Files and File groups, snapshot isolation, database snapshot, database mirroring, triggers and online indexing.
• Worked wif litespeed tool, SCOM for monitoring, Tivoli TSM, TDP for back up and recovery.
• Expertise in Query Optimization, Performance tuning, Database consistency using DBCC utilities and server connectivity, analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency TEMPEffects.
• Expertise on physical storage SAN configuration on different RAID levels.
• Experience in working wif CTE’s, Temporary tables, Temporary variables, global variables.
• Verifying and tuning stored procedures created by developers by using SQl Server Profiler, Data Tuning Advisor. Debugging stored procedures, triggers, optimizing code and improving efficiency in database including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Fixed the failed PRINCIPALS (logins), user permissions and security in ACTIVE DIRECTORY and SQL SERVER LEVEL.
• Experience in administrative activates comprising Database health Check, Index optimization( Rebuild and reorganizing indexes), Updating Statistics, Performance Tuning, Query Optimization, Client/Server Connectivity.
• Rebuilding indexes wif different fill factors and updating statistics.
• Expertise in identifying the bottlenecks caused by complex queries using Active Monitor/SQL profiler and handling them by implementing better Query execution plans.
• Experience in logical and physical data modeling of the database in ERWIN and MSVISIO.
• Experience in Normalization, denormalization Database design, Performance Analysis and Production Support for very large (VLDB) in both OLTP, OLAP and Complex Databases.
• Explicitly used third party tools like Litespeed, Foglight and Red gate.
• Proficient in SQL programming, physical and logical database design.
• Involved in all phases of the SDLC cycle (soft ware development life cycle).
• Experience in writing complex T-SQL (DDL, DML, cursors, triggers, functions, constraints, query hints, joins) .
• Experience in using Dynamic Management views (DMV), DBCC commands to improve server performance.
• OLAP experience using in SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS) and SQL Server Integration Services (SSIS) both in star and snow flake schema.
• Experience in DTS, BCP and Bulk Insert, Package deployment, SSIS.
• Experience in handling cubes wif fact, dimensions tables, measures and measure groups in SSAS using BIDS.
• Expertise in Performance monitor/ Profiler to resolve dead locks and long running queries. Checking the threshold values and baselines and monitoring in performn and SCOM.
• Used Tivoli Storage Manager (TSM) for back up especially file groups in SQL Server.
• Worked extensively in Query analyzer and profiler for tuning queries using variable for characteristics and query costs.
• Strong experience in mentoring and working wif team, good communication skills documentation and 24/7 on call production support.

TECHNICAL SKILLS

SQL Server Tools: Enterprise Manager, Profiler, DTS (Import & Export), Query Analyzer, Replication, SQL Server Management studio.

Languages: C, C++, T-SQL, VB.NET, XML, HTML.

Operating Systems: Windows server 2003, Windows 2000 Server/ Advanced Server, Windows NT/95/98/ME/XP.

Data Bases: MS-SQL Server 6.5/7.0/ 2000/2005/2008 , MS Access 97/2000/2003 , Oracle.

Front End Tools: MS FrontPage 98/2000, MS Office 97/2000/XP, MS Outlook 97/2000.

Database Tools: Profiler, DTS, Query analyzer, SSRS, SSIS, SSAS, Erwin.

Reporting Tools: SQL Server Reporting Services, crystal Reports.

PROFESSIONAL EXPERIENCE

Confidential, Marshalltown, IA

SQL Server DBA

Responsibilities:

• Implementing the migration methods for the three different integrated databases systems Visual Foxpro, MicroSoft SQl Server 2008/2008 R2,Oracle.
• Has been developing the SSIS packages for migrating data into the Microsoft SQL Server for data binding purposes of the data to a front end application for migrating into a new information systems.
• Documenting all the required information regarding the tables to be migrated and architechture for the new system i.e. being built.
• Working on Microsoft CRM and Oracle Databases for Extracting the Data, Cleaning the data and loading into a staging databases for migration.
• Responsible for building a staging database which is cleaned out of the bad data and using the data in the migration.
• Implementing and planning the migration startegies for migrating all the databases into a newly build integrated database systems.
• Building, Developing and Deploying the SSIS Packages for extracting the data from the three different databases of Visual Foxpro, Oracle and Microsoft SQL Server 2008/2008 R2.
• Using SSIS built high performance data integration solutions, including extraction, transformation and loading (ETL) packages for building a Staging Databases.
• Involved in implementing SSIS package security, protecting packages, executing, monitoring and managing them.
• Implementing T-SQL features like Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Implementing new features in Microsoft SQL Server 2008 like the Merge Join for merging several databases based upon their Referential Integrity.
• Daily routine Developer/DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Tuning 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.
• Created Sub-Reports, Drilldown-Reports, and Cross Tab reports using MS SQL Reporting Services (SSRS).
• Developed Queries for generating drill down, drill through reports in SSRS 2005.
• Good understanding of Microsoft Reporting Service (SSRS) wif Report authoring, Report management, Report delivery and Report security.
• Experience in integrating SharePoint Server wif SSRS and deploying SSRS reports on to SharePoint Server.
• Project Management experienceincluding defining requirements, tasks allocation, and handling the allocations of resource.
• Responsible and accountable for the coordinated management of multiple related projects directed toward strategic business and other organizational objectives.

Environment: MS SQL Server 2000/2005/2008 , Windows 2000/2003, IIS 5.0, SSIS, SSRS, SSAS, Excel, ETL, TSQL, Replication, Microsoft Visual Studio 2005, MOSS 2007.

Confidential, AL

SQL Server DBA

Responsibilities:

• Implemented the disaster recovery models like clustering, mirroring, log shipping and transactional replication.
• Implemented the new SQL Server 2005 concepts like Data partitioning, Snap shot isolation, database mirroring, database snapshot, DDL triggers, try-cache blocks, online indexing, DMV’s, DMF’s, Mail Setup, Jobs, and Alerts, DTA,SQLCMD and dedicated admin connection.
• Worked wif SQL Server 2005 inplace and side by side upgrade from SQL server 2000.
• Created Documentation for steps need to be taken while upgrading the SQL server 2000 to SQL server 2005.
• Worked in Active passive cluster environment.
• Daily routine Developer/DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Involved in all the phases of SDLC including Requirements Collection, Design & Analysis of the Customer Specifications, Development and Customization of the Application.
• Strong experience in working on Very Large Databases (VLDB) over 80 GB for OLTP and 2TB for OLAP databases.
• Installed couple of SQL Server 2005/2008 on cluster environment.
• Extensively worked on TSM litespeed backup.
• Solving the Bugs and issues reflected by the Testing team. SQL Server 2005/2000 Database Administration.
• Migrated databases from SQL Server 2000 to SQL Server 2005.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.
• Use SQL Server RML Utilities to do performance baseline analysis report between the SQL Server 2000 and SQL Server 2005.
• Experience in Database security and integrity planning.
• Created Maintenance Plans for Regular Backups and Rebuilding of Indexes.
• Tuning 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.
• Successfully implemented the Capacity planning for different servers.
• Implemented new T-SQL features added in SQL Server 2005 dat are Data partitioning, Error handling through TRY-CATCH statement, Common Table Expression (CTE).
• Migrated DTS packages to SSIS packages.
• Used C#.NET code in script Task for developing SSIS packages
• Designed and developed SSIS packages using different control flow tasks, Transformations and dataflow tasks.
• Checked Database Health and consistency by using DBCC Commands and DMVS
• Monitored and modified Performance using execution plans and Index tuning.
• Recovered the System and User databases from suspect mode.
• Expert in sizing Temp database.
• Wrote and debugged Stored Procedures and (DDL /DML)Triggers, Functions as per client requirements
• Daily routine Developer/DBA tasks like handling user’s permissions and space issues on Production and Semi-Production Servers and handling maintenance Jobs.
• Did Performance Tuning of the Stored Procedures.
• Rebuilding the indexes at regular intervals for better performance
• Managing the VERITAS net backups and Litespeed.
• Monitored the performance of the server and checked the database health wif Foglite.
• 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.
• Performed code reviews to ensure high Software quality and participated in weekly team meetings.
• Installed and configured Microsoft SQL Server 2008 in Virtual Machines using VMware ESX 4.0.
• Used Update statistics, database integrity check and Backup operations.
• Worked on call 24/7 Support on weekly basis

Environment: MS SQL Server 2000/2005, Windows 2000/2003, IIS 5.0, COGNOS, SSIS, SSRS, Excel, TSQL, ETL, Erwin, Replication, Microsoft Visual Studio 2005.

Confidential, Branchville, NJ

SQL Server DBA

Responsibilities:

• Developed logical and physical data models to support specific needs as requested by the company.
• Involved in Data Administration and Database Design. Created Database Objects like Tables, Stored Procedures, Views, Joins, Triggers, Rules, Defaults, user defined data types and functions.
• Responsible for Query optimization and Performance tuning.
• Involved in Data Migration from SQL Server 2000 to SQL Server 2005.
• Implemented database mirroring as a part of disaster recovery plan.
• Created Clustered Indexes and Non-Clustered Indexes to increase the performance of database.
• Used DBCC commands to check physical and logical consistency of the databases and to rebuild indexes.
• Used SSRS in creating the reports about the database administration.
• Deploy/Design cubes in SSAS environment Snowflake/ and Star Schema Designs.
• Created SSIS packages to export data from text file to SQL Server Database.
• Managed replication issues during DDL changes over data in development servers.
• Managing and scheduling daily jobs relating to data transfers, backup and recovery, transaction log dumps.
• Managed various issues like the Orphan user and transfer of logins etc., during the process of migration of SQL Server 2000 to SQL Server 2005.
• Configuring and administering Database Mirroring on SQL Server 2005.
• Migrated and tested DTS packages to SQL Server 2005 Integrating Services (SSIS).
• According to the fragmentation value on the table which was obtained by DBCC SHOW CONTIG either reorganized the index or rebuilt them by using DBCC INDEXDEFRAG or DBCC DBREINDEX.
• Created logical and physical databases for the production development and testing servers as per the end-user specification.
• Created Entity Relational diagrams while designing the databases in the SQL server according to the end-user specification.
• Setup profiler traces for slow running queries & analyze load file through query tuning wizard.
• Created complex SSIS packages making use of various Active X scripts, send mail tasks.
• Worked wif SQL server profiler to generate traces.
• Worked on the clustering of SQL server.
• Established and maintained Security Integrity controls in conjunction wif the applications and security groups and maintained the required level of security for all production and test databases.
• Automated various Database maintenance plans used the DTS packages and SSIS in SQL server.
• Implemented transactional replication model and involved in maintenance of the replication.
• Implemented Backup and restore in SQL Server 2005.
• Maintained multiple instances SQL Servers wif maximum availability.

Environment: MS SQL Server 2000/2005, Windows 2000/2003, IIS 5.0, Symantec VERITAS Backup Exec 10, Excel, TSQL, DTS, SSIS, SSAS, BCP.

Confidential, IL

SQL Server DBA

Responsibilities:

• Monitor and maintain SQL Servers in Production, QA, Test and Development Environments.
• Set up SQL Mail and Created Jobs to Automate & Scheduled many tasks.
• Managing Logins, Users, Roles and User permissions.
• Implementing Automated Backup and Database Maintenance / Cleanup jobs.
• Imported Data from Text files and Excel Spread sheet into SQL Server 2000 database using DTS package.
• Setting up logical/physical backups for the databases.
• Created Data Mart using Analysis services for finance, inventory and sales department to review the data from production databases.
• Create packages, procedures, functions, and triggers; handle database performance and tuning.
• Creating DTS Packages migration of data across different servers and Other Databases such as Oracle and DB2.
• Assist Developers in writing and tuning new procedures.
• Executed DBCC commands like CHECKDB before backing up the databases.
• Troubleshooting Replication Errors and handling Logs.
• Creating new procedures using Dynamic SQL and Table Variables.
• Create and modify procedures, Triggers and functions
• Assisted users in modifying store procedures over performance issues.
• Wrote customized scripts for monitoring of the SQL Servers and other database administration work.
• Check consistency of databases.
• Check the fragmentation of tables and indexes and run DBDEFRAG and DBREINDEX at appropriate time.

Environment: Erwin, SQL Server 2000, Windows 2003 Server, T-SQL, SQL Profiler, DTS, MS Office 2000, Front Page, MS-outlook.

Confidential

SQL Server DBA/Developer

Responsibilities:

• Designed, created and managed the databases and objects.
• Provided day-to-day administration tasks like spacing and logging management.
• Responsible for fine tuning of the database, troubleshooting, user administration, memory management, and running DBCC (Rebuilding Indexes and fine tuning Stored Procedures).
• Performed data transfers using BCP and DTS.
• Generated script files of databases whenever changes are made to stored procedures or views.
• Managed the use of disk space, memory and connections.
• Performed DBCC utilities and fixed data corruption in application databases.
• Worked on monitoring and tuning of SQL scripts. Created upgrade scripts for production databases and supported it.
• Created and managed schema objects such as tables, views, indexes, procedures, triggers.
• Targeted performance tuning of SQL Server databases dat enhance performance.
• Developed set of administrative scripts to automate most daily operations.
• Implemented Disaster Recovery Plan by maintaining Backups and restored the system and user databases.
• Developing SQL scripts for maintaining administration tasks.
• Maintained Production, Test, and Development Servers.
• Setup and maintained Linked Servers.
• Controlled user access rights, and managed data security.
• Setup and maintained Replication Servers.
• Developed Stored Procedures and Triggers for new applications.
• Traced long running queries and deadlocks using SQL Profiler.

Environment: MS SQL Server 7.0/2000, Windows 2000/NT 4.0 Server, T-SQL, Crystal reports, MS Access, SQL Profiler, DTS.