Deepesh Bhatia Email & Phone Number

Austin, Texas, Us

Austin, Texas, Us

Austin, Texas, Us

Lead the implementation of Data Lake using Kafka, Python, SQL, Presto, Apache Spark, Vertica, MinIO AWS Services Apache Airflow, Notification based real time processing.• Responsible for Big data initiatives and engagement including analysis, brainstorming, POC, and architecture. • Lead the data lake solutions to empower data warehousing system.• Lead the migration from old ETL based architecture to real-time data pipelines architecture.• Designed and developed data processing pipelines on a high volume (25 Million requests/day) with near real-time using aggregates reported to executive reporting from 15-20 minutes to 5-10 seconds. • Designed and developed lambda-architecture processing for critical data sets using Kafka and Spark, hive, Hadoop, presto, AWS EMR, s3, apache minIO.• Lead the implementation of SSL and data security implementation.• Designed and built PCI compliant data pipelines to encrypt PCI & PII data at rest and in fly.• Wrote python-based Processing engine to processes csv, json, pickle file, airflow for auto pilot imaging system

London, Gb

NO-SQL Technologies:MongoDB:• Installed, configured MongoD, MongoS, Config Servers Linux 64 bit platform with best practices• Implemented 11 nodes sharding cluster with 5/3/2 node Replica sets to best fit application performance and reliability.• Experience in maintaining setting up poc, pre-prod clusters in Mongodb Environment.• Experience in installing and maintaining On-Prem Mongo Ops Center, Mongo Backup Agent service Mongo databases for Point in time recovery strategies.• Implemented, environment based Backup and Recovery procedures• Created policies and developed models to support MongoDB Backups, Notifications and Security in non-MMS environments Cassandra:• Installed Cassandra 2.0 in Production, Pre-prod environments as per best practices.• Configured 12 node Cassandra clusters with 4 datacenters across different regions. • Experience in Tuning Cassandra for Read/Write Workloads.• Experience in building scalable and fault tolerant Cassandra production database system• Experience analyzing Big data internal structure in to provide custom results in big data space.• Experience in storage model in Cassandra and implemented various optimal configuration to meet storage requirements • Experience in administrating Cassandra cluster using Opcenter 5.0• Experience in installation, configuration and management of Hadoop Clusters • Experience in managing the Hadoop infrastructure with Cloudera Manager. • Knowledge of in various Hive, pig, hdfs, map reduce.SQL Technologies:• Experience in setting and configuration High availability solution like Oracle 11gR2 4 Node RAC on exadata, adding and deleting node to RAC cluster online.• Experience in setting up disaster recovery solution like Data guard, Standby Databases, Replication, Always On, and Golden Gate.• Excellent knowledge in Backups, Recovery and Cloning of databases using RMAN & exposure to various technology using VERITAS Net Backup, snapshot technologies.

London, Gb

As a Sr. Database administrator responsible for supporting more than 25 Banks using Monitise platform, implementation, and production support Oracle 10g, 11g, MS SQL Server 2008 R2, 2012, troubleshooting production issues.

Teaneck, New Jersey, Us

As Oracle DBA consultant Working on below cliient.- Amgen : an American-based multinational biopharmaceutical company headquartered in Thousand Oaks, California. Worked as Oracle DBA in team supporting more than 1500+ databases, and working actively in migration from various data center to los Vegas datacenter ,implementing Oracle 11gR2 RAC, Dataguard, HP Database and Middleware Automation .

Thousand Oaks, Ca, Us

Worked in a team that supported more than 1500+ databases, actively worked on migration from various data center to los Vegas datacenter, implementing Oracle 11gR2 RAC, Dataguard, HP Database and Middleware Automation.

Noida, Uttar Pradesh, In

I was working as Senior Specialist System ( Sr. Oracle DBA) HCL Comnet System Pvt. Ltd. Worked on below projects.- Johnson & Johnson (Jan 2008 – Apr 2011) - Fox News (Apr 2011 – Jan 2012)

Worked for Client: Ranbaxy, Gurgaon, India• Worked as trainee DBA for 9 months and then as joined full time Oracle DBA.• Installation and implementation of the Oracle8i, 9i on Windows NT, Linux environment.• Performed recoveries using hot and cold backup, applied on-off patches, patch sets.• Upgraded the databases from 9.2.0.8 to 10.2.0.4.• Setup the backup for SAP Database backup management using (Brtools).• Worked as administrator SQL Server databases.• Write and modifying UNIX shell scripts to manage Oracle environment.• Cloning databases manually as well as via RMAN tool. Installation, setup and configuration of Data guard. • Used PL/SQL, SQL Loader as part of ETL process to populate the operational data store.• Worked database development writing PL/SQL code, analyzing business requirement.

Bachelor'S Degree, Computer Science

12, Physics, Chem, Maths, English