SUMMARY

• 10 Years of extensive experience in Information Technology as a Senior SQL Server DBA in TEST, DEVELOPMENT and PRODUCTION Environments.
• 24 X 7 Production Database On Call Support.
• Experience in Installing, Configuring and managing SQL Server in a Multi Node Clustered and Non Clustered Environment.
• Extensive experience in Database Migrations and Upgrading In Place Side by side of SQL Server 2000 to SQL server 2005/2008 R2 and SQL Server 2005 to 2008 R2 /2012.
• Expertise in implementing and maintaining Snapshot, Transactional and Merge replication in SQL Server 2000, 2005 and 2008 R2 /2012.
• Hands on experience in Designing Database Server Infrastructure, Physical Database, Database Solution for Data Recovery, High Availability and Strategy for Data Archiving.
• Extensive experience with High availability and Disaster Recovery solutions include Microsoft Failover Clustering, Database Mirroring and SQL Server Log Shipping, Replication, Always On High Availability Groups
• Extensive experience with backup and restore procedures using native and third party backup tools.
• Experience in allocating system storage and Capacity planning for future storage requirements for the database system.
• Experience in Designing, Establishing a strategy to manage data across servers using linked servers.
• Experience in Configuring and deploying various applications using SSRS and SSIS packages in Test and Production environments.
• Experience in Data Loading, ETL process and Supported Cubes in SSIS and Transferred data to Data Warehouse Environment ETL using SSIS.
• Expertise in Monitoring and Optimizing the Performance of Database using DTA Database Tuning Advisor and ITA Index Tuning Advisor .
• Experience with SQL Server 2005/2008 DDL/DML Triggers.
• Extensive experience with Batch processes using Import, Export, Backup, Database Monitoring tools and schedule jobs monitoring.
• Experience in customization and deployment of Third party application software with vendor interaction.
• Experience in creation and maintenance of T-SQL Procedures, Functions and Packages.
• Extensive Knowledge with HTML, XML, VB Script, Java Script, ASP, IIS, Java, website design, FTP, Telnet, uploading, software development life cycle.

SKILLS

• Databases: SQL Server 2000, 2005, 2008 R2 , SQL 2012 Oracle 8, 8i, 9i, 10G, IBM UDB DB2, IBM DB2/400 and MS Access, SAP BW
• O/S: Windows 2000, 2003, 2008 R2 and 2012 R2 Servers
• SQL Services: SSIS, SSRS, SSAS, DTS, SS Upgrade Advisor, SS Migration Assistant
• Languages: T-SQL, PL/SQL, C, C , ASP, HTML, VB, VB Script and Java Script
• Tools Litespeed, Foglight, Crystal Reports, Informatica, PeopleSoft, Capacity Manager, Erwin Data Modeler, TOAD, IIS, Visual Interdev , MS Access , BMC Patrol, FogLight, BMC Remedy, VERITAS Storage Foundation, QLogic SAN Server, VERITAS Net Backups, Visual Studio .NET, Sandpiper VSU Snap Backups, ESPx Job Scheduler on Main Frame for Cold/Hot Backups, SQL Servers in VM Ware Environment

PROFESSIONAL EXPERIENCE

Confidential

Designation: DBA Tech Lead

Responsibilities

• Provided 24x7 On Call DBA Support for Production Servers which included Multi Instances clustered and non clustered environment.
• Coordinated and Controlled Installing, Configuring, Implementing, Managing, Monitoring and Troubleshooting SQL Server 2005, 2008 R2 and SQL Server 2012 in clustered and non-clustered environment on Windows 2003, 2008 R2 and 2012 servers.
• Involved in the database migration of SQL Server 2000/2005 databases to SQL Server 2008 R2 /2012.
• Worked on Database Recovery Plans and Implementation of the Mirroring in SQL Server 2005/2008 R2 /2012.
• Involved in Implementation of the Always On Availability Groups in SQL Server 2012 Instances.
• Involved in both P2V and V2V Migrations for SQL Server 2005/2008/ 2008 R2/2012.
• Managed troubleshooting of Client connections, viewing error logs and applications.
• Performance Tuning of the SQL Server
• Responsible for Setup and maintaining Log shipping, Replication for Data Migration.
• Installed, Authored, Managed and Deployed Reports using SSRS SQL Server 2005/2008 and 2012 Reporting Services.
• Strong Working Experience in Clustered and Non Clustered Environment.
• Monitored SQL server performance on regular basis, and gathered data for trending analysis.
• Used Performance Monitor/Profiler to solve Dead Locks/Long running queries.
• Used SQL profiler, System Monitor, Query Analyzer for troubleshooting, monitoring, and optimization and tuning of SQL Server and SQL code.
• Responsible for regular database maintenance process and disk defrag procedures in Production environment.
• Coordinated the installations Security Patches, Service packs and evaluated the performance before Pre-deployment.
• Configured SQL Servers with appropriate settings to resolve various resource allocation memory issues.
• Managed capacity planning and implement database security for multiple instances of development, QA, Demo, Integration and Production SQL Server databases.
• Maintained and managed Change and Release Management process for all database related change controls and releases.

Environment

SQL Server Versions 2005, 2008 R2 and 2012 on Windows 2003/2008 R2 /2012 Servers, LiteSpeed 6.5.1/7.1 and 8.0, Symmetrix Remote Data Facility SRDF , DoubleTake, DB2, SiteScope, BMC Patrol, Foglight, VERITAS Net Backups, QLogic SAN Surfer, BMC Remedy 7.1 and 7.6 to implement ITIL Process for Release, Change, Problem and Incident Management

Confidential

Designation: Senior SQL Server DBA

Responsibilities

• Provided 24x7 On Call DBA Support for Production Servers which included Multi Instances clustered environment.
• Coordinated and Controlled Installing, Configuring, Implementing, Managing, Monitoring and Troubleshooting SQL Server 2000/2005 and 2008 in clustered and non-clustered environment on Windows 2003 and 2008 servers.
• Involved in the migration of SQL Server 2000/2005 databases to SQL Server 2008.
• Worked on Database Recovery Plans and Implementation of the Mirroring in SQL Server 2005 and 2008.
• Managed troubleshooting of Client connections, viewing error logs and applications.
• 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 process, the trend in the Available Bytes, Context Switches/sec, Page Faults, growth of Temp db, 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, and I/O and tuned and improved the overall performance of the server for many clients.
• Responsible for Setup and maintaining Log shipping, Replication for Data Migration.
• Installed, Authored, Managed and Deployed Reports using SSRS SQL Server 2005 Reporting Services.
• Monitored SQL server performance on regular basis, and gathered data for trending analysis.
• Used Performance Monitor/Profiler to solve Dead Locks/Long running queries.
• Used SQL profiler, System Monitor, Query Analyzer for troubleshooting, monitoring, and optimization and tuning of SQL Server and SQL code.
• Responsible for regular database maintenance process and disk defrag procedures in Production environment.
• Coordinated the installations Security Patches, Service packs and evaluated the performance before Pre-deployment.
• Configured SQL Servers with appropriate settings to resolve various resource allocation memory issues.
• Managed capacity planning and implement database security for multiple instances of development, QA, Demo, Integration and Production SQL Server databases.
• Reviewed T-SQL code written by developers to follow better standards, procedures to optimize for better performance before QA deployment.
• Captured and analyzed the long running stored procedures using SQL Server Profiler and tuned the same to optimize application and system performance.
• Involved in 32 bit to 64 bit Data Migrations, SQL 2000/2005 to SQL 2008 Migrations on Windows 2000, 2003 and 2008 Servers.
• Maintained Change Control and Release Management process for all database releases, data fixes
• Maintained a stable process of database refresh from production to internal environments.

Environment

SQL Server 2005 and 2008 SQL Servers on Windows 2003/2008 Servers, Visual Studio .NET, Oracle 10G,DB2,Toad, BMC Patrol, Lite Speed,VSU Snap Backups, Capacity Manager, MS Access, VERITAS Net Backups and ESPx Job Scheduler on Mainframe for Hot Backups

Confidential

Designation: SQL Server DBA

Responsibilities

• Provided 24x7 On Call DBA Support for Production Servers which included Multi Instances clustered, non-clustered environment.
• Coordinated and Controlled Installing, Configuring, Implementing, Managing, Monitoring and Troubleshooting SQL Server 2005 and 2008 in clustered and non-clustered environment on Windows 2003 and 2008 servers.
• Involved in the migration of SQL Server 2005 databases to SQL Server 2008.
• Worked on Database Recovery Plans and Implementation of the Mirroring in SQL Server 2005.
• Managed troubleshooting of Client connections, viewing error logs and applications.
• 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 process, the trend in the Available Bytes, Context Switches/sec, Page Faults, growth of Temp db, 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, and I/O and tuned and improved the overall performance of the server for many clients.
• Responsible for Setup and maintaining Log shipping, Replication.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
• Installed, Authored, Managed and Deployed Reports using SSRS SQL Server 2005 Reporting Services.
• Strong Working Experience in Cluster Environment.
• Monitored SQL server performance on regular basis, and gathered data for trending analysis.
• Used Performance Monitor/Profiler to solve Dead Locks/Long running queries.
• Used SQL profiler, System Monitor, Query Analyzer for troubleshooting, monitoring, and optimization and tuning of SQL Server and SQL code.
• Responsible for regular database maintenance process and disk defrag procedures in Production environment.
• Coordinated the installations Security Patches, Service packs and evaluated the performance before Pre-deployment.
• Configured SQL Servers with appropriate settings to resolve various resource allocation memory issues.
• Managed capacity planning and implement database security for multiple instances of development, QA, Demo, Integration and Production SQL Server databases.
• Reviewed T-SQL code written by developers to follow better standards, procedures to optimize for better performance before QA deployment.
• Captured and analyzed the long running stored procedures using SQL Server Profiler and tuned the same to optimize application and system performance.
• Performed general technical troubleshooting and provided consultation to internal and external client project teams. Maintained ETL Process and supported cubes in Microsoft Analysis Services.
• Maintained Change Control and Release Management process for all database objects like tables, views, procedures, and triggers.
• Maintained a stable process of database refresh from production to internal environments.
• Installed, Configured, Developed and Deployed SSIS packages.

Environment

SQL Server 2005 and 2008 SQL Server Integration Services SSIS , SQL Server Reporting Services SSRS , Windows 2003/2008, Visual Studio .NET, Oracle 9i,Sybase,SAP,Toad, Peoplesoft, BMC Patrol, LiteSpeed, Capacity Manager, MS Access, Foglight, SSMA, SSUA, Crystal Reports

Confidential

Designation: SQL Server DBA

Responsibilities

• Provided 24x7 On Call DBA Support for Production Servers which included Multi Instances Clustered, non-clustered environment.
• Involved in Installing, Configuring, Monitoring and Troubleshooting SQL Server 2000 and 2005 in clustered and non-clustered environment on Windows 2000 and 2003 servers.
• Upgraded the existing Servers from SQL Server 2000 to SQL Server 2005.
• 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, and I/O, 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 Sever Memory structures and troubleshooting the existing issues with Buffer Pool and Paging.
• Remote Monitoring of SQL Server 2000/2005.
• Developed and configured Database Mirroring.
• Involved in the migration of SQL Server 2000 databases to SQL Server 2005.
• 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.
• Developed and Configured Logshipping and Replication.
• Installed and Configured SQL server Failover Cluster and applied service packs.
• 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.
• Responsible in migrating DTS packages from SQL 2000 to SSIS Packages in SQL Sever 2005 databases.
• Installed, Managed and Deployed Reports using SSRS SQL Server 2005 Reporting Services.
• Installed, Configured, Developed and Deployed SSIS packages.
• Implementation of SQL Logins, Roles and Authentication Modes as a part of Security Policies for various categories of users.
• Monitored and tuned 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.

Environment

SQL Server 2000 and 2005 and Windows 2000 and 2003, Toad, Oracle 8i, Veritas NetBackup, Litespeed, Visual Studio.NET, SSIS, SSRS, Crystal Reports, Sybase,Informatica, Litespeed, Capacity manager,Foglight,SSMA,SSUA

Confidential

Designation: SQL Server DBA

Responsibilities

• Provided 24 7 Production support for 110 total numbers of servers out of which 78 Servers are production servers.
• Installed SQL Server 2000 on windows 2000 servers. Installed service packs and applied latest security fix.
• Installed and configured transactional and snapshot replication for production servers to other production servers available in remote locations.
• Installed and maintained MS SQL Fail over clustering with two nodes for mission critical database for high availability solutions.
• Created logical and physical data modeling using Erwin tool.
• Experienced with upgrading from SQL Server 7.0 to MS SQL Server 2000 server
• Worked with the application administrators to make sure applications are fine after the upgrade.
• Created log shipping for reporting purpose and backup purpose in case primary server failure for high availability solutions.
• Developed, Configured and Monitored Logshipping.
• Responsible for Migration and Upgradation of SQL Servers.
• Experienced with configuring SQL Server to run in optimal conditions.
• Involved in architecting the SQL Server environment, installation and maintained the SQL Servers for maximum database availability.
• Involved in backup and restore of the SQL Server databases.
• Experienced with improving server performance using windows performance Monitor.
• Involved in improving SQL Server database performance using Query analyzer
• Index tuning wizards, execution plans and profilers.
• Created the DTS packages to import the data from oracle, access databases in
• To the SQL Server.
• Experienced in creating documentations for the SQL Server and SQL Cluster
• Installations and apply service packs and SQL Server security administration Processes.
• Experienced with SQL Disaster recovery solutions and created the procedure to recover the databases in the disaster situations.

Environment

• SQL Server 7.0/2000, Windows 2000/2003, Oracle 8, IIS 5.0, Visual Basic.Net, SQL
• Server Reporting Service, Crystal Reports, Litespeed, ErwinDataModeler, Sybase, DTS, Toad, MS Access.

Confidential

Designation: SQL Server DBA

Responsibilities

• Provided 24x7 On Call DBA Support for Production Servers.
• Installed, Configured and maintained various databases for Production, Development and Testing environments using SQL Server 2000.
• Created Database Maintenance Plans for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Planned the Complete Backing up of Database and restoring the Database from Disaster Recovery.
• Worked on Creation of new database, planning the location of data, index, and transaction log files on the disks.
• Created and redesign procedures, functions, and triggers.
• Developed, Configured and Monitored Logshipping.
• Involved in Migration and Upgradation of SQL Servers.
• Installed and Configured SQL server 2000 on windows 2000 data Centre server system and Created roles and alerts for new Databases.
• Configured Transactional Replication Creating Distribution Databases, updating Publishers, creating managing Publications, managing Replication monitors .
• Performed daily backups and developed recovery procedures.
• Created DTS Packages for data import / export data from SQL Server to Access, text and EXCEL files.
• Experienced in performance tuning using SQL profiler of SQL server.
• Setting up backup plans for the databases.
• Provided support to the application developers on the application databases.

Environment

SQL Server 2000/7.0, T-SQL, Windows 2000,Oracle 8,Visual Basic 6.0,Toad,Crystal Reports, Litespeed, Erwin data modeler and MS Access