Lead Oracle Dba / Peoplesoft Admin Resume
Dover, DE
SUMMARY:
Over fourteen years of experience, building, planning and maintaining from Oracle 7 to 11g databases, Performance Tuning, Database Backup and Recovery. Mr. Ntangu is well versed in the functionality of Oracle 10g and 11g Real Application Cluster (RAC), 10gAS, and SSO - OID integration with Windows AD. He also has extensive experience of cross platform migration, OEM Grid Control, TOAD, Erwin. He has worked on all configurations of the Oracle Database Server: Distributed Option, Parallel Server and Data Guard.Team leader, motivated team member or independent worker with strong problem solving abilities and communication skills, an aptitude for sharing knowledge and quickly adapting to new environments.
TECHNICAL SKILLS:
Software and Languages: Hyperion, Essbase, Weblogic, Workspace, BPEL, 9iAS, 10gAS, OCS, Portal, SSO, PeopleSoft PeopleTools, J2EE, OID, OAM, Web Cache Clustering, RAC, OWB, DataGuard Disaster Recovery, Discoverer, Designer, 9iDS, Oacle 8i, 9i, 10g, WebDB, PL/SQL, Erwin, Veritas DBE/AC, Micro-Strategy.
Operating Systems: Linux (RedHat, SuSe), AIX, HP-UX (9.0.4, 10.10, 10.20. 11i), SOLARIS (2.7, 2.8, 5.9, 10), TRU-64, Windows 2000/3/8.
PROFESSIONAL EXPERIENCE:
Confidential, Dover, DE.
Lead Oracle dba / PeopleSoft Admin
- Daily support, setup, migration, upgrade of different version of Microsoft SQL server databases.
- Installed and configured the new Oracle Enterprise Manager Cloud Control (12C), and registered databases as well as Oracle Web Logic and Microsoft SQL Servers databases.
- Installed and configured High Availability Single Sign-On Servers. Deployed Oracle Internet Directory (OID) and Single Sign-On (SSO). Configured SSL for SSO server using SSLConfigTool. Integrated Oracle Internet Directory with Windows Active Directory.
Confidential, Washington, DC.
Oracle dba
- Converted the Oracle Development, Integration and Production Databases to Automatic Storage Management (ASM).
- Migrated single instances Development, Integration to 2 nodes RAC and Production database to 2 nodes RAC.
- Designed and developed Backup (Hot & Cold Backup) & Recovery procedures for Production databases.
- Set up Operating System level tasks for backup, recovery and housekeeping.
Confidential, Woodlawn, MD
Lead Oracle dba
- Managed a wide range of databases from Oracle 9i to 11g On Sun Solaris.
- Upgraded databases from version 9.2.0.8 to 11.1.0.7. Setup, and configured Oracle Data Guard.
- Cloned several databases using RMAN, with either cold backup or hot backup.
- Recovered databases from backup files on different servers and file systems, with different database SID.
- Installed and configured Oracle Enterprise Manager (10g grid) to assist in managing all Oracle databases.
- Installed and configured ETL tool Informatica on a three tiers environment.
- Helped the ETL team with the design, tuning and troubleshoot of ETL processes.
- Used Erwin for physical and logical modeling. Forward and reverse engineering to and from the database.
- Installed and configured reporting tool Cognos, and later MicroStrategy on a three tiers environment.
- Assisted the reporting team with the tuning of report processes.
- Daily Maintenance involving performance monitoring, backup monitoring, upgrading to new releases and patches, manage space, instance/SQL tuning, process scheduler maintenance, perform adhoc SQL for users and review production process logs.
Confidential, Washington, DC
Oracle dba, 10g AS dba
- Applied different Oracle 9i and 10g patches, quarterly Oracle CPU and security Patchsets to the database server on Sun Solaris and Linux servers.
- Applied the quarterly Oracle CPU and security Patchsets to the HTTP servers, middle-tier tiers and infrastructures.
- Performed several database upgrades from 9i to 10g, as well as database migration from different servers using cold backup and cloning
- In charge of day-to-day maintenance of five OID, and AD domains. Designed, and implemented the integration of Oracle Internet Directory (OID), Oracle Identity Manager (OIM) and Oracle Access Manager (OAM) with Windows Active Directory (AD).
- Deployed Oracle Internet Directory (OID) and Single Sign-On (SSO), which is to be integrated with J2EE and E-Business Suite 11i applications within the Unified Desktop framework.
- Created a wallet and generated a certificate request.
- Installed the wallet to the HTTP server default location for both SSO servers.
- Configured SSL for both SSO servers using SSLConfigTool. Integrated Oracle Internet Directory with Windows Active Directory.
- Configured Oracle Single Sign On for Windows Native Authentication (WNA). Setup Kerberos.
- Configured Windows Native Authentication. Reconfigured OID Local Accounts. Installed, and deployed homegrown J2EE partner Applications, Oracle Application Express (Apex). Reregistered mod osso on the Partner Application Middle Tiers to enable SSO.
- Upgraded the Oracle OID, SSO metadata repository from 10.2.0.1 to 10.2.0.3 version, and then applied the quarterly Oracle CPU and security Patchsets to SSO and OID servers.
Confidential, Gaithersburg, MD
Oracle dba, 10g AS dba
- Using Oracle version 10g, Oracle Fail-safe, and standby databases, I designed and implemented the database servers for two new data centers.
- This effort included creating, tuning, managing and monitoring of the development and production database instances to support 24x7 e-commerce applications.
- This effort also included the implementation of backup and recovery, and disaster recovery strategies.
- Configured Advanced Security Option to encrypt connections between clients and server, and secure the databases, as per DOC requirements.
- Involved in daily maintenance of databases to ensure the improvement of a high performing SQL statements and database availability at all time.
Confidential, Milford, CT
Oracle dba
- Installed and configured 10g Real Application Cluster (RAC) on Linux 3.0.
- Created a physical Standby database using Data Guard. Migrated the database to Oracle Automatic Storage Management (ASM).
- Converted the Single Instance Database to Oracle RAC.
- Managed and tuned online transaction processing (OLTP) database by using fully normalized schemas to optimize update/insert/delete performance, and to guarantee data consistency.
- Installed and configured Oracle Enterprise Manager (10g grid) to assist in managing all Oracle databases.
Confidential, Washington, DC
Oracle dba, Datawarehouse dba
- Installed and configured Oracle Enterprise Manager (10g grid) to assist in managing databases, application servers and web servers.
- Installed and configured 10gAS with load balancing routers.
- Designed and planned the layout of the Application Servers universe, including clustering of the Infrastructure, integrated Oracle OID with Microsoft Active directory.
- Integrated 10gAS to work with a backend RAC database. Implemented Single Sign-on (SSO) plan for OTR including the integration of Oracle infrastructures, Portal, Business Intelligence Reports. Served as technical lead, and DBA consultant on the Datawarehouse project using Oracle 10g RDBMS on a RAC server, Informatica (ETL), Cognos (Business Intelligence) implementation. Designed a sound backup and recovery strategy on TB database, including crisis scenario, capacity planning.
Confidential, Tulsa, OK
Oracle dba
- Served as an application server DBA, coordinating and supporting the effort of PL/SQL and web developers, then translating their recurrent changes into database objects.
- Installed and administered Oracle 9iAS and set up reports and forms services.
- Installed and administered Oracle Warehouse Builder.
- Designed and implemented a summary management including bitmap indexes, materialized view and Partitions. Installed, setup, configured and administered the Payroll an HR databases (PeopleSoft).
