Uploaded File
Ngopang
Info Security Analyst
9 years experience W2 Charlotte, NC
Available immediately
Actively seeking
Ngopang
193
views
Info Security Analyst
0
Recommendations
Average rating
193
Profile views
Linux Oracle SQL IAM MS Active Directory SQL Server BMC Remedy MySQL Provisioning Security Analyst
Remove Note
View Note
Recent Experience
Info Security Specialist / IAM Analyst 07/19 - present
Compliance Enterprise Security IAM LDAP Linux MS Active Directory RACF SQL UNIX SQL Developer PostgreSQL Oracle PuTTY MS Visio DB2 HP SQL Server
Info Security Analyst 02/15 - 07/19
Linux Provisioning Security Analyst SQL MS Active Directory SQL Server BMC Remedy Oracle IAM MySQL
Oracle Database Administrator 07/12 - 01/15
Data Replication Database Backups Database Design DBA Disaster Recovery Linux OLTP Oracle Performance Tuning Shell Scripts SQL TOAD UNIX Load Balancing Windows
Summary

9 years of overall experience in the IT field. This includes strong experience in Oracle database administration in heterogeneous system environment including Solaris, UNIX, and Windows, supporting a variety of mission critical applications with Oracle 11g and 12c. Experience in Information Security Analysis, combined with outstanding leadership ability and creative problem solving skills in both strategic and tactical areas as well as excellent communication /documentation skills and strong aptitude to analyze and resolve problems.

  • Implementation of high availability solutions with Oracle 11g RAC, Standby Database Data Guard.
  • Management of schemas, objects & Partitioning the tables & indexes, USERS and PRIVILEGES 12c Monitoring.
  • Creation of Active Directory groups, users, and adding users to Active Directory groups.
  • Creating and managing Linux users, adding them to Linux groups.
  • Experience in Upgrading databases and applied patch sets to multiple databases.
  • Expertise in Database Space Management, Expertise in troubleshooting and performance tuning.
  • Excellent analytical and problem-solving skills, Sound judgment and use of initiative.
  • Backup of Databases (Making Backup Schedules depending upon Business Strategy: Daily Backup, weekly Backup etc.) using RMAN and other backup techniques.
  • Recovery of Databases (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc.)
  • Experience in using OEM, TOAD, Data Migrations using export/import.
  • Experienced in using 10g features Data pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Monitoring.
  • Database performance tuning using STATPACK, Explain Plan, AWR, ADDM, ASH.
  • Experience on working with data guard physical standby databases.
  • Extensive performance tuning experience, specializing in tuning, Oracle 10g and 11g RAC tuning, Load balancing.
  • Expert in configuration and Installation of RAC on Linux and Solaris using ASM and RAW devices and Oracle CRS.
  • Expertise in maintaining Database Security using security compliance auditing, expertise in loading data from flat files using external tables, SQL*LOADER.
  • Excellent work experience in developing applications using ORACLE SQL Scripts, PL/SQL, Shell Programming.
  • Upgrade/Migration of Databases from Oracle 10g to 11g as well migrating experience over cross platforms from Linux to Solaris, AIX to Solaris and from windows to Linux.
  • Skilled in dealing with RAIDs on local server (Via RAID card BIOS) in ASM environment such as installation, taking backup, migration of database from Non –ASM to ASM environment.
  • Excellent knowledge in Hot/Cold Backup, Recovery, Cloning of databases using RMAN, VERITAS Net Backup.
  • Excellent Written and verbal Communication skills with a customer service oriented attitude. Knowledge on Oracle Support processes for technical requests with Metalink.

Technical Skills

  • Operating systems
    • LINUX, SOLARIS, MS-DOS, Windows Advanced Servers 2003/2008R2, HP-UX, AIX.
  • Databases
    • Oracle 11gR2, 12c RAC, Microsoft SQL Server 2008/2012/2014, Sybase, DB2, Teradata, MySQL
  • Oracle Database Tools
    • SQL*Loader, TKPROF, Toad, SQL Developer, Grid Control
  • Tools & Utilities
    • Export/Import, RMAN, Data Pump, Winscp3, ERWIN, Remedy.
  • Languages
    • SQL, PL/SQL, Java, C++, JavaScript, jQuery
  • Web Tools
    • PHP, HTML and XML
  • Other Tools
    • Microsoft Office Suite, VMware Workstation 10, Active Directory

Top 5 Skills
SkillsProficiencyLast Used
Linux
2020
Oracle
2020
SQL
2020
IAM
2020
MS Active Directory
2020
Education and Certifications
Bachelor's in Information Technology
Georgia Southern University, 2016 - 2018
Associate's in Information Technology
Northern Virginia Community College, 2014 - 2016
Scrum Master Accredited Certification, 2019
Oracle Database 11g Administrator Certified Associate, 2014
Preferences
Availability:Immediately
Willing to relocate?:No
Prepared to Travel:No travel (0%)
Employment Type:Any
Security Clearance:No clearance
Citizenship:U.S. Citizen