Database Administrator Senior

SUMMARY

PROFESSIONAL SUMMARY

Accomplished IT professional and a RDBMS Db2 DBA and NoSQL DB MongoDB with 10 years of experience. Good experience on implementing

• Backup and recovery strategies

• Installation of DB2 and MongoDB

• HADR

• DPF

• TSA

• HACMP

• DB2 Upgrades on LUW

• Performance tuning Db2 and MongoDB

• MongoDB Administration and Service recovery

• MongoDB Replication and Sharding configuration

• Monitoring MongoDB through OPS manager

PROFESSIONAL EXPERIENCE

Senior Database Administrator -

HSBC

Working in HSBC as Senior Database Administrator

Projects worked:

Db2 Production support for all regions of HSBC.

MongoDB Production support for all regions in HSBC. Database Administrator -

DXC Technology Limited

Worked in DXC Technology limited as Professional 1 Database Administrator Projects worked:

Farmers Insurance

Database Administrator -

Wipro Technologies Limited

Worked in Wipro Technologies as database Technical Lead Projects worked:

Northwestern Mutual

Database Administrator -

IL&FS Technologies Limited

Worked in IL&FS Technologies as database Engineer

206-***-****

************@*****.***

Redmond, WA

Linkedin Profile

Venu Babu Avala

DB2 and MongoDB 10 Years Experience

Oct '21 Present

Sep '20 Oct '21

May '19 Sep '20

Aug '18 Feb '19

Projects worked:

ANVP Smart City

DB2 LUW DATABASE Administrator -

SOFTENGER India Private Limited

Worked in SOFTENGER as database Administrator

Projects worked:

Bharti Airtel

EDUCATION

Master of Business Administration -

Jawaharlal Nehru Technological University

KEY SKILLS

DB2 MongoDB Shell Scripting Database partitioning Feature Disaster Recovery Db2 HADR Migrations NoSQL (MongoDB) MongoDB Management Service MongoDB Profiler IBM DB2 TECHNICAL SKILLS

Experience with DB2 UDB 8.x, 9.x, DB2 UDB 10.x, 11.1 & 11.5 Installations, Fixpack installation and upgrades. Backup automation using scripts and health-check implementation. Experience in project Transition and Transformation directly from customer environment. Able to use tools like db2 Load, Import, Export, db2look, db2dart, db2inspect, Reorg, Runstats, Backup, Restore and db2move.

Worked heavily on Database restores including Redirected restores within production, stage and development environments.

Monitoring Daily and Weekly Auto system jobs and takes preventive measures against failures. Part of Global UDB DBA team to provide 24x7 support using follow-the-sun support. Reclaiming space by lowering the tablespace high watermark. SQL Tuning using db2advis, db2expln and db2exfmt tools. Implemented and Worked on HADR Environment with TSA. Experience with Multi standby HADR nodes configuration. Implemented and Worked on DPF environment (Physical & Logical). Implemented and Worked on DB2 with VERITAS Cluster (VCS). Worked on Migration of databases to the latest versions. Installed Client/Server Software on Windows servers. Implemented DB2 Encryption and SSL certificate.

Implemented DB2 Audit.

Implemented Adaptive compression.

Commission and decommission of the DB2 servers.

Mar '15 May '18

Jul '12 Sep '14

Experience in MongoDB (Versions 4.2, 4.4 and 6.0) installation, configuration and administration. Tuning a collection by creating indexes.

Worked on MongoDB database concepts such as indexes, Sharding, Replication. Restore MongoDB by using the OPS manager snapshot. Monitoring and performing maintenance activities by using the OPS manager. (Versions 4.4, 5.0.17 and 6.0.16) Responsible for managing MongoDB environment with high availability, performance and scalability. Enabling profiler to find the long running queries and for performance tuning. Recovered multiple services during the major issues. CERTIFICATIONS/TRAINING

• DB2 LUW V11.x Certified.

• Actively participated in DR activities.

• Providing technical training to team members.

• Provided on job training for freshers.

• Completed MongoDB Developer Foundation (DF01) training by MongoDB Vendor.

Contact this candidate