Prabin Bhandari Email & Phone Number

San Jose, Ca, Us

Redwood City, California, Us

Redwood City, California, Us

Santa Clara, California, Us

• Installation and maintenance of Oracle RAC, MS SQL Server clustering and MongoDB databases on Linux and Windows Servers using Hitachi VSP G/F Series storages.• Migrate On-premises Oracle and SQL databases to Cloud - Oracle Cloud Infrastructure (OCI) and Microsoft Azure • Manage and monitor Oracle RAC cluster and Oracle Data Guard environment.• Design Oracle and SQL Server backup strategy, scheduling and implementing database backup and restoration using Oracle RMAN and SQL Maintenance plan• Execute routine Databases and applications upgrades and applying Quarterly Security and One-Off patches • Design and architect a dashboard using Hitachi storage, Pentaho PDI ETL, Oracle and MongoDB databases.• Lead projects to certify MS SQL Server and Oracle RAC Databases with Hitachi VSP storages through various proof of concept project by running benchmark tests.• Create parity group, pools, LDEVs, and mapping devices through Hitachi Storage Navigator• Create Engineering Reference Document (ERD), Reference Architecture (RA) documents

San Jose, Ca, Us

• Installing, managing, and administering oracle multitenant database 12c CDB & PDBs in prod and development servers.• Administer databases running on SQL Server Standalone, Replication and SQL Always On platforms on SQL 2012, 2014, 2016 using SQL Server Management Studio• Coordinating cross-functional team in an effort to drive PoC initiatives to certify new and existing technologies.• Upgrading and patching oracle databases including production and gold code tree (GCT).• Experience working on Oracle TimesTen In-Memory databases to improve response time and meet the demand of the high throughput.• Benchmarking for Oracle databases running on Virtual and Bare metal machines using tools such as Swing bench, SLOB, and ORION.• Working knowledge in installing, configuring, and managing MongoDB databases 2.4.x & 3.x with multiple instances on the servers.

Houston, Texas, Us

• Supported Medi-Cal applications/components, SURGE, E-TAR databases deployed in oracle real application cluster/Linux environment, Data Mart Servers. Batch jobs and OEM, and Extensive use of RMAN Technology.• Maintained & monitored 5 nodes production and 4 nodes development Real Application Clustering environments.• Administered, managed, maintained DSS Datamart databases in Linux AS 4 servers with two RAC Nodes.• Developed RMAN script to take RMAN Full backup for datafile, archivelog, and controlfile.

Basking Ridge, Nj, Us

• Installed and Tested standalone and RAC database instances for applications such as IConfig, IP Manager to design, create, test, and manage IPV4 and IPV6 network addresses.• Used direct and conventional path methods for SQL Loader to insert data from flat file to oracle tables.• Optimized Instance parameter settings for Shared Pool, Buffer Pool, Log Buffer, Sort Area and evenly distributed control files, log files, data files on multiple disks to balance I/O.

Chicago, Illinois, Us

• Worked on the SCREEN3 project which is about how the users get their up to date news, sports, weather reports with 0 clicks on the Motorola handsets and legacy devices. • Upgraded Oracle Databases from 9i to 10g in prod/non-prod environments.• Designed oracle backup strategy, scheduled and implemented database backup by using Import/Export, cold/hot backups and data pump utilities.• Installed and Implemented Oracle Downstream Capture at high volume OLTP environment.

Bachelors, Economis, Computer Science

Master’S Degree, Computer Science