Uploaded File
Ngopang
nkefor.n@gmail.com
703-986-7090
Charlotte, NC 28205
Info Security Analyst
10 years experience W2
0
Recommendations
Average rating
271
Profile views
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

Experience
Info Security Specialist / IAM Analyst
Insurance
Jul 2019 - present
Jacksonville, FL

  • Performed security administration across 200+ internal applications in multiple environments (PROD, TEST, STAGE and UNIT) using application specific tools.
  • Implemented user authentication and authorization on multiple database platforms including Oracle, SQL Server, PostgreSQL, DB2 on Unix and Mainframe using platform specific database tools like SQL Developer, SQL Server Management Studio, pgAdmin following enterprise security policies.
  • Administering security of LDAP groups and user accounts using application specific tools.
  • Managing and administering Linux and Unix server access using Centrify and Super PuTTY
  • Providing subject matter expertise and guidance to end users on enterprise security policies, standards, processes and procedures.
  • Maintaining the Security knowledgebase and also updating the Operational Procedures.
  • Active Directory groups and user administration using Remote Server Administration Tools
  • Writing and updating SQL Scripts used for access management on Oracle and SQL Server databases
  • Completing Security tasks and tracking them in HP Service Manager ticketing system.
  • Responsible for ensuring compliance with security regulations and laws as well as preventing unauthorized access.
  • Responsible for administering highly sensitive access to end users while ensuring compliance with policies and regulations.
  • Troubleshooting and resolving all database access related issues
  • Managing and administering security on the Mainframe using TSO and RACF commands
  • Ensuring that users have the appropriate level of access they need to applications and data resources.
  • Reviewing and processing applications and database Access Requests submitted via HP Service Manager while using the appropriate IAM Tools to provision or deprovision the access.
Compliance Enterprise Security IAM LDAP Linux MS Active Directory RACF SQL UNIX SQL Developer PostgreSQL Oracle PuTTY MS Visio DB2 HP SQL Server
Remove Skill
Info Security Analyst
Banking/Financial
Feb 2015 - Jul 2019
Charlotte, NC
  • Provisioning and deprovisioning database access across multiple database platforms including Oracle, Teradata, SQL Server, MySQL, Sybase and DB2.
  • Working closely with customers and end users through emails, conference calls and IM in identifying and resolving database access related issues.
  • Creating Active Directory groups, users, and adding users to Active Directory groups.
  • Creating and managing Linux users, adding them to Linux groups.
  • Following the company’s policy in provisioning Oracle and SQL Server database users using SQL Developer, SQL Server Management Studio and IBM Tivoli.
  • Creating and submitting Pac2000 Problem Tickets and Work requests to responsible support groups for database access related issues.
  • Provisioning and de-provisioning bulk user access via project requests.
  • Executing Work Requests and working on assigned Problem Tickets.
  • Training and bringing new team members up to speed with Oracle, Sybase, Teradata, MySQL and SQL Server database provisioning and deprovisioning as well as getting them used to the environment.
  • Working in collaboration with the DBAs to identify and resolve database access issues.
  • Identifying stale data within DSAM’s database inventory and submitting updates from other sources like the Triage tool and WDAI inventory.
  • Administering and monitoring ART Workflow, manually generating reports and assigning ART tickets.
  • Creating new ART form mockups for onboarding SybaseIQ and MySQL databases.
  • Overseeing the Teradata database onboarding project for new Teradata environments.
  • Troubleshooting failed IES requests and manually completing them.
  • Rewriting and updating documentations with new processes and procedures on Access management on the various database platforms, including Oracle, Sybase, MySQL, Teradata and SQL Server.
  • Updating and implementing new and existing policies to be followed by the team to mitigate risk and stay compliant.
  • Modifying and executing Linux shell scripts to automate Sybase audit jobs and Sybase maintenance
  • Writing Oracle and SQL Server SQL scripts for bulk access management.

Some tools used: AMS, Triage, ART, ACT, IBM Tivoli, SQL Developer, SSMS, Office Suite, sqlplus, BMC Remedy, IES, MySQL Workbench.
Database Platforms: Oracle, SQL Server, Sybase, DB2, Teradata, MySQL.

Linux Provisioning Security Analyst SQL MS Active Directory SQL Server BMC Remedy Oracle IAM MySQL
Remove Skill
Oracle Database Administrator
Information Technology
Jul 2012 - Jan 2015
Greensboro, NC
  • Installation and Maintenance of Oracle 10g and 11g, on IBM-AIX, LINUX and Windows platforms.
  • Utilized Grid Control to administer multi-node RAC database also managed redo and undo in the RAC environment. Load balancing of RAC instances.
  • SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
  • Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export and Data pump utilities).
  • Creating &Managing Database Structures, Storage Allocation, Table/Index segments, Constraints, Database Access, Roles and Privileges.
  • Performance tuning of Queries by maintaining Aggregates, Compression, partition, Indexing and use of Hints, Stored outlines, Statistics for the same.
  • Performance tuning and diagnosing DBMS and individual Production databases, organized various migration review meetings with the application team to discuss the migration strategy based on their requirements.
  • Applied Patches on RAC, Standalone, Standby databases based on the requirements.
  • Evaluated mix of backup and recovery methods based on organizational needs. Implemented, tested and documented various backup/recovery scenarios for knowledge base.
  • SQL tuning using explain plan, tkprof.
  • Installation, Configuration and Maintenance of RAC on Linux and Solaris using ASM and RAW devices and Oracle CRS, Stand by database.
  • Upgrading development and production databases to Oracle 11g.
  • Migrating from Oracle 10.2.0.4 on Solaris databases to Oracle 11.2.0.2 on Linux.
  • Installed and applied various patches which include Critical Patch Update (CPU), Patch Set Update (PSU) and One-off patches using OPatch and runinstaller, also involved in upgrade of oracle database 10g to 11g.
  • Experience with data movement using Oracle utilities like Export/Import, Data pump and SQL *Loader.
  • Involved in Monitoring, Optimizing Oracle database for Performance Tuning & system/modules for Application Tuning using tools like AWR, ADDM, ASH, STATSPACK, TKPROF, EXPLAIN PLAN, SQL TRACE, and UTLBSTAT.
  • Responsible for optimizing the queries and application tuning.
  • Experience on working with data guard physical/logical standby databases.
  • Used Data Pump for export and import. Wrote scripts for Backup of databases, maintenance of archive logs for databases. Streamlined backup procedures and implemented RMAN for backup and disaster recovery.
  • Database Refreshing / Replication from production to testing using Exp/Imp.
  • Designed, developed and maintained UNIX shell scripts to collect and monitor database metrics and Statspack snapshots and reports.
  • Performed Table Partitioning, created Index Organized tables and Locally Managed Tablespaces.
  • Monitored and provided weekly reports on the server’s memory, disk and CPU I/O using HP tools and UNIX command-line utilities.
  • Planned and configured disk layout, mount points and capacity requirements for servers.
  • Provided maintenance of user accounts, privileges, profiles and roles.
  • Involved with OLTP relational databases system analysis, design, implementation and management.
  • Upgrade/Migration of Databases from Oracle 10g to 11g, Cross platform migration from different platforms.
  • Administered (11g RAC) environments adding and removing nodes to the cluster and handled performance tuning using AWR.
  • Supported off-hour on call support for database related issues.
  • Created logical and physical design installed and upgraded databases.
  • Documented the Standard Processes for peers to follow.

Environment: IBM-AIX, Windows 2003/NT, Oracle 11g and 10g, RAC, TOAD, OEM, DATAGUARD, RMAN, Data Pump, Diagnostic and Tuning Advisors.

Data Replication Database Backups Database Design DBA Disaster Recovery Linux OLTP Oracle Performance Tuning Shell Scripts SQL TOAD UNIX Load Balancing Windows
Remove Skill
Jr Oracle Database Administrator
Consumer Goods
Apr 2011 - May 2012
  • Installation and Maintenance of Oracle 10g and 11g, on IBM-AIX, LINUX and Windows platforms.
  • Utilized Grid Control to administer multi-node RAC database also managed redo and undo in the RAC environment. Load balancing of RAC instances.
  • SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
  • Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export and Data pump utilities).
  • Creating &Managing Database Structures, Storage Allocation, Table/Index segments, Constraints, Database Access, Roles and Privileges.
  • Performance tuning of Queries by maintaining Aggregates, Compression, partition, Indexing and use of Hints, Stored outlines, Statistics for the same.
  • Performance tuning and diagnosing DBMS and individual Production databases, organized various migration review meetings with the application team to discuss the migration strategy based on their requirements.
  • Applied Patches on RAC, Standalone, Standby databases based on the requirements.
  • Evaluated mix of backup and recovery methods based on organizational needs. Implemented, tested and documented various backup/recovery scenarios for knowledge base.
  • SQL tuning using explain plan, tkprof.
  • Installation, Configuration and Maintenance of RAC on Linux and Solaris using ASM and RAW devices and Oracle CRS, Stand by database.
  • Upgrading development and production databases to Oracle 11g.
  • Migrating from Oracle 10.2.0.4 on Solaris databases to Oracle 11.2.0.2 on Linux.
  • Installed and applied various patches which include Critical Patch Update (CPU), Patch Set Update (PSU) and One-off patches using OPatch and runinstaller, also involved in upgrade of oracle database 10g to 11g.
  • Experience with data movement using Oracle utilities like Export/Import, Data pump and SQL *Loader.
  • Involved in Monitoring, Optimizing Oracle database for Performance Tuning & system/modules for Application Tuning using tools like AWR, ADDM, ASH, STATSPACK, TKPROF, EXPLAIN PLAN, SQL TRACE, and UTLBSTAT.
  • Responsible for optimizing the queries and application tuning.
  • Experience on working with data guard physical/logical standby databases.
  • Used Data Pump for export and import. Wrote scripts for Backup of databases, maintenance of archive logs for databases. Streamlined backup procedures and implemented RMAN for backup and disaster recovery.
  • Database Refreshing / Replication from production to testing using Exp/Imp.
  • Designed, developed and maintained UNIX shell scripts to collect and monitor database metrics and Statspack snapshots and reports.
  • Performed Table Partitioning, created Index Organized tables and Locally Managed Tablespaces.
  • Monitored and provided weekly reports on the server’s memory, disk and CPU I/O using HP tools and UNIX command-line utilities.
  • Planned and configured disk layout, mount points and capacity requirements for servers.
  • Provided maintenance of user accounts, privileges, profiles and roles.
  • Involved with OLTP relational databases system analysis, design, implementation and management.
  • Upgrade/Migration of Databases from Oracle 10g to 11g, Cross platform migration from different platforms.
  • Administered (11g RAC) environments adding and removing nodes to the cluster and handled performance tuning using AWR.
  • Supported off-hour on call support for database related issues.
  • Created logical and physical design installed and upgraded databases.
  • Documented the Standard Processes for peers to follow.

Environment: IBM-AIX, Windows 2003/NT, Oracle 11g and 10g, RAC, TOAD, OEM, DATAGUARD, RMAN, Data Pump, Diagnostic and Tuning Advisors.

Data Replication Database Backups Database Design DBA Disaster Recovery Linux OLTP Oracle Performance Tuning Shell Scripts SQL TOAD UNIX Load Balancing Windows
Remove Skill
Edit Skills
Non-cloudteam Skill
Education
Bachelor's in Information Technology
Georgia Southern University, 2016 - 2018
Associate's in Information Technology
Northern Virginia Community College, 2014 - 2016
Related Courses
Oracle University, Oracle 11gR2 Database Administration,
Certifications
Scrum Master Accredited Certification
International Scrum Institute, 2019
Oracle Database 11g Administrator Certified Associate
Oracle, 2014
Oracle Cloud Infrastructure 2019 Certified Architect Associate
Oracle, 2019
Oracle Autonomous Database Cloud 2019 Certified Specialist
Oracle, 2019
Oracle Cloud Infrastructure 2019 Certified Architect Professional
Oracle, 2020
Skills
Linux
2021
8
Oracle
2021
8
SQL
2021
8
IAM
2021
5
MS Active Directory
2021
5
SQL Server
2021
5
BMC Remedy
2019
4
MySQL
2019
4
Provisioning
2019
4
Security Analyst
2019
4
UNIX
2021
4
Data Replication
2015
3
Database Backups
2015
3
Database Design
2015
3
DBA
2015
3
Disaster Recovery
2015
3
Load Balancing
2015
3
OLTP
2015
3
Performance Tuning
2015
3
Shell Scripts
2015
3
TOAD
2015
3
Windows
2015
3
BMC Discovery
2015
1
Solaris
2015
1
Compliance
2021
1
DB2
2021
1
Enterprise Security
2021
1
HP
2021
1
Information Security
0
1
Java
0
1
LDAP
2021
1
Microsoft Excel
0
1
MS Visio
2021
1
PostgreSQL
2021
1
PuTTY
2021
1
RACF
2021
1
SQL Developer
2021
1
Languages
French, Fluent/Bilingual
English, Fluent/Bilingual