SUMMARY

• 8+ years of Administration, Data Architect and Development using SQL server 7.0/ 2000/20 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.
• Migrating from SQL Server 2000 to SQL Server 2005 by In - place upgrade process and as well as side-by-side upgrade process.
• Installed and administered two node Active/Active cluster on MS Windows Server.
• Implemented side by side Migration of MS SQL server /2008R2 and applied Patches and Service packs to update different versions of MS SQL server.
• Extensively worked on 32 bit and 64 bit clustered and standalone server environments.
• Configured more than 2 GB of RAM on 32 bit clustered and standalone environments.
• Handled up to 700GB Size databases in clustered and Log shipping environment
• Good at SQL Server 2008 new features like Policy Based Management, Data Compression, Resource Governor, Performance Data Collector
• Transparent Data Encryption (TDE), Object Search, Object Explorer Details, Activity Monitor, Multi Server Query, Intellisense in Query Editor and T-SQL Debugger.
• Experience in migration and maintenance of data using various utilities like DTS, SSIS, Import and Export, ATTACH/DETACH Data Migration tools.
• Expertise in RDBMS S/w Installation, applying patches, upgrading, configuring, managing, monitoring disk space usage
• Database integrity/consistency and troubleshooting of SQL Server 2008 R2/05/00 on Windows 2008/03/00 servers built on Clustered & stand alone servers.
• Expertise in implementing and setting up DISASTER RECOVERY and HIGH AVAILABLITY solutions like Log Shipping, Mirroring and Replication ( Transactional and Snapshot Replication )
• Experience in creating and deploying the CUBES in BIDS with Fact and Dimension Tables using different data warehouse styles (star and snow-flake schema).
• Explicitly used third party tools like Litespeed, Fog light and Red gate.
• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities and DMVs and DMFs.
• Creating SSIS Packages using Complex Tasks like ActiveX script task, Fuzzy Lookup And fuzzy Groupings.
• 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, Recovery, Linked Servers, Database Maintenance Planning.
• 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.
• Creating SSIS Packages and involved in Package configurations and deployments between Development and QA and Production servers.
• 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.
• Configuration and Administration of Share Point 2007.
• 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/20 R2, Access, Oracle9.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,ASP.NET

ETL Tools: DTS,SSIS,Informatica

Tools: Microsoft Office SharePoint Server 2007 (MOSS 2007), Windows SharePoint Services 3.0 (WSS 3.0), MS Office 2000/2003, MS Excel 2000/XP/2003, MS Outlook 2000/2003, Erwin, MS Visio.

Backup and Monitoring Tools: VERITAS Net Backup, Litespeed, Spotlight, Fog light.

Operating systems: Windows 95/98/Me/XP/NT/2000, Unix, DOS, Linux, Windows Server .

PROFESSIONAL EXPERIENCE

Confidential, Cincinnati, OH

SQL Server DBA

Responsibilities:

• Worked on Client/Server tools like SQL Server Management studio (2000), SQL Server Enterprise Manager (2008R2) and Query Analyzer to Administer SQL Server.
• Migrated SQL server 2000 databases into SQL server 2008R2 databases by In-place upgrade process and also used upgrade advisor tool in up-gradation.
• Migrated DTS packages into SSIS packages.
• Configured Transactional replication on migrated server.
• Involved in the migration of SQL Server 2000 databases to SQL Server 2008R2.
• Installed, authored, and managed reports using SQL Server 2008R2 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.
• 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.
• 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 on enhancing the application specific data sources and added new fields according to the requirement.
• Successfully applied schema change scripts to existing objects to synchronize with changing business rules.
• Creating and implementing 2008R2 concepts like DMV’s, DMF’s, Data partitioning, online indexing.
• Configured more than 2 GB ram on 32 bit Environment.
• Tuned stored procedures by adding the try catch blocks for error handling.
• Removed excess indexing by using the index include clause.
• Implemented the online indexing on 24X7 environments.
• Created the documentation for issue diagnostics reports.
• Migrated data to new location using Snapshot Replication, and implemented Transactional Replication to support up to date record of Inventory Information.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedure.
• Involved in DATA Analysis like Analyzing and Accessing collection of Data.
• SQL and PL/SQL Performance Tuning and Identifying SQL and PL/SQL bottlenecks using PL/SQL Profiler (package DBMS PROFILER), Explain Plan, Auto trace, TKPROF and tuned them to suit SLA.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• 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.
• To implement all database development enhancements to multiple SQL Server databases to ensure a flawless functioning of production environment.
• To perform installations & performance tuning, manage capacity planning & user accounts, and implement database security for multiple instances of development, certification, QA, and production SQL Servers databases.

Environment: SQL Server 2000/2005 with clustering, Replication, T-SQL, Windows bit, SQL/PL SQL, DTS, SSIS, Profiler, Litespeed.

Confidential, St Louis, MO

Technical Database Administrator

Responsibilities:

• SQL Server bit Failover Cluster Installation on Windows Server bit.
• SQL Server 2008 Installation.
• Writing batch scripts to do automation of database tasks.
• Writing scripts to manage different servers for auditing purpose.
• Running packages as for system promotion requirements.
• Solving Memory Problem related with SSIS Packages.
• SQL Server Analysis Services 2000 installation and Reporting Services 2005 installations on existing SQL Server Instances and SQL Server 2005 installations.
• Performance tuning on different Production Servers.
• Extensively worked on Dynamic Management Views (DMV’s) and Dynamic Management Functions (DMF’s).
• Running profiler to troubleshoot Blocking issues, Deadlocks issues and Slow running Queries.
• Implementation of SQL Principle, Securable, Permission, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Solving memory related problems by changing server configuration settings.
• Rebuilding indexes with different fill factors and update statistics manually.
• Building Maintenance plans for database maintenance.
• Writing stored procedures as for business requirements.
• Backup and Restore databases.
• Moving Tempdb to different file location.
• Shrinking the data files as the space requirements.
• Effectively used PL/SQL advance features like collections, ref cursors, dynamic sql and bulk loading.
• Managing users and security.
• Managing schema objects, such as tables, indexes, and views.
• Making database backups and performing recovery when necessary.
• Involved in database development by creating Oracle PL/SQL Functions, Procedures, Triggers, Packages, Records and Collections.
• Used Team Foundation Server 2010 for maintaining source control, data collection, reporting, and project tracking
• Involved in Configuration and Administration of Share Point 2007 environment.
• 24 X 7 Production Database on Call Support.

Environment: SQL Server 2000/2005, T-SQL, Windows 2003/2008 Server, Team Foundation Server 2010, Oracle 10g,Vb.net,Asp.net.

Confidential, Atlanta, GA

SQL Server DBA

Responsibilities:

• Managed and Administrated SQL SERVER 2008/2000 on highly transitive Production environment and Installed and setup SQL Server 2008 instances on clustered environment.
• 24x7 production support SQL server 2008 Database administration
• Implemented SIDE BY SIDE Migration of MS SQL SERVER /2008 on Windows.
• Implemented Transactional Replication on MS SQL server 2008 as a part of disaster recovery strategy
• Applied Service packs and patches and hot fixes on clustered nodes
• Migrated DTS 2000 PACAKGES to SSIS packages and maintained the archival data using Control flow task.
• Configured the AWE and /3 GB switch for the 32 bit 2005 server.
• Applied Patches and Service packs to update different versions of MS SQL SERVER.
• Fixed the failed PRINCIPALS (logins), user permissions and security in ACTIVE DIRECTORY and SQL SERVER LEVEL.
• Implemented the new SQL Server 2005 concepts like Data partitioning, Snap shot Isolation, Database Snapshot, DDL triggers, Try-Cache blocks
• Online Indexing, DMV’s, DMF’s, DTA,SQLCMD and dedicated admin connection, Common table Expression(CTE).
• Moved files between the File Groups and partitioned the tables to improve the performance.
• Extensively used litespeed backup with MS SQL SERVER 2005/2008.
• Utilized the new features of 2008 like TDE, MERGE STATEMENT and Compressed Backups.
• Managed multiple MS SQL 2008 RDBMS on Web-based, transactional platform
• Scheduled regular BACKUP JOBS and kept track of DATABASE by receiving the emails on Alerts.
• Documented and performed the data base health checks regularly.
• Created new tables, stored procedures and triggers IN T-SQL.
• Refactored and fine tuned the queries and stored procedures in TSQL.
• Used native tools like DATA BASE TUNING ADVISOR, PROFILER and ACTIVITY MONITOR for performance analysis.
• Created baseline and sampling intervals in the perfmon considering threshold values of the counters.
• Rebuilding indexes with different fill factors and update statistics manually.
• Implemented native log shipping for HIGH AVALIBLITY of the Production Server DATA BASE.
• Generated reports in SSRS using BIDS (Business Intelligence Development Studio)
• Rendered DRILL DOWN, STATIC reports in MATRIX form in SSRS
• Used SSIS packages to move data from dev to QA and QA to Production
• Generated reports in SSRS using BIDS (Business Intelligence Development Studio).
• Deployed SSIS package for bulk insert and maintained archival data.
• Handled monthly Database Refresh in QA-Test environment for testing of new Deployments and Build.

Environment: TSQL, MS SQL SERVER 2000/2005/2008, SSRS, QUERY ANALYSER, VISUAL STUDIO 2005, VB.NET,C#,WINOWS SERVER 2008,IIS

Confidential, Roanoke, Virginia

SQL DBA / Developer

Responsibilities:

• Database Administrator/Database Programming/Product specialist.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
• Extensively working on IMS performance issues like update statistics, rebuilding the indexes at regular intervals for better performance.
• Extensively worked on compliance issues.
• Wrote the packages using DTS in SQL2000.
• To analyze long running slow queries and tune the same to optimize application and system performance.
• Worked on key performance indicators for customizable metrics.
• To set up SQL Server configuration settings.
• Installed, authored, and managed reports using SQL Server 2000 Reporting Services.
• Monitoring SQL server performance using profiler to find performance and dead locks.
• Managed Disk space, memory and User connections.
• Rebuilding the indexes at regular intervals for better performance.
• Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Monitored and modified Performance using execution plans and Index tuning.
• Rebuilding the indexes at regular intervals for better performance.
• Managing the clustering environment.
• Using log shipping for synchronization of database.
• To setup, implement, and maintain industry standards in database management.
• Monitoring SQL server performance using profiler to find performance and dead locks.
• Monitoring the servers using spot light third party Quest software.
• Maintaining the database consistency with DBCC at regular intervals.
• Implemented Data Access Layer using ADO.NET to communicate With the MS SQL Server 2005 Database.
• Involved in developing user controls and asp pages.

Environment: SQL Server 2000 with clustering, T-SQL, Windows 2003 Server, Oracle, VB.Net and ASP.Net.

Confidential

SQL SERVER DBA/Developer

Responsibilities:

• Performance tuning of the SQL 2000 servers in order to reduce I/O and Memory contentions.
• Reviewed and offered recommendations for Database system configurations, responsible for tuning data, indexes, and queries as well as providing assistance on these areas to development teams.
• Troubleshoot SQL Server performance issues for internal and external customers.
• Monitored and tune databases, indexes, stored procedures and Server Performance using Performance Monitoring tools for Microsoft SQL Server 2000.
• Developed SQL Server Maintenance Plans.
• Automate and enhance daily administrative tasks, including space management, object alteration, backup & recovery and performance monitoring.
• Writing stored procedures and DTS packages for maintenance tasks in Production environment.
• Created Alerts and Notifications for system errors, insufficient resources, fatal database errors, hardware errors, security breach, etc.
• Export or Import data from other data sources like flat files using Import/Export of DTS
• Recovering the databases from backup in disasters
• DBA support for a development team customizing and testing new releases of client-server applications
• Analyze various aspects of Stored Procedures and performed tuned as needed to increase productivity and reusability of code.
• Written Tested and Documented Program code and implemented programs.
• Actively involved in hardware and network specification, installation and configuration, and participated in database design, architecture and SQL scripting.

Environment: SQL Server 7.0/2000, Windows 2000, Visual Basic 6.0, Oracle 8i, Erwin