Resume

Sign in

Oracle Manager

Location:
Philadelphia, Pennsylvania, United States
Posted:
August 16, 2019

Contact this candidate

Resume:

PETER EPHANGA

AWS Solutions Architect

ac93og@r.postjobfree.com 240-***-****

I have overall 9+ years of IT related experience. With over 7 years of hands-on experience as an Oracle Database and Fusion Middleware Administrator and over 3 years experience planning, designing, implementing and maintaining system applications in AWS Cloud in Windows and Linux environments as a cloud security and apps engineer. I am very comfortable supporting a full system development life cycle. Worked with AWS key services including Ec2, S3, VPC, RDS and Route53 running on both Single and Mutli-AZ deployments. Worked with Oracle 10g, 11g and 12c versions where database administration duties involved production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, cloning, space management and security.

TECHNICAL PROFICIENCIES:

Tunning Tools :

TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM.

Languages :

SQL, PL/SQL, UNIX Shell Scripting, PERL. JSON, Python, s3 API

Tools and Utilites:

Cloudwatch,

RMAN, OEM, SQL*Loader, EXP, IMP, Data pump,, TOAD, Oracle SQL Developer.

RDBMS :

Oracle 10g, 11g, 12c

Operating Systems :

HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise Server 9, 10. Windows 95/98/NT/2000.

SKILLS SUMMARY

Cloud Computing

AWS - EC2, RDS, S3, Glacier, SQS, SNS, SES, CloudFormation, VPC, IAM, Route53, EBS, DynamoDB, Lambda, Kinesis, Cloudwatch

•Experience in maintenance and configuration of user accounts for dev, QA, and production servers and created roles for EC2, RDS, S3, CloudWatch, EBS resources to communicate with each other using IAM.

•Experience in migrating and implementation of multiple applications from on premise to cloud using AWS services like SMS, DBMS, CloudFormation, S3, Route53 Glacier, EC2, RDS, SQS, SNS, Lambda and VPC.

•Build and configure a virtual data center in the Amazon Web Services cloud to support Enterprise Data Warehouse hosting including Virtual Private Cloud (VPC), Public and Private Subnets, Security Groups, Route Tables, Elastic Load Balancer.

•Build servers using AWS, importing volumes, launching EC2, RDS, creating security groups, auto-scaling, load balancers (ELBs) in the defined virtual private connection.

•Designed AWS Cloud Formation templates to create multi region Web applications and databases.

RDBS

Oracle, MySQL

Highly Experienced in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.

Database upgrades from 11g to 12c using DBUA, DATA PUMP and Transportable tablespaces

Worked on Deploying and Administering ADF applications.

Highly experienced in performance monitoring/tuning/troubleshooting.

Oracle Database performance-tuning services with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE. Applying patches under UNIX platform.

Configured and administered 12c PDB and CDB databases.

Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 11gR2 Grid and 10g on ASM and OCSF2 file systems.

Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.

Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.

Knowledge in configuring ASM (Automatic Storage Management)

Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g, 10g RAC servers for the purpose of disaster recovery procedures.

Proficient with Database Cloning, Migration, and Patching of Oracle Databases.

Fusion Middleware

Highly experienced in implementing Oracle's Fusion Middleware components from Weblogic server, Oracle identity manager including OID and OAM integration for Single-Sign-on (SSO).

Oracle Identity and Access Management suits. (OID, OVD, OUD)

Experienced in using 10g features like 10g RMAN, Data pump Flash-Back Recovery and ASM, NOsql.

Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.

Expertise in maintaining Database Security using auditing.

Experience in PeopleSoft HRM and PeopleSoft Finance modules

Configured Manager, Replicate and Extract processes and implemented unidirectional, bidirectional replication using Oracle 11g Golden Gate on RHEL 5 platform.

Oracle forms and reports. Oracle ADF

Strong knowledge of BI solution with Star Schema, Snow Flake Schema, Dimension and Fact table.

Configure OBIEE and SQL Reporting Services (SSRS) for Developing Drill Tabular Reports, Matrix Reports and Drill Down Reports. Experience in doing upgrades including maintenance & monitoring implementation.

Extensive knowledge in UNIX platforms includes HP, SOLARIS, AIX, and LINUX.

PROFESSIONAL EXPERIENCE

MetroPol-Tech Consulting Svc Feb’15 – Present

AWS Solutions Architect

•Responsible for launching Amazon EC2 Cloud Instances using Amazon Web Services (Linux) and Configuring launched instances with respect to specific applications and regions.

•Installed applications on AWS EC2 instances and configured the storage on S3 buckets.

•Responsible for S3 buckets creation, policies and the IAM role based polices.

•Build servers using AWS, importing volumes, launching EC2, RDS, creating security groups, auto-scaling, load balancers (ELBs) in the defined virtual private connection.

•Responsible for creating monitors, alarms and notifications for EC2 hosts using Cloud Watch.

•Involved in the migration and implementation of multiple applications from on premise to cloud using AWS services like SMS, DBMS, CloudFormation, S3, Route53, Glacier, EC2, RDS, SQS, SNS, Lambda, Kinesis and VPC.

•Build servers using AWS and launching EC2, RDS, creating security groups, auto-scaling, load balancers (ELBs) in the defined virtual private connection.

•Build and configure a virtual data center in the Amazon Web Services cloud to support Enterprise Data Warehouse hosting including Virtual Private Cloud (VPC), Public and Private Subnets, Security Groups, Route Tables, Elastic Load Balancer. • Configuration of Continuous Integration (CI) and Continuous Delivery (CD) using CodePipeline and CodeDeploy for automation.

•Involved in 24X7-support rotation for all the Production, Test, and Development environments.

•Responsible for the Installation, Configuration and Maintenance of Oracle 12c/11g/10g Single Instances and RAC databases for High Availability and Disaster Recovery. • Performed patching, upgrade and migration of multiple development, test and production databases from 10g/11g to 12c and migration to different platforms.

•Performed backup and recovery strategy using Recovery Manager (RMAN) - physical backup - and Data Pump (Import/Export) - logical backup, respectively.

•Created User accounts, Roles and granting required access Permissions and Privileges to the users. • Implemented SQL, PL/SQL and T-SQL queries, packages, functions, stored procedures, triggers, tables, views, materialized views, indexes.

•Involved in 24X7-support rotation for all the Production, Test, and Development databases.

•Performed Performance Tuning using SQLTRACE, EXPLAIN PLAN, TKPROF, STATSPACK, AWR and ADDM.

Environment AWS/oracle - EC2, S3, Glacier, SMS, DBMS, RDS, SQS, SNS, SES, CloudFormation, VPC, Redshift, DynamoDB, Oracle 12c, 11g, 10g, Linux, OEM, RMAN, Python, MySQL, MS SQL Server 2012

US CENSUS BUREAU March ’14 – Feb’15

Oracle Database Administrator

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.

Provided PeopleSoft technical support to developers for maintaining overall performance of databases while troubleshooting daily issues as they arise.

Used SBM and remedy to engage in day to day support of tickets

Formulated and managed database stored procedures, database administration scripts and database functions.

Troubleshoot daily production issues from user authentication to session wait events and locks to general performance optimization

Worked with development team to rewrite application codes to provide better execution plans to ensure optimal performance.

Wrote plsl and Perl scripts to automate processes for bulk processing including material view refreshes, warehouse refreshes and code migrations

Created, managed and analyzed disaster recovery plan, database backup and capacity planning strategies.

Examined, identified and formulated solutions to resolve issues in PeopleSoft environments for best performances.

Maintained and updated SOP technical documents for the team.

Monitored and managed performance of PeopleSoft environments at every phase including installation of patches, updates, and upgrades.

Designed and implemented technical upgrades of all PeopleSoft applications.

Install and configure oracle Weblogic and Fusion Middleware components including weblogic server, BI Publisher, Forms and Reports instances on RedHat Linux 6.

Configure and administer oracle Identity manager (IDM), including OID and OAM and integration of both for Single-sign-on (SSO) and more robust user security.

Created logical and physical design installed and upgraded databases.

Experience in troubleshooting server configuration issues on Forms and Reports, oracle Identity.

Evaluate, install deploy and administer ADF applications including security patches and other changes across environments.

Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.

Refreshing Dev and Test instances with data from Production on a regular basis.

Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.

Knowledge in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments, Oracle OLTP.

INFOSYS LTD Jun ’10 – Mar ’14

Sungard Availability Services, PA

Oracle Database Administrator-Consultant

Successfully implemented Disaster Recovery solutions for different oracle database environment using RMAN, COMMVAULT, and User managed systems

Efficiently performed installation, setup and creation of four node cluster RAC with Oracle 11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 5.5.

Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.

Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5 RAC databases.

Implemented switchovers on primary and standby databases as a part of planned maintenance activities.

Evaluated Oracle 11gR2 Golden Gate for future purposes that is for reducing the complexity involved in Oracle Streams.

Configured Oracle Streams on Oracle 11g, 10g databases for data replication and monitored them using Grid Control.

Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 9i and 10g/11g environments.

Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.

Involved in the installation, configuration and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) with ASM file system on AIX platform.

Involved in converting Oracle 11g, 10g RAC to single instance databases to databases for disaster recovery solutions

Installed ASM environment and migrated databases from NON-ASM to ASM and vice versa. Administer NOsql databases

Used PUTTY for database management.

24 X 7 Production & Development database support and administration.

Environment: Oracle 11.1.0.7, 10.2.0.5, IBM AIX V6.1, RHEL 5.2, RAC, ASM, RMAN, AWR, COMMVAULT, SQL* Plus, PUTTY.

BI Performance Services, MN Mar ’08 – Jun’10

Oracle Production Support Database Administrator

Installation and configuration of Oracle database 9i (9.2.0.4), 10g (10.2.0.1) on various OS platforms like HP-UX, Linux, and Windows NT, 2000

Monitored Customer Databases, physically located in U.S and Remote administration of fifteen Production Databases in UNIX environment

Performance tuning of application and database, identification and resolution of contention, defining and implementing Backup Recovery policy, and day-to-day monitoring of the Production database

Worked on the physical and logical designing of the database, which includes the distribution of data- files on different disks

Controlled and monitored user access to the database. Optimized the performance of the database. Tuned SGA data dictionary and set database parameters.

Cooperated with PeopleSoft domain architect to ensure compliance of PeopleSoft HR solutions with established standards.

Proposed solutions for process enhancements and provided feedback on PeopleSoft project migrations.

Identified long-running database queries, refining queries for better performance, and working with end- users to implement changes

Created primary database objects (tables, views, indexes) once application developers have designed an application

Worked with Oracle Diagnostics tools such as Explain Plan, SQL Trace, TKPROF Used to analyze timing and execution plan for SQL query to tune the SQL statements

Reorganized data files, identified and eliminated contention factors like I/O, buffers and locks

Allocated the separate rollback segments for the Batch processing jobs in order to speed up processing

Reorganized data files, identification and elimination of contention factors like I/O, buffers and locks

Environment: Oracle 10g/11g RAC/9i, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.

EDUCATION

MBA in Management Virginia International University, VA

Bachelor Degree in Law University of Buea, Cameroon

AWS Solutions Architect

Oracle Database 11g Certified



Contact this candidate