SUMMARY:

• Over 9 years of IT work Experience and 7 years expertise as DBA in Microsoft SQL Server 2000/2005/ 2008/200R2/2012 management and performance tuning, System analysis, Design, deployment, and experience on development and testing ETL.
• Experience in managing very large databases VLDB like 2 TB of Database
• Expertise in DB designing, Installation, configuration ,Server upgrade and managing different versions of SQL servers 2005/2008/2012
• Architect the Design Migration/Upgrade-Build of SQL SERVER 2008/2012 servers Both High Availability clusters, Availability Groups AG and Failover clustering
• Expertise in Troubleshooting, Installation, configuration, Backup /recovery, database security, Data Transformation Services DTS , Database design, query optimization, Security administration, Replication Distributed Data Administration , mirroring, log shipping and clustering
• Experience with Storage Area Networks SAN and utilizing SAN disk space in a Windows Environment-Recommendation on LUNS, RAID levels etc.
• Familiar with Virtualization technology and running Windows inside a Virtual Machine
• Experience with ETL processes for importing vendor data for e-commerce products, assimilating bulk job postings, and data loads and re-loads, and integrating corporate acquisitions' entire databases.
• Experience in disaster recovery, performance tuning, and migration from 2000 to 2005 and 2008 to 2012
• Expertise in configuring and maintaining SQL Server Active/Active and Active/Passive cluster.
• Experience in installing MS SQL multiple instances in windows cluster environment.
• Monitoring: Disk space, log space, publishers latency, waits, index fragmentation and generating all the reports
• DBA-Provided full life-cycle support and development of migration projects to go-live support.
• Troubleshoot issues reported by users, interfacing with Microsoft and IT helpdesk teams as appropriate.
• Experience in installing multiple instances of SQL failover cluster on SQL 2005 2008
• Extensive expertise in implementing High availability: Mirroring, Log shipping and Replication
• Extensively worked on Integration SSIS and good experience in data migration from MS-Access/ MS-Excel Sheets/ Flat file to SQL Server 2008/2005/2008.
• Extensively used tools like SQL Profiler, Index Tuning Wizard, and Windows Performance
• Worked with different Transformation tools like DTS packages, BCP, and BULKINSERT.
• Worked on different tools like Net Backup, Hyper backup
• Performed Key role in set up and maintain the different standard operating practice for prod environments
• Good Experience in Data moving for DB's and DB objects from one server to other server
• Expertise in setting up alerts which will update us with daily reports like backup failure report, disk space utilization report etc
• Good knowledge in trouble shooting and resolving production level issues
• Strong functional knowledge in the World top Hosting datacenters, Largest Media and Entertainment Company and world top health care product based company
• Capacity planning, Performance tuning, Disaster recovery, troubleshooting backup /restore procedures
• Monitoring: SQL Profiler for monitoring instances, Debug T-SQL statements, identifies slow running queries.
• Interact with internal business customers to define and document business process and functions
• Expertise in writing and debugging Stored Procedures, Triggers, Cursors and T-SQL coding.
• Experience in working with global clients and handling high priority production issues over Email/phone
• Worked as Tier 3 level DB Engineer and Troubleshooting customer escalations and providing solutions to Tier 1 and Tier 2 DB support team.

• Operating Systems: Windows 2000/2003/2008, 2008R2, 2012, Data Center edition, NT ,
• Languages: T-SQL, XML, HTML.
• Databases: MS SQL Server 2000, 2005, 2008, 2008R2, 2012, MS-Access
• Tools :DTS, SQL Server Integrated Services, Enterprise Manager, SQL Server Management Studio, SQL profiler, Database Tuning Advisor, SQL Backup Red gate , SQL safe, SQL compare, SQL Diagnostic Manager, light speed, HP Service Desk, CA Service Desk toll, SSIS, SSRS,SSAS
• Other Skills: Visual Source Safe, Microsoft Visio studio, MS SQL Integration Services
• VMWARE: Hypervisors VMware ESX/vSphere, Microsoft Hyper-V Server
• SAN: Storage and Storage Area Networks SANs including EMC, Fusion-IO, HP, IBM, NetApp, Dell
• Server Hardware: Dell, HP, IBM both blades and rack-mount servers
• Specialties
• SQL Server Clustering Database Mirroring Log shipping T-SQL SQL Agent Database administration High Availability Disaster Recovery Replication Profiler performance tuning SAN NAS disk configuration NUMA SSRS Reporting Services DTS Power shell Enterprise applications Infrastructure Elite Enterprise ERP software upgrades migrations Project planning SSRS SSIS SSAS SAN-RAID

Professional Experience

Confidential

Sr Associate DBA

Roles Responsibilities

• Working day to day production issues and alerts and maintenance activities
• Working on DB refresh on a regular basis from Production environment to Dev, QA, and Staging Environments and also working on partial refresh requests.
• Monitoring our daily backup report and fixing the issues
• Copying data from one table of the instance to another instance according to the requests.
• Monitoring data and log files and updating the customer about the required down time for maintenance weekend.
• Running of Profiler to capture Trace for Smoke Tests by the Development Team on Dev, QA, Staging, and Production Environment.
• Working on incidents and WO as per the requirements and implementing the WO with in the scheduled timeframes.
• Accepting the Work orders, Incident's on behalf of team members and assigning the resources to the tasks
• Review and analyze system logs to pre-emptively detect and correct system issues. Monitor usage including load and usability issues.
• CPU Tuning: Heavy resource intensive queries optimization as well as optimizing System cache L1, L2, L3
• Server level: Optimizing Memory usage both Buffer pool Plan cache and Data Cache with Kernel level allocation.
• Performance Tuning on both Instance level Server Level and Database Level Query Tuning
• Wrote automated backup and highly configurable index /statistics maintenance stored procedures for both the DEV an client production sites in a VLDB environment
• Coordinating with other teams like Windows server support to ensure the better performance and high availability of the database server in day-to-day manner.
• Day to day monitoring of database servers for any errors or failures. Checking errors, re-indexing, updating stats etc
• Preparing daily Weekly monthly report log to show the resource utilization and their productivity, Handling Onsite and On-call requests.
• Working as a On call support and resolve all production level issues
• Handling outages and providing the RCA to the clients about the issues and providing suggestions
• Perform capacity planning to ensure adequate availability and performance. Manage and test disaster recovery strategies
• Automated bugs/white list apply in all Prod/Sandbox and Pre-Prod environment
• Setting up Log shipping Replication Transitional on Production environment
• Individually implemented Transactional Replication process push for updating 180 subscribers with 100 publishers.
• Work with application development staff to develop database architectures, coding standards, and quality assurance policies and procedures
• Create models for new database development and/or changes to existing ones
• Respond to and resolve database access and performance issues
• Monitor database system details within the database, including stored procedures and execution time, and implement efficiency improvements
• Installed MS SQL Server2000/2005/2008 on Windows 2003/2008 servers, applied service packs, security fixes
• Resolve database performance issues, database capacity issues.
• Develop database procedures, triggers and SQL scripts for development teams.
• Created Scheduled jobs to execute multiple DTS package to extract data from multiple Rockwell and Avaya switches from the southeast regions call centers.
• Involved in set-up of the clustered SQL server environment at VLDB.
• Monitored log space of all the instances with generation of reports.
• Extensive experience with VMWARE consolidated environment
• Monitor databases for errors and perform problem determination when necessary.
• Troubleshooting security issues like orphan logins and common issues related to database and server level.
• Review existing T-SQL code, to locate performance issues and develop improved T-SQL processes.

Sr Associate DBA

Confidential

Role : DBA

Roles Responsibilities

• Production support to all 580 NBC SQL Servers out of that 300 are production servers
• Involve in Performance Tuning, Disaster Recovery setup, Database refresh, Migration, Installation, patching, Replication, Database Mirroring, Log shipping, Cluster maintenance, Optimization jobs, security Administration, maintenance Jobs, upgrades etc
• Server and Database monitoring with SQL Server and windows server jobs.
• Handling server outages and database crises.
• Log Shipping, Clustering database instances for failover
• Playing role on Users and Security following the business standards.
• Day to day monitoring of database servers for any errors or failures. Checking errors, re-indexing, updating stats etc.
• Monitoring customized jobs using Site Scope and Insight which alerts the failure of jobs and database server.
• Monitoring Backups, taking backups and restoring them depending upon requirements.
• Maintained mirror databases to provide foundation for disaster recovery
• Configured a mirror database with Production database either synchronously or asynchronously.
• Patching and upgrading to keep up to latest Patch level. With a flow of Dev, QA and Production.
• Installation, Configuration and administration of database instances as per the request on SQL 2000/2005/2008.
• Recommend upgrade / addition of new servers based on current and planned application usage.
• Managing Active-Active Cluster, their failover, patching and maintenance.
• Worked on Client/ Server tools like SQL Server Management studio 2005 2008 , SQL Server Enterprise Manager 2000 and Query Analyzer to Administer SQL Server.
• Performing automatic as well as manual failover
• Installed and Configured SQL server 2008 on windows 2008 advance server and windows 2008 systems.
• Role in Database Normalization, Optimization and Tuning, Backup/ Restore, Data Import/ Export, Troubleshooting, Database Objects authorization, DTS,ETL using DTS SSIS , Objects Creation such as Tables, Views, User created Data Types, Indexes, Stored Procedures, Cursors, and Triggers.
• Performance Tuning, Query Optimization, Client/Server Connectivity, Database Consistency Checks using DBCC Utilities.
• 24 7 on call support for Production databases.

Confidential

Role : Production Support DBA

Roles and responsibilities:

• Administration of the all Client servers.
• Monitor server capacity and make recommendations for hardware upgrades or add-ons e.g. processors, disk space, memory to accommodate current and planned server usage.
• Recommend upgrade / addition of new servers based on current and planned application usage.
• Modified the current database by adding tables and relationships as per the new requirements.
• Responsible for creating batches scripts for implementing logical design to T-SQL.
• Defined Check constraints, Business Rule, Indexes and Views.
• Created DTS packages to import/export data and to transfer database objects among servers.
• Supported development and operational processing.
• Responsible for the inception and implementation of Database Policy in the organization.
• Documentation of all the processes involved in maintaining the database for future reference.
• Responsible for developing, reporting stored procedures and ad hoc reports.
• Indexes are created on tables for new database to faster retrieval.
• Responsible for creating database objects like Views, Stored Procedure, Triggers etc to provide structure to store data and to maintain database efficiently.
• Conducted performance tuning on regular basis to improve performance of slow running queries and stored procedures.
• Schedule Jobs to run DTS package in night feed to system for fresh day data.
• Implemented the Slowly Changing Transformation to maintain Historical data in Data Warehouse.

Role : SQL Administration Dot net developer

Software : SQL Server 2000, DTS, JOBS

Responsibilities:

• Taking care of 200 production database servers, which are containing databases for all core business applications in which the size of the databases vary from 10 GB to 400 GB's.
• Monitor server capacity and make recommendations for hardware upgrades or add-ons e.g. processors, disk space, memory to accommodate current and planned server usage.
• Responsible for creating database objects like Views, Stored Procedure, Triggers etc to provide structure to store data and to maintain database efficiently.
• Space management on the Database servers.
• Maintaining Log Shipping for ensuring the high availability of Production server as well as updated data on development and DR servers.
• We have clustered environment here to take over any kind of failures and to maintain high availability of databases for production.
• Recommend upgrade / addition of new servers based on current and planned application usage.
• Installation, Configuration and administration of database instances as per the request on SQL 2000/2005
• Patching and upgrading to keep up to latest Patch level. With a flow of Dev, QA and Production.