RIDDHI SHAH

: +91-797******* : adlphs@r.postjobfree.com Location: China; willing to relocate

PROFILE

Certified DB2 11.1 professional with 10+ years of experience involving DB2 database development, administration, data architecture and modelling, implementation, extensive performance tuning, deep troubleshooting, high availability including HADR, SQL coding in development and production environments on UNIX, Linux, and Windows

AREAS OF EXPERTISE

DB2 Database Administration DevOps Engineering Database Programming Database Tuning Server Migration Disaster Recovery DW Reporting Shell Scripting Database Maintenance CRUD Operation Performance Tuning ITIL Implementation Incident Ticket Management Change Management Service Request Management

TECHNICAL SUMMARY

Expert in DB2 8.2/v9.x environment developing and maintaining database backup and recovery systems, installing, configuring, upgrading, maintaining, monitoring and tuning DB2 databases, providing 24x7 production support services

Very good understanding of DevOps concepts and a critical thinker of its different application areas

Experience in performance tuning for a large DB2 AIX data warehouse system

Skill in planning and implementing HADR High Availability Disaster Recovery environment

Delivered an infrastructure prioritized action plan with initiatives for mitigating identified risks and for moving toward the desired state network, storage and disaster recovery environments

Exposed to shell scripting and implementing scheduled jobs in AIX and Windows

Equipped with data maintenance using various DB2 utilities like reorg/runstats

Proven experience in installation, configuration and monitoring IBM CDC (Change Data Capture) for data warehouse reporting purpose

Well versed with backup tools like TSM and NetBackup

CAREER HISTORY

IBM Technology Feb 2017 -Ongoing

Service Delivery Specialist

Client: IBM China GDC Location: Shenzhen, China

Heading end-to-end activities on incident management, release management, and change request management

Providing production support within the areas of problem resolution, implementation of service requests/emergency changes and scheduling

Testing, building, designing, deploying and maintaining continuous integration and continuous delivery process using various tools

Leverages expertise in choosing the best tools and technologies as per the business needs

Working closely with the development and operations team such that the application is in line with performance according to the customer's expectation

Implementing regular alerting and monitoring of database performance which reduces database downtime through quicker response times

Leveraging expertise on EMC VMAX10K, VMAX 20K, VNX 5700

Configure HP P95K, 10K for allocation

Collecting SP collects and Support material from VNX, Clarion and Celera arrays regarding the issues faced on the arrays

Log calls with vendors for any hardware faults on storage arrays and CISCO switches

Providing advanced DB2 expertise to clients including extensive performance tuning, deep troubleshooting, data storage architecture, SQL analysis and tuning, memory allocation and architecture

Beyond Private Limited Feb 2014 - Jul 2016

Senior Database Engineer

Client: IBM China GDC Location: Shenzhen, China

Managed database and maintenance activities like reorg & Runstats

Configure and tune DBM and DB parameters

Implement best practices of ITIL process

Resolved DB related issues and worked with DB team for DB performance tuning

Responsible for shared ID's and client data

Create, delete, manage services and accounts in ITIM

Granted access to shared ID's and added members to the roles

Worked on LDAP, TDS and TDI for daily BAU activity

iGate Global Solutions Mar 2013 - Oct 2013

Senior Systems Engineer - IMS

Client: MetLife Insurance Private Limited Location: Mumbai, India

Installed and configured DB2 on AIX server for DEV and production environments

Migrated DB2 9.5 (32 bit) to DB2 9.7 (64 bit)

Configure for high availability with ACR HADR

Extensively used tools like db2advise, db2explain, db2look, db2move, db2top and db2adutl to monitor, analyse and make changes in the database

Regularly maintained DB objects for better performance

Resolved regular performance issues like locks, execution plans, physical reads

HSBC Software Development India Private Limited Nov 2012 - Jan 2013

Database Administrator Location: Pune

Installed and configured database server and ensured availability of the required information

Handled data transfer from the existing system to the new platform

Crated backup and recovery plans and procedures within the time and as per the cost

Setup employee access and provided privileges as per the organization policies

Atos Origin Aug 2010 - Nov 2012

Associate Engineer

Client: Standard Chartered Location: Mumbai, India

Monitored load and CPU usage and tuning parameters to improve performance

Configured and tuned DBM and DB parameters

Maintained online/offline backup of databases daily

Scheduled jobs like backups/DB health check-up on UNIX system

Created and maintained database objects and grant privileges

Performed regular levels of performance reports and created snapshots to analyse performance

Restored databases using redirect restore and roll forward recovery

Closely monitored long running SQLs, HADR status, Hit ratios and tuning to improve performance

Implemented changes as per the process and closed incident tickets

EDUCATIONAL QUALIFICATIONS

Bachelor of Science - Information Technology, Mumbai University, India (2010)

Certification

DB2 10.5 Certified Professional

Contact this candidate