SUMMARY:

• 17+ Years of experience in all aspect of application design, development, legacy migration, modernization, implementation, maintenance and Database Administration.
• Self - motivated with strong leadership and team player skills, adept at motivating and supporting team members to achieve professional goals.
• Having rich experience in consulting in medium to large-scale enterprise wide migration projects.
• Strong understanding of various technologies, applications development and migration project life cycle Phases.
• Rich experience in Legacy application migration and Modernization.
• Strong experience in Requirement Analysis, Impact Analysis, System design and Implementation.
• Strong knowledge and hands-on implementation experience with Migration concepts using tool based solutions.
• 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.
• Skilled in DB2 database administration, data modeling, SQL coding, stored procedure and trigger development.
• Extensive experience in Incident Management and Problem Management.
• Certified ITSM.
• Good knowledge on IBM and AWS cloud Managed Services. Good knowledge on Docker images, containers and storage drivers.
• Good understanding and hands-on experience on migration using Micro Focus suite of products.
• Good in understanding complex interfaces across applications.
• Good 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.
• Skilled in DB2, Sybase, Oracle, SQL Server, MySQL, PostgreSQL.
• Strong experience on Micro Focus Enterprise Server Administration.
• Having strong knowledge of scripting in UNIX & Linux.
• Experienced as Application & Support DBA.
• Hands on experience in Data Integration, Performance Tuning and troubleshooting.
• Experienced in managing projects & handling responsibilities in various phases of SDLC.
• Good People management skills in hiring right talent and team management.
• Good exposures to SW build systems and configuration, change & release management.
• Effectively worked on Operating systems Windows, Linux, Solaris and Unix.

TECHNICAL SKILLS:

Operating System: Microsoft Windows, UNIX (HP & AIX), Solaris, Linux and Z/OS.

Languages: Micro Focus Cobol, JCL, CICS and SQL

Database: DB2, Sybase, Oracle, SQL Server, MySQL, PostgreSQL.

Tools: GoldenGate, Data Server Manager for Real-Time DB2 Monitoring, IBM Migration Toolkit, SQL Server Migration Assistant.

Others: Micro Focus Enterprise Server, UNIX Shell Programming, Clarify, Clear Case, CIRTIX, Connect Directory (NDM), CVS, Subversion, Control-M, Autosys & OpsWise. Bigdata/Hadoop, HDFS, Hive, Pig, HBase, Sqoop, Flume, Oozie, ZooKeeper, Cloudera CDH4, HiveQL, PigLatin, WebSphere, WebLogic and WebSphere MQ Programs Attended.

PROFESSIONAL EXPERIENCE:

Database Admin

Confidential

Responsibilities:

• Working as a DB2 SME for Federal Home Loan Mortgage Corporation. Planning DB2 server and client upgrade, Database Applications and routine upgrade. Working on DB2 database upgrade and upgrading essentials for db2 servers, data clients and Database applications. Working on tuning and monitoring Database system performance. Developing the Database Remediation Strategy Report and Remediation Estimates.
• Working on storage subsystem for data protection using TSM advanced copy services. Working on partition databases (DPF) with 32 Partitions and data partition environment.
• Upgrading the DB2 Version 9.7, 10.1, 10.5 11.1 on Linux and AIX environments.
• Migrating the DB2 database from AIX to Linux platform. implementing High Availability Disaster Recovery (HADR with TSA) and HACMP Strategy, DB2 SQL & Queue Replication, setting up the Federation databases.
• Performance monitoring and fine tuning the OLTP Applications.
• Problem determination and troubleshooting, interacting with UNIX and Application group, and playing a diverse role with a large team of DBA’s.
• Working on Oracle and Sybase database routine admin activities.
• Implementing the DB2 Governor rules on the databases based on the Business requirements.
• Configuring the DB2 Workload manager to controlling the resource consumption amongst the different application and build the Application Centric Performance.
• Developing the scripts to automate the scheduling and notification of periodic maintenance jobs, including REORG, BACKUP, RUNSTATS, LOAD, IMPORT, etc
• Tuning long running queries in OLAP and OLTP environments using db2advis, db2batch, and db2explain.

Lead DB Migration specialist

Confidential

Responsibilities:

• Worked on Confidential Legacy Plant Monitoring and Time Tracking business processes.
• Worked on Migration of the database systems from Sybase to Microsoft SQL Server 2016 and IBM DB2 10.5.
• Worked on Database, Application and Server Migration assessment.
• Developed Migration Strategy Report and estimates.
• Worked on proof of concept for Database and Application migration.
• Worked on End to end database administration tasks (installation, Database builds, managing table spaces, Creating Users, Profiles, roles and granting to users based on requirement) for Sybase, SQL Server 2016 and DB2 10.5 on windows and Unix Environment.
• Performed database move from one server to another server.
• Effectively worked on SQL Server Migration Assistant (SSMA) to migrate the database from Sybase to SQL Server 2016.
• Effectively worked on IBM Migration Toolkit to migrate the database from Sybase to DB2 10.5
• Developed the DPF on DB2 10.5.

DB2 SME

Confidential

Responsibilities:

• Supervising architectural & design specification, transforming business requirements to architectural Models, designing & developing business solutions.
• Developing high level designs meeting the prescribed functional & non-functional requirements.
• Experience in Disaster recovery, Buffer pool maintenance/tuning.
• Implemented DB2/UDB partitioning (DPF) and data partition (Table Partitioning).
• Worked on storage subsystem for data protection using TSM advanced copy services.
• Database operations like Tuning, monitoring, backups & recovery, Data loads and other Database operations.
• High availability and disaster recovery experience with DB2 HADR.
• DB2 database administration, data modeling, SQL coding, stored procedure and trigger development.
• Tuning long running queries in OLAP and OLTP environments using db2advis, db2batch, and db2explain.
• Writing Shell scripts to avoid all the manual efforts in the application.
• Perform capacity planning and analysis and implement required changes
• Worked on enhancements of systems and change of code for the changing requirements from the client side.

TECHNICAL MANAGER

Confidential

Responsibilities:

• End-to-end project management activities inclusive of planning, designing, scope, and estimation, tracking milestones, Resource, task list, resource coordination and delivery as per specified time frame.
• Served as a key driver of pre-sales activities across technology, handled proposal submission process, quotation gathering, consolidation and solution suggestions
• Collaborated with interface teams for on-going enhancements & implementations.
• Supervising architectural & design specification, transforming business requirements to architectural Models, designing & developing business solutions.
• Defining service standards and guidelines as per global best-practices, governance structures and best practices for software delivery life cycle and documentation that serve as benchmarks for excellent service delivery.
• Developing high level designs meeting the prescribed functional & non-functional requirements; ensuring the design is as per company standards and best practices.
• Leading, mentoring & monitoring the performance of team members to ensure efficiency in process operations. Developing competency among the team members.
• Steered process re-engineering, defect tracking and root cause analysis on production related issues.
• Liaised with interface teams for on-going enhancements & implementations.
• Ensured process change deliver to meet end user’s requirements.
• Worked on IBM WebSphere Application Server on Linux Environment.
• Handled codes development, modification & bug fixing; involved in extraction, transformation & loading of data to DWH tools.
• Exceptional skills in Tuning and analyzing application code such as SQL, Triggers, Stored Procedures, CPU, I/O, Memory, setting up Backup and recovery strategies, Scheduling jobs, developing database procedures and functions.
• Implemented DB2/UDB partitioning (DPF) and data partition (Table Partitioning).
• Worked on storage subsystem for data protection using TSM advanced copy services.
• Extensively worked with DB2 Explain, Runstats, REORG and other ONLINE and Offline utilities.
• Has extensive experience in Database operations like Tuning, monitoring, backups & recovery, Data loads and other Database operations.
• Working on TSM backup and restore.
• Working on Micro Focus Enterprise server.
• High availability and disaster recovery experience with DB2 HADR.

Technical MANAGER

Confidential

Responsibilities:

• Steered process re-engineering, defect tracking and root cause analysis on production related issues.
• Liaised with interface teams for on-going enhancements & implementations.
• Ensured process change delivered to meet end user’s requirements.
• Handled codes development, modification & bug fixing; involved in extraction, transformation & loading of data to DWH tools.
• Tuning and analyzing application code such as SQL, Triggers, Stored Procedures, CPU, I/O, Memory, setting up Backup and recovery strategies, Scheduling jobs, developing database procedures and functions.
• Working on OLTP databases for Private Banking system.
• Managed Sybase databases running on UNIX servers.
• Providing the technical assistance to the developers.
• Created various shell scripts to automate database maintenance.
• Involved in the database upgradation and migration activities.

TeCHNICAL MANAGER

Confidential

Responsibilities:

• Developed the Assessment technique AHP - Analytical Hierarchy Process to derive the Business Value, Risk Exposure and Capability improvement weightage.
• Developed the Legacy migration approach using AHP model.
• Worked on storage subsystem for data protection using TSM advanced copy services.
• Worked on DB2 Explain, Runstats, REORG.
• Database operations like Tuning, monitoring, backups & recovery, Data loads and other Database operations.
• Working on TSM backup and restore.
• High availability and disaster recovery experience with DB2 HADR.
• DB2 LUW Application and DB2 Admin Support.

Senior TECHNICAL LEAD

Confidential

Responsibilities:

• Managed database instances for Wealth Management systems in DB2 UDB on AIX and Linux servers.
• Provided DBA 24x7 on call Support for Production databases.
• Troubleshooting all database related issues and on-time resolution for all PROD and DR issues.
• Responsible for DB2 UDB upgrade planning and design.
• Analyzing and tuning the performance of DB2 UDB and Applications.
• Understanding the database workloads configuring the database for optimal performance.
• Monitoring the database and UNIX system performances. Used several tools like snapshot monitor, Event monitor and SQL explain facility.
• Installing DB2 fix packs and perform the necessary tasks before and after installation.
• Working with IBM DB2 support to resolve database and OS related issues.
• Worked on Database operations like Tuning, monitoring, backups & recovery, Data loads and other Database operations.
• Working on Enterprise job scheduling.
• Working on Micro Focus Server Express and COBOL

Senior Consultant

Confidential

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.
• Working on Micro Focus Server Express and COBOL.

TECHNICAL CONSULTANT

Confidential

Responsibilities:

• Offered 24/7 support and maintained mission critical SAP Oil & Gas - Production and Revenue Accounting system.