PROFESSIONAL SUMMARY:

• 11+ Years of Extensive Experience in DB2 Database Administration with Team handling capability
• Cloudera CertifiedAdministrator for ApacheHadoop(CCAH) - CCA-500
• Completed course on Understanding Cassandra Architecture from Datastax Acadmey
• Completed course on Installing and configuring Cassandra from Datastax Acadmey
• Excellent technical knowledge as Database Administrator on DB2 database on Mainframe as well as on Linux, Unix and Windows environment
• Experience in DB2 Database upgrades & migrations on Linux, Unix and Windows
• Good Knowledge and experience in Hadoop Administration.
• Over 1.5 years of experience in installing, setup, monitoring and managing of Big Data projects using Hadoop, Hadoop Ecosystem and NoSQL data stores.
• Setting up Hadoop in various modes and integrating Hadoop Ecosystem with Hadoop.
• Working with both SQL and NoSQL Databases.
• Experience in creating, implementing and maintaining database objects on DB2 database on on Linux, Unix and Windows.
• Worked on Dev, Test and Production environment
• Good Functional Domain knowledge - Insurance, Banking and Telecommunication.
• Commended and recognized on numerous occasions for projects and papers presented
• Received a Certification of achievement in accomplishing REXX tools development
• Had attended trainings on Banking Domain
• Certified for Basics of Banking from Indian Institute of Banking and Finance (IIBF)
• Certified for Credit Cards Operations from Indian Institute of Banking and Finance (IIBF)
• Experience in On-call 24x7 production support.
• Friendly, cooperative attitude, Team Player, detail-oriented, analytical and self-driven.
• Outstanding organizational, communication & presentation skills.
• Excellent oral and written communication skills as well as the ability to interface with peers, management, vendors
• Strong planning and project management skills, self-starter able to work under minimal supervision
• Worked on creating Logical data modeling using Erwin

TECHNICAL EXPERTISE:

Operating Systems: UNIX, Linux, AIX, Solaris, OS/390, z/OS

Tools: db2pd, Netbackup, Oracle Golden gate, Erwin

Database: DB2, Oracle, Mysql

Big Data Technologies: Hadoop (Apache, Cloudera and Hortonworks), Hbase, Zookeeper, Working knowledge of Hive, Pig, Sqoop, Flume, Zookeeper, Ambari

Monitoring Tools: Nagios, Ganglia (For Hadoop ecosystem)

NOSQL Databases: Hbase, Cassandra

PROFESSIONAL EXPERIENCE:

Hadoop Administrator and DB2 database administrator

Environment: DB2, Hadoop, Linux, HDFS, Pig, Hive, Sqoop, Flume, Zookeeper and HBase

Confidential

Responsibilities:

• Installed and configured multi-nodes fully distributed Hadoop cluster
• Involved in installing Hadoop Ecosystem components.
• Involved in Hadoop Cluster environment administration that includes adding and removing cluster nodes, cluster capacity planning, cluster Monitoringand Troubleshooting.
• Maintaining and monitoring clusters.
• Loaded data into the cluster from DB2 relational database management systems using Sqoop based on the retention criteria .
• Loaded data into the cluster from dynamically generated files using Flume .
• Involved in writing Hive DDL to create the table to have similar kind of structure which DB2 database tables had .
• Involved in Hadoop Cluster environment administrator that includes adding and removing cluster nodes.
• Monitoring Using Network Monitoring Daemons like Ganglia and Service monitoring tools like Nagios.
• Decommissioning the Node on running cluster.
• Installation of various Hadoop Ecosystems and Hadoop Daemons.
• Installation and configuration of Sqoop and Flume.
• Installation and configuration of Mysql.
• Configured various property files like core-site.xml, hdfs-site.xml, yarm.xml based upon the job requirement.
• Importing and exporting data into HDFS using Sqoop.
• Loading log data directly into HDFS using Flume.
• Adding and removing a node and Data rebalancing
• Installation of Hadoop, HIVE, SQOOP, HBASE.
• Provided 24X7 On-call Support during weekends on rotation basis
• Responsible for Manage and support of DB2 databases on Linux environment
• Applying fix pack to db2 database servers.
• Migrated db2 from 9.5 to db2 9.7 level on Unix based server
• Migrated DB2 9.5 and 9.7 to 10.1 level on Linux servers as part of Data Center Migration
• Work on security tickets.
• Housekeeping activities.
• Oncall and weekend support
• Worked as offshore coordinator.
• Providing status to client on regular basis
• Ability to manage multiple DB2 UDB 9.7 instances
• Planning and implementation of Backup and recovery procedures
• Was part of Data Center Migration team to migrate all DB2 databases from one data center to another one
• Restoration of DB2 databases online, offline databases.
• Tablespace management and capacity planning.
• Provide technical expertise in all aspects of database implementation life cycle from sizing, through capacity planning, design, and implementation.
• Provide inputs in defining database standards and best practices for advanced monitoring and troubleshooting, performance tuning and automation
• Support DB2 UDB databases on Linux operating environments.

Confidential

DB2 Database Administrator

Responsibilities:

• Handling escalations and managing team
• Responsible for supporting and Upgrading DB2 databases from 8.2 to 9.7 in DEV, TEST,UAT and PRODUCTION Environment
• Migrated db2 from 8.2 to db2 9.7 level on AIX server
• Worked as offshore coordinator.
• Coordinating with multiple team like application team, testing team, UNIX team.
• Providing status to client on regular basis
• Ability to manage multiple DB2 UDB 9.7 instances
• Planning and implementation of Backup and recovery procedures
• Restoration of databases online, offline databases.
• Tablespace management and capacity planning.
• Manage large-scale DB2 UDB databases on AIX operating environments.
• Support HADR environment
• Worked on data modeling
• Requirement gathering and converting those requirement into Logical Data model using Erwin

Confidential

DB2 Database Administrator

Responsibilities:

• Handling escalations and managing team
• The scope of activities includes database maintenance of db2 application products
• Responsible for DB2 database on Solaris Operating System
• Responsible for Maintaining DB2 databases in TEST, DEV and PRODUCTION Environment.
• Primarily responsibility as DB2 UDB Database administrator includes but not limited to; applying fix packs, Installing DB2, troubleshooting, maintenance of backup, recovery, performance tuning of databases, handling scheduled build, Creating databases objects as per requests etc. on development, test and production servers.
• Experience in working in Process-driven environment, by following processes like Problem Management and Change Management
• Worked on Remedy tool.
• Implemented database policy for backing up data on daily basis.
• Regularly attended customer meetings and precisely reporting weekly and monthly status in different calls.
• Monitor and proactively manage all databases
• Installed and Upgraded DB2-UDB V9.1 Fixpak levels on Solaris.
• Frequently worked with cron scheduler jobs.
• Executed the DDL and DML scripts as per the customer request.
• Monitored tablespace growth using standard scripts.
• Cataloging Databases on various nodes.
• Updating DB/DBM cfg parameters based on the requirements.
• Handling table space and file systems space issues.
• Resolving the Problem tickets of different severity levels during on-call support.
• Experience on data movement Utilities i.e. import, export and load
• Monitoring the scheduled jobs like backup, runstat etc.
• Granting / revoking various authorizations to different Users/Groups.
• Installed DB2 fixpack on HADR servers
• Created a record of completing 100% on production support activities on time without any escalations.
• Regularly attended customer meetings and precisely reporting weekly and monthly status in different calls.
• Provided on-call support in a 24x7 environment.
• Setup the Golden Gate unidirectional replication from db2 to db2

Confidential

DB2 Database Administrator

Responsibilities:

• The scope of activities includes database maintenance of around 42 customers that includes internal as well as external customers’ systems database
• Responsible for supporting 200+ servers where DB2 Database is installed on UNIX, AIX, Linux and Windows environment
• Responsible for Maintaining more than 350 instances and 400 databases in TEST, DEV and PRODUCTION Environment.
• Experience in handling Production databases up to 1 TB.
• Primarily responsibility as DB2 UDB Database administrator includes but not limited to; applying fix packs, Installing and upgrading toolkit, troubleshooting, maintenance of backup, recovery, performance tuning of databases, Creating databases objects as per requests etc. on development, test and production servers
• Experience in working in Process-driven environment, by following processes like Problem Management and Change Management as well as CHAMPS request tool.
• Implemented database policy for backing up data on daily basis.
• Experience on Federated Database, Replication, HADR, Migration from V8 to V9.5
• Regularly attended customer meetings and precisely reporting weekly and monthly status in different calls.
• Monitor and proactively manage all databases
• Installed and Upgraded DB2-UDB V8.1 Fixpak levels on Linux, AIX and Windows.
• Installed and Upgraded Toolkit V.27g and DB2 Connect server upgrade V.26
• Frequently worked with cron scheduler jobs.
• Executed the DDL and DML scripts as per the customer request.
• Monitored tablespace growth using standard scripts.
• Cataloging Databases on various nodes.
• Updating DB/DBM cfg parameters based on the requirements.
• Handling table space and file systems space issues.
• Resolving the Problem tickets of different severity levels during on-call support.
• Experience on data movement Utilities i.e. import, export and load
• Monitoring the scheduled jobs like backup, runstat etc.
• Granting / revoking various authorizations to different Users/Groups.
• Created a record of completing 100% on production support activities on time without any escalations.
• Regularly attended customer meetings and precisely reporting weekly and monthly status in different calls.
• Provided on-call support in a 24x7 environment.

Confidential

DB2 Database Administrator

Responsibilities:

• Primarily responsibility is as DB2 Database administrator.
• Support of 40+ DB2 Subsystems across several MVS LPARs
• DB2 DBA Help Desk support
• Troubleshooting any DB2 problems that the staff encounters
• Backup and Recovery of the different testing and production environments
• Production support for DB2 7.1 and DB2 8.1 for various applications of Confidential
• Responsible for backup, recovery, production support, performance and tuning of numerous data bases supporting the Confidential applications
• Responsible for maintaining, enhancing and improving some of the jobs related to database on production environment.
• Implemented Automation using REXX on production jobs on various Lpars to receive email when job fails and received appreciation from peers and manager.
• Experience with Mainframe tools, programs, utilities as well as DBA tools, i.e. ISPF, Rexx
• Trouble shoot DB2 problems
• Experience with Database utilities like Copy, Recover, Runstats, Reorg, Load etc
• Experience using Job Control Language (JCL), REXX and SQL
• Experience on working on DB2 V7 and V8 on Z/OS environment

Confidential

DB2 Database Administrator

Responsibilities:

• The scope of activities includes enhancement and maintenance of CAMS system.
• Attended trainings on Banking Domain
• Attended extensive training on Umbrella architecture, CAMS-II at CSC, India.
• Primarily responsibility was Database Administrator and works on corresponding Enhancements and Maintenance tasks
• Backup and Recovery of the different testing environments
• Troubleshooting any DB2 problems that the staff encounters
• Received Certification of achievement for making tools on REXX language to support CAMS system effectively and easily.
• Experience with Confidential Utilities like Load, Copy, Recover, Repair, Check etc.
• Experience in BMC Change Manager, Librarian, Endevor, FileAid etc.
• Experience in SQL, REXX and JCL
• Experience with Confidential DB2 V7 on Z/OS platform

Confidential

DB2 Database Administrator

Responsibilities:

• The scope of activities includes enhancement and maintenance of DB2 Database.
• Primarily responsibility was Database administrator and works on corresponding Enhancements, troubleshooting and Maintenance of test environment.
• Troubleshooting DB2 problems encountered by the Users
• Upgrading DDL as and when required and requested by client
• Checking the nightly jobs run on the system for any error.
• Ensure that the jobs ran at previous night should be successful. If any problem found then need to resolve it and manually submit the jobs again.
• Experience with Confidential Utilities on like Load, Copy, Runstats, Reorg, Recover etc.
• RCA analysis if job failed and report to the customer
• Experience with BMC Change Manager, BMC Catalog Manager, Omeganom for DB2, FileAid, SPUFI etc.
• Experience in SQL, REXX and JCL
• Experience with Confidential DB2 V7 and V8 on Z/OS platform