Resume

Mohd Samsad Hussain

E-mail: adprdu@r.postjobfree.com

Mobile: +60-195******

Whatsapp: +60-195******

CAREER SUMMARY:

Having Nearly 5+ years of working experience on DB2 Database administration. Got IBM Certified Database Associate -- DB2 9 Fundamentals

Customer Recognition : My contribution in Database & SAP R/3 on installation of DR 24/7 site has been immensely appreciated by Customer and part of crack team per say.

Technical Knowledge Details:

1. DB2 Administrator: Installation of DB2 database, Perform DB2 database management (Backup, Maintenance of Container & Table spaces through DB Cockpit (SAP end), Administration of Database and SAP Connectivity, Database and Backup management on Linux Server, Performed database recoveries, Regular housekeeping DB2 activities like BACKUP, REORGCHK, REORG, RECOVER, LOAD, Provide the support for DB2 Movement Utilities like Export, Import and Load, Log Maintenance (archive Log).

2. SAP Basis: Installation, Configuration and monitoring of SAP Server, User ID management, User's Authorization management of system User ID, Transport Management System etc.

OS Proprietary Worked for DB2 Database:

Windows, Linux, AIX, HP-UX etc.

Database Proprietary Worked:

IBM DB2(Core Role), MS SQL, ORACLE, Postgres.

Details on MS SQL: Installation, Backup & Restoration, Cataloging Of DB etc.

Details on ORACLE: Installation, Backup & Restoration, Export & Import through EXP & IMP Utility etc.

Proprietary tool Worked:

TOAD for DB2, DB2 Performance Expert, Infosphere Optim Performance Manager, IBM Data Studio, TALEND.

IMPEMENTATION:

DB2 database Version upgrade (with WAS & SAP)

DB2 database FP Upgrade.

HADR Implementation.

Professional experience:

Aglint Consulting (Malaysia) 05/06/2017 –Till Date

Client: TNB

Role: DB2 DBA Administrator

Responsibilities:

●Installation & Administration of DB2 database on Linux, AIX, HP-UX & Windows.

●Scheduling Backup Scenario through Cron Job and Tuning Backup.

●Implementation of High Availability Disaster Recovery.

●Migration of DB from Windows to Linux(Export & Import)

●Implemented redirect restores in all production, test and dev environments.

●Experienced in working with large tablespaces, processing and maintenance of partitioned tablespaces.

●Database Version Upgrade & Fix Pack Upgrade, Upgrade of SAP Client driver for DB2 Database.

●Analyzing SQL Queries by using db2advis and creating indexes based on requirement.

●Monitoring and troubleshooting the issues used by db2 tools such as db2top, db2pd,

snapshot and event monitoring.

●Successfully implemented read-only standby using HADR.

●Extensive experience in utilities and tools used for database monitoring (DB2 traces, online performance monitors, EXPLAIN, DB2 catalog queries), data movement and organization (IMPORT, EXPORT, db2move,db2look, LOAD, REORG), etc. Can recognize the problem using db2diag log.

ALCHEMY TECHSOLE INDIA Pvt. Ltd. 21/03/2016 –09/03/2017

Client: IBM, KOLKATA

Role: DB2 DBA Administrator

●Installation of DB2 product on Linux/windows platforms and connecting through client to server.

●Expertise on fix-pack installation.

●Have experience in Upgrading DB2 product (Ver. 9.7 to Ver.10.5).

●Creation of Partitioned table and deployment in production system

●Implementation of High Availability Disaster Recovery.

●Successfully implemented read-only standby using HADR.

●Have hands on experience on db2pd, db2top.

●Query Optimization.

●Exporting DDL and maintained DDL for all DB2 databases.

●Handled the Database backup and recovery.

●Implemented redirect restore in all production, test and dev environments.

●Implemented shell scripts for DB backups.

●Maintaining system storage according to the DB usage.

●Export data from the tables belongs to one database into CSV files.

Project Experience 1

Vayam Info Solutions Pvt Ltd 21/09/2011 –19/03/2016

Client: Indian Navy, New Delhi

Role: DB2 DBA Administrator

Responsibilities:

●Installation & Administration of DB2 database & SAP Application and Connectivity.

●Worked on data center move project to move all the Test, Quality and Production servers from DC to DR center SAN Based Replication.

●Performing Run stats & Reorg of tables and other DB2 utility jobs like db2look, db2move, export, import, load.

●Monitoring the databases for locks, deadlock and transaction log full errors.

●Supporting and maintenance functions of over 500 production/development/test & Quality databases on Linux Platforms.

●Database and Backup management on Linux Server (Manual backup or with the help HP Data Protector)

●DB2 database fix-pack Upgrade.

●DB2 Database Upgrade form Version 9.7 to Version 10.5(SAP EHP testing).

●Installed and configured DB2 V9.7 HADR environment (DR Drill).

●Perform Recovery, Cloning of Databases using redirected restores when required.

●Perform DB2 database management (Backup, Maintenance of Container & Tablespaces) through DB Cockpit (SAP end).

●Monitoring archive mount points and data mount points.

●Database performance tuning, troubleshooting and fixing problems.

●Extensive monitoring of all the databases performance and resolving the issue to sail database smoothly and efficiently.

●SAP User ID management, User's Authorization management of system User ID, Transport Management System etc.

●Currently part of Migration of SAP EHP4 to EHP6 SAP Basis Team.

Professional: Project Experience 2

Vayam Info Solutions Pvt Ltd.

Client: FIU (Financial Information Unit)

Role: DB2 DBA

●Migrated databases from Ver. 9.1 to 9.7. Participated in projects supporting physical move (SAN based) of all the database servers from DC to DR.

●Performed backup and restore functions using TSM.

●Implement DB2 LUW Backup/Recover procedures.

●Problem determination / Troubleshooting, Performance Monitoring and Tuning like Snapshot monitoring.

Professional: Project Experience 3

Vayam Info Solutions Pvt Ltd.

Client: ICF INTERNATIONAL

Role: DB2 DBA

●Install and configure DB2 UDB new releases, upgrades, and patches.

●Perform database software installations including and database creation and configuration.

●Database Backup/Recovery of databases, including Redirected Restore.

●Implement and test HADR performance for production environments.

●Monitoring the databases for locks, deadlock and transaction log full errors.

●Table space space usage/growth estimation, space forecasting.

●Execution of standard database utility like Runstats, Backup and Restore.

Vayam Info Solutions Pvt Ltd. 11/03/2011– 20/09/2011

Client: Future Group

Role: Technical Support Engineer

Responsibilities:

●Administration Managing the Network Printers.

●Managing User profiles and applying permissions.

●Enterprise Mail Configuration in BLACKBERRY Device.

●Installation of Patches, Antivirus and Microsoft Applications.

●McAfee® Virus Scan® Enterprise 8.7i Installation and configuration.

●Maintaining Daily, Weekly and Monthly call Reports.

●Solving issues regarding REM Application used for billing.

●Installation & configuration of SAP.

Professional Certification:

IBM Certified Database Associate -- DB2 9 Fundamentals

Technical Training:

Professional training in Computer Hardware & Networking from Jetking Infotrain Ltd, New Delhi.

RHEL 6 Training from Wipro InfoTech Ltd

Academic Qualification

Bachelor of Computer Application, in the year 2009.

Contact this candidate