David R Email and Phone Number

Key Assignments• Data is transferred on a daily basis from multiple data sources, such as the MySQL database and HDFS, to build the history data locally in the three-node ClickHouse Cluster.• Data Injection AWS S3 Bucket: Data Injection from different data sources, including MySQL, the ClickHouse database, and HDFS, is used to generate the History data into the Nodes AWS S3 bucket and is then used to access the data from the AWS EMR Presto.

Key Assignments• Expertise in administration cluster of Apache/Confluent Kafka, Cloudera Hadoop, Apache Solr• Expertise in administration of Hive / Drill / Hbase / Sqoop• Experience in setting up Kerberos principals and Production HDFS, Hive, Hbase, and Solr access for the new users• Strong knowledge of scripting and automation tools and strategies, e.g. Shell, Python• Effectively involved in replacing OLTP system from traditional RDBMS into Hadoop setup with HBase as primary storage and Hive as Aggregation platform. Made Apache Phoenix as SQL layer that sits on top of HBase in order to ease the customer reporting UI changes.• Implemented HA solution for Hadoop cluster by externalizing HUE, HIVE, OOZIE metadata databases into PostgreSQL.• Implemented Big Data (Hadoop) solutions for aggregation and log export in order to satisfy the exponential data growth in the transaction system. It reduced the execution time by 80%.• Implemented cost effective on-line archival solution using Apache Drill and Parquet combination and there by reduced customer log response TAT from months to hours.• Implemented incremental single view repository of 1.2 billion unique mobile numbers using PostgreSQL NoSQL plugin• Built Elastic Search cluster for data mining and identified HNWI (High Net-Worth Individual) Customers in various verticals like banking, travel, insurance etc.,• Designed data warehouse in MySQL combining two platforms data (unified platform & mGage platform) using open-source ETL (PentahoDI) for data loading.

Key Assignments• Successfully Migrated Data Center from Bangalore to Chennai DC without downtime to customers traffic, by which performance of the application is improved and saved the cost to the organization as well.• Developed ETL framework to anonymize & validate client different data sources such as CSV, EXCEL, MAIL, RDBMS, BIGDATA.• ASM migrate to new storage online• Schema migrations in various databases

Key Assignments• Installing Oracle software & Creating Oracle databases.• Performing upgrades of the database and software to new release levels• Starting up and shutting down the database• Managing the database's storage structures• Managing users and security• Managing schema objects, such as tables, indexes, and views• Making database backups and performing recovery when necessary• Proactively monitoring the database's health and taking preventive or corrective action as required• Monitoring and tuning performance