| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Email: EMAIL AVAILABLEhttps:// LINKEDIN LINK AVAILABLEPhone: PHONE NUMBER AVAILABLESUMMARY:With over 7+ years of IT experience with extensive knowledge and proficiency in Oracle 11g, 12c, 18c, 19c database administration and system analysis within a multifaceted environment. Possess excellent communication skills and a great team player with a fast-learning curve. Works perfectly and effectively under stressful conditions where speed and accuracy are necessary for critical databases. Remarkable attention-to- detail with the ability to coordinate multiple activities; determine and analyze problems and implement corrective actions. Migrated on-premises Oracle databases to Amazon Aurora Postgres cluster with five Read replicas using Schema Conversion Tool, Database Migration Service, and AWS Snowball. Worked on various operating systems like UNIX, LINUX, Windows, AIX, and Solaris. Experience includes Patching, Cloning, Memory Management, Database Security, System maintenance, Database design and Modeling, Capacity planning, deployment, and documentation.CORE COMPETENCIES:Oracle Installation, Configuration & AdministrationDatabase Upgrade and MigrationBackup and recovery using data pump and RMAN.OMS Grid Installation & AdministrationApplication SupportWindows & Linux Security AdministrationIncident, Problem & Change ManagementMonitoring and Performance tuning using OEM12c and 13c Grid Control/ManualDatabase integrity and Advanced security implementations TDEOracle High Availability involving Oracle RAC, and ASMOracle Data GuardOracle Golden GateMultitenant architectureTECHNICAL SKILLS:Database Technologies: Microsoft SQL Server 2000, Oracle 11g R2 and 12c, 19c. Operating Systems: Windows 2008 Server, Red Hat Linux, Sun Solaris, HP-AIX, Windows Tools: Toad, Data Pump, SQL loader, SQL Developer, AWR, ASH, Explain Plan, OPatch Utilities: RMAN, ADRCI, SQL*Plus, RDA-HCVEHigh Availability Solutions: RAC, Data Guard, and ASM Networking: SQL*NETPROFESSIONAL EXPERIENCE:American Family Insurance, Madison, WI Jul 2019 Present Oracle Database Administrator (DBA)o Monitoring and performance tuning using Oracle Enterprise Manager Console and SQL Developer to manage daily tasks regarding performance and maintenance. o Upgrade Oracle Databases Software from 12.1.0.2 to 19.3.0 o Creation of CDBs and PDBs as well as converting non CDBs to PDBs databases. o Application of Oracle Database 19c OPatch Release Update in both Dev and Prod environments. o Performed scheduled maintenance and support release deployment activities regularly o Performed Oracle database administration tasks including configuration and database design. o Performed full Database and incremental backup using RMAN, restored and recovered using RMAN Catalog or Flashback recovery using SCN or timestamp. o Manage large volumes of transactions and provide high availability for mission-critical applications through Online Transactional Processing (OLTP).o Worked with Sys/App Dev/Network Admin teams to initiate and perform capacity planning across database environments.o Configured, Installed and administered Oracle Data Guard 19c for HA on server from scratch. o Configured Physical Standby, Logical standby, Snapshot standby and Active Data Guard from Primary Database respectively and vice as well as performed failovers and switch overs. o Resolved small gap and big gap resolutions using Flashback and incremental backups respectively. o Enhanced performance and health check of Oracle environment by providing advanced performance tuning using AWR, ADDM, EXPLAIN PLAN, ASH, SQL TUNING ADVISOR, SQL TRACE. o Implemented Oracle ASM 12c/19c software installation and configuration (Grid infrastructure) and partitioning disks in Linux.o Creation of ASM disk groups in RAC as well as ASM mirroring and failure groups. o 24x7 Production support and monitoring to ensure a proactive problem-solving approach. o Upgraded Oracle Enterprise manager 13.3 to 13.4 and applied OMS, Agents, Grid and Database Patches. o As part of our Disaster Recovery I have set up the Data Guard broker for automatic failover and switchover by enabling Fast Start Failover.o Implementing Oracle Advanced Security using Transparent Data Encryption (TDE) to enforce database hardening through data-at-rest / in transit encryption. o Unix Shell scripting for automating RMAN backup and recovery, Import and export procedure of databases, tablespace alerts, network, system and database triggers. o Developed a backup strategy for our MSSQL Server databases and administered these databases using SSMS and T-SQL.o Working on several project on Microsoft SSIS, SSAS and SSRS. o Writing of scripts using SQL and PL/SQL including Procedures, Functions, and Triggers to automate procedures.o Developed documentation and scripts for database design, analysis, creating objects and schemas. o Used Oracle Golden Gate 19c for replicating data across homogeneous and heterogeneous platforms. o Performed Initial load and Change Sync replication, integrated extract/replicat using OGG 19c. o Configured and managed local/remote listener for an Oracle Database instance. o Configure the Single Client Access Name (SCAN) listener for high availability and load balancing. o Configured AWS cloud environment API, Application load balancer plus Amazon EC2, Amazon RDS for databases, monitoring with Amazon CloudWatch, Amazon VPC for security. o Document automation processes and scripts to ensure transparency and facilitate knowledge sharing within the team especially Team meetings.Saint Peter's University Hospital. New Brunswick, NJ Apr 2016 Jun 2019 Oracle Database Administratoro Monitored and optimized database performance, troubleshooting performance issues using OEM 13c and AWR reports.o Performed SQL Tuning and provided consultation such as creating Materialized views, table partitions, adding indexes, dropping and rebuilding indexes.o Installed and configured Oracle OEM 12c and 13c on Dev and Test environments. o Helped current DBAs to use OEM 12c Tuning Advisor as a tool for performance tuning. o Performed data and metadata migration to newly installed servers using Data Pump Expdp/Impdp. o Performed Oracle Database LifeCycle Management (LCM) tasks that included migrations, patching, upgrades, automation, and decommissioning legacy databases. o Demonstrated ability to work in a team environment to design and implement complex GoldenGate architectures that meet business requirements and performance targets. o Upgraded databases from 10g, 11g to 12c (12.1.0.1 and 12.1.0.2) by doing either in place upgrades for dedicated databases or migrations for shared databases. o Data loading using external tables, SQL*LOADER, Logical backups using full export and DATAPUMP. o Setup and Configured Axon and its related agents on Linux instances. o Identify long-running database queries, refine queries for better performance, and work with end- users to implement changes.o Improved 24/7 alert and maintenance of databases by solely configuring OEM Alert Rules. o Applied Oracle quarterly patches of the current PSU version to non-RAC and RAC databases. o Performed data and metadata transfer from legacy servers to newly installed servers using Data Pump. o 24x7 remote support and on call Database support using RSA-VPN. o Built and configured RMAN Recovery Catalog for Backup and Recovery strategy. o Cloned production databases as needed for testing and development using RMAN and Grid Control. o Managed database security by creating and assigning appropriate roles and privileges to users depending on the user activity.o Designed, tested, implemented, and documented database migration procedures involving the use of export/import utilities and Transportable Tablespace. o Identified and worked with developers on automating processes using python to minimize errors. o Created primary objects (tables, views, indexes, synonyms, procedures, functions, and triggers) using SQL DDL and DML scripts/commands using primary and foreign keys o Working knowledge of Exadata for replication of data across servers. EDUCATION:B.Sc. in Mathematics and Computer ScienceUniversity of Buea, Cameroon, 2012 |
