| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
PHONE NUMBER AVAILABLEEMAIL AVAILABLEOracle Database AdministratorhighlightsEdwin, is an experience Oracle DBA with 6 years of experience in supportingProduction & Development databases. He has great knowledge in databaseadministration, backup/recovery, and performance tuning. He also have a clearunderstanding of database back-end and application front-end. Edwin is a great team player and has good communication skills.professional summary6+ year Experience in Oracle Database Administration encompassing Installation, Configuration, Patch Installation, Migration, Upgrades, Backup and Recovery, Cloning, Replication, Database Security, Memory Management, Data Modelling, Performance Monitoring and Tuning, RAC, Data Guard, Grid Control, Oracle Streams Enterprise Manager on Sun Solaris, Exadata,Red Hat Linux, ETL tools, HP-UX, AIX, and Windows Platforms Ability to provide expert-level technical support in all aspects of database administration including installation, configuration, upgrades, patching, migration, capacity planning, performance tuning and backup & recovery Hands-on experience with Oracle Real Application Clusters (RAC) and Data Guard.Experience in Database management systems like MYSQL, PostgreSQL, Oracle and SQL server.Ability to work both as an individual contributor and as a member of a team.Good Experience in migrating Databases from Solaris, AIX Oracle 11g/12c to Linux Oracle 19c and 21cImplementation of high availability solutions with Oracle 12c RAC and 19c RAC, Physical and Logical Standby database (Data Guard) and GoldengateExperienced working with ZDLRA for database backups and restores.Manage and administer oracle zero data loss recovery appliance (ZDLRA)Apply Quarterly patch oracle zero data loss recovery appliance (ZDLRA)Experienced with Oracle databases 19c and 21c and multitenant concepts (CDBs and PDBs).Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and data Ware-housing.Managed MYSQL databases for e commerce and content management systems, ensuring high availability and minimal downtime.Experience with Oracle Data Guard setup, maintenance and troubleshooting for High Availability.Experience in performing Backups/Recovery using RMAN, Datapump and Flashback Technologies.Experience in SQL Tuning using tools like Explain Plan, SQL*Trace, TKPROF and OEM.Experience in Database capacity planning, monitoring object growth and Storage Management.Experience in Shell Scripting for configuring monitoring alerts and automation.Experience in performing Data Migration between Non ASM and ASM databases and also between the databases of different vendors.Worked with EXP/IMP, EXPDP/IMPDP to refresh the schemasDatabase Performance Tuning Diagnosing using AWR (Automated Workload Repository) / Stats pack and ASH (Active Session History) reports, ADDM (Automatic Database Diagnostic Monitor) analysis.Proactive database monitoring via automatic Email and Text alerts of Alert.log, Listerner.log and Space errors to DBA cell phoneExperience in Upgrading databases, applying patches.Managing Security Management, Schema Management, Instance Management, Storage/Space Management.Proficient with Database Cloning, Migration, and Patching of Oracle Databases.Installed Oracle 12c with ASM and OCFS2 File systems.Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.Extensively implemented Datapump, conventional Export/Import (Oracle 12c, 11g) for migration and logical backup of database.Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 19c, 12c, 11g) allowing users to quickly move a user Tablespace across Oracle databases.UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.Experience in handling very large databases (VLDB) ranging up to 100TB.Proficient in writing SQL, PL/SQL (Stored Procedures, functions, packages and triggers) scripts.professional experienceLANE BRYANT - Nashua, NHFeb 2023 PresentOracle Database AdministratorWorked with customer for different RAC related issue: [hangcheck timer, split brain, hugepages setup etc]; Troubleshoot performance issues for the RAC instances (GC events)Monitoring and Troubleshooting of Database Replication issues using Golden Gate, dealing with conflict resolution and performance issues.Installation, maintenance and tuning of Oracle 12c RAC databases including ASM and CRS.Recovering Golden Gate corruptions and managing host/cluster maintenance mode blackouts.Experienced working with ZDLRA for database backups and restores.Apply Quarterly patch oracle zero data loss recovery appliance(ZDLRA)Implemented Initial Data Load, Batch/Online replication, Security in Golden Gate.Implementing Best Practices for migration of regular databases to Oracle ExadataResolved/Diagnose Node Eviction issues.Implemented Oracle database 19c RAC databases using Oracle Clusterware for achieving high Availability.Experience working on POC of 19c new features like Redaction policy, adaptive query optimization, multiple indexes on single column, Restore table through RMAN etcAble to resolve the performance issue in database 19c using automatic big data caching, full database caching and In-Memory Aggregation features.Hand on experience in cloning the non-multitenant container database to pluggable database in 19c using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot cloning feature.Have implemented two types of standby databases supported by Data Guard, logical standby and physical standby databases in 12cR2 on two node RACHaving hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with VERITAS Net Backup and Comm vault.Implemented Active Data guard, creating both Logical and Physical Standby databases in 11g,12cRAC& 19c environment for the Production databases.Configured and managed Data Guard extensively for Production databases of sizes ranging from 50GB to 5TB.Experiencing in Installing OEM 19c Cloud Control and upgrading the 12c management agents to 19c agents.Cloning/duplicate of database with RMAN and user-managed (hot/cold) backups.Migration of databases to 19c from Oracle 11g&12c.Implemented and maintained Oracle 12c Data Guard/standby databases for fail-over purposes. Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 12c R2.Also worked on Network data encryption to improve the security and also implemented SSL wallet to secure the connections.Database Services creation for distributing the applications across multiple nodes, extensively used all command line utilities SRVCTL, CRSCTL, ADR, ASMCMD,Redefinition of tables using DBMS_REDEFINITION, partitioning the tables in the production, re-defining the columns data types, and moving the LOBS to different tablespacePartitioned tables Maintenance, adding new partitions, exchanging one year old partitions then archiving of the exchanged partitions, dropping or truncating of old portions.Implemented 12c Interval Partitioning for monthly partitioning of large tables.Developed RMAN Backup strategies for cloning the test databases with the production environment and worked on RMAN active-active duplication.Experience with Logical backups EXPDP/IMPDP and extensively used for Re-hosting the application using Golden Gate and worked with conventional EXP/IMP for migrating data from 11g to 12c to 19c.Scheduled RMAN backups, purge jobs, Maintenance Jobs using DBMS_JOBS, DBMS_SCHEDULER, Crontab and $UNIVERSE.Designed and implemented different backup strategies like Cold, Hot, MAN with Flash Recovery Area and Logical Backups EXPDP/IMPDP.Handled Chained Rows and Row migration and solved the database performance issues.Experienced with ASM, adding, deleting disks to the disk group.Supported development teams for all the database related issues and handled the critical issues like network failures and ASM DISK group errors and node failures in the RAC cluster.Experience in performance tuning with ADDM,AWR,ASH,index optimizations, partitioning.Experience in usage of OEM and setting alerts.Experience in managing database backups/recovery, data movement using RMAN,datapump,and Flashback.Generated Statspack/AWR reports using OEM 19c from Oracle 12c database and analysed the reports for Oracle wait events, time consuming SQL queries, tablespace growth, database growth.Used Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements. Involved in SQL Query tuning and provided tuning recommendations to Application jobs, time/CPU consuming queriesCardinal Health - Dublin, OHNov 2017 January 2023Junior Oracle Database AdministratorPerformed data migration from flat files into an Oracle database using SQL*Loader.Performing Cloning and Refresh using RMAN and Datapump.Oracle Advanced Compression techniques.Partitioning Tables, Rebuilding of Indexes, Securefiles, DBLINKS, Materialized Views, Store Procedures, Triggers and constraints.Demonstrated proficiency in managing Oracle Instance, database storage structure, schema objects, managing tablespaces, Rollback and undo segments, creation of database objects, Data Modelling.Defining Users, Roles, Privileges, Auditing to ensure database Security.Working with database security tools TDE, DB Vault / VPD.Applying CPU/PSU patches to various versions of databases with minimum downtime.Upgrading Oracle Binaries and databases from 11g to 12c and 12c to 19c, and 19c to 21cHandling very large databases (VLDB) ranging up to 100TB.Writing SQL, PL/SQL (Stored Procedures, functions, packages and triggers) scripts.Worked closely with application teams in the migration process of the 11g and 12c databases doing performance testing and designing optimal migration process.Configuration, maintenance and tuning of 12cr2 3 nodes RAC Cluster.Setup, configured and maintained oracle data guard (primary and standby databases) to ensure disaster recovery, high availability and data protectionApplying new database patches and upgrading to new application releasesResponsible for documenting database changesPerforming backup and recovery operationsPlanning Backup/ Restoration Strategy, Scheduling Backups, taking Logical Backups (with Export/ Import Data Pump utilities)Analysis and management of Oracle problems/defects using SRs and/or Metalink with Oracle Corporation and installation of patchesWriting SQL scripts, stored procedures, functions and transactions analysis for performance tuningSecurity User Management, Privileges, Role, Auditing, Profiling, AuthenticationMade performance improvements to the database by building Partitioned tables, Index organized Tables, Materialized Views and Bitmap IndexesEnvironment:HP-UX, Windows, Oracle 11g, 12c,19c,21c, SQL, PL/SQL, SQL plus, TOADEducationUNIVERSITY OF YAOUNDE 1 CAMEROONTechnical skillsOperating SystemsHP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise Server 9, 10. Windows 95/98/NT/2000RDBMSOracle 11g, 12c, 19c,21cLanguagesSQL, PL/SQL, UNIX Shell Scripting, PERL,MYSQLToolsTKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM.Toad, Putty, NX client, WinscpDatabase UtilitiesSQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import |
