We provide IT Staff Augmentation Services!

Resume

Senior Security, ConsultanT

SUMMARY

  • An accomplished and results - driven senior IT Professional with over 12 years’ of success leading IT security engineering and administration, IAM Engineer & Architect, database administration and data security, security solutions architecture for public and private sector organizations, at a global level. Experience includes systems security, engineering solutions, service delivery and operations, enterprise applications, and end-to-end product configuration and deployment. Leverages innovative thinking in solving complex problems and managing conflict, collaborates with geographically dispersed cross-functional global teams, consultants, and project resources to success, and serves as trusted advisor and partner to Senior Executive Leadership.
  • 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 confidencial 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

    Senior Data Security Consultant

    Responsibilities:

    • Led and responsible for data security architecture, design, solution for Confidential Corp to comply with HIPPAA, SOX, PCI (Payment Card Industry) data security standards transactional platform for Confidential Corp and CVS pharmacies across U.S.
    • 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

    Operating System

    Confidential

    Responsibilities:

    • Led security architecture implementing Oracle Security IAM Suite for Department of Excise and Customs.
    • Advised and collaborated on security architecture, installation, deployment, configuration and production support of security and siem on HP UNIX platform.
    • Participated in Information Technology Security, Risk Management for the Department by understanding emerging security threats, vulnerabilities and control techniques to direct department’s security policies and define IT security architecture.
    • Helped create new and update existing department’s security policies and guild lines based on the new security platform architecture and governance model.
    • Led the creation of user security authorization and authentication model in compliance with Department’s security guidelines and standards.
    • Managed, installed and deployed Oracle Identity Access Management Suite (IAM) Security Product
    • User management and database Security
    • Installed, configured and deployed of Security Software Suite for database, OID, OIM, OAM and SSO(Single Sign-on) including setup of SSO for enterprise users
    • Managed and provided current security risk assessment status via audit and monitoring reporting tools.
    • Responsible for creating acceptable information security risk controls and policies.
    • Maintenance, administration, installation and configuration of Oracle 10g/10g RAC on HP-UX, UNIX and Solaris platforms
    • Upgrade Oracle software & database 10g to 11g version
    • Working in 24x7 Production Support for Oracle databases.
    • Fault analysis, customer tickets resolution, driving corrective actions in accordance with Customer impact.
    • Patch Implementation on RAC and Non-RAC Environments for the bugs detected.
    • Worked on Disaster Recovery (DR) Setup, DR simulation and DR Drill.
    • Periodic maintenance activities like database re-org as and when required.
    • Database cloning/refresh from production using RMAN
    • Managing Logical/Physical storage structures and Capacity Planning
    • Migration of local sites to centralized database.
    • Monitoring and health check using Grid and UNIX scripts.
    • Backup using RMAN, user managed HOT and COLD backups
    • Installation of Agent 10g, configuration of Database in Grid Control.
    • Worked on Oracle Tools like OEM, Grid Control and Monitoring through 11g grid control/OEM
    • Monitoring and administrating Database Servers using Oracle Grid.
    • Troubleshooting about the problem reported and documenting the same for future reference.
    • Working on database activities that come through Customer CR and incidents reported.
    • Interface with vendor (Oracle Support) as needed for more complicated issues.
    • Deployment of application ear/war files on application server.
    • Setup backup jobs, database cloning - from one server to another and their monitoring.
    • Designing Backup and recovery Strategy for maximum database availability.
    • Performance analysis of databases and queries and provide suggestions to application teams for performance improvement in database tuning.
    • Writing shell scripts for day to day maintenance activity.
    • Maintaining ASM and RAC instances.
    • Maintaining user security and creating users and roles for different modules.
    • Monitoring Server and network performance.
    • Deciding partition strategy to maintain tables with large number of records.
    • Analyzing network performance and its effect on batch performance.
    • Implementing SQL scripts for session and lock monitoring.
    • Writing UNIX Shell scripts for automated mail alerts for monitoring various DB activities.

    Environment: Oracle 10g, OEM, OIM, OAM, OID

    Confidential

    Oracle DBA & Data Architect

    Responsibilities:

    • Creation of oracle databases, upgrade and decommissioning of databases.
    • Managing table spaces, database objects, user, profiles, user privileges and roles.
    • Database performance tuning, tracing sessions, monitoring alert log and trace files.
    • SQL & PL/SQL programming of stored procedure
    • Database monitoring through HP Open View Service Desk (OVSD)
    • SQLNET Administration, setting up SQLNET.ora, Listener.ora and tnsnames.ora.
    • Database refreshes, cloning of databases using RMAN and logical backups.
    • Setting up Dev, UAT and test databases.
    • Data loading using SQL Loader.
    • Promoting Data model releases to various environments
    • Analyzing TKprof and AWR for performance improvement
    • Maintaining user security
    • Space management and objects creation.
    • Writing SQL scripts for session and lock monitoring.
    • Writing UNIX Shell scripts for automated mail alerts for monitoring various DB activities and statuses.
    • Setup of batch jobs and programs and allocation of resources for their execution as per required functionality and expectation.
    • Setup of monitoring tools for system availability and performance analysis

    TECHNICAL SKILLS:

    Hardware: IBM servers, RHEL server

    Operating System: HP UX, AIX, Solaris, Linux, Windows

    RDBMS: Oracle 12c, 11gR2, 11gR1, 10g, 9i

    DB Tools/utilities: SQL loader, OUI, DBCA, DBUA, ASMCA, ASMCMD, GGSCI, OEM, NETCA

  • High Availability: Oracle Clusterware, RAC 11g/10g and Data Guard

  • Tuning Tool: Stats Pack, AWR, ADDM, Explain Plan, SQL trace, Auto trace, TKPROF

    Backup Tool: RMAN, Data Pump, Hot/Cold, Cloning with RMAN, Export/Import

    Tools: TOAD, PLSQL Developer, SQL Developer, SQL * Plus, OVSD, Control-M

    Oracle Products: Oracle Connector Server, AD connector, WebLogic Server, Oracle SCM, Oracle IO Optimization, Oracle ASCP, Oracle ERP, Oracle e-business suite, Oracle Access Management Suite (Oracle IAM), Oracle Fusion HCM Approval and Workflow Management

  • Microsoft & Other Tools: Microsoft Active Directory (AD), .Net Server Framework, Entrust Certs, .NET API, JVM, SAML, XML, OAUTH2, SaaS (PeopleSoft, Salesforce)

    Scripting: Shell, DOS, WLST

Hire Now