Sr. Oracle Database Administrator Sample Resume Format in Word Free Download

Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download

Teresa Ifeobu                                 

Senor Database Administrator                                                          phone: 404-453-9876  teresa@yahoo.com

Tools & Experience:

·         Oracle RDBMS 8i/9i/10g/11g ( 10yrs)	·         PL/SQL & SQL*Plus (9yrs)
·         RAC (5yrs), Teradata DW   ·         UNIX scripting (10yrs) ·         Erwin (4yrs), ETL(5yrs)	·         Streams/Oracle DataGuard(5yrs) ·         ADDM, AWR, TKPOF, SQL trace (5yrs) ·         Transportable tablespaces ,SAP (3yrs)
·         DataWarehouse (6yrs) ·         Oracle RMAN (8yrs), dpimp(4yrs), exp/imp(8yrs) ·         ASM, ASMCMD (4yrs), WebLogic Server ·         Oracle Financial App. (4.5yrs) ·         Goldengate(4yrs),	·         SAN, TOAD (9yrs) ·         OEM Grid control, OSW, LTOM ·         Toad (9yrs) , OEM Grid control(5yrs) ·         SQL Server 2005/2008 (5yrs) ·         Platforms (Linux, Solaris, Windows, HP-UX, AIX)

Professional Experience

ITBF Systems Inc.                                                                                              (12/10/11 to Present) 

Sr. Oracle Database Administrator 

• Installed, upgrade and configured  Oracle Enterprise Databases 11.1 to 11.2 and  configure datagaurd 11g for DR  with two physical standby database and one logical standby database for upgrade, migrations and patch sets application
• Used OEM, AWR report, ADDM, V$view, trace files, SQL tuning Advisor, SQLplan, Alert log, tkproff, iostats, vmstat, netstat etc to handle SQL and DB performance tuning. User RMAN, dpimp/dpexp, transportable tablespaces, Oracle dataguard, goldengate, OS copy etc for managing backup and recoverys.
• Administer Unix systems and maintain appropriate security-related patches using dataguard hundres of personal command level scripts in SQL and UNIX. Kipped the database up to date on patches and supporting the roll-out of new versions
• Used Goldengate to perform a zero downtime cross platform database migration (AIX to Red Hat Linux) and also a database upgrade and patch application from 10g to 11g Release 2 using a combination of RMAN, Cross Platform Transportable Tablespace (TTS) and GoldenGate

• Provided Oracle database administrative support to ITBF. Responsible for Oracle9i/10g/11gR2 logical and physical databases design, implementation and maintenance on UNIX and Linux. .

L3 Communications Service group                                    09/2011 to 12/04/2011

Command & Control Systems and Software.

Computer Scientist/ Sr. DBA

• Installed and configured  Enterprise Management Grid control 11g R 1 (11.1.0.1) on Linux x86 with Oracle 11g R 2 RDBMS and WebLogic Server. Also install the corresponding OEM grid agents in all the 15 server having Oracle instatances including RAC.

• Used the  Standby Database wizard  to create a physical, snapshot, and logical standby                database or import an existing physical, snapshot, or logical (RAC or non-RAC) standby database. Supported  the existing Dataguard 11. Kipped the database up to date on patches and supporting the roll-out of new versions

• Used locally managed tablespace to track all extent information in the tablespace itself. This results in improved performance as it eliminates recursive operations and reliance on data dictionary.
• Performed SQL tuning by using Explain Plan and Tkprof.,AWR, ADDM reports , Making structural changes to the databases when database design changes are to be implemented.
• Implementation and maintenance of read only snapshots and snapshot logs  Migration from Oracle 10g R2 to Oracle 11R2 using Oracle Data Migration Assistant and other utility. Refreshing development/test database from production using Export/Import.

FUNDTECH Corporation

Sr. Database Administrator                      (02/26/11 to 9/28/11)

• installed Oracle 10g in four UNIX boxes. Upgraded two Solaris boxes running Oracle 9i to Oracle 10g. Also installed and maintained a box running Oracle 11g R 2. Lead the project of building, implementing and supporting Oracle DataGuard in the current 10g Oracle database server and SAP environment.
• Installed OEM grid control 11 with Oracle RDBMS 11R2 using Weblogic serverUsed OEM, AWR report, ADDM, V$view, trace files, SQL tuning Advisor , SQLplan, Alert log, tkproff, iostats,vmstat, netstat etc to handle SQL and DB performance tuning. User RMAN, dpimp/dpexp, transportable tablespaces, Oracle dataguard, Goldengate, OS copy etc for managing backup and recoverys.

·         Managed and support several oracle DB instance running in production housing high traffic online banking applications like Cashplus, Payplus, Ipayment.

·         Installed and configured 11g R2 (11.2.0.1) 3-Node RAC primary to 2-Node RAC Physical Standby DataGuard on Oracle Enterprise Linux.

·         Used Goldengate to perform a zero downtime cross platform database migration (AIX to Red Hat Linux) and also a database upgrade from 10g to 11g Release 2 using a combination of RMAN, Cross Platform Transportable Tablespace (TTS) and GoldenGate.

• Monitored & implemented  backups, reorganizations, apply patches, implement daily export and import for DR database refresh from production, upgrades, migration and other database maintenance jobs.  On-call responsibilities include 24/7 coverage.

AT&T IPTV Lab Technologies                                                                                                    (11/03/09 to 01/28/11)

Sr. Database Administrator

• Installed Oracle RDBMS 10g and 11g and .upgraded Oracle 9i to Oracle 10g using existing dataguard standby DB. Also supported the system 24x7 oncall .

·        Lead the project of  implementing and maintaining two node  Oracle 10g RAC on LINUX X86_64 RHEL 3AS Oracle database server. For Shared Storage used OCFS for Cluster Registry and Voting Disks & ASM for all other database related files

·          Used OEM, AWR report, ADDM, V$view, trace files, SQL tuning Advisor, SQLplan, Alert log, tkproff, iostats,vmstat, netstat etc to handle SQL and DB performance tuning. User RMAN, dpimp/dpexp, transportable tablespaces, Oracle dataguard, goldengate, OS copy etc for managing backup and recoverys.

• Used Goldengate to perform a zero downtime cross platform database migration (AIX to Red Hat Linux) and also a database upgrade and patch application from 10g to 11g Release 2 using a combination of RMAN, Cross Platform Transportable Tablespace (TTS) and GoldenGate
• Created Data Guard configurations that incorporate a primary database, to new or existing (physical, logical, or snapshot) standby database, redo transport services, and log apply services, Used Oracle Enterprise Manager, SQL*Plus and the Data Guard command-line interface (DGMGRL) to  manage and configure the support of  the collection of primary and standby databases, including managing switchover & failover which assist in zero downtime upgrades and migration, and patch sets application.
• Installed Oracle GoldenGate on Oracle Media Pack for Linux x86-64 on an Oracle 11g database. Configure data pump, manager, extract source and destination to tables, data from DB in AIX to DB in Linux.

McKesson Provider Technologies                                                                                              (03/06/07 to 11/01/09)

(Healthcare/Information/ Application/Clinical & Financial System)

Sr. Database Administrator

• Lead Oracle DBA.  Administer, monitor and maintain 36 Oracle databases and SAP running mostly in UNIX boxes and windows 2003 server.  Implemented and supported McKesson Meds Manager Bundle application (HMM, HCI & HCR) Also monitor and maintain 315 SQL Server databases
• Installed, configured and supported OEM grid control 10g. Install and configure oracle RAC (four nodes) in four different machines in production servers. Apply parches to upgraded the database from 9.2.0.1 to 9.2.0.7. Design, develop and test processes to extract, transform, and load (ETL) data from varying data sources to the data warehouse.
• Participated  Oracle Financial 11.0.3 to 11.5.8 upgrade with migration from HP-UX to Linux Suse 7 SLES. Upgraded and supported multi-country, multi-language 11.5.8 to 11.5.9 installation of virtually all financial and discrete manufacturing modules, including DP, ASCP, Call Center and Email Center.    
• Used Goldengate to perform a zero downtime cross platform database migration (HP-UX to Red Hat Linux) and also a database upgrade from 10g to 11g Release 2 using a combination of RMAN, Cross Platform Transportable Tablespace (TTS) and GoldenGate ases.   

• Also supported the system 24x7 oncall, Used AWR report, ADDM, V$view, trace files, SQL trace and SQLplan, Alert log, tkproff, iostats,vmstat, netstat etc to handle proactive SQL and DB performance tuning. User RMAN, dpimp/dpexp, transportable tablespaces, Oracle dataguard, goldengate, OS copy etc for managing backup and recoverys,

WellStar Health Systems                                                                                                              (12/05/06 to 03/05/07) (Information, Application, Clinical & Financial System)

Sr. Database Administrator

• Administer, monitor and maintain 28 Oracle databases running mostly in UNIX box with six databases running on windows 2003 server.  Also monitor and maintain 286 SQL Server databases running 67 different application servers. Install and configured Oracle 10gAS (on windows server 2003) clustered application server in two production boxes. implemented and supported McKesson Meds Manager bundle  application (HMM, HCI & HCR)
• Install and configure oracle RAC in four different nodes in production servers. Use Oracle Grid Control Software within Oracle Enterprise Manager 10g for automatic grid monitoring, space management, performance monitoring and alerting DBA and other System Managers.  Apply parches to upgraded the database as the system requires. Strong experience in database maintenance and UNIX scripting, Oracle Data Guard, ASM, Grid Control, and RMAN.  

• Design, develop and test processes to extract, transform, and load (ETL) data from varying data sources to the data warehouse, Design, develop and test all automated processes to facilitate the ETL, Coordinate with business analyst to ensure necessary underlying data is acquired, Coordinate Kipped the database up to date on patches and supporting the roll-out of new versions

• Revamp and incorporate business rules for fields and calculations into the new updates and upgrades. Troubleshoot Database and Web server related problems and make sure to keep the downtime to a minimum. Create new databases as needed.  Prepared complete documentation for any new upgrade/configuration, Mentor Analyst and new DBA.

Bellsouth (Accenture Business Object Team)                                                                           (06/02/05 to 12/04/06)

Sr. Database Administrator

:

• Designed and wrote ETL code using PL/SQL to extract and load large data from seven different severs into the Bellsouth data mart. Installed Oracle RDBMS 9.2.0.6 and created the test, QA and production database. Support the need of seven Business Object developer needs for creating and maintaining the Universe.
• Installed and configured Oracle Enterprise Manager Grid control, and also implemented the OEM agents in all servers housing oracle instance. Used Oracle Enterprise Manager 10g  grid monitoring, space management, performance monitoring and alerting DBA and other System Managers. Designs, implements and maintains complex databases and database dictionaries, overall monitoring of standards and procedures, and integration of systems through database design.
• Support and own database management. Works closely with Software Development Team and Systems Architects to prepare database for significant growth. Lead in planning coordination and execution of database upgrades from 9 to 10g and conversion.
• Perform backup and recovery management/Strategies using Oracle tool RMAN, dataguard, imp/exp, transportable tablespaces and third party tool Veritas Backup.
  
  

                                                                                                          

Georgia State department of Education Atlanta GA, (Contractor)                                     (08/04/04 to 05/30/05)

Oracle Database Administrator

:

• Install and configured Oracle 10gAS (on windows server 2003) clustered application server in two production boxes, Install and configure oracle RAC in four different machines in production servers. Upgraded the database from 9.2.0.4 to 9.2.0.5. Assisted in transitioning applications to cluster environment, configured and tuned the cluster database (four nodes) for better performance. 
• Installed and configured oracle database 9.2.0.4 in test machine, and later applied patch to upgrade to 9.2.0.6.   Administer and maintain two Oracle Application Server 10gAS, four GSSIS database servers, two GTID/Verification application servers, two ETL severs, two Web servers, two Cognos application Reports Servers, and Two ftp servers.
• Perform regular monitoring, tuning and maintenance of Production/test databases, Web services, forms and reports services. Troubleshoot Database and Web server related problems and make sure to keep the downtime to a minimum. Create new databases as needed.
• Prepared complete step-by-step documentation for installing RAC with OCFS in windows and installing and configuration of Oracle 10gAS cluster on two different boxes. Installed and setup OID synchronization with Microsoft Active Directory, On call for any emergency support of 24/7 .
  
  

T-mobile Wireless Atlanta, GA                                                                                                   (08/13/01 to 07/28/04)
Oracle DBA/Business Systems Analyst

• Work with AMDOCS Billing team to redesign, test, run and implement new application Fix/changes Provide production DBA activities w/24 x 7 support for Oracle database in Ensemble.  Assisted in installing, testing and implementing the Enabler system.  Perform Backup/recovery, database refresh, database performance and tuning, new database creation, reorganizations, space management, application development database support. Write SQL*Plus, PL/SQL or Perl scripts to provided full security, implement new patches, conduct Database upgrade and perform upgrades as needed..
• Installed, Developed, monitored and maintained Oracle 8i/9i database, stored procedures, functions, triggers, packages and instance. Designed data warehouse / data mart system ETL, and created  relational data objects eg  tables, views, materialized views, sequences, external  tables.
• Installed OWHB and implemented setup for Data Transformation in Oracle Warehouse Builder,  Mappings, operators,  Transformations and  Transformation Libraries

                                                                               
BellSouth Advertising & Publishing Tucker GA.                                                                   (07/20/98 to 06/30/01)
DBA /Business Systems Analyst IV

• Provided administrative supports for PEOPLESOFT 7.5 and 8 with Oracle running on HP. Upgraded the application from 7.5 to 8.0. Provided migrations of SQL and SQR patches.

·         Installed, Migrate, Upgrade, and Configure Oracle Applications 10.5 to 11 and Databases running on various platforms including Solaris, Linux and HP servers.

·         Maintaining environments including technologies like RAC, and OBIEE.

·         Implemented Oracle Application and Database refreshes/clones

·         Implemented Database/Oracle Applications Performance tuning. Used trace files, TKPROF, Explain Plan, statpack, vmstat, iostat, netstat for performance tuning.

·         Implemented Database backups and recovery using storage capabilities including Netapp, EMC, 3par and  Oracle Application Patching.

·         Coodinated and participated in  7x24 on Call DBA Support and served as  the main analyst for the AMDOCS Ensemble conversion. Managed and maintained all jobs, tables, applications relating to Billing and Obligation modules.

Tektronix Inc. Beaverton, OR                                                                                                      (05/1997 to 07/20/98)
Information Systems Engineering

Database/Application Developer

• Performed numerous Oracle Database and Tools upgrades from RDBMS version 5 through 9.1.x Performed numerous application and database tuning assignments on Oracle Applications, legacy, custom and third party systems
• Used PL/SQL and SQL*Plus to developed a major archive program that compiles all account payable information in the Oracle financial system, Maintained and managed several programs written in C++ and Pro*C used for report creation in the Oracle and Sybase databases.  
• Managed the fixed assets (FA), Payable (PA), GL, Order entry and purchasing modules of the oracle financial system, used the concurrent manager to setup oracle jobs and reports.  

Oregon State DHR/OIS ISE Salem, OR                                                                                      (01/1992 to 05/1997)

DBA /Systems Analyst

• Provide system maintenance to existing Oracle Government financial which includes Oracle Purchasing, Payable, General Ledger, Fixed Assets, and Oracle RDBMS ver. 7.0.15 running in Solaris, SEQUENT box in DYNIX/ptx (UNIX) and DB2.  Create scripts and routines using PL/SQL, UNIX, and PERL to perform administration functions. Lead the Analysis Service team to design and maintain the OLAP, data mining and Meta Data services that allow customers to view data in multidimensional. Design, develop, implement and maintained the Oregon State     Shared Information System (SIS).

Education:

Masters Degree & BS Mathematics Portland State University Portland,  OR

Diploma Programming in Mainframe, UNIX & PC CLC Los Angeles,  CA 
Oracle9i Certified Database Administrator Kennesaw State University Kennesaw,  GA.

Download Resume Format