Oracle Dba Resume
4.00/5 (Submit Your Rating)
Knoxville, TN
SUMMARY:
- Having experienced and motivated Oracle DBA with Oracle Core DBA accomplished in delivering Administration, Design and Developing Applications, performance tuning, installation, support, upgrade & migration of multiple database versions, backup and recovery.
- Over 7 years of experience in as an Oracle Database Admin (11g/10g/ 9i) in Production and Development environment. Worked in 24x7 production environment and provided on - call and day-to-day support.
- Experience in configuring and managing 7-node RAC database and used ASMCMD command-line utility to manage ASM disk groups, administering ASM storage by adding Disks to the Disk groups
- Experience in installing and managing Golden Gate on stand-alone and on multi-node RAC, upgrading Golden Gate software from 9.5 to 10.4, 10.4 to 11.1 and 11.1 to 11.2
- Experienced as an Oracle Applications DBA in Production Support, Handled System admin and DBA tasks - Concurrent Managers, Profiles, Custom Module deployment and Installation, Patching, Cloning and Upgradations
- Oracle Apps DBA R12/11i (11.5.10.2, 11.5.9) administration, New Design, Upgrades, migration, regular maintained activities, Worked on Oracle Applications Database upgrade from 11.5.9 to 11.5.10.2 and 11.5.10.2 t o R12 and on R12.1.1 to R12.1.3 (Applied AD Patch to upgrade patch level from R12.AD.B.1 to R12.AD.B.3 and RUP patch for enhancement to R12.1.3).
- Successfully upgraded from Oracle 9i to 10g and 10g to 11g can support smooth and accurate conversions from legacy Oracle (other database upon assessment) to the latest release of Oracle. Also, applied time to time Oracle Patches to the existing Production, development and test environment databases
- Proficiency in Programming Languages PL/SQL and Shell Scripting. Installing RPM’s and Hands on LINUX/UNIX Systems and Scheduling jobs using Crontab.
- I’m an adaptable and efficient team player with excellent communication skills at all levels. I’m looking for a role where I can develop my skills further, researching new technologies and reveling in new challenges.
TECHNICAL SKILLS:
- Involved in creation of Databases in LINUX and Windows Platforms.
- Creating and managing table spaces, tables and indexes.
- Involved in Oracle Migration from 9i to Oracle 11g Databases (9.2.0, 10.2.0 & 11.2.0).
- Strong knowledge in administration of database monitoring.
- Basic Knowledge in data guard (physical standby, switchover, fail over)
- Creation of database using manual and DBCA and maintain system and user table spaces
- Database backup using user managed (cold and hot backup) and RMAN(Incremental backup)
- Restoring and Recovering the database both manual and RMAN
- Database cloning using Manual and RMAN.
- Performance checking the databases by using the OEM,.
- Performing database backup by EXP/IMP utility.
- Upgrade from Oracle 9i to 10g both manual and automatic (using DBUA) (On Oracle Enterprise Linux 32 bit and 64 bit).
- Configuring FRA and flash backing Database
- Basic knowledge in PL / SQL
- Virtualization Technologies:
- VMware, Oracle Virtual Machine
- Tools:
- Oracle Enterprise Manager (OEM), Oracle 11g, SQL
PROFESSIONAL EXPERIENCE:
Confidential, Knoxville, TN
Oracle DBA
Responsibilities:
- Responsible in upgrading RAC and Stand-alone databases from 11.1.0.7 to 11.2.0.3 and 10.2.0 to 11.2.0.3.
- Backup and Recovery issues related (loss of OCR, Voting Disk and Oracle clusterware) & also issues with corruption of individual disk data blocks, loss of OS configuration files, loss of net configuration files.
- Evaluated and implemented new technologies. Deployed and maintained 50+ servers that include VMware, Microsoft and Unix platforms
- Responsible in leading the project and writing shell scripts to automate the process of upgrading Golden Gate from 11.1.1.1.1 to 11.2.1.0.14
- Refreshed/instantiated Physical standby database using advanced 11gR2 features like Active Database Duplication (ADD) from stand-alone to 2-node RAC and vice-versa.
- Used extensively Flashback’s feature of Guaranteed Restore point on standby-database to perform large sized data-exports to not disturb the Primary database and placed the database back to Standby mode
- Responsible in performing Dataguard Switch-over and Switch-back exercises during the maintenance window.
- Responsible in leading the project and writing shell scripts to automate the process of upgrading Golden Gate from 11.1.1.1.1 to 11.2.1.0.14 .
- Wrote shell scripts to automate the process of monitor file-system usage, switching Archive log destination, database monitoring etc
- Performed logical backup using export and import utilities. Creating tablespaces, tables, views, scripts for automatic operations of the database activities .
- Performing the daily tasks of a DBA including alert logs, backups, space management and health check of the databases .
- Designing Tables, Constraints, Views, and Indexes etc. in coordination with the application development team.
Environment: Oracle 10g, 11g, SQL, Oracle Grid Control, Oracle Enterprise Manager Database Control, TOAD, SQL Developer, SQL*Loader, NT, Red Hat Enterprise Linux, ASM, Golden gate, RAC, RMAN, AWR, ADDM, ASH, TTS, Data pumps, Exports/Imports.
Confidential, Columbus, OHOracle DBA
Responsibilities:
- Oracle Applications 11i/R12 Maintenance, Patching, Performance tunings Apps Development and Database Support & Maintenance.
- Oracle Apps on AD utilities.
- Applied patches (One-off, Mini-patch, Rollup Patch, CPU) and performing AD activities and Trouble shooter several worker issues and used default files to reduce patch timelines.
- Resolve the view log/out files issue of concurrent requests, TAR support, database tuning, CM administration
- Monitoring tablespace free spaces, re-sizing datafiles, Alert log trace files.
- Responsible for cold/hot and rman backups.
- Cloning Oracle RAC Applications R12 from production RAC to uat RAC & NON-RAC environment.
- Cloning Oracle Applications 11.5.9, 11.5.10.2 from production to uat NON-RAC environment.
- Oracle 9i and 10g 2-Node and 3-Node RAC installation and configuration.
- Oracle Clusterware installation and database upgradation from 9i RAC to 10g RAC.
- Good exposure of using Oracle performance tools like AWR/ADDM, STATSPACK, Explain plan, TKPROF, SQL Trace, ANALYZE Indexes Opatch.
- Performance analysis of different database objects. Development of the front-end functionality
- Create various Stored Procedures and Database triggers. Monitoring the Tablespaces Usage and Indexes usage regularly.
- Storage management, sizing the database objects, monitoring Disk usage. Monitoring the Backup Status. (Exports, Cold Backup, Hot Backup).
- Debugging the bugs in SQL using toad and troubleshooting end users problems. Migrating data using Import and Export utilities.
- Creating RMAN backup, recovery catalog. Gathering Statistics by using Stats pack.
- Loading data using SQLLDR from flat files.
Environment: Oracle Applications 11i/R12, Oracle 9i, 10g, 11g, RHEL 4.2, SQL, Windows 2003 with active directory, PL/SQL, OEM, TOAD, SQL Developer, SQL*Loader, NT, ASM.
Confidential, EthiopiaSystem Analyst
Responsibilities:
- Responsible for newer system set up across the branches of Wegagen bank (over 31 branches are networked across the country). Trouble shooting in exiting system; generate recommendation for efficient utilization of the system; monitoring of suspected loopholes from fraud and mismanagement in the bank, educate end users, work as an intermediator or bridge between software developers and end users, etc.
Internal Auditor
Responsibilities:
- Responsible for scrutinizing the daily income and expense transactions; preparing and sending monthly and special reports to the control department; overseeing customer complaints; ensuring proper custody of negotiable instruments and security documents; checking interbank deposit tickets against respective interbank debit and credit; checking daily positing activities to subsidiaries and control legers; checking long outstanding items in sundry debtors and creditors; checking payrolls; etc.
Teller/Pay Master
Responsibilities:
- Responsible for coordinating a Confidential; paying cashes (teller); arranging cash consignments; verification of payments; controlling of petty and volt cash; and preparation of periodic financial statement.
Account Clerk/Personal Banker
Responsibilities:
- Responsible for opening and amending Account for new and existing customers; preparation and verification of payments; preparation of letters and periodic reports to respective departments/clients; handling customer services; updating clients’ accounts on the computer database; reconciliation of interbank payments; etc.