SUMMARY:

• Around 9 years of experience in teh IT industry spanning teh Database Analysis & Design, Development and Support of MS SQL Server 2008, 2008 R2,2005, 2000, and 7.0 in Production.
• Extensive Experience in MS SQL Server 2005 and 2000, Database Administration including Planning, Installation, Deployment / Implementation and configuration
• Experience in Migration of MS SQL Server 2000, MS SQL Server 2005 to MS SQL Server 2008.
• Played a key role in business requirements analysis, architecture design, physical and logical Data modeling, application development, testing,, production support and Project review with client.
• Scheduled and monitored all maintenance activities including database consistency check and index de fragmentation.
• Excellent in DTS package development and implementation.
• Experience in Web Application Supporting.
• Extensive experience in Installation, Configuration and Upgrading of MS SQL Server, Client Software and related products for Production, Development and Test Environment.
• Expertise in Table Partitioning.
• Expert in handling sub reports in SSRS
• Expert in installation, upgrade and configuration of MS SQL Server and databases in clustered and unclustered environments.
• Expert in writing parameterized queries and generating formatted reports using Microsoft Reporting Services
• Extensive experience in space allocation, database migrations and database security.
• Extensive experience in writing Complex Stored procedures as well analyzing and debugging existing complex stored procedures.
• Experience working with Windows 2003/2008 Advanced Server - Administration and Installation.
• Experience in Installing and Configuring Cluster SQL Servers in Active/Passive or Active/Active in SQL server /2008.
• Expertise in MS SQL Server databases backup/restore, Disaster recovery strategies
• Extensive experience in Capacity planning, Performance Tuning and troubleshooting.
• Experience in using Native Tools for Performance Monitoring and Tuning of MS SQL Server 2000
• Planning and Implementing teh Replication of MS SQL Server Database successfully Configured Transactional replication using MS SQL Server 2000/2005/2008 R2.
• Experience on Maintaining teh VeryLargeDatabases on Production Environment, Cleansing, andPerformanceTuning.
• Expertise in Optimization of T-SQL procedures, removing teh deadlocks, Client/Server Connectivity, Database Consistency Checks using DBCC Utilities.
• Proficiency in other RDBMS like Oracle and MS Access and languages like PL/SQL, VB, VB.net, and C++. Java
• 24 X 7 Production Database On Call Support.
• Strong Communication and Time Management skills and excellent team player.
• Ability to adapt quickly to changing environments.Application Areas
• Expert in writing and debugging complex XML Based stored procedures, Functions, Views and DML/DDL Triggers.
• Experience with DTS, SSIS, SQL Server Reporting Services.
• Setting up Replication on MS SQL Server 2005, 2008, 2000 and 7.0 using SQL Server Replication.
• Setting up Log-Shipping on MS SQL Server /2008.
• Installed, configured and maintained MS SQL Server 7.0/ 2000/2005/2008 on Windows NT & Windows 2000 Server.
• ODBC/OLEDB/Windows API’s used for Data Access, Connection Pooling.
• OLAP Data Warehouse

TECHNICAL SKILLS:

Languages: T-SQL, ASP.NET, VB6.0, VB.NET, C#. NET, ASP, JavaScript, VBScript, XML, COBOL, JCL, DB2, VSAM

Databases: MS SQL Server 2008, 2005, 2000, Oracle, MS-Access

Operating Systems: Windows 2003, 2000, Advanced Server, Windows NT 4.0/3.51Windows 3.x, Windows 9.x

Other Tools: MS OLAP, Crystal Reports, ERWIN 3.0, DTS, SSIS, SSRS, ETL, Performance Manager, IIS, Visual Interdev 6.0, MS OFFICE 2000

PROFESSIONAL EXPERIENCE:

Confidential

Sr.SQL Server DBA

Responsibilities:

• Involved in installation, configuration, and upgradation of MS SQL Server 2000/2005/2008 R2 servers.
• Involved in Database upgradation and Migration of SQL2000 to SQL2008R2 and co-ordinate all Upgrade activities.
• Involved in teh database migrations from physical to VM servers
• Involved in installation, configuration of SQL SERVER on VM Servers.
• Involved in comparing teh performance on both Physical and VM servers.
• Involved in Data modeling, designing and building Relational Databases
• Worked on SQL server clustering to provide an active and passive node, SAN storage with RAID 10 implemented on Dell servers, VIP pool to manage teh IP address of SQL servers.
• Configured SQL Mirroring, Log shipping and Replication
• Performed data transfers between various servers using BCP and SSIS for developer requests, Environment Migrations, Backing up and Archiving Data for various business requests.
• Exported and imported data from text files and Excel to SQL Server using bulk insert and BCP utility.
• Heavily involved in writing stored procedures with complex logic for both Reporting needs.
• Creating and managed schema objects such as Tables, Views, Indexes and referential integrity depending on user requirements and converting them into technical specifications.
• Security Administration by creating user logins with appropriate roles, dropping and locking teh logins, monitoring teh user accounts, creation of groups, granted privileges to users and groups.
• Backup and recovery of production databases and Monitor data and log growth, Jobs, Alerts, disk usage and cleanups using 3rd party tool Lite speed.
• Worked on backup and recovery strategies for SQL Server databases (e.g. Maintenance Plan, Native backups, Lite speed Backups and IBM TSM).
• Create linked servers to grant teh data access to teh users depending on teh needs.
• Optimize teh tempDB performance by striping and move to dedicated SAN.
• Involved in troubleshooting dead lock issues and performance issues for optimal performance. Used teh Index tuning wizard and rebuilt indexes for faster query response.
• Comprehensive noledge on high availability option log shipping (DR/Standby-server).
• Monitoring backup jobs daily and run teh jobs manually in case of failure depending upon teh necessity and prepared daily report on teh job failures, backup failures and disk space.
• Created various reports like charts, sub reports, graphs and scheduled these reports using windows task scheduler to run on daily, weekly and monthly basis.
• Perform database monitoring data and log growth, Jobs, Alerts, disk usage and cleanups, using various custom scripts in SQL Server Agent jobs, setup of Database Mail /operators for alerting.
• 24/7 Production support for SQL Server databases
• Performed documentation for capacity usage factor data validations and work summary for capacity usage factor calculations.

Environment: MSSQL Server 2000/2005/2008 R2, MS-Access, Windows 2000/2003/2008, DTS/SSIS, SSRS 2005/2000, SSAS, Visio, Lite speed, VSS 6.0, Erwin, SQL Diagrams, Fog light. Indextuningwizard, SQLProfiler, Query Analyzer, Enterprise Manager.

Confidential .

Sr.SQL Server DBA

Responsibilities:

• Worked on SQL SERVER 2008/2005 Production Environment.
• Worked on SQL server clustering to provide an active and passive node, SAN storage with RAID 10 implemented on Dell servers, VIP pool to manage teh IP address of SQL servers.
• Provided support to resolve complex issue for production databases.
• Migrated databases from SQL Server 2005 to SQL Server 2008 which was planned during teh maintenance window.
• Worked on Massey import of data to servers once received from teh client.
• Providing Capacity Planning for handling user load in distributed environment.
• Setting up database Backup and Recovery procedures for production, stage and development servers.
• Performed Backups using a third party tool SQL Back Track.
• Resolved Space issue on production servers by implementing TEMPTEMPeffective methods.
• Create database maintenance plans and active directory for teh performance of SQL Server including database integrity checks, update database statistics, reorganizing, re-indexing and data backups for Database optimization and Disaster recovery in production and non-production environment.
• Configured Replication methods like snapshot replication, transactional replication and Merge replication for Read write with all Read-only’s.
• Creating teh users, user groups and maintains teh access permissions.
• Configured SQL Security features and maintained teh user administration.
• Worked on SQL Database mail and configured it. Maintained and Created SQL server jobs.
• Constantly monitoring SQL Server Logs to ensure whether teh backup operations, batch commands, scripts and TEMPhas completed successfully.
• Monitored and modified Performance using execution plans and Index tuning, store procedures by getting information regarding teh CPU, memory and Disk utilization.
• Created traces files using Profiler for all Read-only’s and load them into databases using functions for analysis of long running queries and also monitored store procedures.
• Checking Database Health by using DBCC Commands, DMV’s and DMF’s.
• Created SSIS packages for loading teh data to a particular database and also created SSIS package to manage teh VIP pool IP addresses.
• Worked on creating reports using SQL server Reporting Services (SSRS).
• Configured Reporting Services configuration manager and IIS manager to enable teh Email setting so that reports can be subscribed to teh customer for referral.
• Created Reports on SQL server 2008 and 2005 for managing teh jobs failed on server’s instances and etc.
• Participated in project team activities prior to release and contributes to documentation requirements consistent with methodology.

Environment: Windows 2003 and 2008, SQL Server 2000/2005/2008 with clustering, Replication, Log shipping T-SQL, Migration, SQL Back Track, Query Analyzer, SQL Profiler, Database tuning Advisor, DTS, SSIS, SSRS, IIS Manager, Tree-Size.

Confidential, Bellevue, WA

Sr.SQL Server DBA

Responsibilities:

• A 24/7 production SQL Server DBA responsible for all production, development and QA SQL servers, both clustered and stand alone.
• Involved in Data center migration.
• Migrated databases from SQL Server and
• Installed, configured and maintaining SQL databases on Windows cluster.
• Ensure disaster recovery and business continuity for all database related infrastructure components.
• Performed database tuning and performance monitoring, performed general technical troubleshooting and give consultation to development teams.
• Scheduled Full, Differential and Transactional log backups for teh user created and system databases in teh production environment using Quest LiteSpeed tool.
• Used Quest Lite speed to implement Log shipping at teh remote site for production databases.
• Created transactional Replication, configuration and monitoring teh replication between two sites, generated scripts for automation, for creating publications, articles and running teh snapshot agent job, so that teh same scripts can be used from system test to production.
• Identify deadlock, blocking scenarios and Perfrom Reindexing and Index defrag operations for teh maintenance of Large tables to resolve performance issues.
• Setting up and configuring Database Mirroring in SQL Server 2005.
• Used Encryption for Security of SQL Scripts for protection against unauthorized access of various codes like stored procedures, views and user defined functions.
• Developed SSIS packages to load data from heterogeneous databases.
• Troubleshooting SSIS packages and SSRS reports issues
• Developed Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by using SSRS.
• Monitored teh use of disk space usage, memory and connections.
• Monitored Databases for lock escalation, dead Lock, resource utilization by sessions, package caching, buffer pool hit-ratios, Captured long running SQL/runaway queries using SQL Server profiler & performance monitor.
• Installed and configured Quest Performance Analysis to monitor teh SQL servers.
• Running DBCC consistency checks, and fixing data corruption in application databases.
• Involved in developing a number of Stored procedures, UDF’s, Triggers and Views using SQL Server 2005
• Fine tuned Stored Procedures using Execution Plan in T-SQL for better performance.
• Creation and monitoring of all SQL tasks (DTS packages) and scheduled daily jobs using Agent Scheduler both through Enterprise Manager and code in Visual Basic. Includes implementation of necessary batch processes for periodic updates.
• Provide support to application Users and Developers.
• Documentation for best practices, policies, procedures and standards.
• Interact with All teams like Business Analyst, Development Team, Testing team, Configuration Management Team and Project Management.

ENVIRONMENT: MS SQL Server 2000/2005/2008, SSIS, SSRS, Windows 2003/2008 Advanced Server, MS Access, UNIX,VB script, XML, Data Ware housing, Erwin 7.0, Quest Performance Analyzer, SQL Sentry, Quest LiteSpeed, Visual Basic 6.0.

Confidential

Sr.SQL Server DBA

Responsibilities:

• Designed and Maintained databases, performed software installations and upgrades, monitored database performance, performed capacity planning and SQL Server clustering, managed database quality assurance including database consistency check.
• Responsible for Maintaining and managing multiple instances of SQL Server.
• Worked on Client/Server tools like SQL Server Management Studio, SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Involved in setting up New server builds and their configuration settings.
• Involved in Migration of SqlServer 2000 to SQL Server 2008
• Responsible for installation and configuration of SQL Server 2008, 2005 and SQL Server 2000.
• Installed SQL Server service packs based on teh errors and flaws that are found in teh application.
• Created and managed SQL user logins, database user accounts, server roles, database roles and its permissions.
• Perform and schedule DBA administration tasks like Backup, Restore Database, Retrieve logs, monitor performance and create users.
• Scheduled Full and Transactional log backups for teh user created and system databases in teh production environment using Database Maintenance Plan Wizard and LiteSpeed Third party tool
• Creating Backup strategies and scheduling them for execution.
• Involved in Database design for logical and physical model using Visio tool.
• Eased administrative work through automatic script performing daily/weekly backups.
• Developed and created data dictionary, stored procedures, advanced queries, triggers, views, indexes, and functions for database.
• Created and developed teh stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Migrated objects from SQL Server 2000 to SQL Server 2008.
• Implemented and maintained Log Shipping for DR server.
• Configured Database Mirroring is SQL Server 2005.
• Configured windows Clustering (Active/Active) on various servers to maintain data Availability and Server up and running.
• Transferred data from Flat files, Excel spread sheets and heterogeneous data to and from SQL Server using DTS and also used BCP and Bulk insert.
• Involved in Configuring Replication to maintain teh data consistency between teh servers.
• Troubleshoot databases and custom application issues.
• Involved in Analysis and Reporting Phase of teh project.
• Conducted Performance tuning/MS SQL server development - SQL Profiler and PerfMon, SQL scripts, stored procedures, triggers, functions and transactions analysis, thorough understanding of indexes and statistics (Query Optimizer).
• Created Database Maintenance Planner for teh Performance of SQL Server which covers Database Integrity Checks
• Worked with SQL Server Profiler to generate traces
• Query Tuning and optimization through T-SQL.
• Monitoring SQL Server activity through profiler.
• Performance Tuning using SQL profiler and windows performance monitor of SQLServer and Monitoring SQL Server activity through profiler
• Optimized teh performance of queries with modification in index system for online system.
• Used DBCC commands to Troubleshoot issues related to database consistency
• Dropped and recreated teh indexes on tables for performance improvements
• Generated various reporting services RDL’S using reporting services (SSRS) for Market Insight.
• Involved in creating and maintaining Cubes using Analysis services (SSAS).
• Created teh DTS interfaces to vendors in which records were loaded daily, also to other data resources such as Excel, Access, flat file, XML in order to create and maintain a centralized data warehouse.
• Configured and managed Server Alias and Linked Servers between SQLServers, Oracle databases.
• Reduced systems downtime risk through automatic offsite backup and recovery over network.
• Responsible for database security of teh operational and developmental application system databases.
• Managed teh granting of access to operational and developmental application system databases.
• Maintained VLDB up to 2 Terabytes of database
• Involved 24/7 On call support

Environment: SQL Server 2008/2005,SQL Server 2000, Windows 2003, MS Access, JavaScript, Java, JSP, Microsoft Visio 2000, Visual Studio 6.0, ASP.Net, C#, VB 6.0,Lite Speed.

Confidential

SQL Server DBA

Responsibilities:

• Worked with tools like SQL Server Management Studio, SQL Server Enterprise Manager and Query Analyzer to Administer, Maintain.
• Managed multiple instances of SQL Server on a Failover Cluster
• Involved in creating database Objects like Tables, Stored Procedures, Views, Triggers, Rules, Defaults, user defined data types and functions.
• Involved in Migration of SqlServer 2000 to SQL Server 2005
• Database capacity planning and Space forecasting.
• Used Erwin Data modeling tool to design Database Schema and perform validations on existing Databases using Data Validator.
• Database troubleshooting and raising Service request s with MS support and applying patches
• Migrated DTS packages from SQL Server 2000 to SQL Server 2005 as SSIS packages.
• Setup Database Mirroring in SQL Server 2005.
• Configured Transactional Replication between Primary Server and Read-Only servers with separate Distributed server and experience in troubleshooting replication problems.
• Advanced Tuning for SQL Server Transactional replication.
• Configured Active/Active clustering on different servers for data Availability and Server up and running.
• Helped Development team in Deploying and testing application with SQL Server 2005 as backend.
• Responsible for changed management maintenance: created Stored Procedures scripts, cursors for teh applications, tested them on teh test server and moved them to production.
• Creating Backup strategies and scheduling them for execution.
• Writing Scripts for monitoring and alerting team through Email and Pager using SQLmail and Customized extended procedures.
• Generated various Report models on Views (due to security issues) and deployed them on to teh production reporting server and generated various Report models and ad-hoc reports.
• Developed daily, weekly, monthly reports and delivered reports to required users.
• Created and managed transaction replication scripts to re create teh replication if required.
• Created Documentation to install Sql server, apply service pack, hot fix on production, Development, testing environments.
• Monitor and troubleshoot ETL jobs daily using BCP, DTSRUN
• Security User Management, Privileges, Roles, Auditing, Profiling Autantication.
• Generated test data and tested new databases consistency with existing databases to meet teh functionalities requirement. Created jobs, alerts, activity logs, error logs to capture any possible errors.
• Development of automated daily, weekly and monthly system maintenance tasks such as Database backups, replication verification, database integrity verification and indexing updates.
• Daily monitoring of Database performance and SQL Jobs and bottlenecks of SQL Server including network related issues with SQL Server.
• Performance Tuning, Analyze, tuning and optimizing for SQL Server Application by using performance monitor. Assist teh SQL Developers in SQL tuning.
• Optimized teh performance of queries with modification in index system for online system.
• Performance tuning and optimization of procedure and queries.
• Worked with SQL Server Profiler to generate traces.
• Used Diagnostic Manager from Idera solutions for monitoring SQL Servers
• Had good experience in 24/7 Production support.
• Maintained VLDB up to 13 Terabytes of database

Environment: SQL Server 2000/2005 Enterprise Edition, Windows 2000 Advanced Server/Windows 2000 Server, HP Proliant Dl585 server, Idera Diagnostic Manager, Lite speed.

Confidential

Sr.SQL Server DBA/Developer

Responsibilities:

• Design/Build Extract Transform Load procedures in SQL Server 2000 using DTS packages to import/export data feeds to/from data warehouse and claim systems.
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000.
• Worked with Client/Business Analysts to define data requirements for reporting warehouse and disability claim systems import data feeds.
• Designing and building data load procedures, using MS SQL Server.
• Wrote DTS ActiveX scripts that extract data from database tables and write teh data to text files.
• Created SQL server Reports using SSRS.
• Configured product meta-data tables to support client data reporting needs.
• Performance: Analyzed database performance with SQL Profiler and Optimized indexes to significantly improve queries.
• Data migration using BCP and DTS from Oracle/MS Access databases and flat files.
• Maintained databases, performed software installations and upgrades, monitored database performance, performed capacity planning and SQL Server clustering, managed database quality assurance including database consistency check.
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Worked on Stored Procedures and Database Triggers. Worked on large number of business analytical functions.
• Installation of Security Patches & preparing environment as per requirement like DUT, DIT and SIT.
• Expert in troubleshooting by trapping events using SQL Server 2005 Profiler.
• Exposure to Configuring IIS 5.0 / 6.0, Creating Virtual Directory, Modifying Web.Config & App.Config files.
• Fine-tuned teh logic in Procedures, Functions and Triggers for optimum performance.
• Created SQL reports, data extraction and data loading scripts for different databases and schemas.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and Stored Procedures.
• Identify, resolve and provide solutions to different kinds of performance issues of Database
• Create users, roles and profiles
• Daily work involves checking of archive logs, alert logs, space issues of tablespace, traditional backups and tape drive backups, SQL tuning and generating reports
• Use of software’s like Core Ftp and Leach Ftp and VNC viewer to connect to remote desktops
• Data synchronization and quality control of database
• Use SQL*Loader to dump data and check data consistency on standby server
• Generate stats pack reports to identify bottlenecks
• Provide Oracle database administrative supports for teh application
• Provide 24x7 on call production support
• Understanding of Oracle Tools with working noledge of SQL* Plus and PL/SQL
• Provide good support to deliver teh result as per client specifications

Environment: SQL Server 2000/2005, Windows 2003, VB 6, Transact-SQL, Oracle (8i/9i), PL/SQL scripting VBScript, Java, J2EE, IIS 6.0, Erwin, Crystal Report, Microsoft Visio 2000, Active X, .Net, ASP, Source Depot, MS-Excel, Windows 2000/NT/XP, UNIX Shell Scripting, SQL*PLUS, TOAD, Erwin 4.1

Confidential

SQL Server Developer/DBA

Responsibilities:

• Worked on upgrading SQL Server 7.0 to SQL Server 2000.
• Designed, implemented, and administrated databases in SQL Server 2000.
• Maintained databases, configured permissions, and conducted backup and recovery
• Developed stored procedures, advanced queries, trigger, views, and indexes by using T-SQL.
• Responsible for tuning data, indexes, and queries.
• Automated and enhanced daily administrative tasks, including space management, backup & recovery and performance monitoring.
• Created alerts and notifications for system errors, insufficient resources, fatal database errors.
• Design and implementation of Performance Tuning and Maintenance plan for consistency checks, backup/restore and Indexes.
• Installed MS SQL Server Active/passive Cluster Server and configured SQL Server 2000 on Windows 2003 Advanced Server.
• Scheduled and monitored all maintenance activities including database consistency check, index defragment.
• Used SQL Profiler for troubleshooting, monitoring, tuning of SQL Server and SQL code
• Wrote DTS ActiveX scripts that extract data from database tables and write teh data to text files.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Involved in performance tuning using indexing (Cluster Index, Non Cluster index) tables.

Environment: SQL Server2000, SQL Server 7.0, Windows 2000/NT, Excel, Access, Java, J2EE, Oracle 9i, Microsoft Visio 2000