Oracle Dba Support Resume
Troy, MI
SUMMARY:
- 5+ years of experience as an Oracle Database Administrator having hands on experience in database administration and performed different tasks like installation, configuration, upgrades, patches, performance tuning, backup and recovery, production support, cloning, space management, database security, RAC, Data Guard, Golden gate, Grid Control and Enterprise Manager using ORACLE 12c/11g/10g on Sun Solaris, Red Hat Linux, HP - UX, AIX and Windows Platform.
- Installed configured and maintained Oracle 11g Real Application Cluster (RAC) with ASM and ACFS file system.
- Migrate Teradata database to the new Linux Oracle 11g RAC and Compare table structures between Teradata and Oracle 11g RAC .
- Performed Migration and Upgrade of databases to 11g and 10g
- Up gradation of databases applying patches, patch sets and critical patch updates.
- As a DBA we use to give permissions to access the LDAP databases.
- Experience on Oracle 11g/ASM/RAC and up gradation of standalone databases to 11g RAC environment
- Configuration of Automatic Storage Management and Data Guard on RHEL, OEL and Windows
- Extensive experience with Database Cloning and Refreshing pre-prod/dev databases with prod/pre-prod databases and implementing OEM and TOAD and setup of Oracle Grid Control
- Extensive on Data Replication using Snapshot, Materialized views, import/export.
- Installation and configuration of RMAN with and without Recovery Catalog.
- Design and implementation of Backup and Recovery strategies (both cold and hot backups) and performing periodical backup, restoration and recovery using RMAN (full and incremental)
- Testing and implementing different physical and logical backup and recovery methods including point in time, media recovery, full/partial, and data pump export/import.
- Have extensive experience in RMAN, RAC, Oracle Fail Safe, Statspack, PL/SQL,C++, JAVA, UNIX shell scripting.
- Installed, configured and maintained Oracle Failsafe based on project requirements.
- Knowledge on Oracle Virtual Directory and LDAP service.
- Experience of Oracle Golden Gate installation, configuration and troubleshooting Golden Gate issues.
- Extensive experience using SQL* Loader, External Tables and Oracle Application Express for data loading.
- Detecting and diagnosing production system performance problem by analyzing STATSPACK reports, Oracle trace and log files, AWR, ADDM, analyzing SQL statements, measuring system and database activity, Querying Oracle dynamic performance views.
- Monitoring and Optimization of database performance through database tuning, system tuning and application tuning.
- Experience in advanced Oracle features such as Table partitioning, Oracle Streams (Replication).
- Experience in SQL Tuning, Optimization
- Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE.
- Proficient in INDEX REBUILDING and INDEX TUNING
- Experience on Oracle monitoring tools including Oracle Application Server monitoring and Oracle Linux monitoring using NMON and TOP commands.
- Experience working with Database Resource Management
- Working experience in creating materialized views.
- Proficient in writing PL/SQL Procedures, Functions and Triggers.
- Experience using Erwin as a Data Modeling tool & Designing the ETL processes
TECHNICAL SKILLS:
Operating Systems: OEL, Red Hat Linux RHEL 2.1, 3.x, 4.x, 5.x, 6.x HP-UX 10.x, 11.x, Sun Solaris 9.0/10.0, AIX 5.1, 5.2 and Windows 98/NT/2000/2003.
Databases: Oracle 12c/11gRAC/10gRAC/10g/9i, SQL Server 2005
Languages: SQL, PL/SQL, Java, C++, UNIX Shell Scripting
Tools: RAC, OEM Grid Control, SQL* Loader, ASM, SQL Server, Export/Import, RMAN, Goldengate, TOAD, Patch Management, ODBC, Export/Import, Data pump, Data Guard, VERITAS Net Backup, VMware, CronTab, EXADATA, Microsoft Active Directory, LDAP
EMPLOYMENT EXPERIENCE:
Confidential, Troy, MI
Oracle DBA Support
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, implementation of Oracle Database Vault.
- Administered all database objects, including tables, indexes, views, sequences, procedures, and packages.
- Implementation and configuration of Oracle Data Masking pack.
- Performed database physical redesigned from one table space to another that 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 with 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 that enhance database performance.
- Implementation of oracle advanced security.
- 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)
Confidential, Mayfield, OH
Oracle DBA Consultant
Responsibilities:
- Worked with 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 comp liance, audit trail monitoring, implementation of Oracle Database Vault.
- 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.
- Implementation and configuration of Oracle Data Masking.
- 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
Confidential, Chicago, IL
Oracle DBA Consultant
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.
- Installed configured and maintained Oracle 11g Real Application Cluster (RAC) with ASM and ACFS file system.
- Migrate Teradata database to the new Linux Oracle 11g RAC and Compare table structures between Teradata and Oracle 11g RAC.
- 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
- Implementation of oracle database firewall
- Participated in on-call and off-hours production problem resolution activities.
- Evaluated all systems for enhancements designed, developed and maintained databases that interact with 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