Oracle Database Administrator Resume
4.00/5 (Submit Your Rating)
SUMMARY
- Proficient in Oracle 11g and 12c Database Administration
- Proficient in Enterprise Manager
- Proficient in RMAN, Backup and Recovery
- Proficient in Database Migration, Upgrade and Patch Application
- Performance Tuning
- A self - motivated, responsible and reliable team player wif a set of strong technical skills.
- Strong in solving problems of diverse scope where technical analysis and evaluation is required
- Results-driven IT personnel wif skills in team building and problem-solving wif an established reputation for effectively working wif diverse groups of people and adaptability to changing environments.
PROFESSIONAL EXPERIENCE
Confidential
Oracle Database Administrator
Responsibilities:
- Planning, installation, configuration, management and troubleshooting of Oracle 10g, 11g and 12c databases on Linux and Windows OS
- Expertise in teh creation of databases, table spaces, tables, indexes and other database objects.
- Installs and manages Oracle Enterprise Manager.
- Install and configures relevant network components to ensure database access as well as database consistency and integrity
- Troubleshoots and resolves various Oracle connectivity problems.
- Provides network troubleshooting and administrative support for teh development staff.
- Installation and management of Oracle database using database control
- Creates and manages documentation on teh configuration and support of teh Oracle databases
- Performs bulk load into teh database using SQL Loader
- Performs standard and fine grain database auditing.
- Documents database structure, changes, problems, issues for future references
- Administers database user accounts.
- Creates, modifies and deactivate user accounts
- Assigns and monitors user access rights
- Create Testing and Development databases following OFA compliance rules.
- Provide database administration on production, testing and development database servers.
- Managing Schema Objects.
- Regular Monitoring Alert log Files and trace files on Day to Day Basis.
- Identifying and removing Fragmentation, row migration/chaining of database objects.
- Analyzing teh Tables and Indexes on performance base regularly
- Monitoring Tablespaces and Datafiles utilization.
- Managing Undo Tablespaces, Redo Logs, Control files and Archive logs.
- Implemented multiplexing control files and redo log files
- Configures various RMAN parameters as per teh requirement.
- Performs physical backups using RMAN utility.
- Performs incremental backups using RMAN.
- Identify and recover teh corrupted db blocks using Block recover option in RMAN utility
- Performs Complete Media Recovery of Database depends on teh nature of failure.
- Configure and implement teh use of Oracle Recovery Manager (RMAN) for cold and hot backup to teh databases
- Extensive use of DATAPUMP and Export /Import utilities for logical backups.
- Performs database cloning and duplication using RMAN.
- Monitors teh user sessions and take appropriate action to kill teh inactive sessions
- Creates and rebuilds indexes as necessary.
- Moves data from one database to teh other using Transportable tablespace
- Performs various performance goal oriented database tuning.
- Use explain plan, AWR, ADDM and various Oracle Advisors to tune teh database.
- Created and tuned various materialized views.
- Tunes various slow running query
- Performs instance tuning, memory tuning query tuning and complete database tuning.
- Creates and implemented various table partitions for large tables
- Resolves various complex issues wif teh database.
- Applies quarterly CPU patches to different version of databases.
- Upgraded Oracle 10g database to 11g and 11g to 12c
- Upgraded Oracle 11g databases from 11.2.0.1 to 11.2.0.3 using patch set
Confidential, Edgewood MD
Product Management Intern
Responsibilities:
- Provided testing and application support for Chemical and Explosive detection products ( Confidential )
- Worked wif Product Management and teh Marketing Communications team to develop marketing collateral for teh US market
- Supported full time staff on defined projects such as data collection efforts, technical evaluations, and internal testing of products.
- Participated in teh submission of report to teh government explaining a yield issue by compiling information from several members of teh product management team, incorporating edits from several sources, and formatting teh report in a clear, concise manner.
- Performed machine testing to ensure compliance wif government regulations
