SUMMARY

• Experience of over 11+ years in Security Engineering & Solutions, Data Security and Administration, policies, standards and guidelines.
• Experience of over 12+ years in data security, database engineer and administration on UNIX, Linux and .NET Platforms.
• Experience of approx. 7+ years in design, architecture, installation, deployment, configuration and production support of security and SIEM products like Oracle IAM (identity access management) Security Suite part of (Oracle Fusion) (Components: OIM, OAM, OAAM, OES, and OUD) on UNIX/Linux and .NET Platforms.
• Managed and provided current security risk assessment status via audit and monitoring reporting tools.
• Responsible for creating acceptable information security risk controls and policies.
• Solutioned, Installed and Configured oracle security software suite of products Database, RAC, OID, OIM, OAM and SSO in primary and DR sites.
• Experience with Oracle AD connectors, authentication, provisioning and recon jobs. Strong experience in SOA architecture, Web Services ( ReST, SOAP, JSON etc.) and security protocols LDAP, OAUTH & XML based.
• Installed OEM Oracle Agents, configured database in OEM. Worked extensively on Oracle Tools like OEM, Grid Control and Monitoring through 11g grid control/OEM 12c.
• Installed oracle 12c/11g/10g/9i databases on AIX, SOLARIS, LINUX, HP - UX and upgraded databases from 9i to 10g & 11g, 10g to 11gR1 & 11gR2 versions.
• Oracle Database Engineer with 12+ years of experience in Database Administration on Oracle11g/ 10g RAC, 9i versions in different environments like Oracle Linux, Windows, HP-UX, IBM-AIX, Sun Solaris.
• Strong experience with CDB and PDBs of Oracle 12c databases.
• Strong experience in managing and applying security patches i.e. CPU, PSU on standalone and RAC-one database servers of 9i, 10g, 11gR1 and 11gR2.
• Good experience in implementing database security features like profiles, roles, privileges and auditing.
• Expertise in manual and automated database installation.
• Worked on GRID Infrastructure, CRS management and Real Application Clusters (RAC) in Oracle 10g and 11gR2.
• Worked as team lead to design, create, manage, support and enhance large databases for applications running in parallel phases such as development, system & regression testing and production.
• Ability to handle multiple projects with deadlines to meet SLAs and have good coordination skills with management, development teams, vendors and systems administrators.
• Worked in tandem with developers to implement and maintain the database design, create database objects, promote data model releases to various environments and monitor application related jobs and data replication activities.
• Experience in Disaster Recovery (DR) Setup, DR simulation and DR Drill.
• Proficient in shell scripting. Experience with WebLogic administration and WLST scripting
• Designed strategic and tactical solutions for database capacity planning, scheduled database refreshes, backups and formulated recovery processes using RMAN, Data Pump, HOT/Cold methods, Export/Import and Database Cloning.
• Experienced with Automatic Storage Management (ASM) administration, ASMCMD for RAC and single server installation.
• Responsible for analyzing and tuning the performance of bad applications queries using Stats Pack, AWR and ADDM and well versed with utilities such as Explain Plan, TKPROF, SQL Trace and Auto trace.
• Experience in using Flash-Back Recovery, Transportable tablespace and Grid Control.
• Experienced in using My Oracle support, raising SR, downloading patches, database patching, upgrades and updates.
• Good managing and reporting skills, task allocation to resources and tracking the progress on daily & weekly basis.
• Sound knowledge of ITIL process - Incident Management, Change Management and Problem Management.
• Extensive experience in interaction with clients, excellent verbal and written communication skills and quick learner.

PROFESSIONAL EXPERIENCE

Confidential

Senior Security Consultant

Responsibilities:

• Led security architecture implementing Oracle Access Identity Manager Suite, HP ArcSite SIEM Appliance security monitoring, compliance and policies on multi-million-dollar (212 million+) Infrastructure and software automation projects for State of Delaware Health and Social Services department to increase productivity and reduce support costs plus comply with CMS’s HIPPAA & NIST 800-XX guidelines.
• Advised and collaborated on security architecture, installation, deployment, configuration and production support of Oracle IAM security suite and siem products in .NET Platform running WebLogic servers and .Net Servers.
• Participated in Information Technology Security, Cyber Security Risk Management for the Department by understanding emerging security threats, vulnerabilities and control techniques to direct security policies and define IT security architecture based on Federal NIST Guideline Publication 800-XX
• Led the creation of user security authorization and authentication model with HIPPAA compliance.
• Managed, installed and deployed Oracle Identity Access Management Suite (IAM) Security Product and help with solution and integration of HP ArcSite for SIEM (security information event management).
• Managed and provided current security risk assessment status via audit and monitoring reporting tools.
• Responsible for creating acceptable information security risk controls and policies.
• Hardware, Network & Systems Security Penetration was secured using Tenable’s (Nessus, tenable.io) security suite. Network Monitoring was conducted via SolarWinds.
• WorkingwithOracle’sSecurity Architecture and supportteam toresolveORAerrorsissues
• Partnered with Vendor to Solution the conversion of User and Application Request from Paper and Pencil to Online request form by automating creation of user and their application request using Oracle’s Identity Manager Approval Request and Provisioning Application part of Oracle Fusion Middleware Software Suite. New User Account created in Microsoft AD (Authoritative Directory Store for the State of Delaware)
• Applysecuritypatches(CPU/PSU)andbugfixeson RACdatabasesandGridInfrastructure
• Installed 11gR2PS3 Oracle Security Identity Manager (OIM) and configured in cluster mode with Microsoft Active Directory (AD) as directory store.
• Installed 11gR2PS3 Oracle Security Access Manager (OIM) and configured in Microsoft AD and OAAM.
• Installed Oracle Security Connector Server (OCS) and configured it OIM and AD connector.
• Installed Oracle 12c databases and migrated 10g and 11g databases to 12c environment.
• Installed, configured, maintained and tuned Oracle 11g databases.
• Installed and Configured Oracle 10g and 11gR2 with ASM setup.
• Installed OEM Oracle Agents and Configured databases using OEM 12c.
• Installed WebLogic Server 10.3.6 and set up cluster mode.
• Extensively used Oracle utility Recovery Manager (RMAN) to implement Oracle backup and recovery.
• Designing the Oracle backup strategy, scheduling and implementing database backup and restoration using Import/Export, hot backups, cold backups and data pump utilities.
• Experience in scheduling jobs in Control-M. Collaborated with implementation team to schedule batch jobs on Univer$e(Dollar Universe) batch scheduling
• Performed databases cloning manually using scripts and Recovery Manager (RMAN) for QA Testing team, application team and for developers.
• Performed Capacity planning, capacity monitoring and management.
• Tuning and optimizing current and new applications using SQL Trace utility and DBMS package, and enhancing performance through regeneration and rebuild of indexes and creation of views.
• Managed users and security of database as per business requirements.
• Trouble shooting performance issues using Explain Plan, TKPROF, STATSPACK, AWR and ADDM.
• Monitored the database, table space management and sizing of objects and space utilization in database using shell scripts.
• Performance monitoring and Database/Instance/RAC tuning using Dictionary views, AWR, Stats pack, ADDM, ASH reports, OEM Grid Control.
• Working with Oracle support to resolve like ORA errors issues.
• Apply security patches (CPU/PSU) and bug fixes on RAC databases and Grid Infrastructure

Confidential, Woonsocket, RI

Senior Data Security Consultant

Responsibilities:

• Led and created data security solutions using secure in Transport Payment Gateway Processing (TDE), Security Certs, and Payment Data Transaction Security Requirements, PCI Point-to-Point Encryption Standard and Full Track and Auditing of Data transaction from End-End across internal and external Confidential Platform in compliance with HIPPAA, SOX, PCI standards and NIST 800-XX.
• Assisted and collaborated with vulnerability and penetration testing team to identify the risks and mitigate the security issues as per HIPPAA compliance using IBM® Security Guardium (Guardium is data security platform that provides a full range of capabilities - from discovery and classification of sensitive data to vulnerability assessment to data and file activity monitoring to masking, encryption, blocking, alerting and quarantining to protect sensitive data.)
• Led solution, architecture and management of user security access to databases and DB-APP servers per Confidential Organization’s Security and Risk Compliance Policies and Standards.
• Performed Capacity planning, capacity monitoring and management of data security auditing and reports.
• Led in-flight and at rest data security architecture, management, installation and solution of over 200 terabyte of data across hundreds of databases and tables.
• Managed and provided current security risk assessment status via audit and monitoring reporting tools.
• Responsible for creating acceptable information security risk controls and policies.
• Apply security patches (CPU/PSU) and bug fixes on databases and Grid Infrastructure
• Designed backup strategy, scheduling and implementing database backup and restoration using Import/Export, hot backups, cold backups and data pump utilities.
• Installed, configured, maintained and tuned Oracle 10g, 11g and 12c databases.
• Installed and Configured Oracle 10g and 11gR2 with ASM setup.
• Configured and monitored various databases using OEM Grid Control.
• Extensively used Oracle utility Recovery Manager (RMAN) to implement Oracle backup and recovery.
• Implemented replication using Golden Gate and Oracle Streams.
• Migrated databases to different environment using Data pump.
• Implemented and Configured Oracle Golden Gate 10g for real-time replication of data for reporting database.
• Experience in taking incremental and cumulative backups in daily and weekly.
• Performed databases cloning manually using scripts and Recovery Manager (RMAN) for QA Testing team, application team and for developers.
• Created process to monitor golden gate replication lagging data from OEM Golden Gate, Streams, Data Guard and Active Data Guard.
• Tuning and optimizing current and new applications using SQL Trace utility and DBMS package, and enhancing performance through regeneration and rebuild of indexes and creation of views.
• Used SQL Loader extensively to extract data from flat files and loading into the new application.
• Trouble shooting performance issues using Explain Plan, TKPROF, STATSPACK, AWR and ADDM.
• Monitored the database, table space management and sizing of objects and space utilization in database using shell scripts.
• Experience in scheduling jobs in Control-M.
• Provided 24x7 Production on call Database support.
• Upgraded Oracle binaries from 9i, 10g to 11gR1 and 11gR2.
• Performance monitoring and Database/Instance/RAC tuning using Dictionary views, AWR, Stats pack, ADDM, ASH reports, OEM Grid Control.
• Working with Oracle support to resolve like ORA errors issues.
• Coordinate with Onshore and Offshore team members.
• Reporting to client, Onsite Project Manager and Offshore Project Manager.

Environment: Oracle 9i, 10g, 11g, GRID Infrastructure, RAC-ONE, OEM, PCI Transactional Platform