SUMMARY

• 12 Years of extensive experience in Information Technology, out of which 10 years as an SQL Server DBA SQL7.0/2000/ 2005/2008/2008R2 and 2012 in Production, Development and Test Environments under Windows platforms.
• Possess 6 years of experience in Database Design, Administration, Implementation, and Application Development.
• 24 X 7 Production Database On Call Support.
• Installed SQL Server Clusters in Active/Active and Active/Passive Topology.
• Installed SQL Server 2012 on Development/Test and Production Environments.
• Experience on migrating the database from SQL 2000 to SQL 2005/SQL 2008/2008 R2 and
• SQL 2012.
• Created Mirroring, Replication and Log shipping for different customers.
• Experience on using the AlwaysOn feature for SQL 2012.
• Installed SQL2012 on Microsoft Azure cloud environments.
• Backup and Restore VLDB databases using Veritas Netbackup, LiteSpeed, Data protector and Tivoli.
• 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.
• Experience in space allocation, database migrations and database security.
• Experience in Capacity planning, Performance Tuning, Disaster Recovery and troubleshooting.
• Extensive experience in backup and restore procedures.
• Expertise in creation and maintained of Procedures, Triggers and Functions.
• Extensive experience in Batch processes, Import, Export, Backup, Database Monitoring tools and application support.
• Experience in Installation, Configuration and Upgrading of SQL Server, Client Software and related products for Production, Development and Test Environment.
• Experience in SQL Server Reporting Services SSRS Installation and Configuration for Scale-Up and Scale-Out topology.
• Experience in controlling the user privileges, monitoring the security and Audit issues.
• Prepared Documentation for the Disaster Recovery plan.
• Worked on the more than 6 TB size.
• Experienced in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities
• Knowledge with HTML, XML, VB Script, Java Script, ASP, IIS, Java, website design, FTP, Telnet, uploading, software development life cycle.
• Proficiency in other DBMS like MS Access 2000/2003/2007 and languages like Visual Basic 5.0/6.0, and C .
• Strong Communication and Time Management skills and excellent team player.
• Ability to adapt quickly to changing environments.

SKILLS:

• Database : SQL Server 7.0/2000/2005/2008/2008 R2 and SQL2012.
• O/S : Windows NT/2000/2003/2008/2008 R2/2012 and Window 2012 R2
• Languages : SQL, T-SQL, ASP, HTML, VB, VB Script and .Net.
• Tools : VISIO 2000/2003, IIS, MS OFFICE 2000/2003, BMC Patrol, MOM, SCOM, Tivoli, Data Protector, Veritas Netbackup, LiteSpeed, Spotlight and Foglight.

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• 24 X 7 Production Database On Call Support.
• Installation of SQL 2008/2008R2 and SQL2012 servers for various applications.
• Installation of SQL 2012 on Windows Azure environments.
• Installed SQL Server Clusters in Active/Active and Active/Passive Topology.
• Upgrading the existing servers with Service Packs, and applied Patches and Hotfixes.
• Worked with the various teams to document, Install and configure Microsoft Dynamics AX, MCMS Microsoft Content Management Server , Microsoft Share Point Server.
• Configured Log shipping/Transactional Replication and Mirroring for the mission critical application.
• Migrated databases over 1TB from SQL 2005 to SQL server 2008 R2/SQL2012 with minimum down time.
• 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 TIMS and Change Management CM .
• Worked on the Change Requests as per Change Management Schedules.
• Manage and maintain database changes in Development, QA, Staging and Production
• Troubleshoot Blocking and Deadlocking issues by making appropriate changes to Transaction Isolation levels and the types of locks being held avoiding keeping transactions open for long durations, breaking large transactions to smaller ones.
• Create Maintenance planes for Database integrity checks and Index-rebuild on a Regular basis to maintain good database health.
• Installed and configured SSRS SQL server Reporting services and SSAS SQL Server Analytical Services
• Deployed SSIS SQL Server Integration Services Packages in SQL Server 2005/2008/2008R2 and SQL Server 2012.
• Scheduled Backup/Recovery jobs and developed Disaster Recovery Plans.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Monitoring database status including CPU, memory, I/O, space, and dead lock using SQL Server Utilities.
• Participated in disaster recovery exercises.
• Worked on archiving and shrinking of the old production data.
• Scheduling Full and Differential Database backups, and TLog Backups to disks, tapes or remote servers, using batch scripts, TSQL and Maintenance Plan Wizard and configure appropriate Recovery Model for the databases.

Environment: SQL Server 2000/2005/2008/2008 R2 and SQL2012, Windows 2000/2003/2008/2008R2/2012 and 2012R2 and Windows Azure,.Net 3.5/4.0,Remedy ticketing ,Solarwinds Orion, Backup Exec Symantec , SQL Litespeed, Foglight, Guardian and Spot Light, VB Script, Oracle 8i/9i and 10g, CRM, SSIS,SSRS,SSAS, MS Access, Siebel, IBM AS/400,Enterprise resource planning ERP ,Microsoft Dynamics AX and Hyperion.

Confidential

Responsibilities:

• Installed SQL Server 2012 on Development/Test and Production Environments.
• 24 X 7 Production Database On Call Support.
• Installed SQL Server Clusters in Active/Active and Active/Passive Topology.
• Remote Monitoring of SQL Server 2000/2005/2008/2008R2 and SQL2012.
• Migrated the existing Servers from SQL 2000/2005 to SQL 2008/2008 R2 and SQL 2012.
• Migrated databases over 6TB from SQL 2005 to SQL server 2008R2 with minimum down time.
• Create and manage SSIS, SSAS and SSRS from Lower level environments to Production Environments
• Configured AlwaysOn for SQL2012 Servers.
• Moved the data from iSeries to SQL Server databases by using IBM CDC Change Data Capture Software, Implemented Transactional Replication between Bank server to the Vendor servers.
• Upgrading the existing servers with Service Packs, and applied Patches and Hotfixes.
• Successfully implemented High-Availability solution in MS SQL Server 2000/2005/2008/2008R2 Cluster environment databases. Implemented disaster recovery for SQL Server Production Database as Fail-Over or Standby servers.
• Troubleshoot Blocking and Deadlocking issues by making appropriate changes to Transaction Isolation levels and the types of locks being held, avoiding keeping transactions open for long durations, breaking large transactions to smaller ones.
• Working on the Production Servers using Remedy for Ticketing and Incident Management system TIMS and Change Management CM .
• Participating in SAN Migration, DCC Migrations and OS Patching as per Change Management Schedules.
• Creating high availabilities like Mirroring, Replication and Log shipping for different Applications.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Scheduled Backup/Recovery jobs and developed Disaster Recovery Plans.
• Expert in Using DMV's, Performance dash board, Mirroring, database snapshot.
• Analyzed long running /slow queries and tune the same to optimize application and system performance.
• Involved in various projects from start to production deployment, guiding development team for efficient performance and planning capacity.

Environment: SQL Server 2000/2005/2008/2008 R2 and SQL2012,Windows 2000/2003/2008/2008R2 and 2012,.Net 3.5/4.0,Maximo IM, Tivoli, Visio, BMC Patrol, Veritas Net backup, SQL Litespeed, Foglight, Guardian and Spot Light, Repliweb, VB Script, Oracle 8i/9i and 10g, SAP, DTS, SSIS,SSRS,SSAS, MS Access, IBM CDC Change Data Capture Software,DB2 UDB and iSeries.

Confidential

Responsibilities:

• 24 X 7 Production Database On Call Support.
• Installed SQL Server Clusters in Active/Active and Active/Passive Topology.
• Performed Physical and Logical Data Modeling for databases of varied sizes including VLDBs. Designed and implemented capacity planning module to make future projections in terms of system resources
• Remote Monitoring of SQL Server 2000/2005/2008 and 2008 R2
• Migrated the existing Servers from SQL 2000 to SQL 2005/SQL2008 and SQL 2008 R2.
• Migrated databases over 1TB from SQL 2005 to SQL server 2008 R2 with minimum down time.
• Scheduled Backup/Recovery jobs and developed Disaster Recovery Plans.
• Performance Tuning of the SQL Server in OLTP, Web based, Production and Development environments including the usage of Performance Monitor and Profiler Trace to monitor the Memory, CPU and Disk usage, the private bytes of each process, the trend in the Available Bytes, Context Switches/sec, Page Faults, growth of Tempdb, Cache-Hit ratio, disk reads and writes, Avg. Disk Wait Times, Transactions/sec, Growth and Shrinkage of databases and other counters, and use Index Tuning Wizard to create proper indexes. Identified the performance bottlenecks like CPU, Memory, I/O and tuned and improved the overall performance of the server for many clients.
• Involved in Physical and Logical design and Schemas for databases of new application.
• Tuning of SQL Server Memory structures and troubleshooting the existing issues with Buffer Pool and Paging.
• Manage and maintain database changes in Development, QA, Staging and Production
• Creating high availabilities like Mirroring, Replication and Log shipping for different Applications.
• Configured database mail, Linked server and database mirroring as per the application requirement.
• Batch programming, stored Procedures, triggers with T-SQL and optimizing queries with Show Plan.
• Scheduling Full and Differential Database backups, and TLog Backups to disks, tapes or remote servers, using batch scripts, TSQL and Maintenance Plan Wizard and configure appropriate Recovery Model for the databases.

Environment: SQL Server 2000/2005/2008 and 2008 R2,Windows 2000/2003 and 2008 R2,IIS, Oracle 8i/9i,10g and 11g , DB2 UDB,.Net, SAP, ESP, Tivoli, Oracle Grid, BMC IMS, Veritas Net backup, SQL Litespeed, Foglight, Guardian and Spot Light, Crystal Reports.

Confidential

Responsibilities:

• 24 X 7 Production Database On Call Support.
• Remote Monitoring of SQL Server 2000/2005 and 2008.
• Good expertise in migration of MS SQL Server 2000 to MS SQL Server 2005/2008
• Planning and implementing the Snapshot and Transactional Replication of MS SQL Server Databases, successfully configured/administered transactional replication using MS SQL Server 2000/2005/2008.
• Installed SQL Server Clusters in Active/Active and Active/Passive Topology.
• Successfully implemented High-Availability solution in MS SQL Server 2000/2005/2008 Cluster environments database. Implemented disaster recovery for SQL Server Production Database as Fail-Over or Standby servers.
• Used Log Shipping Technique for warm backup solution for MS SQL Server databases.
• Upgraded the existing Speedpay enterprise application from 3.4 to 4.0
• Very good experience in the maintaining production servers, monitoring performance issues, trouble shooting and solving production issues.
• Used tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• 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.
• Manage and maintain database changes in Development, QA, Staging and Production
• Expert in Using DMV's, Performance dash board, Mirroring, database snapshot.
• Analyzed long running /slow queries and tune the same to optimize application and system performance.
• Involved in various projects from start to production deployment, guiding development team for efficient performance and planning capacity.

Environments: SQL Server 2000, 2005 and SQL Server 2008, Windows 2000, 2003/2008, F5 Load balancers, IIS Servers, Auto Task, Site Scope, SQL LiteSpeed, SQL Spotlight and VSS

Confidential

Designation : SQL Server DBA

Responsibilities:

• Managing the production, development, and test databases including access controlling, performance monitoring and tuning, capacity planning, SQL Server clustering, database security configuration, and database continuity.
• 24 X 7 Production Database On Call Support.
• Create and manage SSIS packages.
• Migrated DTS packages to SSIS Packages.
• Migrated the existing Servers from SQL Server 2000 to SQL 2005 and SQL 2008.
• Upgraded the existing QNXT enterprise application from 2.6 to 3.4
• Tuned Production, Development and Test database servers to ensure optimum performance.
• Providing consultation and advice to application development groups to ensure that development efforts do not negatively affect production systems.
• Providing performance reviews and tuning recommendations for applications.

• Providing primary DBA support for existing MS SQL Server environments and applications.
• Planned, recommended, and implemented capacity, growth and changes for SQL Server architecture.
• Identified opportunities for consolidation of SQL Server implementations.
• Proactively monitoring system events and error logs as well as disk drive space available to databases and transaction logs.
• Proactively monitoring and analyzed system performance.

• Monitoring database status including CPU, memory, I/O, space, and dead lock using SQL Server Utilities.

• Coordinated database server maintenance and patching, and implemented infrastructure changes in accordance with IT Configuration and Change Management policies.

• Modified, and optimized very complex queries to data retrieval and modification.

• Planned, implemented, tested and documented backup and recovery procedures.
• Participated in disaster recovery exercises.
• Worked on archiving and shrinking of the old production data.
• Communicated regularly with internal technical staff to ensure the database integrity and security.

• Scheduled and monitored all maintenance activities of SQL Server 2005 including database consistency check, and index de-fragmentation.

• Consulted with application developers regarding optimal use of SQL Server and related technologies, and assisted in recommending and overseeing database enhancements.
• Analyzed and resolved database and application issues affecting SQL Server environments.
• Tested and implemented new releases of SQL Server-related software.

• Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, hardware errors, and security breach.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Configured securities and access to product databases in SQL Server 2005, Windows 2003 Server.
• Used SQL Profiler for troubleshooting, monitoring, optimizing SQL Server and T-SQL statement from developers and testers.

Environment: SQL Server 2000/2005 and 2008 ,Windows 2000/2003 and 2008, Oracle 8i/9i and 10g , DB2 UDB,.Net, SAP, ESP, Tivoli, BMC Patrol, Veritas Net backup, SQL Litespeed, Foglight, Guardian and Spot Light, Crystal Reports.

Confidential

Designation : SQL Server DBA

Responsibilities:

• Performance Tuning of the SQL Server in OLTP, Web based, Production and Development environments including the usage of Performance Monitor and Profiler Trace to monitor the Memory, CPU and Disk usage, the private bytes of each process, the trend in the Available Bytes, Context Switches/sec, Page Faults, growth of Tempdb, Cache-Hit ratio, disk reads and writes, Avg. Disk Wait Times, Transactions/sec, Growth and Shrinkage of databases and other counters, and use Index Tuning Wizard to create proper indexes. Identified the performance bottlenecks like CPU, Memory, I/O and tuned and improved the overall performance of the server for many clients.
• Involved in Physical and Logical design and Schemas for databases of new application.
• Tuning of SQL Server Memory structures and troubleshooting the existing issues with Buffer Pool and Paging.
• Monitor and troubleshoot ETL, BCP, DTSRUN and SSIS Jobs and other tools.
• Installed SQL Server Clusters in Active/Active and Active/Passive Topology.
• Remote Monitoring of SQL Server 7.0/2000 and 2005
• 24 X 7 Production Database On Call Support.
• Monitor Microsoft SQL Server activity on a proactive basis and tune the system for optimal performance
• Performed Physical and Logical Data Modeling for databases of varied sizes including VLDBs. Designed and implemented capacity planning module to make future projections in terms of system resources
• Involved in shriking databases using sql server management studio.
• Troubleshoot Blocking and Deadlocking issues by making appropriate changes to Transaction Isolation levels and the types of locks being held avoiding keeping transactions open for long durations, breaking large transactions to smaller ones.
• Migrated the existing Servers from SQL 2000 to SQL 2005 and SQL 2008.
• Create and manage SSIS packages
• Migrated databases over 1TB from SQL 2000 to SQL server 2005 with minimum down time.
• Monitor and tune both server and databases using DBCC, Server configurations options sp configure and Database options sp dboption . Contributed to automation of many daily administrative activities like backups, thresholds, monitoring server resources and proactive problem diagnosis.
• Manage and maintain database changes in Development, QA, Staging and Production
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Creating Replication and Log shipping for different Applications.

Environment: SQL Server 2000 ,2005 and 2008 and Windows 2000/2003 and 2008, Visual Basic 6.0, Oracle 8i/9i and 10g PeopleSoft, SAP, ESP, Tivoli, SCOM, BMC Patrol, Veritas Net backup, SQL Litespeed and Crystal Reports.

Confidential

Designation : SQL Server DBA

Responsibilities:

• Conducted various Migration review meetings with application teams to meet corporate milestones for database consolidation and data migration. Security and architectural planning.
• Migrated database from SQL Server 2000, MS Access, SQL Server 7.0 to SQL server 2005.
• Used different method for migration to minimize the down time during the MTP. Configured standby with customized log shipping between SQL 2000 and SQL 2005, in- place migration.
• Migrated databases over 1TB from SQL 2000 to SQL server 2005 with minimum down time.
• Migrated and supported over 50 HP Entity essential and Mission Critical application Worldwide Like HPVR Hewlett Packard Virtual Rooms , HPParts Hewlett Packard Parts store site
• SQL server 2005 enterprise 64 bit binary installation on both clustered and standalone environments.
• Installed SP2 and 3045 hot fix upgrade to all the SQL server 2005 servers.
• Configured Log shipping and Transactional Replication for the mission critical application.
• Installed and configured Monitoring tools for the database like DBSPI and MOM Microsoft Operational Manager 2005 for monitoring the database health checks.
• Configured database mail, Linked server and database mirroring as per the application requirement.
• Create Maintenance plan for regular database Full, Differential, and T-log backup.
• Create Maintenance planes for Database integrity checks and Index-rebuild on a Regular basis to maintain good database health.
• Migrated packages DTS to SSIS packages.
• Installed and configured SSRS SQL server Reporting services .
• Worked with the various teams to document, Install and configure BizTalk 2005 server, MCMS Microsoft Content Management Server , Microsoft Share Point Server.
• Working on the HP Open View database Incident, Service Calls, RFC on a regular basis. Provided on-call support on shift bases.
• Performance monitoring to identify SQL server Hardware bottlenecks , Operating system performance , SQL 2005 configuration performance , database configuration settings performance, index performance , using SQL profiler to identify poor performance Queries.
• Supporting application developer during the Migration, Load testing, MTP during the entire period of there move to the New SQL server 2005. Working with the connection, SQL server compatibility issues.
• Regular Health Check Process for the production databases
• Connectivity to Heterogeneous Data Source like MS Access through Linked Servers and Distributed Transactions.
• SQL Server Error Log Review, Space Check, Backup Verification, Standby verification, DBCC Checks.

Environment: SQL Server 7.0,2000 and SQL Server 2005 ,Windows 2000/2003, Tivoli, BMC Patrol , MOM , DBSPI , Data protector , Oracle 8i/9i and 10g PeopleSoft, SAP ,Veritas Net backups, MAP and SSRS SQL Server Reporting services .