| Candidate Information | | Title | Database Administrator Oracle | | Target Location | US-IN-Greenwood |
| | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateSENIOR ORACLE DATABASE ADMINISTRATOROverall experience of more than six (7+) years as an Oracle DBA Administration with all Database versions from 10g to 21c.Proficient in running Windows, Linux, Solaris, HP UX, AIX, RHEL and VM databases.Extensive experience in Database Installation, Configuration, Upgrade, Migration,Excellent knowledge of Standalones, RAC, and Exadata, especially X6, X7, X8 & X9Backup and Recovery of various releases on different platforms.Database restore and recovery, dealing with various restore and recovery scenarios.Experienced in SQL, PL/SQL, and shell scripting.Proficient in Tapes Backups and Store/Recovery from Tapes.Proficient in RMAN Backups, Net Backups, data domain DBboost, and Commvault Backups.Proficient in setting up and maintaining RAC and troubleshooting issues with RAC.High experience with Oracle Data Guard build, configuration, and maintenance.Work experience with Oracle Golden Gate technologies.Implement and maintain database security (create & maintain users & roles, assign privileges).Adding, removing, extending, and mapping ASM disk groups.High Experience with Database performance tuning.Expert in performance tuning the database by using SQL Profile, AWR, ASH, ADDM,Explain Plan and SQL Tuning Advisor.Multitenant container and pluggable database architectureTicketing like ServiceNow, Remedy, Jira, Slack and bitbucketsProficient in Exadata features like Smart Scan, Flash Cache & HCC (Hybrid Columnar Compression)High Experience working with OEM, Grid Control, Cloud Control, and DB console.Long years of experience with Database design and architecture.Experience in TDE (Transparent Data Encryption), Wallet & KeystoreManage all aspects of the OGG design, implementation, and support in development, UAT, and production environments. Identify and resolve OGG problems occurring in all database environments.Multitasking and working on multiple projects in parallel to deliver highly critical projects on time.Good experience with MS SQL Server/database Installation, Configuration, Migration, Upgrading, Performance Tuning.Setup both physical & logical Data guard using RMAN duplicate and standby resync.Day-to-day database administration with tools like srvctl, crsctl, asmcmd, cellcli & dcli.Flashback and Restore Points TechnologyTECHNICAL EXPERTISE:Key SkillsApplications: EBS,EbsuiteHardware Server: Oracle X4/X6/X7/X8M full rack Exadata machine, IBM PowerPC, X64 box, Hitachi, EMC, Dell Servers, Compaq Servers SOLARIS, HP/UX-900.Operating System: Oracle Enterprise Linux(oel), Redhat Linux,Aix( Ibm ), Unix( Hp and Solaris)Languages: SQL, PL/SQL, Unix Shell Scripting Bash/KornData Replication: Oracle GoldenGate 12c, 19c, Oracle Streams & DataGuardTools / Utilities: Oracle sql developer,PL/SQL developer,toad, ERWin,Jira, SrviceNow, RMAN, Logminer, TKPROF, AWR/ADDM/ASH, OEM(10g,11g,12c & 13c), Export, Import, Datapump, RMAN, SQL*Loader, DBCA, DBUA, and TTS.WORK EXPERIENCE:Miso Inc. Indianapolis, INOracle Database Administrator 02/2023 PresentResponsibilities:Supports Oracle Database 12c & 19c on X9 and RAC on OEL.Upgraded Oracle databases 12.2.10 databases from 12c non-container to 19c Container.Cloned EBS 19c databases with RMANMigrated Ensuite databases from on-premises to AWS using AWS Data Sync, AWS SnowballUsed Auto Upgrade to upgrade RAC databases from 11g to 19c.Create documentation for resolved Performance issues related to databases, applications, networks, etc.Constantly worked with testers & developers to resolve both database & application performance issues.Worked as a Primary support for database-related issues with clients.Implemented Disaster Recover Site with Data Guard and maintained Active Data Guard.Performed Database Tuning and performance, Storage Management, Plan growth and changes (capacity planning), Database Monitoring, Security Management, and Tuning SQL queries.Work extensively with Oracle Materialize Views build, refresh, and troubleshooting.Setup Active data Guard on a two-node RACLead Upgrade project to upgrade 11g, 12c database to 19c.Maintain ASM, add, remove, and extend disk groups.Write and implement scripts for database maintenance and daily tasks.Create procedures, triggers, and packages for the application team.Installed and configured High Availability Oracle Golden Gate (OGG) systems on Oracle 19c RAC environments.Assists in the development of policies for standardizing systems, development tools and security practices.Participated in the analysis and designing of Oracle Exadata Server for infrastructure and related projects.Work with Exadata machines (FULL RAC) migrations from legacy to Exadata new machines.Proficiency in analysis, design, development, testing, implementation, and maintenance of applications in Oracle Application Express (APEX) and client/server configurations.Used tools like TOAD, Grid Control, and Cloud Control to monitor database performance.Flagstar Bank, MIOracle Database Administrator 09/2021 02/2023Responsibilities:Support daily administration, monitoring, tuning, and troubleshooting of standalone as well as RAC databases built on Linux (Database sizes range from 50GB to 100TB).Led a big company project to migrate more than 400 databases from lower versions to the newer version 19c.Performed Oracle Fleet Patching and Provisioning (Gold Images and working copies and Clients).Setup ZDLRA (Zero Data Loss Recovery & Appliance), with Real-Time RedoUsed Oracle Auto Upgrade to upgrade 11.2.0.4 databases to 19c and 12.2.01. to 19c.Supported Financial applications like RPO (Retail Payment Office).Worked on restoring data from ZDLRA.Tuned database instances and applications and recommended changes to improve database performance.Led upgrade of in-place upgrade of 11g databases from 11g to 19.14.0 RAC on AIX.Supporting the applications teams and developers in the Restoration and Recovery of databases at times of critical failures and testing.Provide technical support to clients, Implement POS systems, and support these critical business databases across the company.High experience with Oracle E-Business Suite integration and administration, Oracle cloud ERP suite.Expertise in maintaining Database Security using auditing by creating audit trails for databases.Built DR systems using Active Data Guard for 7 critical databases.Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using "runInstaller" and "opatch utility" on databases, OMS patching.Oracle Golden Gate installation/administration for High Availability and Disaster Recovery (DR).Helped with the performance issues and tuning of some busy databases in the current project.Perform day-to-day database administration tasks tablespace management, user password management, ASM space/disk addition, privileges, grants, etc.Applied table and index partitioning to Minimize DB time, increase disk load balancing, improve query speed, and enable faster parallel query.Henkel Inc. Indianapolis, INOracle Database Administrator 03/2019 08/2021Responsibilities:Supported Postgres applications both on-prem and cloud.Used silence install to install oracle19c and created new databases manually.Worked extensively with CDB/PDB Databases including migration from non-CDB to CDB/PDB.Upgraded Multi Nodes Production RAC including QA/ DEV/TEST RAC from 10g to 11g and from 11gR2 to 12.1 and 12.1 to 12.2, from 12.1 to 19c.Had a big project of Data Centers migrating from one hardware to new hardware and upgraded RAC and Standalone Databases from 10g and 11g to 12c.Migrated 10 databases from standalone to RAC for high availability and upgraded to 12.2.Upgraded Physical Standby Databases along with Primary Databases without re-instating Standby.Created Physical Standby Databases with Data Guard Broker enabled for DR databases.Configured Active Data guard environment for reporting purposes.Switched all Database backups from TSM to Commvault and performed testing on 1G and 10G backup Network and Databases Refresh using Commvault backup with RMAN duplicate from Commvault Console.Providing Production and non-production database support as a part of daily activity.Participating in 24/7 on-call rotation for production support.Performed point-in-time recovery of the production database because of media failure.Installation, configuration, and maintenance of Oracle 11g/12c databases.Working with Databases installed on AIX 7, the latest operating system from IBM.Data Security SSL/TLS and Native encryption.Data Guard replication technology, Solving DG issues and troubleshooting performance.Dealing with various cases of Data guard failure, Async scenarios, switchover, and failover.Database tuning using AWR, ASH, ADDM, and SQL Advisor.Shell scripting to maintain database tasks, cold and hot backups housekeeping tasks, and Database refreshes.Disaster Recovery Projects and Drills.Troubleshoot different performance issues of the database, long-running SQLs, slow database, stats issues, and database tuning.Scheduled and maintained backups, cold/hot, RMAN, and OS backups.Applying SPU, PSU, and interim Patches.Space Monitoring through OEM/Cloud Control alerting and crontab jobs.Solved issues with slow-running Queries and ones with bad performance.Worked extensively with Oracle Exadata patching and maintenance.IU Health Inc., INOracle Database Administrator 11/2018 03/2019Responsibilities:Installation, configuration, upgrade, and performance tuning of Oracle RACApplied DB PSU + GI PSU using Opatch auto using rolling patching on data guard.Upgraded databases from 9i Windows to 12c on AIX.Worked with third-party vendors to re-write PL/SQL (procedures, functions & packages) for onsite applications.Create procedures, triggers, and packages for the application team.Managed movement of data between Dev, Test, UAT, and Production.Assists in the development of policies for standardizing systems, development tools, and security practices.Cloned database using RMAN and used the data pump to refresh databases.Work with Exadata machines (FULL RAC) migrations from legacy to Exadata new machines.Proficiency in analysis, design, development, testing, implementation, and maintenance of applications in Oracle Application Express (APEX) and client/server configurations.Used tools like TOAD, Grid Control and Cloud Control to monitor database performance.Research and solve with Oracle Support.Supported many databases on 10g, 11g and 12c, running on Aix and Linux, with OEM 12c for monitoring.Able to resolve the performance issue in database 12c using full database caching and In-Memory Aggregation features.Tuned database instances and applications and recommended changes to improve database performance.Created documentation to support the business and satisfy regulatory requirements.Holt Inc. Waco, TXDatabase Administrator 06/2017 11/2018Responsibilities:Supported over 70 databases (12 productions & 68 non-productions) running on Oracle 9i and 10g.Supported databases for warehouse & order management applications like Provia, JD Edwards, RedPrairie, GIS, SI, IFS, and Evavi.Installed and configured Oracle11g on OEL Linux.Set up OEM 11g on OEL Linux.Did a quarterly refresh of production schemas to dev, test, and QA.Set up a physical data guard for both test & production.Installed and configured Oracle 11 R2 Grid Control for monitoringAlso installed and configured Oracle 12c Grid Control-still under testing and evaluation.Helped coordinate and approve database changes before and during CAB meetings.Applied CPU and PSU patches to standalone and RAC databases.Worked closely with the application teams to set up data archiving from the production to the BI database.Worked with EMC to set RMAN backups on Avamar and the data domain.Set up shell scripts to clean up trace & trim files older than two weeks and backup and delete alert log files.Worked with vendors and provided them with daily AWR, ADDM, and ash reports.Setup both database auditing for Sox and PCI compliance.Worked with Offshore DBAs to support global customers.Used external tables to load from middleware to the reporting database.Acted as a liaison for security and Compliance team for database audit.EDUCATION:BSc, Information Technology Management, University of Bamenda, CameroonOracle Certified DBAAssociate of Science in Computer Science from Ivy Tech Community College, IN |
