SUMMARY

• Around 9 years of experience in Database Administration, Development and Design, as SQL DBA/Developer and Production servers in SQL Server 2008R2/2008/2005 environments.
• Experience with SQL Server 2008R2,2008, 2005 installation, database migration side by side and In - Place Migration, configuration, updating with the hot fix and service packs.
• Extensively worked on 32 bit and 64 bit clustered and standalone server environments and creating linked servers between SQL servers 2000/2005/2008 R2 environments.
• Experience in Replication - Snapshot and Transactional, Transactional from backup.
• Experience with analyzing query plans, writing stored procedures, try-catch blocks, using extended Stored Procedures, managing indexes and locks, troubleshooting deadlocks and blocking, Checking the threshold values and baselines.
• Planned & executed of any upgrade such as Service Packs, hot fixes in clustering Active-Active, Active - passive nodes, mirroring, Replication Environments.
• Experience in SSIS for ETL with SCD, incremental loading in star schema for dimension and fact tables, bulk loading, Import/Export wizard, bulk loading partitioning tables, using transformations, developing dynamic packages using variables, expressions, vb.net and c#.net.
• Having experience and outstanding knowledge of Backup and Recovery procedures for Disaster Recovery, Fail Over, high availability and disaster recovery SQL Server solutions, including SQL Server Log shipping, Mirroring and SQL Server clustering.
• Worked on Principals (logins), user permissions and security in SQL server level.
• Experience in Capacity Planning, Data Partitioning, Separating Files and File groups, database snapshot, database mirroring, triggers and online indexing, data base snapshot.
• Expertise in Query Optimization, Performance tuning, Database consistency using DBCC utilities and server connectivity, DMV’S, DMF’S, analyzing Locks, Dead Locks and Handling the Isolation Level and Concurrency Effects.
• Experience in working with CTE’s, Temporary tables, Temporary variables, DDL, DML, cursors, DDL, DML, Logon, Event data() function triggers, functions, views, stored procedures, constraints, query hints, joins in T -SQL.
• Verifying and tuning stored procedures created by developers by using Execution plans, SQL Server Profiler, Data Tuning Advisor. Debugging stored procedures, optimizing code and improving efficiency in database including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Expertise in using Team Foundation Server (TFS), PVCS and Visual source safe (VSS) as a tool for repository of codes and version control, branching and merging into production.
• Experience in administrative activates comprising Database health Check, max dop, Index optimization( Rebuild and reorganizing indexes with different fill factors and updating statistics.), Updating Statistics, Performance Tuning, Query Optimization, Client/Server Connectivity, data base security.
• Experience in SQL programming, logical and physical data modeling of the database in ERWIN and MSVISIO, Normalization, DE normalization, Database design, Performance Analysis and Production Support for very large (VLDB) in OLTP,OLAP Databases.
• Involved in all phases of the SDLC cycle (software development life cycle) and Change Control Management and change Requests.
• Loading Data Warehouse using SQL Server Integration Services (SSIS) and building reports using SQL Server Reporting Services (SSRS) in star schema.
• Incremental loading dimensions and loading facts in SSAS and other data warehouse databases.
• Design the LUNS of RAID 0, RAID 0+1 and RAID 5, RAID Groups and Storage Groups as per the size and Performance requirements.
• Strong experience in mentoring and working with team, coordinating with developers, good communication skills documentation, supporting architects, decision support meetings and 24/7 on call production support.

TECHNICAL SKILLS

Project Domain: Application Development, Systems Integration and DatabaseAdministration of MS SQL Server 2008/2005/2000/7.0 ,Oracle.

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Erwin4.x

ETL Tools: MS SSIS and DTS, PL/SQL, TSQL, SQL Server bulk insert and BCP utilities, Informatica 7.x,8.x

Tools: Active X, IIS, SSIS, DTS,SQL Safe, SQL Sentry, Lite Speed, Spotlight, Visual Studio 2003/2005, Team Foundation Server (TFS), VSS 6.0, Visio 2003, Office Visio 2007, Enterprise manager, query analyser, Perfmon, SQL Profiler and SQL LOADER,, red gate, Idera, Foglight, Red gate, Tivoli TSM, VERITAS Netback.

Business Intelligence: Crystal Reports XI/10/9, SSRS, and Business Objects XI/6.5.1.

Databases: SQL Server 2008R2/ 2008/2005/2000/7.0 , MSSQL, MS Access, oracle.

Languages: SQL, TSQL, PL/SQL, C, vb.net, C#

Markup Languages: HTML, XML

Packages: Microsoft Office 2007/2003/2000/ XP

Operating Systems: Windows NT/2000/XP/2003,2008/2008R2, Unix

PROFESSIONAL EXPERIENCE

Confidential, Sioux Falls, SD

SQL Server Sr. DBA

Responsibilities:

• Migration of databases from SQL Server 2005 to SQL Server 2008R2.
• Installed SQL Server 2008R2 on windows 2008R2 and migrated SSIS packages.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support via ACTIVE DIRECTORY.
• Created stored procedures to incorporate the flow of business and called various stored procedures fromSSIS packages to make the flow of the package effective.
• Experience in SSIS for ETL with SCD, incremental loading in star schema for dimension and fact tables, bulk loading, Import/Export wizard, bulk loading partitioning tables, using transformations, developing dynamic packages using variables, expressions, vb.net and c#.net.
• Rewrote the existing SQL queries according to the requests and executed them to check the performance.
• Experience in capacity planning in estimating disk space in different Raid levels.
• Worked on SQL Server Reporting Services (SSRS), drill down, parameterized reports, and cascading reports deployed them on Report server from Report Manager.
• Performed horizontal data partitioning for efficient management of database tables and indexes, Full text indexes, Using Contains, Tuning LOB, BLOB data types.
• Maintaining the database consistency with DBCC at regular intervals, Managed Disk space and memory and User connections and Monitored SQL server performance using profiler to find performance and deadlocks.
• Implemented & managed database clustering, failover as per client requirement Active/Passive & executed of any upgrade such as Service Pack, Hot fixes in Active/Passive clustering.
• Mirroring experience with both synchronous and Asynchronous and applying service packs.
• Performed Database Integrity Checks, Database Maintenance plans, updated Database Statistics and performed Re-indexing, Rebuilding the indexes, online indexing at regular intervals for better performance.
• Created and managed schema objects such as tables, views, constraints, indexes, functions, procedures, and triggers and maintained Referential Integrity.
• Generated Script files of the databases whenever changes are made to stored procedures or views.
• Configured and managed virtual Servers and worked on virtualization and clustering environment.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Created DB master key, symmetric keys, asymmetric keys, certificates for encryption.
• Monitored and modified Performance using execution plans with query hints and Index tuning.
• Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Creating views and stored procedures and optimizing them as required by front-end developers for easier implementation on web pages and performance testing on stored procedures, indexes, and triggers.
• Data migration using bulk copy program (BCP) and DTS to Flat files and Expertise in Data Staging.
• Experience in writing scripts like retention of data using batch deletes.
• Export or Import data from other data sources like oracle, db2, flat files using Import/Export, SSIS.
• Developing T-SQL stored procedures, Log on & DDL triggers, views and adding/changing tables for data load and transformation, and data extraction and loading to data ware house.
• Working on different environments and a key resource for deployment of modified objects to production environments.
• Developed, deployed and monitored SSIS Packages, Incremental loading and dynamic SSIS Packages with parent package variables.
• Designed and deployed SQL Server Integration Services (SSIS) Packages, with error handling, environmental and SQL server package configurations.
• Incremental loading of dimensions, SCD, facts, error handling in SSIS.
• Created Dynamic SSIS packages, to load Stage tables from text files and oracle.
• Technical Analysis, Code Review, Implementation, 24 x 7 production support.
• Experience in using ERWIN tool for Entity Relationship diagrams.

Environment: Windows 2008 r2, MS SQL Server 2005/2008 r2, c#,vb.net, Reports, SQL Sentry, MS Office Access 2007/2010, Erwin, SSIS, SSRS.

Confidential,, Boston, MA

SQL Server Sr 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.
• Installing Windows and SQL Server security patches, Windows regular updates.
• 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 2005 to 2008 and DTS to SSIS, and involved in SAN Migration for the SQL server 2000 and 2008 Servers.
• Handled up to 6 TB Size databases with clustered environment.
• Involved in installing and configuring latest version of SQLSAFE in SQL Server 2008 Active-Passive Clustered 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 ESP jobs for SQL server, and involved in various production releases.
• Configured the RAID levels for data files, log files and TempDB at server level.
• Reconfigured the default locations of the data files, log files and error log files onto the SAN environment for all the servers.
• Involved in development of complex mappings and also in tuning of mappings for better performance.
• Fixing data issues and writing various SQL scripts and procedures for migration process.
• Expert in using and implementing DMV’s, DMF’s, data partitioning, DDL triggers and Online indexing.
• Configured more than 2 GB Memory on 32 bit Environment and handling Memory configurations for SQL Server 2000 and SQL Server 2005 on Windows 2003.
• Extensively worked on 32 bit, x64 bit and i64 clustered and standalone server environments
• 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: Windows 2008, Microsoft SQL Server 2008, 2005, Microsoft Excel, Fog Light, SQL Query Analyzer, SQL Server Agent, SQL server Profiler, Data Tuning advisor, BI Express, SSIS, SSRS.

Confidential, Boston, MA

SQL Server Developer/ DBA

Responsibilities:

• Upgrading SQL Server 2000 to SQL Server 2005 and developing stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.
• Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Configuring, tuning, and optimizing SQL 2005 stored procedures, indexes, and triggers.
• Creating DTS Packages for data import, export, scrubbing and scheduled jobs for backups.
• Data migration using bulk copy program and DTS.
• Helping the front-end application developers with their queries.
• Job Monitoring and making sure all jobs run successfully every night.
• Performing low-level scripting, fixing of codes and software enhancement process.
• Administrator tasks like managing users, roles, and profiles via ACTIVE DIRECTORY.
• Performed Database backups with tools like lite speed.
• Developing Crystal Reports used to generate all daily, weekly, monthly and quarterly Reports including current status.
• Development of various reports and reporting interfaces utilizing Microsoft SQL Reporting Services and deploying them on Report Server using Report Manager.
• Suggest Replication techniques to meet business needs.
• Setting MAX DOP (Max degree of parallelism) to 8 for 28 GB memory.
• ETL experience with SSAS and SSIS.
• Designed the reporting databases using ERWIN.
• Scheduled and monitored all maintenance activities including database consistency check and index fragmentation.
• Analyzed execution plans, and tuned queries and databases for better optimal performance.
• Generated script files when changes applied to stored procedures and functions.
• Managed schema objects like Triggers, cursors, indexes, procedures.

Environment: Windows 2003, Microsoft SQL Server 2005, Microsoft Excel, SQL Query Analyzer, SQL Server Agent, SQL server Profiler, Data Tuning advisor, SSIS, SSRS.

Confidential Livonia, MI

SQL Server Developer

Responsibilities:

• Updated Database Statistics and Re-indexing, making better actual execution plan in the servers.
• Maintaining the database consistency with DBCC commands at regular intervals.
• Developing stored procedures, triggers, views and adding/changing tables for data load and transformation, and data extraction.
• Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Configuring, tuning, and optimizing SQL Server 2000.
• Involved in requirement gathering, analysis, design, development, change management, deployment and user training.
• Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
• Using log shipping for synchronizing the database.
• Implemented T-SQL features in SQL 2005 like data partitioning, Error handling through TRY CATCH statement, CTE, snapshot isolation.
• Used SQL Server Agent to schedule jobs and Data Tuning advisor, Profiler, to perform daily tasks.
• Designed and analyzed databases.
• Login and User Management: Adding logins, roles, groups to the Window NT and MS SQL Server and maintaining proper security procedures.
• Scheduling Jobs and Alerting using SQL Server Agent.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Installed MS SQL SERVER 2005, and updated with the hot fix.
• Used Dynamic Management Views, DDL triggers, User defined Functions, creating indexes, removing excess indexes and index modification and file group.
• Recovering databases during disaster.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Performed ETL operations from different sources like CSV, text, excel Xml files and Oledb databases using SSIS packages.
• Lookup Transformation, Cache transformation, Merge, Union, checkpoints, logging, Data conversion in SSIS packages.
• Created Drill down and parameterized reports in SSRS (SQL Server Reporting Services).

Environment: Windows 2003, Microsoft SQL Server 2005, Microsoft Excel, SQL Query Analyzer, SQL Server Agent, SQL server Profiler, Data Tuning advisor, SSIS, SSRS.

Confidential

SQL Server Developer

Responsibilities:

• Used Erwin for Logical and Physical design of database for projects on basis of user requirements.
• Created/reallocated database objects on appropriate File groups to ease maintenance and improve data access performance.
• Coded and tuned Stored Procedures, functions and triggers at High level.
• Used Query hints to Tune the SQL queries for maximum efficiency and performance.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Used Query hints to Tune the SQL queries for maximum efficiency and performance.
• Implementing user Training and providing technical support.
• Prepared proper backup and recovery plans.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers. Table partitioning to improve I/O access
• Performed Administration activities like creating users, roles and granting and revoking privileges.
• Using database level triggers code for database consistency, integrity and security.
• Worked on DTS packages, DTS IMPORT/EXPORT for transferring data from heterogeneous database.
• Setting up Disaster Recovery sites using log shipping for moving databases from production to DR server.

Environment: Windows 2003, Microsoft SQL Server 2005, Microsoft Excel, SQL Query Analyzer, SQL Server Agent, SQL server Profiler, Data Tuning advisor, SSIS, SSRS.