SUMMARY

• Over 8 plus years in Database Architecture, Administration, System Analysis, Design, Development and Support of MS SQL Server 2008 R2, 2005 and 2000 in Production, Test, Development and Replication & 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, SQL Server 2005 and SQL Server 2008 R2.
• Worked on more then five Terabyte Database.
• Upgrading from SQL server R2 .
• Installed and maintained SQL Server 2008 R2 on production server and test servers.
• Experience in Database Backup, Recovery and Disaster Recovery (DR) procedures.
• Data migration using SSIS and DTS services across different databases like Oracle, MS access & 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 & 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 MS 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 & 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.

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL, C#, C++, HTML, XML, VB script

RDBMS: MS SQL Server 2005, 2000, MS-Access, Sybase, Oracle 9i.

Front End: MS Visual Basic, ASP, ASP.Net

Version Control Tools: Rational Clear Case, Visual Source Safe

Operating Systems: WindowsXP, Windows2000/2003 Advanced Server, Windows NT, UNIX.

Other Tools: OLAP, IIS, SQL Server Enterprise Manager SSIS, ERWIN 3.0, Reporting Services, Crystal Reports, Idera, Foglight, litespeed.

PROFESSIONAL EXPERIENCE

Confidential, Cleveland, OH

SQL Server Production Support DBA

Responsibilities:

• Managing SQL servers, databases and storage management.
• Installing and configuring new SQL 2005 and SQL 2008 R2 standalone and cluster servers.
• Migrating SQL Servers from old servers to new servers.
• Migrating all the servers from SQL 2005 to SQL 2008 R2 servers.
• Implemented the Data changes, Scripts and New Releases on the production servers.
• Working on Remedy for Ticketing, Incident Management system and Change Management.
• Monitoring SQL production servers using idera for errors, disk spaces, jobs ….etc.
• Installing service pack 1 for SQL Server 2008 R2 on all production servers.
• DB Refreshes from Production to Test and Development based on user requirements.
• Job Scheduling & Re-Scheduling on Production Databases.
• Performance Monitoring on Production Databases as and when required.
• Participated in migration and implementation planning.
• Involved in preparing documentation for migration and implementation.
• Resolved the trouble tickets as soon as possible.
• Interacting with the users and troubleshooting the problems.
• Maintained more than 5 TB size databases.
• Implemented log shipping between production and DR servers.
• Worked on litespeed logshipping between production and DR servers.
• Configured and worked on different DR strategies with Logshipping, Mirrioring, Replication and Clustering.
• Created and configured the link servers.
• Created new logins, users and groups.
• Implemented and maintained database security.
• Managed security issues in production, testing and development environments.
• Worked on FTP FileZilla for transfering large size databases and trans logs.
• Helped the development team in deploying and testing the application, which uses SQL Server as backend.
• Working on the Tickets assigned to SQL database Queue related to application databases.
• Worked and resolved the high priority tickets.
• Executing and Scheduling the DTS and SSIS Packages based on user requests
• Providing 24/7 On-call Support.

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

Confidential, Addison, TX

SQL Server Production Support DBA

Responsibilities:

• Installing new SQL 2000, SQL 2005 and SQL 2008 servers.
• Upgrading SQL 2000 to SQL 2005 Servers and SQL 2005 to SQL 2008 Servers.
• Migrating the SQL Servers from old server to new servers.
• Managed to migrate the databases from one datacenter to another datacenter.
• Upgrading the existing servers with Service Packs, and applying Patches and Hotfixes.
• Working on the Production Servers using Remedy for Ticketing and Incident Management system 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.
• Performance Monitoring on Production Databases as and when required.
• Implemented the Data Changes, Scripts and new Releases onto the Production servers.
• Participating in SAN Migration, DCC Migrations and OS Patching as per Change Management Schedules.
• Production to Test and Development DB Refreshes based on user requirements.
• Interacting with the users and troubleshooting the problems.
• Maintained more than one TB size databases.
• Helped Development Team in deploying and testing the application, which uses SQL Server as backend.
• Configured and worked on different DR strategies with Logshipping, Mirrioring, Replication and Clustering.
• Created linked server to transfer data.
• Configured data mirroring on databases from one server to another server.
• Implemented log shipping between production and DR servers.
• Configured and worked on litespeed backups.
• Created new users, groups and logins.
• Managing Security issues in production, testing and development environments.
• Providing 24/7 On-call Support.

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

Confidential, Bellevue, WA

SQL Server Production Support DBA

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 than 2TB size databases.
• Installed and maintained Litespeed for taking large size batabase backups.
• Migrated large size databases from one 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 DB 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 & 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.

Confidential, Jacksonville, FL

SQL Server Production Support DBA

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 & Re-Scheduling on Production Databases.
• Executing and Scheduling DTS and SSIS Packages based on user requests.
• Using DTS & T-SQL for Data loads & Transformations.
• Interacting with the users and troubleshooting the problems.
• Production to UAT and Development DB 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 & 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.

Confidential, Saint Paul, MN

SQL Server Production Support DBA

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, including 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.
• Actively 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 including 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,, 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, MS Access, ERWIN 3.0, Unix.

Confidential, Raleigh, NC

SQL Server Production Support DBA

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 & 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 including 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.

Confidential, Boston, MA

SQL Server Production Support DBA

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.

Confidential

SQL Server DBA

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 DB 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 such as reports, and communicate changes to application.
• Provided 24/7 Supports for Production, Development & 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, MS Access, MS Excel, ERWIN 3.0.