Oracle Database Administrator Resume

SUMMARY

Currently working at a capacity of Oracle Database Administrator/Developer
7+ years of total IT experience wif proven Analytical, Programming and Technical skills in, Database Creation, Data processing, Data Development, Testing and Production support.
5+years of experience wif Oracle Database products 10g, 11g
Expertise in oracle software installation, configuration, maintenance, performance tuning, customization and troubleshooting of Oracle 10g and 11g databases on Linux and Windows OS
Strong work experience in Oracle 11g, 10g, SQL, PL/SQL, RMAN, Real Cluster Application (RAC) and Data guard
Proficiency in creating PL/SQL procedures, Triggers
Capability in managing base metrics for performance evaluation, efficiency and effectiveness
Abilities in shell scripting, good expertise in Database Adapters
Highly skilled individual and a team player wif extraordinary multitasking ability, as well as strong communication, presentation, documentation and problem solving skills
Experience in creation and management of schemas, DDL, DML, SQL query.
Hands on experience wif Windows and UNIX
Seeking to become a part in the productivity and success of an organization.

TECHNICAL SKILLS

Language: SQL, PL/SQL

RDBMS: Oracle 10g, 11g, MS Access 2000

OS: Windows XP/2000/, UNIX, Red Hat Enterprise Linux

Applications: MS - Office me and II, MS-Works, Photoshop, Adobe, Visio, MS Project

PROFESSIONAL EXPERIENCE

Confidential

Oracle Database Administrator

Responsibilities:

Planned, designed, installed, configured, managed and troubleshoot Oracle 10g and 11g databases on Linux and Windows OS
Installed and managed Oracle database
Installed and applied several Oracle critical patches
Monitored, optimized and allocated physical data storage for database systems.
Installed and configured relevant network components to ensure database access as well as database consistency and integrity
Performed various RMAN, cold and hot backups.
Created PL/SQL procedures
Created triggers to fire before and after DML operations as needed.
Worked on PL/SQL Stored Procedures, Functions, Packages, Package bodies, and anonymous blocks
Troubleshoot and resolved various Oracle problems such as connectivity problems, backup and performance issues.
Created and managed documentation on the configuration and support of the Oracle Databases
Performed bulk load into the database using SQL Loader
Tuned a database and performed applications for faster and better performance; also performed Goal-oriented tuning as necessary.
Performed Oracle database Upgrade and Migration from Oracle 10g to 11g
Managed oracle automatic storage management (ASM)
Configured Real Application Cluster (RAC) and Data guard.

Confidential

Oracle Database Administrator

Environment: Oracle 10g, 11g, RAC, Data Guard, Toad, Red Hat Enterprise Linux

Responsibilities:

Created and manipulated tables, indexes and views.
Imported and exported objects from one Database to another
Developed, implemented and performed backup and disaster recovery strategy.
Performed import and export as needed and scheduled nightly export on each data
Maintained stored procedures, functions, triggers, packages and views used by the database instance
Provided Oracle network troubleshooting, technical and administrative duties
Applied security features to 10g and 11g database
Managed Oracle database partitioning (Range, List, Hash and Composite)
Tune SQL queries and database performance for OLTP and DSS applications wifin various environments
Developed best practices based on associated security policies, industry security standards, and audit regulations to ensure devices are appropriately secured from security breaches Resolve compliance break-fix incidents based on vulnerability testing, audits, and/or associated security monitoring systems
Performed fine grain database auditing
Developed and enforced database related policies, standards, naming conventions, operating procedures and best practices.
Developed a strategic plan for the database development dat supports the organizations operational requirements.
Administered database user accounts. create, modify and deactivate user accounts; assign and monitor user access rights