Summary:

• 8 years of IT experience TSM/ Oracle DBA which includes almost 7 years of experience in Tivoli Storage Manager Administration, supporting multiple platforms and applications.
• Expertise in Storage backup and recovery utilizing IBM Tivoli Storage Manager 5.2/5.3/5.4/5.5/6.2/6.3.
• Experience in Installations and up-gradations of TSM Server/ BA Client on Windows2000/2003 /AIX.
• Configured Tivoli Data Protection for Oracle, VE, DB2, MS SQL Server, Lotus dominos and MS-Exchange.
• Configured NDMP backups for Netapp , EMC VNX and EXADATA
• Experience in Administration of Storage to Multiprotocol Environments like CIFS and NFS in NetApp SAN/NAS environment.
• Configuration, setup and maintenance of Quantum , IBM TS3500 libraries
• Maintenance and configuration of Data Domain VTL / CIFS and NFS.
• Day-to-Day TSM maintenance includes checking failed/ success backups, checking reports, finding missed nodes, TSM database backups, checking database and recovery logs and general health checks
• Good working experience setting up the Storage pools, adding volumes to pools and configuring the Policy domain, Policy Set, management class, copy groups Backup/ Archive , backup/ recover strategy, Archiving/ retrieve, migration, reclamation and collocation.
• Experience in supporting TSM over clustered environments.
• Experience in installing Integrated Solution Console and Admin Center on AIX.
• Strong analytical, problem solving and communication skills.
• Skilled in installations, up-gradations and maintenance of Oracle8i/9i/10g, MS SQL server 2000/2005 and DB2 databases on different platforms like Windows/Sun Solaris/AIX/Linux
• Excellent team player and flair to learn and implement new technologies.
• Supported as system admin on different platforms like AIX, Sun Solaris, Windows and Mainframes as Mainframe operation support.
• Strong written and verbal communication skills appropriate for various levels of an organization.

Technical Skills:

Professional Experience:

Confidential

Role: storage administrator

Responsibilities:

• Planning, Implementation, Installation, configuration and management of TSM Servers/Clients at environment as per client requirements and standards.
• Trouble shooting regular TSM client missed /failed backups including TDP for mails, data bases.
• Hands on experience with EMC AVAMAR and Networker
• Worked on POC regarding EMC DPA installation and administration
• Registration of new TSM clients, creating their respective policies for the backups
• Data Migration from DD890's to DD990's using TSM
• Experience in managing different DD products like DD890 and DD990
• Configuring VTL Tape libraries for TSM operations
• Setup replication between two DD arrays
• Configuring Auto support and SNMP configuration
• Proficiency in Tivoli storage manager administration and maintenance
• Setup/Maintain the TSM server code including schedules, storage pools, management classes, TSM databases, recovery logs, performance parameters, and TSM server options file

Confidential

Role: Backup administrator

Responsibilities:

• Implemented , configured and maintained Data Domain 890 Virtual Tape Library VTL Systems for efficient backup recovery Process
• Worked on AIX/Linux Systems to resolves multi task issues.
• Monitoring day to day activities, Performance activities, troubleshooting software/hardware and supporting team in daily backup issues.
• Created required documents to the higher level management about the present system making required changes as needed.
• Configured backup and archive for EXADATA, EXALYTICS and EXALOGIC
• Worked on NDMP backups for EMC VNX and EXADATA
• Configure TDP for Oracle, SQL, Virtual Environment, DB2, Exchange and Domino.
• Implemented TSM Performance factors like node TDP library audit, disk-backup-migration ratio, library-tape drive Firmware Version upgrade
• Install, configure, patch, upgrade, and maintain TSM technologies, Plan and coordinate the implementation and support of the TSM products, Solve issues related to the deployment of TSM server and client software 6.2/6.3.
• Planning, Implementation, Installation, configuration and management of TSM Servers/Clients at environment as per client requirements and standards
• Configuration and maintenance of IBM TS3500 library and Quantum Library
• Developed daily TSM reports and documented the required modifications in the form of SOP System.
• Setup/Maintain the TSM server code including schedules, storage pools, management classes, TSM databases, recovery logs, performance parameters, and TSM server options file.
• Responsible for disaster recovery DR Exercise
• Worked closely with Avamar/SAN / NAS / CAS technologies i.e. EMC, Netapp, etc. AS400 system backups

Confidential

Role: TSM Administrator

Responsibilities:

• Upgrade, Build TSM servers on V6.2
• Configure IBM VTL Protec TIER , Quantum I6000 Tape libraries
• Maintain of the STK SL 8500 tape library with ACSL configured to TSM , decommission the old IBM 3584 tape library
• Supporting IBM ATL 3584,3583's
• Trouble shooting regular TSM client missed /failed backups including TDP for mails, data bases
• Experience with TSM for VE for virtual environments.
• Plan and coordinate change controls for upgrading TSM infrastructure including Teradata backups, Oracle DB, SQL, lotus notes backups, Journal based backups .
• Creating separate storage pools on dedicate tape library for just for Space management and creating Management class with space management destination.
• Install and configure HSM clients on AIX and Windows, setup auto migration, run manual migration, recall migrate files.
• Configure NAS NDMP backups using LAN free Data movers and using LAN mounted file system backups
• Configuration of LAN free backups
• Creating reports for backup failures using Perl/shell scripting. Use scripting for some of the daily tasks like media management, good experience with TSM SQL query statements, using them in shell scripting.
• Installing and configuring TSM clients in MSCS VERITAS cluster environment.
• Handling Hot pager support in a rotation basis
• Monitoring internal TSM processes, such as Storage pool design, database backup, offsite backups, tape reclamation, volume expiration, migration, DRM, etc
• Support multiple instances of TSM server
• Involving in decommission of old environment and migrating needed clients to new environment.
• Troubleshoot and resolve TSM software and hardware-related issues
• Automating the TSM reports, shell scripting.
• Installing and configuring new TSM SAN agents/ TDP agents
• Support TDP for Lotus mail, exchange, TDP for oracle, TDP for SQL

Environment:

TSM 5.3/5.5/6.x, AIX, Sun Solaris, Red hat Linux, Windows 2000/2003/XP, Oracle 9i/10g,

MS SQLserver 2000/2005, db2

Confidential

Role: TSM Administrator

Responsibilities:

• Installation of Tivoli Storage Manager Server 5.3 on Windows 2003 Server.
• Installing and configuring the ISC and Admin Center on the AIX box.
• Customization of pre and post event scripts, Monitoring cluster health by checking logs files, Project planning data collection, and writing shell scripts to generate TSM reports.
• Provided 24/7 on-call support for the TSM Servers/ clients, on shift basis.
• Trouble shooting of LTO Libraries under TSM environment, Checkup, error log checkup, Administrative schedules, Client backup schedules.
• Check all the scheduled jobs, includes the daily backups and other daily activities like Migration, Reclamation, Collocation.
• Registration of new TSM clients, creating their respective policies for the backups.
• Worked with the IBM Tape library 3584, keep track of the storage volumes LTO , labeling, check-in, check-out and house keeping tapes.
• Trouble shooting of TSM client problems, working on Problem and Change ticket management.
• Installation of Tivoli storage manager B/A, Web Client and configuration on AIX 5.3.
• Developed shell scripts for automation of TSM 3584, Tape Library management report generation.
• Providing operational and management reporting on the backup/recovery environment.
• Managing tape inventory and maintaining tape drives and enterprise level tape libraries.
• Monitoring backups, perform system restores and setting up TSM policies for backups and restores.
• Defining policies to keep the number of versions of the databases and client Files.
• Defining administrative schedules, backup storage pools, run expire inventory process.
• Participated in meeting as point of contact POC for the TSM Servers.
• Writing scripts for the TSM backup schedules, shell scripting when necessary.

Environment:

TSM 5.3/5.4, IBM AIX, Windows 2003, Remedy

Confidential

Role: TSM Administrator/Oracle DBA

Responsibilities:

• Monitor components of TSM, including databases, logs, tape libraries, messages and backups. Daily maintenance of TSM servers like Health check.
• Define and manage storage pools in line with standards.
• LAN-Free backups, Offsite, Disaster Recovery to hundreds of client nodes having different applications including Oracle, SQL Server, Lotus Domino, Exchange.
• Define and manage retention policies, management classes and copy groups.
• Provide support for backup server Tape drives and library problems, including halting and/or restarting the backup server software applications.
• Installed, Configured and managed the Tivoli Storage Manager for backups and restores.
• Provided Oracle and DB2 UDB database support.
• Installing configuring and Trouble shooting of LTO Libraries under TSM environment.
• Installation and testing of the DRM for TSM server Restoration.
• Configuration of Database and Recovery log.
• Worked on the reporting tool, for the backup reports and monitoring.
• Define and setup the Storage pools, Configure the hierarchy between storage pools.
• Configuring TSM operations like expiration, migration, reclamation, collocation etc.
• Define and configure the client schedules and administrative schedules, for automatic backup of Oracle databases and logs at Exchange, File servers data predefined intervals.
• 24 / 7 support for the Production and Disaster recovery site.
• Backup Restoration of databases from local site recovery site.
• Managing different types of OS and database backups and restores using TSM.
• Designing complete backup and restore Strategy.
• Define and setup the Storage pools, Configure the hierarchy between storage pools.
• Define and configure the client schedules and administrative schedules.
• Tuning the SQL queries, providing parallel, index hints for the queries to improve performance.

Environment:

TSM 5.x, Oracle 9i/10g, AIX, Sun Solaris

Confidential

Role: TSM administrator/Oracle DBA

Responsibilities:

• Regular TSM health Checks DB, Log, Storage pool, Scratch count, etc.
• Checking the missed/ failed backups and trying to resolve them.
• Monitoring all the scheduled jobs, includes the daily backups and other daily activities like Migration, Reclamation, Collocation.
• General database health checks, backup checks and monitoring, archiving and user creations, tablespace management, space management, CPU and memory monitoring.
• Define and setup the Storage pools and configure the hierarchy between storage pools.
• Installation and upgrade of TSM 5.2 to 5.3.
• Loading the data from flat files using the SQL Loader.
• Export/Import data from production to Development/ Reporting database for testing.
• Estimated Storage requirements design the physical database layout and create the databases for production, testing and development.
• Worked on the automation of various batch jobs, monitoring CPU, memory at regular intervals.
• Created temporary tables, reports for the development team.
• Created tables, indexes by analyzing and rebuilding Indexes for better performance.
• Developed the databases, Tables, Views, materialized views, Indexes, Triggers, Stored Procedures, Functions and Packages using PL/SQL.
• Cleaning up the decommissioned clients
• Registration of new TSM clients, creating their respective policies for the backups.
• Monitoring the backup plan and managed Import/ Export data for Dev and QA team.
• Provided 24/7 monitoring of network database operations to ensure efficiency.
• General System Administration, which include user creation, creating groups, housekeeping, CPU and memory monitoring using commands like SAR, VMSTAT, PRSTAT, TOP, IOSTAT, etc.
• Installation of Red Hat Linux, allocating IP Address, making system ready for the testing purposes.

Environment:

Oracle 9i, SQLserver 7.0/2000, TSM 5.x, Netback up 6.0

Confidential

Role: Oracle/SQL server DBA / TSM administrator

Responsibilities:

• Creating new objects like synonyms and providing required grants to users.
• TSM server performance tuning and monitoring.
• Monitoring table spaces for space usage and adding required space after it reaches threshold.
• Monitoring listener services and listener logs for access
• Involved in Troubleshooting and support to client sites in case of problems.
• Day-to-Day TSM maintenance, Fixing Library related issues.
• Configuration and checking status of Database, Recovery log and storage pools.
• Define and setup the Storage pools and configure the Policy domain, Policy Set, Management class, Backup copy group, Archive copy group as per Customers requirement.
• Creating the required table spaces, users, and roles for the application. Work with application administrators to implement and support Tivoli Data Protection components.
• Cloning database using cold/hot backup methods
• Performed several schema/object refreshes
• Installation and Configuration of TDP for Oracle and MS SQL Server.
• Troubleshooting several client access issues like toad client and helped users to resolve those issues.
• Installing oracle client versions for developers.
• Administration of Oracle8i/9i databases including installation, creation, and monitoring database.
• Handled database tuning and performance enhancement SQL tuning for number of
• applications. Creating indexes, explain plan, optimizer hints, and TKPROF.
• Backing and restoring the oracle database using RMAN utilities.
• Manage capacity and performance of the backup infrastructure ensuring the integrity of the infrastructure.
• Generating TSM reports by using shell scripts and also scheduling the scripts in the cron job.

Environment:

Oracle 8i/9i, SQL server 7.0/2000, AIX 4.x, Sun Solaris, TSM 5.2