Oracle DBA Resume ,McLean,VA - Hire IT People

PROFESSIONAL EXPERIENCE:

Confidential, McLean, VA

Oracle DBA

Responsibilities:

Database design, from logical design, like partitioning big tables, creating necessary index, using parallel technology and normalizing the tables, to physical design, such as, datafile layout, space capacity planning.
Database development, including writing PL/SQL for stored procedures, packages, functions and triggers.
Developed 12c migration documentation for 11g and 10g databases; upgraded databases from 11g/10g to 12c in Development, Test and Production environments; troubleshooting and documented database upgrading issues. Implemented Oracle Advanced Security with Oracle Key Vault, Audit Vault.
Setup and maintained Oracle disaster recovery site using DataGuard, configured DataGuard broker;
Maintained and administered Oracle ASM, RAC and Exadata.
Performed database performance tuning by adjusting database parameters, changing join order, rewriting SQL statement, creating index and partitions, and adding enough filters to reduce high - volume transaction data processing.
Configured Fast Recovery Area (FRA); setup database backup strategies; Wrote shell scripts for RMAN incremental backup; Cloned and refreshed production databases to other environments using RMAN.
Imported and exported data from production databases to development databases and data warehouse. Used SQL*Loader to load data to database.
Developed and maintained scripts to automate problem determination, change implementation, and monitoring activities.
Developed, managed and tested recovery plans and procedures for Disaster Recovery
Provided deployment, migration, patching, installation, and upgrading support on Oracle 12c & 11g in maintenance window.
Worked with Oracle support for critical issues. Provided 24 x 7 oncall services.

Confidential, VA

Oracle DBA

Responsibilities:

Expertise in Oracle 11g/10g database administration configuration, support and performance tuning
Designed and implemented of high availability solutions with Oracle Database 11g RAC, Flashback, Golden Gate and Data Guard.
Created and modified table partition, load balancing in Oracle RAC implementation and other Oracle specified duties.
Production support for Oracle database 11g/10g ensuring flawless execution and continuous production.
Implemented Oracle database backup using RMAN
Monitored database and applications, tuned SQL queries, indexes, Oracle initialization parameters and clustered application servers.
Performed database upgrade and database migration from 10g to 11g.
Generated and analyze AWR and ADDM reports and monitor statistics for performance tuning of the database.
Working with installation, configuration & upgrade of Oracle 12c and 11g databases
Developed and created the new database objects including tables, views, index, stored procedures and functions according to business requirements.
Cloned database from production to non-production, reviewed database statistics, monitored replication, and performed space management.

Confidential, San Jose, CA

Oracle DBA

Responsibilities:

Configured and maintained Oracle 10g database.
Performed database upgrade from Oracle 9i to 10g.
Configured and monitored Oracle Streams.
Performed, developed and maintained database backup and recovery procedures using RMAN script as well as import/export.
Maintained Data Guard physical standby database.
Monitored the various database activities by developing shell scripts and using various tools.
Performed database tuning using various tools such as Statspack and Linux utilities.
Created and maintained different database entities included tablespaces, data files, redo log files, rollback segments and renaming/relocating of data files on servers.
Developed stored procedures, packages, functions and triggers using PL/SQL.
Implemented automated procedure to monitor archive log destination, database users, security and objects as well as storage and capacity planning.
Ensured that the database systems are reliable, available and functioning at peak efficiency at all times
Checked alert and log files on daily bases
Managed and maintained multiple 24x7 production databases
Developed the technical documentations to support the use and operation of the database system
Provided suggestions to network team regarding disk configuration and RAID level according to database storage capacity planning
Planned and co-coordinated database security measures. Administrated user accounts, user profiles and tablespaces etc.

We provide IT Staff Augmentation Services!

Oracle Dba Resume

Mclean, VA

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship