SUMMARY:

• Accomplished and highly motivated IT professional with over 20 years of experience in software industry with an emphasis on Database Architecture, Design, Implementations, and Administration on OLTP and Decision Support (OLAP) systems utilizing n - tier Architecture. A consultant with personable approach to clients & co-workers in delivering and implementing advanced database solutions to variety of businesses. Seeking the next big career challenge and an opportunity to apply his knowledge and expertise on a larger scale.
• Over 12 years of Hands-on experience in database administration in DB2 LUW 10.x, 9.x, Oracle 10g, 9i, 8i, SQL Server, Teradata 13.x-15.x and Sybase 10.
• Over 4 years of recent Big Data experience in Architecture, Implementation of big data Systems using MongoDB, Cloudera, Cassandra, Hortonworks and Amazon AWS.
• Over 3 years of experience as MongoDB NoSQL Database administrator.
• Worked on MongoDB for Confidential to architect, design, implement and manage a 20 TB clusters with Automatic Failover (with Replica Sets) and Sharding on 20 physical nodes in Production.
• Hands-on experience in building and supporting multi-terabytes clusters using MongoDB and Cloudera on enterprise Linux environments (such as CentOS/RHEL etc.)
• Experience in managing various infrastructure/DBA teams in an on-site & Off-shore model.
• Experience in managing Vendor Cloud Service providers such as AWS, VirtuStream and MS Azure.
• Strong understanding of Hadoop ecosystem such as HDFS, Impala, Kafka, Hive, PIG, MapReduce, HBase, spark, Zookeeper, Hadoop streaming, Sqoop, Flume, Avro and oozie.
• Experience in programming Python, Perl and shell scripting on various flavors of UNIX, Linux and Windows.

PROFESSIONAL EXPERIENCE:

Confidential, Atlanta, GA

MongoDB DBA--Manager Database Operations

Responsibilities:

• Manage North America database support (RDBMS and No-SQL) landscape for the North America operation for the Bottling Investment Group.
• Architected/Managed/Supported several documents based applications using MongoDB 3.4 and their Migration to AWS cloud.
• Worked with the vendor 10Gen for MongoDB support contract.
• Managed/Supported several applications with Databases (close to 6 Peta Bytes) hosted on Oracle, Teradata, DB2 LUW, Mainframe and MS SQL Server.
• Migration of entire coke database infrastructure from CCR’s data centre to multiple could environments - VirtuStream and AWS for SAP and Non-SAP platforms.
• Project Blitz - Resource reduction/optimization of all the newly built database server platform at VirtuStream cloud.
• Day-to-Day database operations in SAP and Non-SAP environment and P1/P2 Incident resolution.
• Manage various vendors in an Onsite-Offshore model.

Confidential, State of UTAH

MongoDB DBA- Data Consultant - Big Data Architect

Responsibilities:

• Worked on MongoDB for Confidential to architect, design, implement and manage a 20 TB clusters with Automatic Failover (with Replica Sets) and Sharding on 20 physical nodes in Production.
• Upgrade MongoDB from 2.4.5 to 2.6.5 on a cluster with 6 Replica Sets and 4 TB in a sharded production environment using rolling upgrade.
• Sharded a collection with 2 TB using in-place across a cluster with 8 Replica sets.
• Facilitated Enterprise support contract between Confidential and MongoDB vendor 10Gen.
• Performed a Proof of Concept (POC) for migrating Enterprise Data Warehouse(EDW) database to Hadoop Based database using Hortonworks - HDP and implemented several use cases using Hive, Pig, etc.,
• Performed a POC on Cloudera based Impala for evaluating flexibility, scalability, and cost-effectiveness, performance, usability, and SQL functionality necessary for an enterprise-grade analytic database.
• Used AWS, EMR, EC2, S3 and Redshift to quickly deploy resources needed for a Data warehousing POC.

Confidential, John’s creek, GA

Systems Specialist - Lead Database/Hadoop Administrator - Information Systems Technology

Responsibilities:

• Lead an initiative to design and successfully implement migration of High availability solution from the current HACMP to HADR with TSA and db2haicu utility using Virtual IP’s on Confidential P7 series and DB2 UDB 9.7. Fixpack 7.
• Designed and implemented strategy for hardware re-platform from Confidential P5 series to P7 Series for several production environments such as ECOM, MCHUB, Dynatrace, ECOM Async and IShip.
• Working on migration of the above e-commerce site DB2 LUW databases to 10.1.
• Installation and configuration of Cloudera Distribution for Hadoop CDH 4.1 on RHL for a cluster with 5 datanodes (20 TB) for a POC on a dell server.
• Developed and maintained the “Gold” copy of the databases for the Cloud computing using Linux VM for faster provisioning of databases for QA and development activities.
• Helped migration of Oracle databases to DB2 LUW 9.7.

Confidential, Bellevue, WA

Consultant - Sr. Database Administrator -

Responsibilities:

• Designed and successfully implemented weekly Backup and Restore strategy of 100+ Terabytes of pre-prod environment on a weekly basis.
• Installation and configuration of Cloudera Distribution for Hadoop CDH 4.1 on RHEL for a cluster with 5 datanodes (20 TB).
• Assisted Confidential in their migration of application modules from DB2 LUW to Hadoop, CDH 4.1.
• Built many environments and supported Appfluent monitoring, Informatica repository and Oracle data warehouse.
• Worked on several recovery situations for fixing bugs, crash recovery, performance issues and disaster scenarios with Confidential support.
• Worked on providing innovative solutions to meet and exceed the customer demands.

Confidential, Torrance, CA

Consultant - Sr. Database Architect

Responsibilities:

• Worked on Socrates Data warehouse project as a lead DBA to develop, support large Data warehouse of about 4 TB. Worked on Physical design and converted conceptual logical model into physical model using Erwin tool.
• Developed multi-partitioned data warehouse database 11 TB from scratch /Maintained/tuned/ support of Socrates Phase I and Phase II for Honda Finance.
• Worked on CoRe MQ Phase II project to improve functionalities such as Problem Definition Tagging, security implementation, QIS and VIN population.
• Worked on Benchmarking/implementing Optim Performance Management tool, Deep (row) compression, Workload Manager.
• Implemented Hash and Range Partition, Multi Dimension Clustering, Column Group Statistics for the Socrates project.
• Developed several Stored Procedures, Triggers and User Defined Functions for OLTP and Data warehouse application databases.
• Worked on installation, configuration and upgrade to DB2 UDB 9.1 FP 5 on AIX 5.3.
• 24/7 Production support of CoRe MQ, Socrates and various other OLTP and Decision support projects.

Confidential

Database Solutions Architect, Information Management

Responsibilities:

• Installation, Configuration, Administration and Maintenance of Maximo Asset Management and Inventory Management modules
• Installation and configuration of DB2 UDB 9.5 for a large data warehouse
• Worked on creating the database logical design model using RDA and worked

Confidential, Atlanta, GA

Team Lead/ Lead DBA-EDW, Business Information Services Group

Responsibilities:

• Lead a team of Production Support DBAs in an onsite/offshore model to support around 30 TB of Data warehousing/ OLTP environment.
• Design the Isolation of Labor application from Sales in a Data warehouse environment.
• Re-engineer the Sales schedules on Maestro for performance.
• Worked on Backup/Recovery strategy and helped Home depot with two of last four major database recovery efforts.
• Improved the performance of the nightly batch by redesigning several database activities in to stored procedures and took advantage of MQTs.
• Design, planning, configuration and development activities for a new project called Common II.
• Resolve the performance issues of some heavy-duty queries on Sales database.
• Evaluate the Query Patroller DB2 Governor for managing the ad-hoc queries.
• Lead the upgrade activity of Maestro scheduler and implement Master/Slave configuration.
• Lead the monthly release of job scheduling activities using Maestro scheduler.

Confidential, Hicksville, NY

Lead DB2 UDB EEE DBA, Sr. Technical Officer - Database Engineering Group

Responsibilities:

• Worked on Regatta (p-series 690 on AIX) Refresh project for testing the feasibility of data movement using DB2 HPU and PDB EXTRACT tools. Also, got involved in performance benchmarking, testing and implementing MDC (Multi-Dimension Clusters) and building Sandbox instance and database on Regatta.
• Successfully carried out the expansion of the ECDM DB2 mart with a size of 1.1 TB data on a nodegroup of 12 partitions (12 CPUs) to a nodegroup of 16 partitions (18 CPUs) using the Stepwise Redistribution.
• Successfully carried out a proof-of-concept to migrate the DB2 UDB databases from version 7.1 to 8.1. Put together a plan to migrate DB2 UDB marts (NWMN2, ECDM and CRDM) hosted on S80s running DB2 UDB version 7.1 on AIX 4.3 to DB2 UDB 8.1 on AIX 5.
• Implemented the DB2 UDB 8.1 Information Integrator on the EDW data warehouse to connect to various Production databases
• Designed, developed and maintained the Disaster Recovery strategies for archiving more than 2.5 TB of data for warehouse and marts on a monthly basis.
• Worked with the Data modeling team to reverse engineer data model from DB DDLs for NEWMAN data mart using ERWIN data modeler.
• Install and test special builds and fix-packs on development boxes and making sure they work.

Confidential

Advisory IT Specialist/ Sr. Staff Software Engineer

Responsibilities:

• Installation, configuration of DB2 UDB EEE 7.2 on AIX and DB2 UDB
• Installation, configuration of DB2 UDB EEE 7.2 and Performance tuning of the databases
• Migrating databases from Oracle to DB2 UDB 7.2 on AIX

Confidential, Worcester, MA

Software Engineer-DB2 UDB Database Administrator

Responsibilities:

• Successfully lead a small team of oracle developers on various Y2K projects from Wausau Insurance Company.
• Data Replication and Data warehousing
• Majestic Honda (E-Commerce website)
• Performance tuning engagement
• E-partner: An e-commerce web site

Team Lead - Software Development

Confidential

Responsibilities:

• Cloudera Administrator for Apache Hadoop
• DB2 LUW 10 for Database Administrators .
• DB2 UDB 9.7 LUW Performance tuning and monitoring workshop
• Information management Services Symposium
• Confidential DB2 Content Manager