ORACLE DATABASE ADMINISTRATOR Resume Loudoun, VA - Hire IT People

SUMMARY:

Confidential is a seasoned, driven, and results - oriented professional with 7+ years of diversified experience in Oracle Database Administration.
Experienced in oracle 11g and 12c as well as RAC multi-node on ASM installation, and DATA GUARD configuration.
She has excellent soft skills, effective communication, leadership, time management and ability to manage expectations whilst resolving conflicts.
Confidential is proficient in ensuring objectives are met throughout the product life cycle in an efficient and productive manner.
A quick learner of new concepts and methodologies with a thirst for improving existing skills and acquiring new ones.

SKILL:

DATABASES: Oracle 11g, 12c

OPERATING SYSTEM: Red Hat Linux 5.1, 5.4

VIRTUAL MACHINE: Oracle VM Virtualbox 4.2.6

MIGRATION TOOLS: Data Pump (impdp/expdp), IMP/EXP

INSTALLATION / UPGRADE / PATCHING TOOLS: Database Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA), OPATCH

SOFTWARE / APPLICATION TOOLS: SQL Plus, Oracle Enterprise Manager (OEM), OEM Grid, Oracle Data Guard (dgmgrl), Automatic Storage Management (ASM), SQL Developer, SQL *Loader, Data Pump, TOAD, Recovery Manager (RMAN), EXPLAIN PLAN, STATSPACK, Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), Cluster Control (crlctl), Server Control (srvrctl), Automatic Storage Management (Asmcmd), bugzilla, quality center

NETWORKING TOOLS: NECTA, NETMGR, Listener (LSNRCTL)

PROGRAMING LANGUAGES: Oracle SQL *Plus, SQL, PL/SQL UNIX/Linux Shell Script

PROFESSIONAL EXPERIENCE:

ORACLE DATABASE ADMINISTRATOR

Confidential, Loudoun, VA

Responsibilities:

24x7 Oracle Production Database Administration
Hands on experience in installing Oracle Software of different versions on various Operating Systems.
Implemented database security using Oracle Transparent Data Encryption.
Experience in installation, configuration, and deployment of Oracle Grid Infrastructure, ASM for single instance and RAC 11g/12c databases.
Installation, Configuration of Oracle Data Guard for Physical and SNAPSHOT standby mode using Data Guard broker.
Performed performance tuning by using AWR/ADDM.
Generated performance reports and Daily health check up of the database to ensure all database are working stable.
Strong experience with backup and recovery implementation using RMAN.
Good experience with Oracle enterprise manager OEM.
Able to independently work with oracle support to resolve outstanding issues.
Part of team that upgraded 11.2.0.2 database to 12c database
Perform Online and Offline database backups on schedule..
Review alert logs and dump files to check for any problems related to the database/user.
Perform database cloning/exp/imp to setup identical databases in the production and development environments.
Enforce security by creating roles, granting system and object privileges on the Tables, and stored procedures with DBA concepts.

JUNIOR ORACLE DATABASE ADMINISTRATOR

Confidential, Arlington, VA

Responsibilities:

Monitoring and optimizing the performance of the database using OEM, AWR & ADDM.
Creating Users, Roles, and Profiles and administering Database for Security.
Implemented daily RMAN backups on production databases.
Troubleshoot and resolve various Oracle connectivity problems.
Performed standard and fine grain database auditing.
Created, modified and deactivated user accounts; assign and monitor user access rights.
Managed Schema Objects.
Managed Undo Tablespaces, Redo Logs, Control files and Archive logs.
Implemented multiplexing control files and redo log files.
Extensively used DATAPUMP and Export /Import utilities for logical backups.
Applied quarterly CPU patches to different version of databases.
Configured and monitored the TNS/Listener using NetCA, NetMgr.

SOFTWARE TESTER

Confidential, Boston, MA

Responsibilities:

Analyzed the use cases given by the business analysts and developed test cases using them.
Created test cases to test Web Application.
Gathered specifications and requirements to develop test plans and to create test cases using QC.
Responsible for complete manual testing of application under test (UAT).
Maintained Test Logs and Reports in Quality Center.
Written SQL queries for data validation and to verify the extract rules.
Performed black box/functional testing, regression testing on Application under Test.
Generated functional test cases that capture actual code behavior as a deployed application is exercised.
Performed database integrity check using SQL.
Did extensive backend testing using SQL.
Executed the test suite to identify unexpected side effects.
Parameterized test cases for use with varied, controlled test input values (runtime-generated, user-defined, or from data sources).

We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

Loudoun, VA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship