Pankaj Dhar
Seattle,WA
Summary
Experienced and Certified Oracle Database Administrator with expertise in Database Design, Server & Storage requirements, Sizing, Migration, Upgrade, Disaster recovery, Cloning, and Performance tuning for Oracle databases for over 20 Years. Successfully achieved results for various database upgrades, and migration from one environment to another at different organizations. Have successfully implemented a Real Application Cluster (RAC) under Sun Solaris and Red Hat Linux with NetApps Storage of 30TB in Size. Have migrated one student database to a cloud environment, Azure. Have successfully implemented Peoplesoft and Banner Projects. Currently teaching master’s class students at Ramakrishna Mission Vivekananda Research and Educational Institute, a deemed University for Oracle Database Administration (19 and 21c) in India.
Overview
30
30
years of professional experience
1
1
Certification
Work History
Sr. Database Administrator
University of South Florida
Tampa, FL
08.2016 - 05.2020
- USF is a leading state university located in Tampa, Florida
- Offered various database services to USF for managing ERP and other systems
- Besides USF, was also helping 3 other educational institutes with their ERP system
- All 4 universities combined, were supporting over 200,000 students and faculty members
- As a senior team member who will interact with developers, clients, and end-users for their database requirements
- Have completed upgrade and Migration of various student-related applications like Result, and Degree Work system to newer environments including cloud, Azure for two Schools (out of 4)
- Peoplesoft HR and Personnel System Upgrade of database for USF
- Areas Worked – Administer, Maintain, Upgrade, Clone, DR, Active Data Guard, OEM, ODI, Backup & Recovery, Patching, Security, Banner database, Sun Solaris, Linux
Sr. Database Administrator
Bright House Networks
Tampa, FL
07.2014 - 07.2016
- Bright House Network is an ISP service provider in 4 markets places including Tampa
- Bright House network subsequently became Spectrum
- My biggest achievement of building four 5-node Oracle RAC clusters with NetApp storage
- I also helped migrate the phone system from one 2 node RAC cluster to a newer environment of 30TB size
- I have successfully implemented Oracle Enterprise Manager to monitor various databases and nodes
- Areas Worked – RAC and Single Instance administer, Maintain, Upgrade, Clone, HA, DR, Active Data Guard, Golden Gate, APEX with REST, OEM, Backup & Recovery, Patching, Sun Solaris, Linux
Senior Database Administrator
Harvard University
Cambridge, MA
05.2005 - 05.2014
- Successfully managed and upgraded Students and Financial System from 9i to 10g to 11g
- Both systems subsequently migrated from a single instance to RAC on Net Apps SAN storage and ASM (EMC’s VNX)
- Successfully tested metro cluster (Harvard University, Cambridge, and another campus in Downtown Boston) set up of RAC
- Successfully upgraded a large social project database called Implicit
- Besides Oracle, also worked on MySQL with Master-Master replication and MySQL 5 node cluster
- Areas Worked – RAC and Single Instance administer, Maintain, Upgrade, Clone, HA, DR, Active Data Guard, OEM, Backup & Recovery, MySQL, Patching, Linux
Senior Database Analyst
AstraZeneca
Westboro, MA
08.2000 - 05.2005
- AstraZeneca is a leading pharmaceutical company
- I was supporting Oracle 8i and 9i databases for various applications related to manufacturing, Finance, QA, and Training Management systems in the development, Test, and Production on Windows and Red Hat Linux environments
- My big achievement was writing an automated interface between SAP and LIMS application using PL/SQL scripts
- Areas Worked – Single Instance administer, Maintain, Upgrade, Clone, DR, Backup & Recovery, Patching, Windows and Linux.
Oracle Database Administrator
Peoplesoft
Marlboro, MA
04.1997 - 07.2000
- During this period, I worked in 3 organizations as a consultant supporting oracle and PeopleSoft implementation.
- I have successfully made operational Peoplesoft Manufacturing, Financial for Corning Corporation, Sterilite Corporation, and
- Student system at Selam State University.
- Ares Worked – Single Instance Oracle database Administer, Maintain, Upgrade, Clone, Backup & Recovery, Patching, Peoplesoft middle-tier setup, App server setup on Windows and Sun Solaris.
Technical Director
National Informatics Center
03.1990 - 03.1997
- National Informatics Center, NIC, Govt of India enterprise is responsible for providing computer-related services to various Government Organizations in India.
- Services include turnkey projects for State, Local, and Federal Govt organizations.
- I have successfully managed various large projects like t1990 Census, and Small-Scale Industry Census
- One of my big achievements successfully implementing of Vehicle Registration System in Kolkata. Project got operational with oracle 6.
Education
Ph.D. -
Poona University
Poona, IndiaPost Graduate Diploma - Computer Management
Poona University
Poona, IndiaSkills
- Oracle
- Create, Maintain, Administrate, Clone Oracle database from 7 till 19c
- Oracle RAC databases for 10g, 11g, 12c, 19c
- Database patching
- ERP system Peoplesoft
- ERP system Banner
- Backup & Recovery, RMAN
- Active Data Guard
- Golden Gate
- Disaster database setup
- ODI
- Enterprise Manager, OEM
- Performance Tuning
- NetApp Storage, EMC’s VNX
- SQL, PL/SQL, Perl, Unix Shell scripting, Bash scripting
- Various tools like Toad, SQL Developer
- APEX, two and three-tier with web logic and REST
- RedHat Linux, Sun Solaris, Azure (Cloud) environment, Windows NT
- Database Patching
- Very Large database, 30TB
- On-Call rotation
- MySQL
- Create, Maintain & Administer MySQL on VM, on servers
- Master-master replication
- Experience with
- MySQL Custer
- Managed using Manage Engine and OEM plugins
- Ubuntu
- Implementing security measures
- NetSuite ERP
- Relational Database Management
- Running backups
- Linux operating system
- Written Communication
- Decision-Making
- Critical Thinking
Certification
Oracle Certified Professional, OCP
PERL programming certificate from Harvard University
Timeline
Sr. Database Administrator
University of South Florida
08.2016 - 05.2020
Sr. Database Administrator
Bright House Networks
07.2014 - 07.2016
Senior Database Administrator
Harvard University
05.2005 - 05.2014
Senior Database Analyst
AstraZeneca
08.2000 - 05.2005
Oracle Database Administrator
Peoplesoft
04.1997 - 07.2000
Technical Director
National Informatics Center
03.1990 - 03.1997
Ph.D. -
Poona University
Post Graduate Diploma - Computer Management
Poona University
Similar Profiles
Karina JimenezKarina Jimenez
Receptionist at University of South FloridaReceptionist at University of South Florida
Jace ErvinJace Ervin
Student Nurse at University of South FloridaStudent Nurse at University of South Florida
Joshelyn GuimarayJoshelyn Guimaray
Graduate Research Assistant (Water Treatment Focus) at University of South FloridaGraduate Research Assistant (Water Treatment Focus) at University of South Florida
ARTHUR EliasARTHUR Elias
Lead Hard Scape at University of South FloridaLead Hard Scape at University of South Florida
Victor BautistaVictor Bautista
Transportation Manager at J.B. HuntTransportation Manager at J.B. Hunt