SUPER RESUME
< Back
Edit this resume to make it your own!

Your Name

Oracle Database Administrator

Baltimore, MD

your.email@example.com
111-222-3333
www.your-website.com

Summary

Over 8+ years of experience in IT Industry as an Oracle DBA.
Installed and configured Oracle Server 10g, 11g standalones and RAC software on UNIX and Linux platforms.
Configured, implemented 10GR2@ RAC with ASM disk on Linux servers
Duties also included database creation, database tuning/reorganization, SQL statement tuning,
Backup/recovery, general troubleshooting, script development, documentation and end user training.
Established best practices and best procedures for database administration
Manage Backup and Recovery Program for all Oracle Databases Install, implement and configure
RMAN Oversee, improve and implement scripts, processes, emergency procedures and testing of all RMAN operations.
Experience with Oracle RMAN and Veritas Net Backup.
Prepared documentation of Database Operations Standards and Database Backup and Recovery
Experience as a Database Administrator for Oracle 7/8i/9i, 10g, 11g under UNIX, Windows NT
Extensive experience in business analysis, design, development, testing and implementation of Oracle 8i/9i/10g Client/Server Application Development
Proficient in SQL, PL/SQL, database objects like Stored Procedures, Triggers and Packages
Managing Database Structure, Storage Allocation, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
Implemented table partitioning to improve performance and data management
Taking Logical Backups with Export/Import and Data Pump (10g)
Expertise in migration/ up gradation of oracle databases (from 9i
  • 10g
Migrated database from Oracle 10.2.0.1 (32 Bit) to Oracle 10.2.0.4 (64 Bit) on windows 2003.
Expertise in configuring Data Guard (9i, 10g) - Physical standby.
Installed and configured Oracle Internet Directory (OID) for service name resolution and setup one way replication.
Experience with Oracle Streams for 10g.
Database Tuning - Tuning Applications, Tuning Memory, and Tuning Disk Usage
Performance tuning of SQL queries and advising the application programmer of the opportunities in tuning the application.
Strong Troubleshooting, Problem solving, Analytical & Design Skills
Excellent communication and problem solving skills

Work Experience

DG broker

STATE OF NJMVC TRENTON-NJ, HP, IN

Aug 2010Current

8/10- Present
  • Installed and configured Oracle 11GR2 RAC software on AIX 6.
  • Created Database single instance and Cluster databases on AIX 6.
  • Setting up Dataguard/Physical standby for a primary RAC database using DG broker.
  • Performing database refreshes using datapump
  • Migrated several Rac systems to ASM.
  • Upgraded databases from RAC databases from 11201 to 11202.
  • Setup RMAN solutions for all Oracle Databases -- created rman repository, wrote scripts for backup, integrated rman with OEM GRID, provided best practices, optimizations and data guard and cloning techniques -- restore and recovery.
  • Implement OEM 11g Grid based monitoring solution.
  • Performs regular reviews of the Database environment.
  • Planning, preparing and executing quaterly PSU patch implementation procedures.
  • Defining and recommending standards and/or naming conventions.
  • Tuned and optimized SQL Query, SGA, and Disk I/O using GRID CONTROL.

Environment: AIX 6 & 5, Oracle 11GR2 RAC, ASM, RMAN, OEM Grid.

Oracle Database Administrator

ACXIOM CORPORATION, Conway, AR

Jan 2010Aug 2010

Installed and configured Oracle (10g, 11g) RAC on RHEL 4/5 servers.
  • Created RAC databases using DBCA (GUI), silent mode, Manual scipts.
  • Migrated Terabytes of RAC/standalone databases from one data centre to another.
  • Reconfigured OCR as part of datacenter migration for many RAC systems.
  • Migrated several Rac systems to ASM.
  • Moved terabytes of database (ASM) from old SAN to new SAN frames.
  • Configured/scheduled RMAN backups for the newly created databases as well as for existing ones.
  • Tested and performed all kinds of backup and recovery strategies.
  • Installed/configured 10.2.0.5 OEM Grid Control on linux.
  • Upgraded existing grid control environment to 10205 from 10201.
  • Building up new environments on demand from Application teams.
  • Application Schema installation and deployments.
  • Involved in User Management, creation, monitoring and management of database users, altering passwords of users and granting and revoking System/object privileges, roles, auditing user actions in the database
  • Monitoring data files, archive log files space issues.
  • Added, maintained and dropped database schema objects.
  • Implemented database backups and disaster recovery strategies using RMAN.
  • Refreshing QA/ISE/STAGING environments on a regular basis using EXPDP
  • Database instance tuning such as tuning memory allocation, tuning I/O, tuning contention, tuning related to sorts and free lists and check points.
  • Improved the overall database by re-setting some of the key database parameters.
  • EXPLAIN PLAN AWR reports and ADDM reports for analyzing database performance.
  • Set trace session, get EXPLAIN PLAN and run TKPROF on trace file to identify SQL problems.
  • Perform general DBA tasks, such as user privileges, monitor space usage, set up database performance alerts and trouble shoot database related issues.
  • Utilized Oracle Streams to capture, propagate, and apply the transfer of data, transactions, and events within managed databases from legacy server to production server using Oracle Stream.
  • Configured physical standby database (Data guard) using RMAN.
  • Managed dataguard using dataguard broker.
  • Apply CPU patches/Interim patches on Test, UAT, DEV and PROD Databases.
  • Support application team to solve any issues in Production Environment.
  • 24x7 production support DBA working on a primary/ secondary pager rotation; and supported on holidays, weekends and beyond regular hours.

Environment: HP 11.1, RHEL AS4, RHEL AS5, Oracle 9i, 10g RAC, 11g RAC, RMAN, 10g OEM Grid, Serviceguard.

Oracle Database Administrator

State of New Jersey Dept of Human Services, Princeton, NJ

Mar 2008Jan 2010

Installed and configured Oracle (10g, 11g) RAC on UNIX.
  • Created RAC Databases, single instance databases on UNIX using DBCA/Manual method.
  • Administration of RAC databases and clusterware using SRVCTL, CRSCTL tools.
  • Involved in implementation of 10g GRID and GRID CONTROL agent.
  • Involved in the project of implementing and configuring Real Application Clusters (RAC) on Oracle 10g/11g.
  • Upgraded Databases from 9i (9.2.0.8) to 11g, 10g (10.2.0.4) to 11g (11.1.6) using DBUA, manual upgrade Process.
  • Cloning databases using manual process as well as using RMAN.
  • Configured physical standby database (Data guard) using RMAN.
  • Successfully configured the databases to switchover, failover and fallback scenarios.
  • Involved in User Management, creation, monitoring and management of database users, altering passwords of users and granting and revoking System/object privileges, roles, auditing user actions in the database
  • Monitoring data files, archive log files space issues.
  • Added, maintained and dropped database schema objects.
  • Building up new environment on demand from application teams.
  • Implemented database backups and disaster recovery strategies using RMAN.
  • Created Recovery catalog databases, Cataloged user managed backups into RMAN.
  • Performed Logical backup of data at schema level (Application Schema) using data pump (EXPD/IMPDP)
  • Database instance tuning such as tuning memory allocation, tuning I/O, tuning contention, tuning related to sorts and free lists and check points.
  • Improved the overall database by re-setting some of the key database parameters.
  • EXPLAIN PLAN AWR reports and ADDM reports for analyzing database performance.
  • Set trace session, get EXPLAIN PLAN and run TKPROF on trace file to identify SQL problems.
  • Perform general DBA tasks, such as user privileges, monitor space usage, set up database performance alerts and trouble shoot database related issues.
  • Utilized Oracle Streams to capture, propagate, and apply the transfer of data, transactions, and events within managed databases from legacy server to production server using Oracle Stream.
  • Apply CPU patches/Interim patches on Test, UAT, DEV and PROD Databases.
  • Support application team to solve any issues in Production Environment.
  • 24x7 production support DBA working on a primary/ secondary pager rotation; and supported on holidays, weekends and beyond regular hours.

Environment: AIX 5.3, Oracle 9i, and 10g RAC, 11g, RMAN, 10g OEM Grid, Streams.

Oracle Database Administrator

Kintetsu World Express (KGIT), Dallas, TX

Oct 2007Mar 2008

Oracle Software/Client Installation (9i & 10g) on HP-UX/Linux.
  • Configured, implemented 10GR@ RAC with ASM disk on Linux servers on a 2- Node Cluster.
  • Created Physical Databases (dataguard) as per the requirements and specifics tailored to the customer needs.
  • Performing Database Upgrade (from 8.1.7.4 to 10.2.0.3, 9.2.0.6 to 10.2.0.3, and 9.2.0.6 to 9.2.0.8)
  • Assists in planning and providing the migration of Oracle databases to a new release/version of Oracle.
  • Implemented security patches and checking whether there is any affect of Day Light Saving 2007 and applied patches where ever applicable.
  • Performing Backups and Restore/Recovery Procedures on all of DEV/TST/PRD databases using RMAN.
  • Implemented new features of Oracle 10g like ASM, Flashback Recovery area, Flashback database..Etc
  • Refreshing environments (DEV/UIT/SYT) using Datapump (EXPDP/IMPDP)
  • Implemented Data Guard-Physical Standby database for fail over situations.
  • Installed and configured Oracle Internet Directory (OID) for service name resolution and setup one way replication.
  • Monitoring Night Jobs, Resolving Performance issues/troubleshooting.
  • Setup Basic Replication using Materialized views for replicating data.
  • Set trace for a session (DBMS_MONITOR), get EXPLAIN PLAN and run TKPROF on trace file to identify SQL problems.
  • Tuned and optimized SQL Query, SGA, and Disk I/O using Oracle Enterprise Manager and by monitoring the AWR Report generated from snapshots taken at the peak business hours.
  • Perform general DBA tasks, such as user privileges, monitor space usage, set up database performance alerts and trouble shoot database related issues.
  • Improve application run time by building optimal indexes, gathering object statistics, analyze objects and using parallel query.
  • Monitoring Database alert log, Process log, and Trace.
  • Database refreshes, environment configurations, and troubleshooting.
  • Provide *x* on-call support for OLTP database and disaster recovery support. Provide assistance and guidance to Application Services, Operations, System Support, and other business partners as needed.

Environment: HP UNIX 11.1v, Linux Red Hat, Oracle 8i, Oracle 9i, and 10g, OEM, Grid Control.

Oracle Database Administrator

Hewlett-Packard, Houston, TX

Nov 2006Oct 2007

Installed and configured Oracle 10g RAC software.
  • Created Database single instance and Cluster databases on HPUX 11.2 (PARISC)
  • Installed OEM Grid Control agents on Multiple Nodes.
  • Added targets (instance) for monitoring in OEM Grid Control.
  • Database refreshes, environment configurations, and troubleshooting.
  • Migrated databases from legacy systems running on different operating systems to HPUX (PARISC/ITANIUM) using export/import and by building physical standbys for terabytes of databases migrations.
  • Troubleshooting issues for Application Teams after Migrations.
  • Upgraded Databases from 9i to 10g using DBUA, manual upgrades.
  • Migrated database from Oracle 10.2.0.1 (32 Bit) to Oracle 10.2.0.4 (64 Bit) on windows 2003.
  • Cloned databases using RMAN.
  • Capacity management using Capman tool.
  • Configured standby's (Dataguard) using RMAN.
  • Oracle Networking Tnsnames, Oracle Names using NETCA.
  • Managing users and resources, controlling user privileges and roles and auditing database use.
  • Developed backup and recovery policy. Experienced in taking open, closed and logical backups.
  • Used Recovery Manager (RMAN) to take full and differential incremental or cumulative incremental backups by registering databases in recovery catalog.
  • Performed Logical backup of critical application databases using EXPDP/IMPDP with a scheduled job (CronJob)
  • Database instance tuning such as tuning memory allocation, tuning I/O, tuning contention, tuning related to sorts and free lists and check points.
  • Improved the overall database by re-setting some of the key database parameters.
  • Reorganized the database tables to improve report generation time.
  • Used DBMS_STATS for gathering Database/Schema/Objects statistics.
  • Generated AWR reports and STATSPACK reports for analyzing database performance.
  • Set trace session, get EXPLAIN PLAN and run TKPROF on trace file to identify SQL problems.
  • Performance tuning of SQL queries and advising the application programmer of the opportunities in tuning the application.
  • Perform general DBA tasks, such as user privileges, monitor space usage, set up database performance alerts and trouble shoot database related issues.
  • Improve application run time by building optimal indexes, gathering object statistics, analyze objects and using parallel query.
  • Monitoring Database alert log, Process log, and Trace.
  • Implemented table partitioning to improve performance and data management
  • Handled various Database administration tasks like monitoring database alerts, resources, security and tuning
  • Generated reports using Sql Server Reporting Services for different subjects.
  • Resolving database storage management issues
  • Handled databases up to 2TB.
  • Communicating with Oracle for SR and providing solutions.

Environment: HP UNIX 11.2v, Windows NT 5.0/ 2000, Oracle 9i, and 10g, Sql server 2000 RMAN, Grid Control.

Oracle Database Administrator

AstraZeneca Pharmaceuticals, Wilmington, DE

Aug 2006Nov 2006

Installed and configured Oracle 10g, 9i, 8i.
  • Tablespaces and DataFile allocation and management.
  • Managing schema objects and rollback segments.
  • Database security such as establishing security policies.
  • Managing users and resources, controlling user privileges, roles and auditing database use.
  • Experienced in taking Hot, cold backups with and without RMAN.
  • Demonstrated benefits of using RMAN for backup and recovery.
  • Experience with Oracle RMAN and Veritas Net Backup.
  • Performed Logical backups at schema level using Export/Import and datapump.
  • Database instance tuning such as tuning memory allocation, tuning I/O, tuning contention, tuning related to sorts and free lists and check points.
  • Reorganized the database tables to improve report generation time.
  • Database monitoring using OEM. Application and database tuning using estat bstat, statspack, AWR.
  • Set trace session, get explain plan and run TKPROF on trace file to identify SQL problems.
  • Improve application run time by building optimal indexes, gathering object statistics, analyze objects and using parallel query.
  • Database refreshes, environment configurations, and troubleshooting.
  • Performed several rollback to undo and dictionary to local extent management tablespace conversions.
  • Troubleshot database errors, warnings, and failed jobs to greatly reduce potential database downtime, and ensure database recoverability
  • Monitoring Database alert log, Process log, and Trace.
  • Resolving database storage management issues
  • Applied patches to upgrade oracle 8.1.7 for fixing bug issues.
  • Provided all kinds of DBA support to development teams as well as production support to various applications.

Environment: UNIX Sun OS 5.6/ HP UNIX 11.11, Windows NT 5.0/ 2000, Oracle9i, 10g, RMAN, OEM, Reflection, Toad, Peoplesoft 8.3, Veritas Netbackup, dataguard

Database Administrator

Coat Factory, Burlington, NJ

Jun 2005Aug 2006

Maintaining over 100 databases running on UNIX and Windows NT/2000 machines (Production, Development and Testing)
  • Installed, configured and maintained Oracle 10g Real Application Cluster (RAC)
  • Responsible for database creation and configuration manually and using Oracle database configuration assistant (DBCA)
  • Creation, configuration of Databases, laying out database tables and Database schema design, startup and shutdown of Databases, setting
  • "init.ora" parameters, maintaining Data Files, Control Files, Redo Log Files,
  • Managing Tablespaces, segments, extents, indexes and performing management of Undo Data
  • Worked on Testing of Database for user acceptance
  • Worked on Migration of Oracle Database from Oracle 9i to Oracle10g (Manual) and from Oracle 8i to 9i using DBUA
  • Involved in User Management, creation, monitoring and management of database users, altering passwords of users and granting and revoking System/object privileges, roles, auditing user actions in the database
  • Monitoring data files, archive log files space issues.
  • Managing Oracle Net Configuration, monitoring Alert Log Files, Listener Log, Redo Log status, rollback segments and trace files for the Database and analyzing STATSPACK Report at regular intervals to ensure good database performance
  • Support the Oracle Database activities in UNIX environment for the application.
  • Dataguard- Physical Standby implementation in ORACLE9i
  • Implementing backup scripts for both hot and cold backup, and testing recovery scenarios
  • Performed Database recoveries like complete/Incomplete recovery, datafile, tablespace point in time recovery (TSPITR) using RMAN and user managed.
  • Worked in a RAC environment setting up RAC In a 2-NODE Linux Cluster.
  • Experience with CRS, ASM in setting up clustering.
  • Worked both as a 24*7 Production DBA and Development DBA

Environment: Oracle 19i/10g RAC, LINUX SuSe 9 (x86), Sun Solaris 5.9, RMAN, OEM.

Database Administrator

DOEA, Tallahassee, FL

Apr 2004May 2005

Installed and maintained Oracle 9i on Solaris systems
  • Monitoring of hot backups, exports on both UNIX and Windows
  • Performed refreshes of databases on UNIX servers
  • Create Schema (Tables, Indexes, views, sequences, synonyms, roles, and packages), grant roles to users.
  • Monitor databases using OEM, reorganization of database tables and indexes, etc
  • Tested and Implemented different physical and logical Backup and Recovery methods like point in time, Media recovery, Full/partial export/import.
  • Partitioned appropriate tables to optimize performance and simplified maintenance work.
  • Write various PL/SQL scripts and procedures to support applications
  • Set up and administered table spaces, data files, tables, indexes, views and sequences Configured and managed users, security and redo logs
  • Performed database Cloning to create Test and Development environments from Production.
  • Dataguard- Physical Standby implementation in ORACLE9i/10g.
  • Performance tuning for Oracle Day-to-day maintenance and management of the several different databases in development, test, regression and production environments; proactively monitoring production environment for any exceptions/ issues.
  • Have written shell scripts for automation of various database-monitoring activities.
  • Participated in on call rotation 24x7

Environment: Oracle 10g, 8i, 9i, SQL, PL/SQL, Win NT/Unix, Sun - Solaris, PVCS, TOAD

Jr.Oracle DBA

CAT Technologies, Hyderabad, Andhra Pradesh

Jan 2002Mar 2004

Oracle Installation, patch application, migration of databases to newer releases of Oracle
  • Monitored server disk space, database performance, replication, backups and scheduled tasks.
  • Production and Development support for an Oracle 8i database.
  • Created and managed an Oracle 8i database/instance and rollback segments.
  • Set up and administered table spaces, data files, tables, indexes, views and sequences.
  • Configured and managed users, security and redo logs.
  • Performed backup and recovery for both hot and cold backups without using RMAN.
  • Creating primary database objects such as tables, views, sequences, triggers, and indexes.
  • Daily monitoring and optimizing the performance of the database to ensure that database resource such as tablespaces, memory configuration, sessions, archive files, etc, are in their proper status.
  • Performing backup and recovery procedures to include exporting and importing of the database.
  • Performed full, tablespace and datafile recoveries with the database open and closed.
  • Creating user accounts and appropriate privileges as well as maintaining database security.
  • Modifying the database structure, as necessary, to support activities of application developers.
  • Created Database storage structures Data Tablespace, Index Tablespace
  • Created/Altered/Modified database objects.
  • Performed Physical backup (hot and cold) as well as Logical backup (Export/Import)
Proactively managed the databases; set up alarms for managing any exceptions in day to day management of the databases; pre-empted and prevented issues disasters from happening.

Environment: Oracle 8i/9i, SQL, PL/SQL, Win NT/Unix, Sun Solaris, PVCS, Toad

Additional Information

Technical Skills: 
 
Languages SQL, PL/SQL, C, C++, PRO C* 
RDBMS Oracle 7x, 8.0, 8i 9i, 10g, 11g, Sql Server 2000, 2005, SQL SERVER Reporting Services (SSRS) 
UNIX Sun Solaris (2.4, 2.5, 2.6, 2.8), Win NT/ 2000, MS-DOS, LINUX SuSe 9 (x86), RHEL 4, Sun Solaris 
Tools SQL*plus, Toad, PL/SQL Developer, 10gGrid Control (OEM), Streams, Rational Tools, Remedy AR Tool. HP OpenView
Resume Builder | Resume Templates | Resume Examples | About Us | Privacy Policy | Terms of Use | Help Articles | Contact Us
Super-Resume.com © 2013-2017