Oracle Dba Support, Resume
3.00/5 (Submit Your Rating)
Troy, Mi
PROFESSIONAL EXPERIENCE
Oracle DBA SupportConfidential, Troy, MI,
Responsibilities:
- Performed the daily checks as part of a predefined routine while supporting the database projects related activities.
- Performance monitoring and capacity planning, database installation and configuration, database backup & recovery, patch upgrades, security compliance, audit trail monitoring.
- Administered all database objects, including tables, indexes, views, sequences, procedures, and packages.
- Performed database physical redesigned from one tablespace to another dat enhance database performance.
- Supported and maintained databases instances on two nodes RAC environment on AIX.
- Researched, evaluated, test and new software and DBMS related tools and facilities as they pertain to the existing DBMS environment, database designs, procedures, and applications.
- Worked wif and train existing on - site DBAs on new technologies to coordinate any overlapping activities.
- Oracle 11g performance tuning. (Explain plan, AWR, ADDM)
- Upgraded (20) databases from 10.2.0.4.0 to 11.1.0.7
- Database physical redesigned from one table space to another dat enhance database performance.
- Applied CPU quarterly patch January 2011and April 2011 to all (60) databases in the environments.
Environment: Oracle 9i, 10g, 11gR2, RMAN, Grid Control, Platform: IBM AIX 5.3.0.0, Red Hat Linux 2.6, Windows 2003, 2008, Front-end Applications: Apex, SSO, data warehousing (informatica).
Oracle DBA ConsultantConfidential, Mayfield, OH,
Responsibilities:
- Worked wif and trained existing on-site DBAs on new technologies to coordinate any overlapping activities.
- Performance monitoring and capacity planning, database installation and configuration, database backup & recovery, patch upgrades, security compliance, audit trail monitoring.
- Administered all database objects, including tables, indexes, views, sequences, procedures, and packages.
- Installed Oracle 11gR2 Grid Infrastructure software on Windows 2008 and Red Hat Linux 2.6 and created databases for new development and production in a data warehousing environments.
- Installed and Configured of Oracle 11gR2 Grid Infrastructure RAC. Supporting and maintaining databases instances on two nodes RAC environment on Windows 2008,
- Migrated (6) Oracle 9i databases to Oracle 11gR2 to a new windows server 2008 platform,
- Migrated (5) Oracle 10.2.0.4 to Oracle 11gR2 2 nodes RAC Windows environment,
- Applied CPU quarterly patch October 2010 to all the database environments.
Environment: Oracle 9i, 10g, 11gR2, RMAN, Database Control, Grid Control, Platform: Red Hat Linux 2.6, Windows 2003, 2008, Front-end Applications: ArcSight
Oracle DBA ConsultantConfidential, Chicago, IL,
Responsibilities:
- Performed the daily checks as part of a predefined routine while supporting the database projects related activities.
- Performance monitoring and capacity planning, database installation and configuration, database backup & recovery, patch upgrades, security compliance, audit trail monitoring.
- Researched, evaluated, test and new software and DBMS related tools and facilities as they pertain to the existing DBMS environment, database designs, procedures, and applications.
- Scheduled and coordinated database maintenance activities including such items as database reorganizations and restructures.
- Installed, configured, Supported, monitored and maintained oracle 10g data guard
- Participated in on-call and off-hours production problem resolution activities.
- Evaluated all systems for enhancements designed, developed and maintained databases dat interact wif software applications.
- Administered all database objects, including tables, indexes, views, sequences, procedures, and packages.
- Database Security: account permission
- Installed Oracle 10g and 11g software on Windows and created databases for new development and production environments.
- Performed routine CPU Patch and advised in-house DBAs on scheduled server tasks regarding database auditing.
- Involved in the Design of Backup and Recovery Strategies using RMAN, and Configuring Oracle Data Guard.
Environment: Oracle 10g, 11g, RMAN, Grid Control, Platform: Solaris, Linux, Windows 2003.