Oracle Database Administrator Resume
5.00/5 (Submit Your Rating)
Atlanta, GA
SUMMARY:
- Around Six years of experience in the following areas: Database Administration, System Analysis and Design, Software installation and upgrade, Data Migration/Conversion and development of Oracle forms and reports. Have knowledge about Data Discovery Tracking and Management.
- This involves hands on experience in Oracle, Visual Basic and Internet related applications Tools.
- Willing to learn and adapt to new challenges, has excellent communications skills and strong interpersonal skills, which provide the ability to interact with end - users, managers, technical personnel, self-motivated, a quick learner and team player. Has excellent work ethics, and is team oriented with strong analytical and leadership qualities.
TECHNICAL SKILLS:
Hardware & software: Worked under SUN, SOLARIS, HP-UX 11i, SCO UNIX, LINUX, NT and WINDOWS on various hardware platform HP - 9000 Series, SUN 6500, C, FoxPro, Oracle Enterprise Manager, Toad, Develpoer/2000, Designer/2000, Developer 6i, SQL*PLUS, Reports, Pascal etc.
Primary Skills:
- Installation and upgrade Oracle Databases
- Worked as an Oracle DBA
- Oracle Database REORG and Database Growth Monitor.
- Performance tuning of Oracle Database
- Experience identifying latch and locks
- Used tkprof to analyze trace file
- 24*7 databases and application support
- Experience in OEM
- Used PFT
- Evaluate Statspack and AWR reports
- Experience in scripting
- Expert in writing Stored procedure, Database Triggers and Database Procedures
- SQL*LOADER and Export/Import utility
- Worked on various UNIX environments
- Worked extensively on Oracle 7.x, Oracle 8.x, Oracle 8i, Oracle 9i, Oracle 10g and 11g Databases
- Experience in database design and modeling
- Responsible for Database maintenance and Support
- Experience in SQL optimization
- Team player and excellent organizational, interpersonal and communication Skills
- Replication of Tables
- Setup, Configure and Implemented DR database
- Create Database Triggers and Procedures
- Conversion of Data using Data Junction
- Toad
Secondary Skills:
- Experiences in developing Oracle forms/reports
- Worked on Visual Basic 6.0
WORK EXPERIENCE:
Confidential, Atlanta, GA
Oracle Database Administrator
Responsibilities:
- Manage Oracle Databases
- Oracle Production Database 100 GB (iPROC,AR, FA, AP, GL, PO, ONT, INV, WSH, WIP etc.)
- Oracle Development, Test Database 100 GB
- Database administration, Installation, creation, tuning, backup and recovery
- Ensure Oracle Database and Application availability 24*7
- Apply Database patches and application patches
- UNIX System Administration activities including user maintenance, backup and restore.
- Refresh Database/Application from Production
Oracle Database Administrator
Responsibilities:
- Manage Oracle Databases
- Oracle Production Database 200 GB (AR, FA, AP, GL, PO, ONT, INV, WSH, WIP etc.)
- Oracle Development Database 200 GB
- Database administration, Installation, creation, tuning, backup and recovery
- Oracle performance tuning using TKPROF, Explain Plan, Enterprise Manager and OS utilities.
- Oracle Database conversion and upgrade
- Ensure Oracle Database and Application availability 24*7
- Apply Database patches and application patches
- Monitoring/tuning both DSS and OLTP operation
- Design and Implementation of Database backup procedures
- Databases restore procedure design and implementation
- UNIX System Administration activities including user maintenance, backup and restore.
- Refresh Database/Application from Production
- Planning and testing Disaster Recovery
Oracle Database Analyst
Responsibilities:
- Conversion voters data into Oracle Database
- Creating Tables/Indexes
- Creating Procedure/Function and Packages
- Load data into Production Database using Data Junction Tool
- Tuning SQL
- Analysis of Data
Confidential, Raleigh, North Carolina
Developer
Responsibilities:
- Functions, Procedures and packages
- Creating tables and indexes
- Create Users
