SUMMARY OF EXPERIENCE

Twenty years of experience in Systems Management, Network Management, and Database Administration. Systems management experience includes installation, administration, and trouble shooting of Large scale systems at Fortune 500 organizations - IBM, Campbell Soups, Advo, Pepperidge Farms. Server management experience across AIX pSeries , Sun Solaris, Linux, HACMP based Fault Tolerant Systems, LDAP administration. Managed TSM storage solutions. Thorough knowledge of Intel based servers from IBM, Windows/NT, and NetWare. Experienced in interconnectivity, heterogeneous network environment, using TCP/IP and other network protocols. Expertise at DB2 administration across Insurance, Banks, Entertainment, Financial Institutions, FDA regulated companies. Strong client interfacing and project management skills. Excellent written and verbal communication skills. Demonstrated experience in successfully managing multiple projects. Clients managed include Campbell Soup Company, Disney, Morgan Stanley, Fireman Fund, ACE Insurance, AIG , Carlson, ING, Investment Bank and Trust, Wellpoint, Hillenbrand to name a few.

TECHNICAL SKILLS

Platforms: RISC Systems RS/6000, pSeries , SP-2 systems, Intel based IBM compatible servers, SUN.

Operating Systems: IBM AIX, SP Administration, Solaris, and Novell Netware 4.11 Languages: 'C', PERL, HTML, Shell Scripting.

IBM Directory Server LDAP V3.2 , V4.1, V5.1, V6.2

Non-DB2 RDBMS and Tools: ORACLE PL/SQL, SQL PLUS 3.2

IBM DB2 UDB -- DB2 Universal Database v6/7.x/8.x,9.x

IBM DB2 Tools - DB2 Recovery expert, DB2 Query Patroller , DB2 Performance Expert Optim Performance Manager , DB2 Cube Views , DB2 Alphablox

Other Tools Tivoli Storage Manager TSM , Tivoli System Automation for Multi platforms TSAMP

WORK EXPERIENCE

Confidential

Systems Administrator

Responsibilities:

• Installing and configuring AIX and Linux servers for DB2 UDB product family, DB2 tools , Sybase direct connect and LDAP.
• Managing space and Ids for db2 servers.
• Configuring pre-requisites for DB2 and LDAP servers.
• Configuring DB2 UDB Federated database Environment
• Configuring DB2 UDB Cluster EEE Environment partitioned logical and physical nodes
• Configuring DB2 HADR with TSAMP Tivoli System automation for Multi platforms for Application failover
• Configuring DB2 UDB For Hacmp Environment
• Trouble Shooting on access issues and application issues on both UNIX and DB2 level
• Installing , Patching and Configuring DB2 UDB server and client software Ver 7.2 , 8.1 , 9.1 , 9.5, 9.7
• DB2 Database maintenance, backup, restore, performance monitoring tuning, maintenance of logs, problem identification and resolution, security and disaster recovery planning.
• Migrating from V7 to V8 to V9.
• Handling day to day production related issues
• Using and configuring TSM for database backup and userexit.
• Setting up and maintain db maintenance jobs like reorg, runstat, online backup and dbrebind.
• Setting up and maintaining TSM for the production databases.
• Setup various database snapshots / event monitor for tracing production issues like application locks, deadlock and system performance etc.
• Setting up debug db servers for testing team using copy of db backup from production.
• Install and configure and trouble shoot DB2 Connect on UNIX AIX, Solaris, Linux and Windows 2000 and ensure end to end connectivity.
• Loading data using export/import, Load utilities in DB2.
• Installing and configuring DB2 tools - DB2 Recovery Expert, DB2 Query Patroller, DB2 Performance Expert, DB2 Alphablox, DB2 Cube Views.
• Installation and Configuration of LDAP 3.2.2 , 4.1 , 5.1 , 6.2 IBM Directory Server
• Configuring LDAP to use SSL for authentication
• Trouble Shooting LDAP authentication issues.
• Installing and configuring Sybase Direct connect for Oracle and DB2 on Unix paltform.
• Trouble shooting connectivity issues on Sybase Direct connect.
• Do on-call duty 7/24 for a week on a monthly rotation period.
• Take Part in Disaster Recovery for External Customers.
• Backup Team Lead in temporary phases during his absense.

Confidential

Systems Administrator

Responsibilities:

• Installation and Configuration of IBM pseries , RS/6000 SP server and Control Workstation.
• HMC, LVM, VIO and LPAR configuration and support.
• Manage user security and authentication using Kerberos and basic AIX security.
• Setup HACMP and manage it.
• Sequence orderly startup and shutdown of cluster.
• Interface external storage and Network devices.
• Create and implement backup/restore strategy for Data, SDR System Data Repository , Kerberos database, Control Workstation and nodes using TSM 3.7 , Sysback 4 and mksysb.
• Install and Manage DNS and DHCP servers.
• Install and manage NTP server
• Write Shell scripts to monitor processes and environment variables for systems.
• Do a daily check of systems and take corrective actions for different processes, variables, and file systems.
• Check backup status of systems on a daily basis and take corrective actions in case of backup failures.
• Do off-shift duty 7/24 for a week on a two months rotation period.
• Plan and carry out Disaster recovery Tests.
• Document Procedures for installs and troubleshooting.
• Do General day to day Trouble Shooting as call comes.