Prabhat K. Ghosh

Jersey City, NJ *****

Email: acuf46@r.postjobfree.com 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

Contact this candidate