Oracle DBA Resume

SUMMARY

Oracle Certified Professional with 3+ years of IT Experience.
3+ years as Database Administrator with demonstrated expertise in installation, configuration, administration and Production Servers maintenance of Oracle 11g/10g/9i.
Expertise and interests include Database infrastructure Design, Administration, Performance Analysis, and Production Support for Large (VLDB) and Complex Databases.
Used SQLPLUS PL/SQL, RMAN utility and SQL Tuning Advisor.
Using EXPDP and IMPDP for export and import. Using SQL*Loader to load external data in database table based on requirement.
Expertise in RMAN and Oracle Backup and Recovery.
Design Relational Databases model and Implementation as per business needs.
Audited the activities for data access & security issues for production, testing and development database.
Strong knowledge in SQL, PL/SQL programming and debugging and strong UNIX, Linux Shell scripting experience.
Experience in Batch processes, Import, Export, Backup, DB Monitoring tools and Application support.
Expertise in very large Oracle databases of sizes up to 10 TB and experience in Oracle migration from 10g to 11g.
Ability to adapt quickly to changing environments.
Excellent communication and inter - personal skills.
Accustomed to work in a team environment.

TECHNICAL SKILLS

Operating Systems: UNIX, Windows 98/2000/XP, Vista.

Programming Languages: Oracle PL/ SQL, SQL, UNIX shell scripting

Databases: Oracle 11g/10g, 9i/8i, MS Access 2000/97, MS SQL Server

Case Tools: Designer 2000, Developer 2000, Toad, Ultraedit.

Reporting Tools: Oracle Business Intelligence, Oracle Reports, Cognos

ETL Tools: Informatica, Talend

Utilities: SQL Loader, Tkprof, Explain Plan, Microsoft Office

Versioning Tools: SVN, Accurev

PROFESSIONAL EXPERIENCE

Confidential

Oracle DBA

Responsibilities:

Implemented Oracle many Standalone Oracle 11g/10g/9i server as part of Agencies Data center migration.
Upgraded the database to 10.2.0.4 from 10.2.0.1 version using Patchset.
Upgrade Database from 10.2.0.4 to 11.2.0.4.
Backup and restore using RMAN utilities, Disaster Recovery testing, recovery Catalog and refreshing databases on multiple environment.
Oracle performance tuning support pack and RMAN, Oracle Universal Installer, RMAN backup and recovery strategy using incrementally updated image copy backup.
AWR report generation and wait analysis for performance.
Expdp and impdp utility for exporting database across 10g and 11g version.
Using version parameter for version compatibility. Using various other parameters for exporting and importing.
Writing SQL and PL/SQL for developmental work to support the product development team.
Using arrays in PL/SQL and bulk collect and fetch limit to optimize PL/SQL code. Working with developers to optimize SQL queries.
Using and recommending partition if requires for large tables.
Setting up materialized view for aggregate data summary.
Good Understanding of Oracle SCM development standards and guidelines
Create Oracle EBS DB

Environment: Oracle 11g/10g/9i, Win 2008/03 Oracle unbreakable Linux 5, IIS, FTP, DTS, SSIS, ASP, XSL, XML Web Services, CSS, IIS 7/6, SSRS, SSAS. RMAN, ASM, DATA

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship