SUMMARY

• Over 10 Years of experience in Database Administration, Production, development, migration, Business Requirement Analysis, Application Design, testing, implementation and maintenance of databases in SAP HANA, DB2 UDB on LUW, Sybase ASE, MAXDB and Oracle
• 3 years of experience in SAP Basis.
• 3 years of experience in HANA implementation, migration and maintenance project
• Played key role SAP HANA mission critical BW, CRM and ERP migration project
• Done more than 20 DB migration (Oracle - > DB2, MaxDB -> HANA, DB2 -> HANA, MaxDB -> SYBASE ASE etc)
• Worked with IBM and SAP for complex issues and bug fix.
• Worked on multiple SWAT calls for P0&P1 issues, with client facing experience.
• Strong Experience in setup, implementation and maintenance of HADR with TSA set up.
• Managing Services with Vendors.
• Worked in Architecture design for multiple projects with end to end implementation.
• Capacity Planning and Hardware sizing.
• Good Experience in stored procedure, Triggers and functions.
• Strong experience in Data Modelling.
• Data Analytics on Hadoop Ecosystems.
• Worked on building Hadoop Ecosystem with Distributed Clusters.
• Currently working on IBM Watson.

TECHNICAL SKILLS

Database: DB2 UDB, SAP HANA, SYBASE ASE and MAXDB.

Hadoop Ecosystems Pig, Hive, HDFS etc.Operating systems: AIX, Linux, HP-UX, UNIX, Windows.

DB Connectivity: ODBC, JDBC

Reporting Tools Spotfire and Tableau

PROFESSIONAL EXPERIENCE

Confidential,

Responsibilities:

• Responsible for operational and delivery for all SAP / IBM Watson Data Lake DB2 databases.
• Complete ownership of end to end support for DB2 databases.
• Upgrade/Migrate databases.
• Worked on system build from Basis/DB2 side.
• Enforcing all company approved policies and procedures (SOP).
• Work with other teams to accomplish optimal results.
• Implement IT Process Management in all request.
• Coordinate with external technology vendors (IBM and SAP).
• Ability to lead projects from initial concept to successful implementation.

Confidential,

Responsibilities:

• Take complete ownership of the landscape for Database and SAP.
• Migration of MSSQL databases to DB2 databases using OS/DB Migrations.
• Responsible for end to end implementation and support.
• Migration of database to v9.1, v9.5, v9.7, V10 and V10.5
• Supported storage visualization project.
• Implementing Adaptive compression in V10.
• Case Study on column store and in memory features in V10.5
• Implements change Management controls, processes and practices to deliver quality services that increase client bottom line results.
• Provide Architect suggestion for system design from SAP, database and OS perspective.
• Data migration from Windows to Linux.
• Data migration from small Endian to Big Endian and vice versa.
• Prepared monthly reports.
• Provide 24/7 on call support.

Confidential,

Responsibilities:

• Was deployed on client side at SAP Labs Confidential Pvt Confidential
• Performed OS and database migrations from DB2 / MAX DB to SAP HANA and MAX DB to DB2.
• Working closely with SAP HANA Development team for the improvement and advancement of new features.
• Responsible for setting up of parameters for optimized performance.
• Performed frequent upgrade and migration on SAP HANA.
• Migration of database to v9.1, v9.5, v9.7 and V10.
• Implementing Adaptive compression in V10.
• Implemented Case study shared by IBM and HP to increase the performance tuning.
• Debug, repair and resolve system-level database problems
• Apply Fixpack on partitioned and non-partitioned databases.
• Migrating the database from Windows to Linux and vice versa.
• Setting up Partitioned environment.
• Performed database Cloning using EMC Console and db2inidb.
• Performance Tuning.
• Worked with clients and developers to understand their requirements and implemented the same.
• Delegated work to team members.
• Provided oncall support.

Tata Consultancy Services,

Responsibilities:

• Implements change Management controls, processes and practices to deliver quality services that increase client bottom line results.
• Debug, repair and resolve system-level database problems
• Implemented automatic maintenance of the backups
• Creation of database, instance and other database objects as and when required.
• Work with application developers (the customer) to maintain production database change windows consistent with application requirements.
• Database size reduction.
• Recovered corrupted data and eliminated data redundancy.

Confidential,

Responsibilities:

• Confidential: Canada For Transition and Knowledge Transfer to Confidential Team
• Implements change Management controls, processes and practices to deliver quality services that increase client bottom line results.
• Debug, repair and resolve system-level database problems
• Provide input to hardware and software architects and participate in hardware changes that affect the physical database.
• Creation of database, instance and other database objects as and when required.
• Work with application developers (the customer) to maintain production database change windows consistent with application requirements.
• Allocate database storage and plan future database storage based on customer Performance Tuning.
• Perform database capacity planning.
• Install, upgrade, patch (includes security patches, critical patch upgrades, performance upgrades and bug fixes), configure RDBMS and associated products and tools

IPC Data Services,

Responsibilities:

• Implements change Management controls, processes and practices to deliver quality services that increase client bottom line results.
• Install, upgrade, patch (includes security patches, critical patch upgrades, performance upgrades and bug fixes), configure RDBMS and associated products and tools
• Recovered corrupted data and eliminated data redundancy.
• Worked closely with application development team in developing, modifying or testing applications.
• Root cause analysis for issues in the production environment
• Moving data using export, import and db2move Utilities
• Q Replication Monitoring and trouble shooting.

Confidential,

Responsibilities:

• Implements change Management controls, processes and practices to deliver quality services that increase client bottom line results.
• Undertook various tuning efforts.
• Daily checked the backup manually.
• Monitor the database growth.
• Performance Tuning.
• Monitor the usage and alter the database as required.
• Provide assistance to application DBAs with application database performance issues.
• Install, upgrade, patch (includes security patches, critical patch upgrades, performance upgrades and bug fixes), configure RDBMS and associated products and tools

Confidential,

Responsibilities:

• DB2 installation and configuration.
• Configured TSM for database backups
• Catalog the databases
• Taking backups to and restoring from TSM
• Implements change Management controls, processes and practices to deliver quality services that increase client bottom line results.
• Controlled data access levels at the application and database level.
• Provide assistance to application DBAs with application database performance issues.