Oracle Database Administrator
Resume:
Semegne A. Tafesse
Semegne A. Tafesse
Vaughan, ON, L6A 4K7
(416) 409 – 7579
*******.*******@*****.***
Dear Sir / Madam:
I am an Oracle Certified Professional (OCP) in Oracle Database 11.2g Administration and Oracle E-Business Suite 12 Apps DBA. I also have two degrees: a B.Sc. in Computer Science (2006) from York University (www.yorku.ca – Canada), and B.Sc. in Architecture (1987) from Addis Ababa University (www.aau.edu.et – Ethiopia). I worked at RPM Technologies (www.rpmtec.com) in Toronto, a software company, as an Oracle DBA for a year in Oracle 12c, RAC, 11.2g, and 10.2g Oracle Databases. I managed more than 250 databases for Production, Development, Performance, Quality Assurance and Embedded Testing databases where the total database sizes were more than 10 TB.
I can design, install, configure, upgrade, secure, maintain, troubleshoot, patch procedures and tune databases. I have experience with different database management technologies, so I am able to perform database recovery in RMAN both cold and hot backup, RAC, ASM, purge and reorganization operations, Administering Oracle databases in Cluster ware, RAC One Node Single-Instance with ASM and ASMCA. I managed the Oracle database administrator responsibility in daily, weekly and monthly maintenance routines. I defined and organized maintain the database by tuning and preparing for production, testing databases for day to day work routine. I have worked more than 7 years in Oracle database and know how to create and manage databases using TOAD, SQLPLUS, Enterprise Manager, SQL Developer in Windows, Linux, AIX and Solaris. I assist and lead with data operations, monitoring, backup, recovery, and cloning, refreshing database from testing to production. I have the ability to collaborate, build and maintain relationships with technical groups, QA and developers. I am experienced at working with the advance features of Oracle, like, AWR, ASM, and ADDM Data Guard, Advance Security & Advance Auditing, Partitioning, Compression. I have hands-on knowledge on hot backup and cold backup, restore point flashback, including logical backup using export/import and Data pump, SQL* Loader. Thank you for your consideration. I look forward to hearing from you. Respectfully,
Semegne A. Tafesse
Page 2 of 4
Semegne A. Tafesse
112 Big Hill Crescents,
Vaughan, ON, L6A 4K7
(416) 409 – 7579
*******.*******@*****.***
PROFILE:
• Responsibilities as Database Administrator include configuration, installation and administration of the Oracle database systems and tools. Administrators develop, implement and maintain the methodology and procedure standards for the effectiveness in the access, backups and recoveries of the Oracle database. Administrators also work closely with those who deal with the actual business to understand what is required. OBJECTIVE:
• To obtain a position as an Oracle Database Administrator. EMPLOYMENT HISTORY:
• RPM Technologies (www.rpmtec.com ). Oracle Database Administrator (Oct 2014 –Oct 2015) o Built different RPM version streams with Developers and QA following Software Development Life Cycle
(SDLC) based on RPM development flow in Planning, Designing, Code Development, Testing/ QA and Implementation / Deployment standards.
o Worked on more than 250 wealth management databases for TD bank, Scotia bank, BMO, Bank of Canada, Assenti, Investment Group and CMA where each database varied in size from 450 – 650 GB in production, performance, QA, development and embedded testing databases. o Knows the Database normalization of RPM database objects. o Plan and implemented cloning, copying, backup and recovery of the Oracle database.
- Taking a hot / cold backups, Monitoring backups, Solving RMAN errors.
- Checking previous night's backup is complete, Using Recovery Manager (RMAN).
- Reviewing log files and test one of the backup to make sure the backup is done well. o Managed and modified Oracle init parameter file for database to maintain SGA and PGA memories size. o Know to set the specific init paramater for the database performance purposes. o Managed, enhanced and maintained hosts area by reviewing the of the databases log files and resize data files. o Design, install and implement development, QA and production databases. o Monitored event and alert logs to overcome the errors and warnings of Production database. o Enforces and maintains database constraints to ensure integrity of the database by solving the ORA errors. o Administers all database objects tables, clusters, indexes, views, sequences, packages and procedures. o Provide and maintain tablespaces and monitoring space usage. o Experience Data Pump and Export / Import utilities. o Duplicating Databases using RMAN.
o Creating and flashback restore point in the before and after query testing for QA. o Applying patches to database to fix QA, development and production databases and knows well RPM patches. o Define and organized in recovering database using RMAN, Data Guard and flashback. o Manage migrating Oracle database from 11.2.0.4 to 12.1.0.2 in Production, QA and other Oracle databases. o Communicate and participate in meetings for development, maintenance and production database. o Writing and maintaining Cursors and Triggers event where and when to use. o Generation of AWR, ADDM, SQLT, ASH reports for performance analysis and troubleshooting. o Giving grant for database users based on system, object and role privileges on the given management instruction. o Monitoring tablespaces for space usage and adding required space whenever it reaches threshold for better disk I/O Semegne A. Tafesse
Page 3 of 4
Semegne A. Tafesse
112 Big Hill Crescents,
Vaughan, ON, L6A 4K7
(416) 409 – 7579
*******.*******@*****.***
• Virtual Studio (www.virtualstudio.ca). Oracle Database Administrator (June 2010 – Oct 2014) o Plans and implements backup and recovery of the Oracle database. o Implements and enforces security for all of the Oracle Databases. o To Monitor Event and Alert logs to overcome the errors and warnings recorded. o Using Oracle Data Guard 11g to create and maintain one or more standby databases at the primary site and make sure the data flow to active stand by site to protect Oracle data from failures, disasters, errors, and data corruptions. o Maintain primary site that Oracle Data Guard 11g replicate by both synchronous and asynchronous configurations with Active and stand by sites.
o Create materialized views, Job scheduling of materialized views o Enforces and maintains database constraints to ensure integrity of the database. o Create new database users as required and user management o Planning and Managing Tablespaces and Monitoring Space Usage o Using Data Pump Export and Import,
• Teknion Furniture System (www.teknion.com) Oracle Database Administrator (Oct 2007 – June 2010) o Plans and implements backup and recovery of the Oracle database
- Taking a hot / cold backups, Monitoring backups, Solving RMAN errors
- Checking previous night's backup is complete, Using Recovery Manager (RMAN)
- Performing Tablespace Point-in-Time Recovery
o Administers all database objects Tables, clusters, indexes, views, sequences, packages and procedures. o Apply database and application Patches
o Database creation, run database in Archive mode
• Teknion Furniture System (www.teknion.com) AutoCAD Drafting (March 1997 – Oct 2007) o AutoCAD drafting creating 2d and 3d drawings
o Creating furniture models in Solid Works
EDUCATION:
• Oracle Certified Professional (OCP) E-Business Suite Apps DBA, Oracle University (April 2015 )
• Oracle Certified Professional (OCP) Database Administrator 11g, Oracle University (July 2014)
• Certificate on Oracle 11g: RAC and Grid Infrastructure Administration Accelerated Rel. 2 (August 2013)
• Oracle Certified Associate Oracle Database Administrator 11g (OCA), Oracle University (April 2013)
• B.Sc. Computer Science, York University working full time at Teknion ( June 2006)
• B.Sc. Architecture, Addis Ababa University (July 1987) SKILLS:
• Install, configure and test Windows 2003, 2008, Windows XP, Windows 7 and 8.
• Thorough understanding of the monitoring and tuning of Windows, AIX, Unix & Linux operating systems.
• Capable managing setup and maintenance of group and user accounts.
• Creating cron schedule to maintain RMAN, archive log files, review broken jobs and resize data files
• Able to effortlessly script Unix and Linux files, in turn reducing work load.
• Apprehensive of numerous Unixs such as Bourne shell (sh), C shell (csh),) and Korn shell (ksh).
• Maintain host area spaces by review daily, weekly and monthly log files
• Proficient in the installation, configuration and testing of Windows, Linux, Solaris, and UNIX databases.
• Efficient in the planning, designing, and implementation of Oracle databases. Semegne A. Tafesse
Page 4 of 4
Semegne A. Tafesse
112 Big Hill Crescents,
Vaughan, ON, L6A 4K7
(416) 409 – 7579
*******.*******@*****.***
Oracle 11g RAC and Grid Infrastructure Administration:
• RAC One Node Single-Instance
• Cluster-Aware Storage Solutions
• Cluster Database Management
• Single Instance–to-RAC Conversion
• Managing Backup and Recovery for RAC
• Administering Oracle Cluster ware
• Adding and Removing Cluster Nodes
• Managing ASM with ASMCA
Oracle E – Business Suite (ERP)
EBS System Administrator
• Adding users and assigning Responsibilities.
• Writing Menu, Creating Role Categories.
• Setting Up and testing Delegated Administration.
• Creating and testing Registration Process for the Role and Responsibilities.
• Defining a Descriptive Flexfield with Context-Sensitive Segment.
• Know Security Rules, Table Validation.
iStore (IBE)
• Setting up mandatory Dependencies Implementation Tasks for Oracle iStore.
• Implementing JSP files for Products, Pricing, Payment Types, and Shipping Methods.
• Setting up Sites for Catalog, Content, Carts and Orders.
• Setting Oracle Web Analytics Integration and Administrative User.
• Understand the integration of Oracle iStore to other modules like OA Framework, Configurator, Order Management and other Oracle E – Business Suites modules
• Create a Templates JSP files based on the company standard.
• knowledge of eTRM diagram for IBE in Concurrent programs like
• Understand the IBE jar files ibeeos.jar and ibetree.jar and their java classes.
• Knows the integration of XML file IbeBiStoreMgmtLink.xml and IbeBiTopActivity.xml
• Knows IBE gif files that applied on iStore and can customized based on the company images
• Customize the shopping card, header, foot and other jps files based on the company standard Oracle Configurator
• Good understanding of Oracle Configurator functionality/processes.
• Items, BOM, Model Structure, Rules, CDL, UI, Publication, Import, BOM Synchronization.
• Understanding of CZ Schema and eTRM Relation diagram.
• Good integrated knowledge in Oracle BOM Oracle Configurator and Advanced Pricing.
• Understand the CZ schema tables and their Entity Relationship model.
• Know how to access the data in the eBusiness Suite tables by writing SQL.
• Writing Procedure to lock and unlock the model.
• Create View Tables to provide groups of users access to data.
• Understand CIO API that helps to write extension for CX rules in CZ. REFERENCES:
• Available upon request
Contact this candidate