Post Job Free

Resume

Sign in

Oracle Database Administrator

Location:
Los Angeles, CA
Salary:
As per market rate
Posted:
March 21, 2016

Contact this candidate

Resume:

Galit Golbari

act1e4@r.postjobfree.com

217-***-****

Professional Summary

Expertise in database administration, support, backup and recovery.

Basic Knowledge in Red Hat Linux system administration.

Excellent group and individual communication skills.

Highly motivated with tremendous analytical and problem solving skills.

Large bandwidth with ability to work in a fast-paced, multi-task environment.

Technical Skills

Databases: Oracle versions 11g and 12c, Microsoft SQL Server, MS Access

Operating Systems: Windows, UNIX, Red Hat Linux

Languages and Software: PL/SQL, Java, XML, C, C++, C#, SQL, T-SQL, SSMS, SSIS

Tools: SQL*Plus, SQL*Loader, Oracle Enterprise Manager (OEM), RMAN, Data Pump, Shell Scripting, SQL developer, AWR, ADDM, ASMCMD.

Experience

CCG Resources, Los Angeles, CA

(as Oracle Database Administrator )

2014 – present

Oakley- Los Angeles, CA Mar 2015- Dec 2015 (Oracle DBA)

Responsibilities:

Install, configure, manage and troubleshoot Oracle 11g databases on Linux and Windows OS.

Install and configure Oracle database software using Database Configuration Assistant.

Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g.

Create databases, tablespaces, tables, indexes and other database objects.

Administer database user accounts, create, modify and deactivate user accounts; assign and monitor user access rights.

Install and configure relevant network components to ensure database access as well as database consistency and integrity.

Troubleshoot and resolve various Oracle connectivity problems.

Create and manage documentation on the configuration and support of the Oracle databases.

Perform bulk load into the database using SQL*Loader.

Manage Schema Objects.

Monitor Alert log Files and trace files.

Used EXPORT/IMPORT to do table level defragmentation.

Analyze Tables and Indexes on performance base regularly.

Monitor the utilization of tablespaces and datafiles.

Multiplex control files and redo log files.

Perform RMAN Backup and Recovery.

Perform Flashback on Database, flashback drop, flashback table, flashback query.

Perform logical backups using DATAPUMP and Export /Import utilities.

Monitor the user sessions and take appropriate action to kill the inactive sessions.

Create and rebuild indexes as necessary.

Execute various performance goal-oriented database tuning.

Perform tuning using AWR, ADDM and various Oracle Advisors as guides to maintain high database availability and reliability.

Tune various slow running queries.

CSU (California State University)- Long Beach, CA Jul 2014 –Jan 2015

(Oracle DBA)

Responsibilities:

Database reorganizations and refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins.

Creating physical databases with multiple table spaces from logical and physical data model

Monitored and performed database sizing, tablespace management and rollback tablespace management, transaction management and security administration

Data migration between databases using both Oracle 10g and 11g export/import utility and Oracle 11g exp/imp data pump.

Experienced with all facets of Oracle DBA day-to-day activities like production, database monitoring, Backup & Recovery using RMAN, Cloning, Troubleshooting production issues, and Physical Database Design.

Extensive Experience in working with the Tools like OEM, AWR, ASH, ADDM Expdp/Impdp.

Keeping the databases up to date with respect to Latest PSU's and comfortable in applying patches.

Responsible for database maintenance, backups, recovery, patching, upgrades and performance tuning.

Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration.

Very comfortable in using ASM for creating diskgroups, adding additional storage (DISKS) and troubleshooting ASM issues.

Certifications

Oracle Certified Professional Database Administrator 11g – OCP. (2015)

Oracle Certified Associate Database Administrator 11g – OCA. (2014)

Course: Oracle Database 11g Advanced PL/SQL. (2015)

Education

Bachelor of Science, Major in Computer Science

The Open University of Israel, Israel

Graduated 10/2007

Language Skills

English (Fluent), Hebrew (Native), Spanish (Conversant), Persian (Conversant)



Contact this candidate