SUMMARY

• 6+ years of administration and development experience on Data Design using SQL server 2005/2008/2008 R2 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.
• 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, Triggers, and Distributed Queries and Common Table Expressions.
• Migrating SQL Server 2005 databases into SQL Server 2008 and SQL Server 2008 R2.
• 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.
• Installed and administered Two-Node cluster Active/Passive on Microsoft Windows Server 2008 R2 Enterprise Edition on SAN 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).
• Implemented new features in SQL 2008 like Policy based Management, Table Compression & Backup Compression, SQL Server Auditing, Resource Governor and Merge statement in T-SQL.
• 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.
• Flexible, enthusiastic and project oriented team player with excellent written, verbal communication and leadership skills to develop creative solutions for challenging client needs.
• 24 X 7 Production Database on Call Support.

TECHNICAL SKILLS

Platform: Windows NT 4.0 Server, Windows server 2000/2003/2008 Enterprise/Standard, Windows 3.X/95/98/ME/XP, Windows 2000 professional, DOS, OS

Database/Data warehousing/BI: MS SQL Server 6.5/7.0/ 2000/2005/2008 Enterprise Edition, MS SQL OLAP / Analysis and DTS Services, MS Access, T-SQL, MySQL.

Web Technologies: HTML, DHTML, XML, XSLT

Databases: SQL server 6.5/7.0/ 2000/2005/2008 , Oracle 8i/9i/10g, DB2, MS-Access, My SQL Internet/Web IIS4.0/5.0/6.0, MS Exchange Server, Microsoft SharePoint server

Programming: SQL, T-SQL, ASP, VB, HTML, XML, Source Safe.

Desktop Application: MS Office Suite, Dreamweaver, IE, Netscape Navigator/Communicator, Norton Utilities, Anti-Virus

PROFESSIONAL EXPERIENCE

Confidential, Hartford, CT

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.
• Installed and administered two node cluster Active/passive on Microsoft Windows Server 2003 R2 Enterprise Edition SP2 on SAN environment
• Migrated SSIS packages from SQL Server .
• Migrated SQL server 2005 to SQL Server 2008/SQL Server 2008 R2.
• 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.
• 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/2008.
• 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 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 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.

Environment: SQL Server 2008/05, Advanced Windows 2008/03 server, SQL Profiler, T-SQL, SSIS, SSRS, SSAS, DTS, Query Analyzer, MS- Office.

Confidential, Irvin, CA

MS SQL Server DBA

Responsibilities:

• Implemented of SQL Logins, Roles and Authentication Modes as a part of security policies for various categories of users.
• Implemented Data Integrity (Domain, Entity and Referential) by means of Constraints, Rules, Defaults and Triggers.
• Scheduled regular Database Maintenance tasks like re-indexing, maintaining the Fill-Factor for the indexes, updating the statistics, remove Fragmentation for DBs.
• Scheduled Full and Differential Database backups, and Log Backups to disks, tapes or remote servers, using batch scripts, T-SQL and Maintenance Plan Wizard and configure appropriate Recovery Model for the databases.
• Improved query execution times by reducing stored procedure recompilations, making use of auto-parameterization, using sp execute.sql, created Covered Indexes using Server-Side Cursors to reduce the network roundtrips between Client and Server.
• Setup Transactional and Merge Replication between Servers, and troubleshoot and monitor Publishers, Distributors, and Subscribers.
• Involved in designing and configuring a replication server where production database was replicated into two different databases: Read-only reporting database and disaster recovery database.

Environment: SQL Server 2005/2008, Windows 2003, MS Access 2008, Log ShippingClustering, Mirroring, SSRS, Web Services, Transact-SQL, JavaScript, SSIS, MS-Excel, Database Backups.

Confidential, Rochester, OH

SQL Server DBA

Responsibilities:

• Checked the configuration and performance of the existing databases including data file allocation, index, fill factor, fragmentation and the impact on system performance.
• Analyzed potential problems (response delay, locking, server down time, etc) to avoid and optimize.
• Gathered business requirement for creating the new mission-critical databases from customers and internal employees.
• Performed installations of database server and client, service packs and security patches.
• Monitored SQL Server performance using Windows monitor on CPU, network, physical drive, memory, etc. and monitored query performance and batch performance using SQL profiler, DBCC tools, combined with PeopleSoft application engine trace. Analyzed, identified and provided solutions for bottlenecks.
• Created database maintenance plans and jobs to update statistics, defrag indexes, and check integrity.
• Optimized database design with proper normalization, index setup and with efficient T-SQL / SP queries.
• Established and implemented appropriate database security plans to include maintaining logins, user accounts and ensuring proper levels of user access.
• Understood SQL Server storage structures and index architecture. Monitored server configurations, database capacity and growth.
• Analyzed storage, CPU, memory and network capacity needs, designed a strategy for data archiving, established database conventions and standards for new production database servers.
• Provided data migration solutions to ensure integrity.

Environment: MS SQL Server 2000 Enterprise Edition (4-way, 32 bits), Windows 2000/2003server, MySQL AS4.0, PostgresSQL 7.4.8, Veritas NetBackup, Oracle 9i.

Confidential

MS SQL Server DBA/Analyst Programmer

Responsibilities:

• Installed SQL Server on the Windows 2000 Server.
• Involved in the Analysis and Design
• Created Database and Database Objects like Tables, Stored Procedures, Views, Triggers, Rules, defaults, user defined data types and functions.
• Defined relationship between tables and enforced the referential integrity constraints.
• Created the Clustered and Non-Clustered Indexes.
• Responsible for General Database Administration, Query Performance tuning.
• Backup recovery schedules, Backup scripts.
• Worked with DTS packages to load the massaged data into Data warehousing system.
• Tuned the SQL queries using SQL profiler
• Involved in tuning the database.
• Data Migration from legacy to master screen using VT Script.
• Used MS Visual Source Safe 6.0 as a Version Control System.
• Trouble shooting Problems by using SQL server profiler. Very proactively identifying the problems before user complaints.

Environment: MS SQL Server 2000/7.0, T-SQL, DTS, Microsoft VC++, Windows 2003 ServerCompuware QA Load test Ramco virtual Works and Crystal reports 8.0.