Summary





Over 8 years in Database Architecture, Administration, System Analysis, Design, Development and Support of Sql Server 2005 and 2000 in Production, Test, Development and Replication and Cluster Server Environments.
Having solid experience in Production Support DBA.
Solid experience in RDBMS database design, installation, configuration, performance tuning, optimization, backup and recovery in SQL Server 2000 and SQL Server 2005.
Worked on more then 2 Terabyte Database.
Upgrading from SQL server 2000 to 2005.
Installed and maintained SQL Server 2008 on test servers.
Experience in Database Backup, Recovery and Disaster Recovery DR procedures.
Data migration using SSIS and DTS services across different databases like Oracle, Access and flat files.
Participated in SAN Migration, DCC Migrations and OS Patching as per Change Management Schedules.
Strong troubleshooting and organizational skill.
Implemented different types of Replication Models like Snapshot, Merge and Transactional.
Established Logshipping from production to DR servers.
Configuring and Automating SQL MAIL notification.
Transferring users and their related passwords to new server.
Identifying and resolving blocking and deadlocks.
Centralize all the databases and setup corresponding user security levels to make it possible for sharing the common data among different divisions.
Designing and documentation of SQL Server Strategies and plans.
Automating the Database Maintenance tasks by creating Jobs and Alerts.
Experience in working with both 32 bit and 64 bit server environments.
Proficient in using Profilers for both performance and auditing purposes.
Experience in other Databases like Access and Oracle 9i.
Worked on Performance Tuning, Query Optimization, Client/Server Connectivity and Database Consistency Checks using DBCC Utilities.
Optimizing SQL Server Performance and Health in multi-terabytes environment.
24x7 support and trouble shoot production issues on high availability system.
Excellent Team Building, Project Management, Analytical, Interpersonal and Communication Skills.
Hands on experience with SQL Server and T-SQL in constructing Tables, Triggers, Stored Procedures, User Defined Functions, Views, Indexes, Relational Database Models, Data Dictionaries and Data Integrity.
Hands on experience with SQL Server and T-SQL in constructing triggers, tables, user functions, views, reports, indexes, user profiles, relational database models, data dictionaries and data integrity.
Ability to learn and adapt to new technology and concepts quickly and create a systematic approach in working towards developing business solutions that increase company s efficiency, Productivity and profitability. Possess strong analytical, inter-personal and problem solving skills.


Employment

August, 2008 -  Present
Senior SQL Server Production Support DBA

Expedia is the worlds leading online travel provider, helping millions of travelers per month plan and book travel. Expedia aims to provide personalized service, the latest technology and the widest selection of vacation packages, flights, hotels, rental cars, cruises and in-destination activities, attractions and services. With the Expedia Best Price Guarantee, Expedia.com promises to offer to its customers the best rates available online for all types of travel, making it the most comprehensive customer guarantee in online travel.

Responsibilities :
Managing SQL servers, databases, storage management.
Installing new SQL Server 2000 and SQL 2005 Servers.
Upgrading SQL 2000 to SQL 2005 Servers.
Installed and maintained SQL Server 2008 on test servers.
Upgrading the existing servers with Service Packs and applying Patches and Hotfixes.
Participating in SAN Migration, DCC Migrations and OS Patching as per Change Management Schedules.
Configured and worked on different DR strategies with Logshipping, Replication and Clustering.
Maintained more that 2TB size databases.
Installed and maintained Litespeed for taking large size batabase backups
Migrated large size databases from 1 datacenter to another datacenter.
Worked on rocket stream.

Checking the Status of Servers, Drive Sizes, Backups, Backup Schedules, Data Base Maintenance Plans and Job Schedules on Application Databases with the help Foglight Alerts
Production to Test and Development Database Refreshes based on user requirements.
Interacting with the users and troubleshooting the problems.
Created new users, groups and logins
Managing Security issues in production and test environments.
Performance Monitoring on Production Databases as and when required.
Working on the Production Servers using Remedy and E. Piphany for Ticketing and Incident Management and Change Management.
Capacity to resolve the Trouble Tickets As soon as possible.
Working on the Change Requests as per Change Management Schedules.
Working on the Tickets assigned to SQL database Queue related to Application Databases.
Interacting with the windows team to solve the system hardware issues.
Participated in Daily Meetings and weekly meetings with Database teams and with SQL Team
Implementing the Data Changes, Scripts and new Releases onto the Production servers.
Helped Development Team in deploying and testing the application which uses SQL Server as backend
Providing 24/7 On-call Support.

Environment : SQL Server 2005, SQL Server 2000, SQL Server 2008, PL/SQL, Windows 2000/2003 Advanced Server, VB Script, Oracle,, Excel, Visio, Access, ASP. Net and VB 6.0, ERWIN, ArcSDE9 .x, Enterprise Manager, Query Analyzer, DTS, SSIS, SSRS, Database Maintenance Plan Wizard, Foglight, Quest, Remedy, Citrix, VSS, Logshipping, Replication.

Washington Mutual Bank, Jacksonville, FL July 07 June08
Senior SQL Server DBA

Washington Mutual conducts business through 4 primary business lines : Retail Banking and Financial Services, Home Loans, Commercial Banking and Card Services. From checking accounts and online banking to personal loans, Washington Mutual's Retail Banking and Financial Services segment offers a comprehensive line of deposit and other retail banking products and services to consumers. The Retail Banking and Financial Services segment provides products and services to small businesses and assists them with payroll, cash management and retirement planning. Customers can take care of all their banking needs by walking in to their local financial center, calling telephone banking or visiting wamu.com.
Responsibilities :
Installing new SQL 2000 and 2005 Servers.
Upgrading the existing servers with Service Packs and applying Patches and Hotfixes.
Working on the Production Servers using Remedy for Ticketing and Incident Management TIMS and Change Management CM.
Worked on the Change Requests as per Change Management Schedules.
Worked on the Tickets assigned to SQL database Queue related to Application Databases.
Coordinating with the Offshore DBA Support Team on production support issues.
Participating in SAN Migration, DCC Migrations and OS Patching as per Change Management Schedules.
Job Scheduling and Re-Scheduling on Production Databases.
Executing and Scheduling DTS and SSIS Packages based on user requests.
Using DTS and T-SQL for Data loads and Transformations.
Interacting with the users and troubleshooting the problems.
Production to UAT and Development Database Refreshes based on user requirements.
Configured and worked on different DR strategies with Logshipping, Replication and Clustering.
Worked on different tools like Foglight, Lightspeed and Remady.

Checking the Status of Servers, Drive Sizes, Backup Schedules, Data Base Maintenance Plans and Job Schedules on Application Databases with the help Foglight Alerts
Implemented the Data Changes, Scripts and new Releases onto the Production servers.
Managing Security issues in production environments.
Performance Monitoring on Production Databases as and when required.
Contacting Database Engineering Team for escalated issues on Production Servers.
Participated in Weekly Meetings with Data base teams and Internal Meetings with SQL Team
Providing 24/7 On-call Support.

Environment : SQL Server 2005, SQL Server 2000, PL/SQL, Windows 2003 Advanced Server, VB Script, Oracle, DTS, SSIS, Excel, Visio, Access, Voyager 3.0, ASP. Net and VB 6.0, ERWIN.

August, 2006 -  July, 2007
Senior SQL Server Production Support DBA

Deluxe Corporation is the largest provider of checks in the United States. Deluxe Corporation, through its industry-leading businesses and brands, helps financial institutions and small businesses better manage, promote and grow their businesses. The Company uses direct marketing, distributors and a North American sales force to provide a wide range of customized products and services, personalized printed items checks, forms, business cards, stationery, greeting cards, labels and shipping/packaging supplies, promotional and merchandising materials, fraud prevention services and customer retention programs. The Company sells personalized checks and related accessories directly to consumers.

Responsibilities :
Installed and Configured SQL Server 2005 and also Upgraded the SQL Server 2000 databases to SQL Server 2005.
Managed the migration of SQL Server 2000 databases to SQL Server 2005.
Identified existing Server and Database Architecture environment and analyzed for server migration, all documentation process to support SQL 2005.
Administers, maintains, develops and implements policies and procedures for ensuring the availability and integrity of the database systems used by the development team.
involved with Backup/Restore Strategy team.
Working on different DR strategies with Logshipping, Replication and Clustering.
Implemented transactional replication for the availability of all data for all users in different locations.
Interacting with the users and troubleshooting the problems.
Performed daily tasks, backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent and Database Engine Tuning Advisor.

Resolves database performance issues, database capacity issues and other distributed data issues.
Increased the size of the database, transaction logs and database devices.
Participated in Migration of DTS Packages to SSIS Packages.
Migrated Users, User Authentications, Job and Job Schedules from DTS to SSIS.
Performed update on table with new columns and populated data using Joins.
Implemented log shipping between production and DR servers.
Created users, roles, groups.
Participated in SAN Migration
Implementing the Data Changes, Scripts and new Releases onto the Production servers.

Having work experience of Encryption
Optimizing and Tuning of SQL Queries.

Provides feedback, training and support to the quality assurance, production database and operations teams.
Interacting with the users and troubleshooting the problems.
Troubleshoot problems in real time with high pressure and ensure production support 24*7

Environment : SQLServer2005, SQLServer2000, PL/SQL, OLAP, DTS, ETL, SSAS, SSIS, Windows Server2003, Oracle, ASP, Excel, C#, Visual Basic, IIS, Visio, Access, ERWIN 3.0, Unix.

November, 2005 -  July, 2006
SQL Server Production Support DBA

Misys Healthcare Systems, a member of the Misys Group of Companies, develops and supports reliable, easy-to-use software and services of exceptional quality that enable physicians and caregivers to more manage the complexities of healthcare. Misys provides a variety of products that serve healthcare organizations of all sizes, electronic health records for ambulatory, acute and post-acute settings, departmental systems, practice management systems and EDI connectivity.

Responsibilities :
Monitor all corporate SQL Server Databases.
Monitor and manage transactional and snapshot Replication.
Creating stored procedures, scripts, cursors for the Bulk application, testing on the test servers and moving them to production.

Experience in Database Backup and recovery.
Created Replication strategies.
Managed Disk space, memory and User connections.
Working on different DR strategies with Logshipping, Replication and Clustering.
Managing databases for website.

Developed DTS Packages to transfer the data between SQL Server and other database and files.
Job Scheduling and Re-Scheduling on Production Databases.
Responsible for database creation, database tuning, performance planning and database administration.
Monitored and modified Performance using execution plans and Index tuning.
Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented.
Process Code Promotion Requests for QA, Staging and Production environments.
Configure and mange Server Alias and Linked Servers between SQL Servers, IBM DB2 and Oracle databases Configure and manage database maintenance plans for update statistics, database integrity check and backup operations.

Create and manage user accounts and track their activities as and when required.
Interacting with the users and troubleshooting the problems.
Assisted to create Disaster Recovery plans.

Manage data transfer between SQL Server and other heterogeneous databases, IBM DB2 and Oracle.
Providing 24/7 On-call Support

Environment : SQL Server 2005, SQL Server 2000, PL/SQL, Windows 2003 Advanced Server, VB Script, DTS, Oracle, SSIS, Excel, Visio, Access, ASP. Net, IIS and VB 6.0, ERWIN.

January, 2005 -  October, 2005
Summit Partner

Summit Partners is a leading private equity and venture capital firm. Since 1984 it has provided financing and growth opportunities to about 260 companies. It has an outstanding management team that has self financed companies to market leadership.

Responsibilities :
Installation and configuration of SQL Server 2000 Enterprise/Developer server editions.
Design and implement database Schemas.
Interacting with the users and troubleshooting the problems.
Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of User Support.
Maintenance plan check for database server.
Worked on Clustering environment.
Implemented log shipping between production and DR servers.
Restore strategy to replicate the databases on different servers.
Involved as part of a team for gathering and analyzing the needs of End User Requirement and Online System Specification.
Modified existing database by adding tables and relationships to support online system.

Communicating with Developers, QA Engineers and other Database Administrators to ensure smooth operational flow and problem resolution
Worked with Bulk Copy Program BCP and DTS to load text files to SQL Server.
Implemented log shipping between production and DR servers.
Optimized the performance of queries with modification in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes wherever necessary.
Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server and develop Distributed Queries.
Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing by using DBCC commands.
Helping application teams in query analyzing and its optimization. Coordinating with users for downtime and maintain the system 24X7 running.
Providing 24/7 On-call Support

Environment : MS-SQL Server 2000, PL/SQL, Windows2003 Server/NT/XP, Oracle, VBScript, MS-Excel, MS-Access.

July, 2003 -  December, 2004
SQL Server DBA

Towers Perrin is the 1 of the world's leading professional service firms. Towers Perrin provides experience to three-quarters of both the world's 500 largest companies and the fortune 1000 United States companies in a spectrum of management consulting areas, up to 20 percent of its business comes from advising corporate clients on how the can contain rising healthcare costs.

Responsibilities :
Installing, Configuring and Maintaining of SQL Server 2000.
Gathered functional requirements and business requirements and written the technical specifications for building the Global Enterprise Data warehouse.
Created database objects like tables, views, indexes etc using T-SQL.
Created and modified stored-procedures, triggers, cursors.
Wrote various Stored procedures for the purpose of application development.
Created DTS Packages to import and Export data from Excel spreadsheets, People soft and text files.
Created Packages and jobs to perform filtering operations and to import the data on weekly basis.
Transformed data from various data sources using OLE Database connection by creating various DTS packages.
Performed some DBA Tasks which included checking the job fails and troubleshooting the issues.
Involved in planning and administration of data migration and performance tuning to achieve cost efficiency and effectiveness of the system.
Worked directly with the Business Team to resolve issues, perform special requests like reports and communicate changes to application.
Provided 24/7 Supports for Production, Development and Test Servers of MSSQL Servers.

Prepared the detailed project layout, analyzed existing technology involved and documented work performed.

Good Experience with Query Analyzer and Enterprise Manager.

Environment : SQL Server 2000, SQL Server Analysis Services, PL/SQL, Windows Server 2000, Access, Excel, ERWIN 3.0.

April, 2002 -  June, 2003
SQL Server DBA

Installation, Configuration and Maintenance of Sql Server 2000.
Involved in Designing Logical and Physical of Customer Database.
Created and managed the Database Users, Login Ids and Security.
Converted various SQL statements into stored procedures reducing the Number of database accesses since Stored Procedures passes the whole block at 1 time.
Implemented and maintained database security.

Administrator tasks like managing users, roles and profiles.
Used DTS Packages for data import and export data from SQL Server to Access, text and EXCEL files.
Created Packages and jobs to perform filtering operations and to import the data on daily basis from the Oracle Database to SQL server. Worked as SQL Server administrator.

Configured Snapshot Replication Creating Distribution Databases, updating Publishers, creating and managing Publications, managing Replication monitors.
Did the database administrative job of Security, Backup/recovery, ODBC connections etc.,
Performed Database backups operating system, flat file backups and export/import.

Environment : SQL Server 2000, Oracle, Windows 2000/ NT/ XP, Access, Excel, VBScript.

February, 2001 -  March, 2002
SQL Server DBA

Education

Training

Microsoft Certified Database Administrator MCDBA
Microsoft Certified Professional in Windows Advance Server 2003
Cisco Certified Network Associate .


Skills


Languages T-SQL, PL/SQL, C#, C++, HTML, XML, VB script RDBMS Sql Server 2008, 2005, 2000, MS-Access, Sybase, Oracle 9i. Front End Visual Basic, ASP, ASP.Net Version Control Tools Rational Clear Case, Visual Source Safe Operating Systems WindowsXP, Windows2000/2003 Advanced Server, Windows NT and UNIX. Responsibilities : Involved in various stages like development, system Analysis and design and creating stored Procedures. Designed and developed Interfaces which were used for connecting to SQL Server database. Validated and coded the application using VB. Debugged and fixed the bugs. Designed the Logical and Physical databases of SQL Server. Performed database testing and maintaining the data by using the procedures. Designed and validated the forms according to client requirement by using VB. Imported and Exported database using DTS utility. Wrote SQL stored procedures to implement business logic. Developed and coded applications in PL/SQL. Designed a report on the monitoring of Server Performance using Task Manager and Perfmon. This report gives a detail report to the management on the Performance of the server. Maintained SQL Script for creation of Database Objects. Environment : Sql Server 2000, Word, Windows NT, Access, Excel, Visual Basic.