Oracle Dba

Priya Joseph

*********@*****.*** 610-***-****

*** ********* ***, **** *******, PA 19380

SUMMARY

Oracle DBA with 7 years of database & systems administration experience. Proficient in database design, implementation, Performance tuning and maintenance of database management systems across multiple platforms. Experience in Oracle RAC, ASM installation, Data Guard setup, Partitioning, RMAN backups, Database, data migration, OEM installation and Management. Have exposure in Oracle 10g, 11g,12c and adapt to demanding work culture, professional driven by challenges and committed to achieving best practices within a multifaceted environment.

SKILLS

Database Administration 10g,11g &12c

Data Guard, RAC setup and installation

Data Security, RMAN Backup & Recovery

OEM, TOAD, SQL Developer

Oracle RAC Administration/Installation

Performance tuning

Exadata

EXPERIENCE

TD Bank

Cherry Hill, NJ

Oracle 11g & 12c Database installation on RHEL 7 & AIX systems.

Setup Data Guard for HA including logical standby setup.

Patching databases on dev, QA & Production environments.

Performance tuning SQL queries and support PL/SQL for developers.

Design data modelling and data migration to other system for Compliance purpose.

Data Warehouse DB schema reverse and forward engineering the data structures.

Create / edit PLSQL statements to support performance troubleshooting for application development team.

Support databases hosted on Exadata Oracle version 19c in a multitenant architecture.

Schedule RMAN backups copy to Comm Vault storage.

Develop backup strategies with RMAN and shell scripting to schedule backups.

Ensure databases adhere to corporate standards and polices including database auditing, SOX compliance and NERC standards.

Creation of schemas, tables & objects for various databases.

Adding business & integrity rules to the Data model.

Creating tables, indexes, sequences, views, partitions, and enforcement of database integrity by creation of primary, unique and referential constraints.

Monitor Database and tablespace growth and alert when it reaches threshold limit.

Tune DB objects to avoid fragmentation of tables and indexes.

knowledge in the use of TOAD, Erwin Model Mart, and the Informatica Source and Target management

knowledge of Microsoft SQL Server tool Management Studio.

Create Unix / Linux shell scripts to schedule jobs through cron job.

EDUCATION AND TRAINING

Bachelor of Business and Accounting

St. Mary's College, India

Post Graduate Diploma in Computer Applications, India

Contact this candidate