Lead Database Migration Specialist Resume
SUMMARY:
- 16+ Years of experience in all aspect of application design, development, legacy migration/modernization, implementation, maintenance and DB2 Administration.
- Strong knowledge on Big Data Hadoop Administration.
- Familiarity with Hadoop Ecosystem and components HDFS, Hive, Pig, HBase, Sqoop, Flume, Oozie, ZooKeeper, Cloudera CDH4, HiveQL, and PigLatin.
- Strong understanding of various technologies, applications development and migration project life cycle Phases.
- Good in understanding complex interfaces across applications.
- Effectively worked on Operating systems Windows, Linux, Solaris and Unix (HP - UX & AIX).
- Having experience in consulting in medium to large-scale enterprise wide migration projects.
- Good knowledge and hands-on implementation experience with Migration concepts using tool based solutions.
- Skilled in DB2 database administration, data modeling, SQL coding, stored procedure and trigger development.
- Skilled in Sybase, SQL coding, stored procedure development.
- Rich experience in Legacy application migration and Modernization.
- Good understanding and hands-on experience on migration using Micro Focus suite of products.
- Having strong knowledge of scripting languages in UNIX.
- Self-motivated with strong leadership and team player skills, adept at motivating and supporting team members to achieve professional goals.
- IBM certified Database Associate - DB2 9 Fundamentals.
- Certified IBM Informix Mastery Test.
- Certified ITSM.
- More than 8 years of proven DB2 DBA experience expertise in leveraging DB2 database platform for enterprise wide solutions and having Work experience includes DB2 Application Programmer/DB2 Database Administrator.
- Experienced as Application & Support DBA.
- Hands on experience in Data Integration, Performance Tuning and troubleshooting problems.
- Extensive experience in Incident Management and Problem Management.
- Good exposures to SW build systems and configuration, change & release management.
- Good People management skills in hiring right talent and team management.
- Strong experience in Requirement Analysis, Impact Analysis, System design and Implementation.
- Experienced in managing projects & handling responsibilities in various phases of SDLC.
- Executed Key projects for major banks like Confidential.
- Developed the Assessment technique using Analytical Hierarchy Process to derive the Business Value, Risk Exposure and Capability improvement weightage.
- Developed the Legacy migration approach using AHP model. Provided the high level migration solutions to the new platform.
TECHNICAL SKILLS:
Operating System: MPE, MVS/ESA, Z/OS, Microsoft Windows, UNIX (HP & AIX), Solaris & Linux
Languages: Micro Focus Cobol, JCL, CICS and SQL
Database: DB2, Sybase, Oracle, Informix, MySql, Tourbo imaze and Allbase
Utilities: sed, awk, perl, TSO/ISPF, VSAM, QUERY, QEDIT, ASKPLUS and SUPRTOOL
Tools: FILE-AID, XPEDITER, INTERFACE TRANSFER MONITOR, ANIMATOR
Others: Bigdata/Hadoop, HDFS, Hive, Pig, HBase, Sqoop, Flume, Oozie, ZooKeeper, Cloudera, CDH4, HiveQL, and PigLatin, Micro Focus Enterprise Server (Net & Server Express), UNIX Shell Programming, Clarify, Clear Case, CIRTIX, Connect Directory (NDM), CVS, Subversion, Control-M, Autosys & OpsWise.
PROFESSIONAL EXPERIENCE:
Confidential
Lead Database Migration specialist
Responsibilities:- Working on FCA legacy systems migration for their critical Plant Monitoring and Time Tracking business processes.
- Working on Migration of the database systems from Sybase to Microsoft SQL Server 2016 and IBM UDB 10.5.
- Worked on Database, Application and Server Migration assessment.
- Developed Migration Strategy Report.
- Developed Migration Estimates.
- Working on proof of concept for Database and Application migration.
Confidential
Application Specialist
Responsibilities:
- Steered process re-engineering, defect tracking and root cause analysis on production related issues.
- Handled codes development, modification & bug fixing; involved in extraction, transformation & loading of data to DWH Tools.
- Development, supporting applications products and client-specific applications software.
- Investigate the options available for migration from the HP3000 to the HP9000 HP-UX Servers.
- Migrating Application from MPE/iX to HP-UX client/server applications.
- DB2 UDB Application and DB2 Admin Support.
- Data Integration, Performance Tuning and troubleshooting problems.
Confidential
Software engineer
Responsibilities:
- Offered 24/7 support and maintained mission critical SAP Oil & Gas - Production and Revenue Accounting system.
Confidential
Associate Consultant
Responsibilities:
- End to end Support for Component Information system.