LENIN ARIVUKADAL

Phone: 563-***-****

Email: acsm41@r.postjobfree.com.

SUMMARY

Track record of configure and monitoring databases both RELATIONAL and NO-SQL technologies for over 9 years in the Investment Banking, Manufacturing and Health care industries.

Good background in database design, installations, performance tuning and migrations.

Experience building databases on premise and cloud infrastructure (amazon).

Well versed with HA, backup and restoration strategies, replications and DB support.

Mongo DB:

3 year of experience with NO-SQL “Mongo DB” (experience with Mongo DB scaling across data centers and on cloud infrastructure.

AWS Cloud:

Migrating and supporting mongo database to Amazon cloud and supporting.

Good Knowledge of AWS and related concepts i.e.EC2, S3, ELB, VPC.

DB2 LUW DB:

. Strong DB2 DBA skill set with 7 Years of experience in Design, development & Support.

ORACLE DB:

App DBA for oracle applications 11g/12c - DB deployment, DB routines and support.

ACHIEVEMENTS

Provided technical support on the architecture, design and successful implementation of a mission critical 24x7 databases for applications at John Deere.

Handled end to end database support for applications and created strategy for migration project to cloud infrastructure AWS & in backup & restoration setup on cloud.

TECHNICAL SUMMARY

DATABASE TECHNOLOGIES

Mongo DB 2.4/2.6 and NoSQL, DB2 LUW, ORACLE, POSTGRESQL,NETEZZA.

FRONT-END TECHNOLOGIES

JavaScript, JSON.

TOOLS

Pentaho,MMS, ROBO MONGO, Oracle Enterprise Manager,Sybase Power designer DB2 UDB v8.2 (Unix), v9 (LUW), v9.5 (AIX), v 9.7(Windows), Toad, DB artesian.

PLATFORMS

DB support in OS (UNIX, Linux, Windows), Amazon Linux.

SOFTWARE DEVELOPMENT METHODOLOGY

Agile methodology, Waterfall.

OTHER

LANGUAGES: PYTHON, SQL, UNIX SHELL SCRIPTING, PERL, JAVA SCRIPTING, WINDOWS BATCH SCRIPTING.

WORK EXPERIENCE

Yash (www.yash.com): From Dec11-2013 – Till date

Intelligent solution group

Deere & Company, usually known by its brand name “John Deere”, is an American corporation based in Moline, Illinois, and the leading manufacturer of agricultural machinery in the world. John Deere has around 800+ databases on different database platforms like Mongo (No-SQL), Oracle, UDB,Netezza,DB2 Z/os on around 30 servers.

Currently working with intelligent solution group of Deere on their Infrastructure side. As part of our team we support many database platforms. Streaming data platform and Agronomic decision support are two critical applications of Deere. Some of the databases like mongo have been recently migrated to AWS cloud.

Role: Senior Database Admin

Technology & Tools:

Mongo (NO-SQL)-Linux, AWS Cloud,oracle,DB2 UDB,TOAD(oracle & DB2 UDB),Robo Mongo.

Technical Contribution:

Manage and maintain mongo DB servers across multiple environments.

Design & implement sharding and indexing strategies.

Monitor deployments for capacity and performance Implement and maintain MMS (mongo DB Management Services).

Define and implement backup strategies per data retention requirements.

Develop and document best practices for data migration, excellent coaching and mentoring skills.

Strong knowledge of Change, Release, Incident, and Problem management Experience with mongo DB scaling across data centers.

In-depth understanding of Mongo DB HA strategies, including replica sets and sharding.

Performing Mongo DBA Routines & installing Mongo & MMS, capacity planning and sizing.

Optimizing, monitoring databases using MMS for better performance.

Working closely with application team for any issues and available for support.

Selection, inserting large amounts of data and creating shards...

Adding indexes to a collection. Reports in-progress operations for the database instance.

Initializes a new replica set.

Applies a new configuration to an existing replica set.

Baking AMI, creating snapshots, dealing with auto scaling group and Launch configuration setting.

Creating Amazon EC2 Instances (for Linux).

Maintaining High Availability with Auto Scaling (for Linux).

Supporting Oracle application deployments and closely work with oracle app team.

Supporting any database related issues in production databases for 24/7 on call support.

As oracle Appdba, I create tables, triggers, sequences, indexes, user access (new & existing users), dropping objects, tablespace management.

Client: John Deere, USA

Cognizant Technologies US Corp

(From 10/07/2009 till 12/10/2013)

JDLINK

It’s a very big/critical application where lot of development work is going on where they follow the agile methodology for their application development. The biggest JDLINK database is around 10 TB and other databases are around 600GB.Apart from this, there are several other Application system contributing and supporting Deere Production.

Role: Database Admin & Modeler.

Technology & Tools:

Pentaho,MMS, ROBO MONGO, Oracle Enterprise Manager,Sybase Power designer DB2 UDB v8.2 (Unix), v9 (LUW), v9.5 (AIX), v 9.7(Windows), Toad, DB artesian.

Technical Contribution:

Work closely with development on implementation of queries, collections and documents. Implement Mongo Performance best practices.

Upgrade Mongo software to latest patch releases and revisions.

Keep updated on new capabilities in Mongo DB and how those might improve our ability to service customers.

Instance and Database creation on different servers as per business requirements.

Perform capacity planning and sizing of databases based on the information gathered from the business users.

As Data Modeler - assisted many applications using Sybase Power Designer tool in Database Model Management, DDL generation & extractions, Database structure modifications, Reverse engineering, Deployment support, database creations, object modifications, Model repository maintenance and providing database alteration scripts to DBA.

Client: John Deere, USA

Manulife Insurance:

Manulife is one of the largest insurance companies in Japan. Manulife Japan is the life insurance company in Japan, providing leading financial protection and wealth management products and services.

As part of project, I travelled to Japan for 3 months.

Role: Senior Associate

Technology & Tools:

DB2 UDB (LUW), Sybase Power Designer, Toad, Control center, SQL, Programming, shell scripting.

Technical Contribution:

Instance and database creation, also statistical analysis of data as data modeler and closely with application team for database changes.

Monitoring the CPU, availability, Trends for the WIN, AIX host with NAGIOS and CACTI.

Performing rehearsal on the PS region & production and reviewing the logs for successful completion.

Implementing Table partitioning for tables, fix pack up gradation,

Reviewing and creating step document for the production releases.

Performing regression test for the batch job in the test databases and also the production releases for the application supported.

Client: Manulife, Japan.

TATA CONSULTANCY SERVICES

(From 03/27/2007 till 10/01/2009)

IM (Information Management) Group for American Express is based in Phoenix. It is responsible for design/development and administration/maintenance of all American Express databases. The TCS DBA team, which is part of AXP IM group, provides DBA services to American Express Technologies.

Role: Database Admin

Technology & Tools:

DB2 UDB (LUW), Sybase Power Designer, Toad, Control center, SQL, Programming, shell scripting.

Technical Contribution:

•Instance and Database creation on different servers as per business requirements.

•Perform capacity planning and sizing of databases based on the information gathered from the business.

•Worked on and supported multi-terabyte size Data Warehouses and Data Marts in the partitioned environments (DPF)

•Perform advanced performance tuning and optimization of database and SQL based on current workload.

•Expertise in maintaining DB2 environment including creating instances, databases, buffer pools, table spaces and tables.

Client: American express, USA & JP Morgan chase, USA

EDUCATION & CERTIFICATIONS

B.TECH. - Bachelor of Technology in Electronics and Telecommunication (from Bharathiyar College of Engineering &Tech) with 74%.

Mongo online course - M101, M102 & Advanced DBA Operations.

Netezza certification by IBM

Test 000-701 - IBM DB2 UDB V8.1 Family Fundamentals

Test 000-701 - IBM DB2 UDB V8.1 for Linux, UNIX, and Windows Database Administration certification.

Test 000-731 - IBM DB2 UDB V9. For Linux, UNIX, and Windows Database Administration certification.

Test 000-734 - IBM DB2 UDB V9. Advanced certification for Linux, UNIX, and Windows Database Administration certification

Contact this candidate