Prabhat K. Ghosh
Jersey City, NJ *****
Email: ***********@*****.*** Cell: 201-***-****
Team-oriented IT professional with balance of technical and management skills and expertise in Database Engineering/Administration, Database Security and Project Management. Sound ability to conduct research and interpret qualitative and quantitative analysis, and problem solving. Proficient in Bigdata MPP, NoSql technologies
Customer-focused and adaptable to variety of work environments, with high tolerance for risk and
stress associated with tight deadlines. Areas of expertise:
Oracle and SQL Server Administration
Real Application Clusters (RAC)
Performance Tuning
Recovery Manager (RMAN)
Data Guard,
Golden Gate
Oracle Enterprise Manager (OEM)
Disaster Recovery Solutions
Unix Shell Scripting
PL/SQL, Pro*C and C
Database Vulnerability Evaluation
Data Encryption and Masking
IBM Guardium
Oracle Advanced Security
MongoDB Administration
Project Management
Technical Proficiency
Database : Oracle (9i, 10g, 11g, 12c), SQLServer 7/2008, MongoDB 2.4/6
ERP Software : PeopleSoft, Oracle Financials, E-Business Suite
Monitoring Tools : HP OpenView, BMC Patrol, Oracle Enterprise Manager (OEM 12c)
ETL & LDAP : Oracle Warehouse Builder (OWB), DataJunction, SQL*Loader, OID
OS : Unix (AIX, Solaris, HP_UX), Windows & Linux
Languages : C, SQL, PL/SQL, COBOL, FORTRAN, JAVA, Unix shell script
Professional Experience
J P Morgan Chase 2015 – Current
Database Administrator
Responsible for Architecture, Design, Configuration and Maintenance of large/complex Oracle 10g, 11gR1/2 RAC databases under Linux/Unix environment
Set up and support Active and Physical Data Guard and Golden Gate
Perform database backups in prod and non-prod environments using RMAN, Net backup
Provide application and database performance tuning at DB and SQL levels
Proactively identify, troubleshoot and resolve live database systems issues using OEM
Troubleshoot and resolve: ASM, Data pump, Partitioning, Materialized views issues
Collaborate with Dev, UAT, QA and production support teams on projects and production issues
Program in PL/SQL and UNIX Shell Scripting for leading automation efforts
Collaborate with business and development team in database consolidation using oracle 12c architecture
Team with Business Development, Infrastructure and software vendor to resolve complex global database issues
Configured, tuned, and troubleshoot database encryption solutions: Oracle TDE, IBM Guardium Data Encryption
MetLife Inc. 2000 – 2015
Senior Database Engineer /Administrator
Led offshore DBA team to develop and maintain over 400 company-wide secure Oracle database infrastructure (installation, upgrade and patch) running under AIX, Solaris, Linux and Windows
Supporting Oracle databases running PeopleSoft financials and FileNet application
Collaborated with application development team in architecting, installing and deploying two node Grid Control, RAC and ASM oracle environment using Solaris/Redhat LINUX cluster
Worked closely with vendor and internal security and audit teams to understand business requirements and provided Guardium expertise in helping to design, configure, and test delivered solution
Planed, documented and Supported Company-wide Database Security patches
Implemented Oracle security features (data encryption, listener password, auditing) and developed code to avoid improper input, SQL injection and improper authorization
Developed and documented technical proposals and project plans including establishing objectives, justifications, schedules, for security software POC for AppsSecurity and IPlocks
Set up and enhanced Business Continuity and Disaster Recovery Plan (BCP & DR) by using Data Guard and Oracle Golden Gate
Installed and upgraded MongoDB 2.4 to 2.6, monitored Mongo Systems, automated routine tasks
Built and maintained mission critical MongoDB clusters using sharded clusters, HA/DR strategies
Maintained, monitored, tuned, and supported existing MongoDB database environments for production, staging, QA and development environments
Worked closely with various development teams across firm to ensure proper use of Mongo/Oracle features, best practices, and adherence to database standards
Performed database and SQL performance tuning at PeopleSoft and FileNet environments
Automated DBA and regular health check tasks by writing Unix shell, SQL and PL/SQL scripts for gathering statistics, full and incremental RMAN backup and archive logs rotation
Provided full project life cycle DBA support in implementing PeopleSoft Financial, Vignette (content management software to develop Company’s main web site: Metlife.com) and Filenet (document management software) implementation
Led Data Utility (DU) Program - shared service designed to allow multiple applications to be housed on five Sun 15K machines
Installed and upgraded Oracle (9i to 10g & 11g, 12c) and OEM (10.2.0.5 to 12c), MongoDB (2.4/2.6) Guardium (8.2, 9.2)
Trained junior system engineers and DBAs on database security and DBA responsibilities
Liberty Securities and Investment Corporation 1999 – 2000
Senior Database Administrator
Supported implementation of Oracle financials (ERP application) and Ported back office applications (US treasuries, corporate Bonds, Repos) from SqlServer to Oracle 8i
Maintained security infrastructure, including IPS, IDS, log management, and security assessment systems. Assessed threats, risks, and vulnerabilities from emerging security issues at different trading applications
Established vulnerability reporting criteria to insure protection of different trading applications
Performed and created procedures for system security audits, penetration-tests, vulnerability assessments
Developed and implemented secure backup & recovery strategies including high availability features such as symmetric replication and standby and standby database
Conducted review of logs and use access data availability and regular and privileged users
Price Waterhouse Coopers 1998 – 1999
Principal Consultant
Worked at client sites Warnaco (1/99 – 3/99) and GT software (8/98 – 12/98)
Planned and coordinated team of system, network and application administrators to review and suggest proper access-controls, separation of duties, and roles at PeoplseSoft, Oracle Financials and SAP applications
Conducted technical risk and vulnerability assessments of the SAP and Oracle financials environment
Developed and implemented database policies, standards and designed business continuity and disaster recovery (BCP and DR) plan
Performed database and SQL tuning, transformed data from different sources and loaded into database using Data Junction
Installed Oracle, Oracle financials and SAP software
Education:
Master in Computer Science and Engineering (Hyderabad, India)
Certifications
CISSP : Certified Information System Security Professional - since Feb 2006
CSSLP : Certified Secured Software Lifecycle Professional - since April 2009
Certified in IT Service Management (ITIL, Foundation) - since Dec 2006
PMP : Project Management Professional - since Sept 2006
CISM : Certified Information Security Manager - since Oct 2008
Professional Honors and Awards (MetLife)
Professional Recognition for Involvement, Dedication & Excellence (Twice)
PRIDE (Partnership, Responsibility, Innovation, Dedication, and Excellence) award for core values of Responsiveness, Teamwork, Quality and Productivity