Production Support Sql Developer

Name: Cedric Leudjou

Contact: 240-***-****

Email: *************@*****.***

DBA SKILLS.

Databases: Oracle 11g, 12c, OEM, 18c, 19c

Operating Systems: Linux, Centos7, Windows HP-UX, AIX, RHEL

Tuning Tools: TKPROF, EXPLAIN PLAN, AWR, and ADDM, Cluster control

Languages: PL/PLSQL,

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

PROFILE SUMMARY.

•7+ years IT experience

•Oracle DBA(11g,12c,18c, 19c)

•Backup and recovery

•Production support

•Data guard

•RAC

•Golden Gates

•Performance tuning

•Cloning

•Shell scripting

•Data modeling

•Installation-upgrade-patching

•Data security

•Bash Scripting

•ETL

•EBS

PROFESSIONAL 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 tuning

Worked 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, EBS

Data loading using external tables, SQL*LOADER, Logical and physical backups using full export, DATAPUMP.

Configured Master-Slave replication and monitored on-going replication

Installed, configured, and maintained Goldengate on Oracle 11g, 12c for disaster recovery and data protection purpose

Ansible for automation of scripts across servers

Enforced Security Administration, system monitoring by adding and removing users, configuring quotas, auditing, TDE, network and database encryption.

Manage applications like PeopleSoft and EBS

Very 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 IP’s 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 file

Creating docker images from containers

Having very good experience in working with Docker volumes

Experience in port mapping in Docker

Setting up of own docker registry

Having very good knowledge in installation of Jenkins

Good knowledge in configuring nodes in Jenkins

Working experience in using multiple plugins

Integrating Jenkins with GIT and Maven

Setting up of maven, CI and CD jobs

Knowledge in configuring dependency jobs in Jenkins

Experience in maintaining the CI with Jenkins

PROFESSIONAL EXPERIENCE.

BANK OF AMERICA – BETHESDA, MD. Nov 2021 – Present

Oracle Database Administrator

Successfully 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 and

BI, ETL, using tools such as ERWIN, INFORMATICA, SQL-LOADER

Migrated 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 performance

Experience 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 intelligence

Reconfigured 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 using

Dictionary 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 AWS

TAYLOR FARMS- ANNAPOLIS JUNCTION, MD Sep 2019 – Sep 2021

Oracle Database Administrator

Created 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 activities

Implemented 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 Administrator

Successfully installed and configured Oracle 11.2.0.4, Oracle 12.2.0.2 databases on Linux

Oracle Production Support Database Administrator

Administered 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.2

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.

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 RAC

Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using

RMAN.

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

Contact this candidate