Oracle Database Dba
Resume:
Didi Kadji-Tedjeu
*********@*****.***
RELEVANT SUMMARY: Oracle 19c Certified Professional (OCP) skilled in Oracle 8i through 19c and Oracle E-Business Suite R12, Oracle Fusion Middleware products, Oracle database implementation, tuning, migration and upgrades. CERTIFICATIONS:
• Oracle Certified Professional – OCP-DBA (19c)
• AWS Certified Solutions Architect – Associate
• CompTIA Security+
SECURITY CLEARENCE: Public Trust
OS experience: HP-UX 11.x, Sun Solaris 7/8/9, AIX 5L, Linux Red Hat ES4 and Windows 95/98/ME/NT/2003/XP & Vista, VI editing, RPM install, TCP/IP, SSH (putty). Experienced in installation of OS, configuration of mount points, addressing of security considerations.
Scripting: C, Visual Basic, HTML, JavaScript, shell, PL/SQL, Seagate Crystal Reports. Tools: Experience in RDBMS Tools like SQL Ansible, Loader, Import/Export, Data Pump, RMAN, OEM Grid Control, experienced with Toad, SQL/PLUS, Foglight, SQL Developer, PgAdmin, DB-access. Cloud: AWS platform involving EC2, RDS, EMR instances Languages: Fluent in English, French: read, speak & write. RELEVANT WORK EXPERIENCE:
CACI, Inc., Quantico, VA (USMC contract) 12/2019 to Present Sr. Oracle Apps DBA
• As a member of a team of 15 DBA’s, performing core tasks such as the creation and administration of Oracle 11gR2, 12c/19c databases, R12 EBS, schema creation, maintenance, and troubleshooting. Administers, maintains more than 45 Dev/Test and 10 Production databases. Implements policies and procedures for ensuring the security and integrity of databases. Implements data models and database designs, data access and table maintenance codes; resolves issues pertaining to backups, and other distributed data issues over a high-volume Terabyte Database. Setup and manage RAC and Data guard environments.
• Experience managing Real Application Clusters (RAC) and Automatic Storage Management (ASM)
• Supporting code deployment activities, refreshing Dev and Test environments with Prod data.
• General administration, patching, monitoring and maintenance of Oracle EBS R12.2.x
• Cloning and patching applications and databases, including usage of ADOP online patching
• Performing DB migrations and upgrades (from 12c to 19c).
• Participating in On-Call rotations to provide afterhours 24x7 database support.
• Supported and managed Oracle WebLogic Servers10.3.6 and 12c, Oracle OAS/OBIEE Suites.
• Perform quarterly Oracle CPU patches on different applications and database instances using Ansible scripting.
• Installed, configured and managed Oracle Cloud Control 13c on Unix Platform to monitor Production and Test instance
(Oracle Databases and Applications).
• Implemented OEM alerts to monitor databases various issues (shutdown, low disk space, listeners, etc.).
• Resolve gaps between Primary and Active Standby.
• Hands-on experience in planning and designing Backups and Recovery strategies like RMAN, Import/Export.
• Hands-On experience in tuning SQL queries and Oracle database related issues.
• Automate RMAN backup using shell scripts in Dev. and Patch and Production environments.
• Other projects include: Training of new colleagues, documentation of the database infrastructure, researching new technologies.
Deloitte LLC, Washington D.C. (US Bureau of Engraving & Printing contract) 02/2011 – 12/2019 Sr. Oracle Apps DBA
• Provided 24 hours and on-call support to Production, UAT and Development environments for E-Business Suite applications (EBS R12.2) and database 12c.
• Provided DBA support for EBS R12.2 and Oracle database 12c that includes performance monitoring, troubleshooting database issues, deployed patches, cloning, and permanent refreshed Dev and Test instances from Production environment.
• Worked on the migration of 12c databases from standalone to 12c Oracle RAC instances in Development, Test and Production environments.
• Supported, managed, and patched EBS R12.2.6 using ADOP utility on Oracle Linux configured with Oracle Databases 12c.
• Supported and managed Oracle Weblogic Servers, Oracle OBIEE Suites on Linux servers.
• Installed, configured and managed Oracle Cloud Control 13c on Linux Platform to monitor Production and Test instance
(Oracle Databases and Applications).
• Implemented OEM alerts to monitor databases various issues (shutdown, low space, listener down, agents, etc.)
• Maintained the Oracle Cloud 13c by applying quarterly security patches to both OEM and database tiers and Agents.
• Upgraded the OEM 13.3 to 13.5, upgraded OEM agents.
• Providing DBA support includes patching, cloning, upgrade and troubleshooting issues.
• Performed administration and maintenance of the Oracle Service Oriented Architecture (SOA) Suite, and Oracle WebLogic Server to support Oracle ERP system integration with legacy systems.
• Provided support to implement Quarterly security patches to Oracle R12.2.6, Oracle WebLogic 10g and 12c, Oracle Applications (OBIEE) and Oracle Databases (RAC and single nodes).
• Managed database upgrade project. Upgraded production, Test and developments databases from 11g to 12c.
• Documented the upgrade and migration process.
• Support Oracle WebLogic application, quarterly cpu patching, troubleshooting issues and upgrade.
• Developed scripts to implement database backups, setup the environment.
• Implemented the backup schedule using CommVault application for databases (RAC and non-RAC).
• Restored production RAC databases backup to a new server using CommVault to test the recovery procedure in case of Disaster Recovery.
• Trained other dba’s for R12.2.6 to teach how to patch with ADOP utility, clone the Oracle application using rapid-clone technology.
InfoZen, Inc., Washington, D.C. (DHS/TSA Contract) 11/2008 - 01/2011 Senior Oracle DBA
• Installed and configured physical standby database to support the AFSP (Alien Flight Student Program) and RMS
(Reporting Management System) applications including the configuration of Data Guard on RAC 2 nodes servers.
• Lead the Upgrade of all production, staging and Development databases from Oracle 9i to 10g and from 10g to Oracle 11g.
• Installed and configured Oracle Enterprise Manager 10g release 2 (10.2) and later upgraded to Oracle Enterprise Manager 11g.
• Created and deployed database continuity and redundancy plans including backup and recovery processes.
• Worked with developers to make structural changes to the databases when design changes are to be implemented and also implemented those changes in Informatica mappings as well.
• Analyzed and deployed Oracle quarterly security patched to production, developments and staging servers and mitigated security vulnerabilities.
Verisign, Inc. (Contract with CMS), Baltimore, MD) 03/2007 – 11/2008 Oracle DBA
• Provided database support for real-time rating, roaming for prepay, post pay and converged telecommunications subscribers.
• Provided primary support that includes proactive and reactive maintenance for large complex databases using Oracle9i and 10g databases in LINUX environment.
• Maintained and built non-production databases, including database refreshes, database patch management, database space management, database performance tuning and migration/upgrade of the non-production database environments in Linux OS.
• Performed database performance tuning, PL/SQL statement tuning and optimization.
• Provided 24x7 operational support of corporate production databases on a rotating schedule.
• Recommended appropriate procedure, query or package changes and optimizations to ensure and improve system performance and reliability.
US Department of the Navy, Naval Surface Warfare Center – Critical Infrastructure Protection 06/2003 – 03/2007 Oracle DBA
• Provided 24X7 Operational Support to the Mission Assurance Division and served as Primary and Technical Point of contact for all CIP (Critical Infrastructure Protection) databases and System Administration.
• Provide work coordination and management for teams of DBAs, including task assignment and coordination, and status reporting.
• Performed physical database design; Transformed logical data models into physical database structures via standard processes.
• Experience administering enterprise level GIS applications (ArcSDE and other ESRI products). To support geospatial data acquisition, processing, and analysis within the context of the DOD mission critical and research availability of remotely sensed data, especially high-resolution imagery, and other data to help developing geospatial information products in response to needs of the organization mission.
• Led the migration, upgrade and installation, configuration and testing of ArcSDE and ArcGIS desktop applications from version 8.3 to 9.2.
• Responsible for the installation, maintenance support, upgrades, monitoring and performance tune of Oracle databases 9i and 10g running on HP-UX UNIX and LINUX.
• Researched, Implemented, and tested Oracle Advanced Security to integrate with Microsoft Active Directory
(KDC) to allow enterprise users to authenticate to multiple databases using a single, centrally managed password.
• Implemented HP Data Protector backup solutions used to backup Oracle and SQL Server databases.
Contact this candidate