| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateName: Cedric LeudjouContact: PHONE NUMBER AVAILABLEEmail: EMAIL AVAILABLEDBA SKILLS.Databases: Oracle 11g, 12c, OEM, 18c, 19cOperating Systems: Linux, Centos7, Windows HP-UX, AIX, RHELTuning Tools: TKPROF, EXPLAIN PLAN, AWR, and ADDM, Cluster controlLanguages: PL/PLSQL,Utilities: RMAN, OEM, SQL*Loader, EXP, IMP, Data pump, TOAD, Oracle SQL Developer Crontab.PROFILE SUMMARY.7+ years IT experienceOracle DBA(11g,12c,18c, 19c)Backup and recoveryProduction supportData guardRACGolden GatesPerformance tuningCloningShell scriptingData modelingInstallation-upgrade-patchingData securityBash ScriptingETLEBSPROFESSIONAL SUMMARY.Extensively used Database Administrative tools like, Oracle Enterprise Manager (OEM), SQL-Loader, SQL*DEVELOPER, TOAD for tuning and monitoring purposes.Production support, database management and performance tuningWorked on different Oracle database versions (10g, 11g, 12c, OEM, and 18c)Good experience in applying Critical Patch Update (CPU) for security and Patch Set Update(PSU) for security and bug fixes using OPatch utility.Participated in Strategic Planning, Logical and Physical Data Modeling & Application Tuning.Experience in Oracle Flashback Technology to recover logical corruptions and Performance Tuning ( I/O, Memory & SQL Tuning etc.) by using tools/utilities such as AWR, ADDM, Explain Plan, Autotrace, TKPROF.Excellent in Hot/Cold Backup with or without catalog, full backup, incremental, cumulative backups, Recovery and Cloning of databases using RMAN.Extensive knowledge with OLTP and OLAP systems.Manage application such as Enterprise Business Suite, EBSData loading using external tables, SQL*LOADER, Logical and physical backups using full export, DATAPUMP.Configured Master-Slave replication and monitored on-going replicationInstalled, configured, and maintained Goldengate on Oracle 11g, 12c for disaster recovery and data protection purposeAnsible for automation of scripts across serversEnforced Security Administration, system monitoring by adding and removing users, configuring quotas, auditing, TDE, network and database encryption.Manage applications like PeopleSoft and EBSVery good hands on experience on EC2 like creating and managing instances of all types.Worked on S3 bucket like version control, Life cycle management, Cross region replication.Hands on experience on VPC like creating own CIDR block, subnets, assigning IPs and launching instances into VPC.Administering users, groups and setting up of policies by using IAM.Monitoring all cloud services by using Cloud Watch.Worked on all kinds of EBS volumes, snapshots and EFS.Creating Elastic Load Balancer and attaching instances to that ELB.Having very good experience on configuring Auto Scaling groups and setting policies.Setup code repositories like GIT.Setting up and working with Ansible.Hands on experience in writing Playbooks.Having very good experience in YAML.Working experience in using Ansible Ad-Hoc commands, Modules.Hands on experience in working with Roles in Ansible.Configuring the Docker containers by using Docker Images.Creating docker images by using docker fileCreating docker images from containersHaving very good experience in working with Docker volumesExperience in port mapping in DockerSetting up of own docker registryHaving very good knowledge in installation of JenkinsGood knowledge in configuring nodes in JenkinsWorking experience in using multiple pluginsIntegrating Jenkins with GIT and MavenSetting up of maven, CI and CD jobsKnowledge in configuring dependency jobs in JenkinsExperience in maintaining the CI with JenkinsPROFESSIONAL EXPERIENCE.BANK OF AMERICA BETHESDA, MD. Nov 2021 PresentOracle Database AdministratorSuccessfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.Administered and monitored over 150 databases both on 10g/11g on prod/test/dev environments.Administering Oracle Databases 10g/11g of sizes ranging from 100GB to 5TB.Data warehouse solution for large databases for data consolidation, intended for OLAP andBI, ETL, using tools such as ERWIN, INFORMATICA, SQL-LOADERMigrated databases from Filesystem to Automatic Storage Management (ASM).Up-gradation of single instance databases from 10.2.0.4 to 11.2.0.3 on Linux.Responsible for using Flashback query mechanism along with automatic undo management.Automating Alerts, using SQL to set thresholds and triggers.Debugging SQL work with developers to fine tune SQL/PL to enhance performanceExperience in Creating Physical and logical database design Data Models using Erwin Tool.Installed 12C grid control and Used Oracle Enterprise Manager Grid control 11g/12c for monitoring databases.Programming in shell to create shell scripts that automate the database backups and maintenance.Involved in Mass Agent Deployment using Oracle Enterprise Manager 12c.Implemented Data Guard with maximum availability and performance configurations for production databases.Worked on Active data guard, Fail over and Switch over cases.Implementing Data pump, conventional export/import utility of Oracle 11g, 10g for reorganizing Databases/Schemas/Tables to improve the performance.Applied Bug fixes patches, Quarterly Security Patches for RAC and non-RAC servers for issues when upgrading, DR switchover testing.Installed, configured, and maintained Goldengate on Oracle 11g, 12c and 19c for real-time replication and business intelligenceReconfigured the OCR, public and private interconnects, modifying the VIPs and the subnet masks for 2, 3, 4 Node RAC Clusters and Upgraded single instance 11g database to 12C RAC.Setup, reconfigured and monitored 2, 3 Node RAC Primary to 2, 3 Node RAC Data guard for DR.Tested the Data guard (DR) SWITCHOVER of RAC to RAC Data guard as part of the migration.Created new databases/instances on 12c/11g RAC and single instances using customized scripts, DBCA.Handled all daily DBA activities and excellent experience with SQL scripting, PL/SQL coding, stored procedures, functions, packages, triggers to enforce the referential integrity constraints.Performance monitoring and Database/Instance/ clustered Application tuning usingDictionary views, AWR (Statspack), ADDM, ASM reports, OEM Grid Control, tuned SGA/PGA parameters, initialization parameters and reorganized physical objects (tables & indexes) and tablespaces to improve the performance.Redesigned table and index partitioning strategies, using HINTS to improve the query performance.Experience in AWS platform and its features including IAM, EC2, EBS, VPC, RDS, Cloud Watch, Cloud Trail, Cloud Formation AWS Configuration, Autoscaling, Cloud Front, S3, SQS, SNS, Lambda and Route53 .Experience with IAM requirements for cloud - based services, including strategies, trust models, and open standards, encryption, etc. used to improve manageability, access governance, provisioning, information security, and privacy.Experience with Troubleshooting AWS EC2 instances for Status check through System Status checks and Instance Status checks alerts and rectifying if necessary.Experience with designing and configuring secure Virtual Private Cloud (VPC) through private and public networks in AWS by creating various subnets, routing table, Network ACL, NAT gateways .Experience on AWS Elastic Block Storage (EBS), different volume types and use of various types of EBS volumes based on requirement.Responsible for setting up databases in AWS using RDS, storage using S3 buckets and configuring instance backups to S3 bucket.Excelled on creating AMI (AWS Machine Images) that utilizes ELB (Elastic Load Balancer) and Auto Scaling.Implemented a 'server less' architecture using API Gateway, Lambda, and Dynamo DB and deployed AWSTAYLOR FARMS- ANNAPOLIS JUNCTION, MD Sep 2019 Sep 2021Oracle Database AdministratorCreated tablespaces, tables, indexes, set privileges and user logins on oracle databases.Perform maintenance activities like checking auto vacuum jobs, and customized vacuum on certain tables.Supported Oracle DB backups (online/offline), logical backups and UNIX scripts, created clone databases, performed DBA day-to-day activitiesImplemented shell-scripts for automation of day to day activities.Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both OEM (client), Oracle 10g database control & SQL*Plus, as well as pre-developed UNIX shell scripts.Applied Critical Patch Updates (CPU) and Patch set updates (PSU) on Oracle databases and interim patches for various bugfixes on database products.Created and managed PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL developer and SQL navigator.Hand on experience in cloning the non-multitenant container database to pluggable database in 12c using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot cloning feature.Backed up and recovered/Cloned/Migrated databases using RMAN and traditional Data pump export/import utilities in Oracle 11g and 12C.Backup Oracle DBA for two major projects involving periodic administration, troubleshooting & tuning of Oracle databases (11g & 12C single instances running on Linux)Used to run scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.Created Physical Standby databases, performed Failover and Switchover using Data Guard Broker and manually when required.Involved in Oracle Golden Gate installation, configuration, and monitoring.Designing/developing/maintaining database schemas.Developed, modified, and optimized very complex queries to data retrieval using Explain Plan, SQL Trace, TKPROF, parallel processing and partitioning techniques.Implemented Oracle database 12C RAC databases using Oracle Clusterware for achieving high Availability.Oracle Installation, Configuration, Migration, Upgrades and Patches. Server versions ranged from Oracle 11g 19c.Disaster recovery planning or Emergency Recoveries and Ensuring Recoverability of Databases.Experience working on POC of 12c new features like Redaction policy, adaptive query optimization, multiple indexes on single column, Restore table through RMAN.ALLIANZ - Minneapolis, MN. Jun 2017 Aug 2019 Oracle Database AdministratorSuccessfully installed and configured Oracle 11.2.0.4, Oracle 12.2.0.2 databases on LinuxOracle Production Support Database AdministratorAdministered and monitored over 150 databases both on 11g/12C on prod/test/dev environments.Administering Oracle Databases 11g/12C of sizes ranging from 100GB to 5TB.Migrated databases from Filesystem to Automatic Storage Management (ASM).Up-gradation of Oracle databases from 11G to 12.1.0.2 and 12.2.0.2Installed 12C grid control and Used Oracle Enterprise Manager Grid control 11g/12c for monitoring databases.Programming in shell to create shell scripts that automate the database backups and maintenance.Installed and set up High Availability Oracle Golden Gate (OGG) systems on Oracle 11g and 12c environments. Upgraded Oracle Golden Gate (OGG) systems from 11g to 12c.Have implemented two type of standby databases supported by Data Guard, logical standby and physical standby databases in 11gR2 on two node RACHaving hands on experience in Hot/Cold Backup, Recovery and Cloning of databases usingRMAN.CERTIFICATIONS/EDUCATION.BSc. in Chemistry. University of Douala, Cameroon July 2016.AWS Solutions Architect certified.Oracle Certified Associate (OCA) 12c AWS DevOps Certified in progress |
