SUMMARY

• Over 8+ years of experience in MS SQL SERVER 2008 R 2/2008/2005/2000 Database Development and Administration (DBA) in Windows environment.
• Experience in Installation, Configuration & Maintenance of MS SQL Server 2008 R 2/2008/2005/2000 Versions for standalone, windows clustered environments.
• Experience in Capacity planning, Performance Tuning, Disaster Recovery, troubleshooting, backup and restore procedures.
• Extensive experience on Upgrading and Migrating SQL Server Software to new versions & applying service packs & patches.
• Experience in Administration, Database Design, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases up to 1.4 Terabytes and 200 Servers.
• Experience in implementing and managing Merge, Transactional and Snapshot Replication models.
• Implementation experience on Log shipping with SQL Server 2000/2005 and Database Mirroring with SQL Server 2005 and Clustering (active active and active passive) for high availability and disaster recovery procedures.
• Experience in configuring and managing Linked Server, Data transfer between SQL Server and other Databases such as Oracle 9i and 10g.
• Good knowledge in creating and managing user permissions, logins and setting up security according to business standards.
• Extensively worked on 32 bit and 64 bit clustered and standalone server environments.
• Experienced in Creating Databases, Tables, Views, Stored Procedures, Triggers, Functions and Indexes using T - SQL statements based on Functional Requirements considering System and Logical database design.
• Proficient in Performance Tuning, Query optimization using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor (DTA), DMV’s, DBCC commands and reading execution plans.
• Handled multiple SQL Instances on Cluster environment for Server Consolidation projects built on SAN using RAID levels.
• Good knowledge on using different system monitors object counters and various reporting tools for monitoring and Tuning MS SQL Server Performance.
• Experience on Data Transfer from and to SQL Server Databases using utilities / tools like SSIS, DTS, BCP, BULK INSERT etc.
• Experience on Migrating DTS packages to SSIS packages; worked on building and deploying SSIS packages.
• Good experience in creating Jobs, SQL mail agent, partitions and scheduling DTS and SSIS, SSRS packages.
• Knowledge and worked on developing and deploying OLAP cubes through SSAS.
• Knowledge on installing and configuring SSRS on windows environment; also know the process of generating different types of reports.
• 24 X 7 Production Database on Call Support.

TECHNICAL SKILLS

SQL Server Tools: Enterprise Manager, Management Studio, Profiler, Tuning Advisor, Query Analyzer, DTS, Replication, SSIS, SSRS (Administration), DB Artisan.

Databases: SQL Server 7.0/2000/2005/2008/2008 R2, Knowledge on Oracle 9x/10x and MS-Access

Scripting Languages: T-SQL,PL/SQL,ASP, VBScript, Java Script, PHP, PERL

Web Technologies: HTML, CSS, XML, XSLT, IIS, Front Page

Operating Systems: Windows XP/ 2000/2003/2008/ NT/98/95,Linux,Unix, VMware Virtualization, HP Polyserve, Compaq

ETL and Reporting: DTS,SSIS(SQL 2008 R2), SSRS (SQL2005),HP OVPI and OVPM,MOM

Other Tools: Power Designer, Erwin, IBM Rational Clear Case, Red Gate SQL Backup, Red Gate SQL Compare, HP service manager 7, Remedy Tool (Pac2000), HP Open view, HP Performance Manager, MS Word, MS Office.

Installation Tools: SQL Server /2008/2008 R2

PROFESSIONAL EXPERIENCE

Confidential, Tampa, FL

Sr SQL Server DBA

Responsibilities:

• Provided support to 75 database Servers. Support included Production, stage, QA and Development.
• InstalledandconfiguredSQL Server 2008R2 on stand-alone and active/active and active/passive clusters on windows 2008 environment.
• Experience in improving SQL Server Database performance using Index Tuning Wizard, SQL Profiler and execution plans.
• Created the disaster recovery plan for production server and development server.
• Support and develop multiple SQL Server Databases and ensure all the developed SQL Server components functions in the production environments.
• Created transactional and snapshot replication on different servers.
• Monitor database environments, related jobs end procedures Database tuning & optimization Write and maintain stored procedures Work with database tools and utilities for administration and development.
• Created logins and users according to required server roles and database roles. And worked fixing orphan users.
• Managing SQL databases, Security, fine tuning of T-SQL queries.
• Involved in performance tuning issues by running Profiler Trace and analyzing the output.
• Running DBCC checks and DMV commands to fixing data corruption in application databases.
• Developed complex stored procedures (T-SQL) for front-end application and reports.
• Maintain Fail-Over and Back-up system through use of transaction logs and Snapshot and Transactional Replication.
• Configured and maintained Log Shipping and DB mirroring Environments for the projects.
• Capacity planning - properly sizes and organizes including archive logs; calculate optimum disk space, memory, etc.
• Manage hardware configurations and considerations for SQL Server environment Recommend security of databases; insure that policies are adhered to when they are approved and implemented.
• Triggers, jobs & created views and encryption of Stored Procedure on SQL Server 2008 R2.
• Supported 24/7 for production servers using HP Service Manager 7 ticketing tool.

Environment: SQL Server 2008/2008R2 Enterprise Edition, Management Studio, Red Gate Backup and SQL Compare, HP service Manager 7, Activity monitor, SQL Profiler, SSIS, SSRS, Windows server 2008.

Confidential, Lansing, MI

Sr.SQL Server DBA

Responsibilities:

• InstalledandconfiguredSQL Server 2008R2/2005 on stand-alone and active/passive clustering on windows 2003 environment.
• Migrated several databases to SQL Server 2005/2008 from 2000/2005on stand-alone and cluster environments.
• Upgraded database servers from SQL 2005 to SQL 2008.
• Configured and Implemented Log shipping, DB Mirroring and Clustering for high availability of data.
• Created Snapshot and Transactional Replication for SQL Server 2000 and 2005.
• Worked on designing and implementing the SQL Server behind the Firewall which sits out of domain.
• Designed and Implemented regular backup, maintenance jobs and recovery procedures.
• Provided support to 50 database Servers. Support included Production, QA and Development
• Managed Security by creating login/groups and assigning appropriate permissions
• Configured linked servers to run distributed queries between SQL Server and other data sources using ODBC, OLE DB Drivers.
• Involved in Capacity Planning and adding new storage space as needed
• Worked on deploying and migrating DTS Packages and SSIS packages.
• Developed SSIS packages to transform data between various data sources.
• Created maintenance plans to perform Index De- Fragmentation, Re-Indexing update the Index statistics.
• Imported and exported data from heterogeneous sources using various techniques like BCP and DTS
• Worked on Performance Tuning and Optimizing Queries by analyzing Execution Plans and Re-designing Indexes.
• Developed and configured databases including objects, stored procedures, triggers and cursors.
• Designed and Extracted the DDL changes from the data modeling tools for databases.
• Implemented new T-SQL features added in SQL Server 2005.
• Used different monitoring tools like MOM, HP Openview, DB Artisan and Performance Manager Tools for monitoring server health.
• Provided Secondary Support to IIS Web Servers.
• Deployed database changes using IBM Rational Tool to all environments.
• Processed and Deployed cubes in SSAS.
• Built and extracted different reports using SSRS.
• Gained knowledge on installing the Sybase and Perl files for monitoring and audit purpose.
• Gathered user requirements from users and managers to better understand the business logic and developed required documentation.
• Worked as on-call DBA for 24x7 production support along with other team members.

Environment: SQL Server 2008/2008R2 Enterprise Edition, Enterprise Manager, Management Studio, Windows 2003 & 2008 Server, DTS, SSIS, SSAS,SSRS,SQL Query Analyzer, Power Designer, DB Artisan, IBM Rational Tool, Secure CRT, Remedy Tool(Pac 2000),HP Openview, HP Performance Manager, SQL 2005 Performance Dashboard.

Confidential, Atlanta, GA

Sr.SQL Server DBA

Responsibilities:

• Working as a Production DBA with 50+ Production MS SQL Servers and 100+ Dev-Test SQL Servers and 1000 + Databases.
• SQL Server 2005/2000 Production Database Administration.
• Installed and configured SQL Server 2005/2008R2.
• Worked on call support 24/7 and solved many Incident Tickets.
• Hands on experience in Performance issues and troubleshooting database issues.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies.
• Migrated DTS packages from Legacy system to SQL SERVER 2005.
• Created and Maintained jobs, alerts and Maintenance plans.
• Worked in Active passive and Active active cluster environment.
• Worked in Huge Transactional, Merge Replication environment.
• Extensively worked to implement Database mirroring, configured Principal, witness and mirror using the SQL SERVER 2005.
• Worked to implement Asynchronous mode for Database mirroring in Staging Environment.
• Monitoring SQL server performance using profiler to find performance and dead locks.
• Used Performance monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency
• Used Online Indexing and online Restoring in SQL 2005.
• Created a new Reporting server in SQL SERVER 2005 environment which is being tested.
• Tested on Test environment with new stored procedures developed by Developers and applied on Production through Change management.
• Installed, authored, and managed reports using SQL Server 2005 Reporting Services (SSRS).
• Configured and maintained Database Mirroring and CTE.
• Implemented new topics like CLR integration on Development server.
• Maintained the database consistency with DBCC at regular intervals.
• Maximum performance and uptime in production environment.
• To set up SQL Server configuration settings to resolve various resource allocation & memory issues for SQL Server databases and to setup ideal memory, min/max server options.
• Created Documentation for steps need to be taken while upgrading the SQL server 2005 to SQL server 2008.

Environment: SQL Server 2005/2008, Windows 2003, QNXT, Care Advance, Biz Talk, Crystal Reports, SSRS, SSIS, Visual Basic, .NET, ADP Pay Roll.

Confidential, River woods IL

SQL Server DBA

Responsibilities:

• Worked on Migration from SQL Server .
• Installed SQL Server 2000/2005 on Stand Alone and Clustered Environments on Windows 2000/2003
• Scheduled Backups of databases and recovered them periodically to verify integrity of Backups.
• Migration of DTS packages to the SSIS on SQL Server 2005.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc) and loaded the data into target data sources by performing different kinds of transformations using SSIS.
• Worked in evaluating various high availability technologies such as Log Shipping, Clustering and Database Mirroring.
• Restricted developer access to production database servers by creating different users and logins on different databases.
• Re-architected numerous existing databases for increased performance and scalability
• Wrote complex T-SQL Scripts for generating reports.
• Wrote stored procedures and designed triggers.
• Generated reports using SSRS.
• Designed and developed OLAP Cubes using Analysis Services.
• Worked on OLAP and OLTP.
• Interacted with development and testing team and Configured Linked Servers.
• Involved in Importing and exporting of Databases using various techniques like BCP, DTS.

Environment: SQL Server 2000/2005 Enterprise Edition, Enterprise Manager, Management Studio, T-SQL,Windows 2000 & 2003 Server, DTS, SSIS, SSAS,SSRS, SQL Query Analyzer.

Confidential

SQL Server Developer

Responsibilities:

• Installation and configuration of SQL Server 2000 components.
• Created and maintained Databases, Tables, Views, Stored Procedures, Triggers, Functions and clustered and Non clustered Indexes using T-SQL statements.
• Designing and testing of Backups and Recovery strategies.
• Designed Logical and Physical Data Models using ERWIN and successfully transformed them into Physical Database.
• Troubleshooting, Monitoring and Tuning the MS SQL Server for optimum performance.
• Designing and managing SQL Databases.
• Developing SQL stored procedures views and triggers.
• Having experience onSANandRAIDlevels and building SQL Cluster servers on SAN Environments.
• Involved in performance tuning of the database and T-SQL queries
• Worked on DTS Packages.
• Designing, testing and implementing of DTS packages.
• Responsible to releases from development to test to production environments.

Environment: Windows 2000 Advanced Server/Server 2003, SQL Server 2000 Enterprise. ERWIN, SQL Profiler, SQL Query Analyzer, SQL Server DTS, Windows Performance Monitor.