Oracle Dba Resume
Adrian, MI
SUMMARY
- Over 4+ Years of total Oracle Database Administration experience in implementing, Design, Development, Testing and Production support in all industry verticals exclusively Telecom, Financial, Pharmaceutical, Insurance Industries.
- Participated in planning and implementation of off - site Disaster-Recovery planning and testing
- Worked with development and operations staff in resolving problems quickly and efficiently
- Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g, 10g RAC servers for the purpose of disaster recovery procedures.
- Expertise in using oracle Export/import, Datapump utility to migrate data across schemas.
- Experience in managing large Oracle databases (VLDB) which includes OLTP as well as DW databases.
- Able to resolve the performance issue in database 12c using automatic big data caching, full database caching and In-Memory Aggregation features.
- Hand on experience in cloning the non-multitenant container database to pluggable database in 12c using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot Cloning feature.
- Excellent knowledge in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.
- Experienced in using 11g features Data pump, AWR, ASM, ADDM, Grid Monitoring, and Oracle
- Enterprise Manager. Installation, administration and maintenance of Oracle 11g
- Designed and tested Backup solutions using RMAN and NetApp Snapshots/Flex Clones.
- Tuned Oracle databases, application programs and operating system.
- Worked closely with diverse application development groups and served as single point of contact for testing, tuning and implementing projects / solutions in production environment
- Cloned and maintained multiple Oracle Database environments for Development, Testing & UAT.
- Carried out migrations between different environments including production using STAT / Manually.
- Carried out yearly DR Testing of Oracle ERP Systems / Critical Oracle Databases.
- Applied various database / applications PSU / CPU patches as required. Also applied monthly vertex updates..
- Team player with excellent interpersonal, analytical and communications skills
- Experience in using OEM, TOAD, SQL Developer and performing data migrations using Export/Import utility.
- Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN, TKPROF, STATSPACK, SQLTRACE, 11gOEM Grid Monitoring custom scripts troubleshooting oracle databases using sqltrace utilities.
- Strong experience in configuration of RMAN, Planning and scheduling Backups using CRONTAB.
- Configured Oracle on different Operating Systems for OLTP & Data Warehousing environments.
- Implementation of high availability solutions with Oracle 11g RAC, Physical and Logical Standby database (Data Guard), Materialized views, VCS, Streams Replication, Golden Gate.
- Experienced in Oracle Support processes for technical requests through Oracle and other Support.
- Excellent communication and interpersonal skills. Highly motivated with strong commitment to quality and customer service Extensive experience in 7*24 production database support.
- Expert in systems analysis and architecture, capacity planning, backup/recovery, installation, configuration, apply patches, troubleshooting, performance monitoring and tuning.
- Design, development, and testing of backup and recovery to ensure complete recoverability.
- Solid experience in disaster recovery, routine maintenance for Oracle databases.
- Security management for database, network, and operating systems.
- SQL Net installation/configuration/troubleshooting (Server and Client side).
TECHNICAL SKILLS
OPERATING SYSTEMS: Red Hat Linux (RHEL 5.x, 6.x), Solaris, AIX and Windows 2008.
RDBMS: Oracle 10g/11g/12c
LANGUAGES: SQL, PL/SQL,UNIX Shell Scripting, Ksh, bash and Perl Scripting
SOFTWARE/ APPLICATIONS/ TOOLS: DBCA, DBUA, Recovery Manager (RMAN), Oracle Enterprise Manager (OEM), OEM Grid Control, Oracle Data Guard, Oracle Management Service (OMS), Real Application Clusters (RAC), ASM, SQL Navigator, TOAD, Data Pump (expdp,impdp),SRVCTL,SQL*Plus
TUNING TOOLS: SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM
WEB TOOLS: HTML, XML
PROFESSIONAL EXPERIENCE
Confidential - Adrian, MI
Oracle DBA
Responsibilities:
- Worked on Multitenant Databases (Oracle 12c Container and pluggable databases)
- Experience working on POC of 12c new features like Redaction policy, adaptive query optimization, multiple indexes on single column, Restore table through RMAN etc…
- Able to resolve the performance issue in database 12c using automatic big data caching, full database caching and In-Memory Aggregation features.
- Hand on experience in cloning the non-multitenant container database to pluggable database in 12c using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot Cloning feature.
- Performed database administration, production support, installation, configuration, upgrades, patches, migration, backup and recovery, performance tuning, and cloning on the above said versions.
- 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.
- Experience in handling Multi-Terabyte Database migrations/Consolidations with minimum/no downtime.
- Proven Experience in implementing high Availability using Oracle RAC & Veritas Cluster server (VCS).
- Proven experience in troubleshooting issues related to Oracle RAC (Node Evictions, Node Reboots).
- 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, SQL Tuning Advisor, SQL Plan Baselines.
- Good Experience in applying patches like Critical Patch Updates (CPU), Patch Set Updates (PSU), and One-Off Patches, Interim patches, DST, Patch sets as per the Oracle recommendations.
- Installed & configured Oracle Management Server (OMS) & Oracle Grid Control.
- Extensive knowledge in maintain Oracle Cluster ware using Srvctl, Crsctl, has, ocrconfig, cluvfy, Private IP, public IP, SCAN IP and Virtual IPs along with NAS and SAN for ASM storage.
- Worked extensively in Performance Tuning at various levels including instance tuning, Query tuning, Database performance tuning. Responsible for maintaining the Database environments under SOX compliance and attend the SOX audit once in a year with all the evidences
- Apply the oracle security patches (CPU patch / PSU patch) on standalone database, Oracle RAC and clusterware (oracle 11g - Grid Infrastructure)
- Providing Level 2 operational support for the database tower
- 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, user access control
- Successfully implemented physical standby database using Oracle Data guard and Active Data guard feature for High availability configuration in RAC environment.
- Setup notifications (various levels for Cluster activities, tablespace utilizations, Listener alerts ) using OEM
- Monitoring and troubleshooting database issues with OEM grid control.
- Very comfortable in using ASM for creating diskgroups, adding additional storage (DISKS) and troubleshooting ASM issues.
- Resolving RAC specific issues such as node evictions
- Performed proactive and reactive tuning/managing database space utilization and growth
- Implementing Oracle ASM and resolving ASM related issues
- Detailed analysis of the business and users requirements by doing various information gathering techniques.
Environment: Oracle 10g, 11g, 12C, Unix shell script, Grid Control, Data Guard, IBM AIX, Sun Solaris, Oracle Linux, SQL*Plus, Toad, Various 10g and 11g Advisories, AWR and Statspack Reports, EXPDP/IMPDP, EXP/IMP, PL/SQL, RMAN, Crontab, Tivoli Storage Management for DB tape backups, BMC Patrol for DB monitoring.
Confidential - Mason, OH
Oracle DBA
Responsibilities:
- Running scripts and monitoring the load process to avoid any issues in ETL jobs running for a long duration.
- Monitored Database growth and provide Database capacity planning for applications expansion or necessary re-organization of tables and indexes as and when required.
- Performing Database Administration activities like space management, user and roles administration, schema management, checking alert log of all the databases. Installed Oracle 10g and 11g on multiple platforms.
- Performed up-gradation of 10g to 11g.
- Performed traditional Cold backup in appropriate environments via OS commands as well as logical exports.
- Automated routine DBA tasks like backup's and stats by using Grid control job's
- Provided Assistance to application team at the time of SQL tuning in applications. Administration of RAC and DATAGUARD databases in Oracle 11g.
- Oracle DB System Development Life Cycle (SDLC) planning and Oracle DB 3-Tier architecture.
- Setup RMAN solutions for all Oracle Databases -- created rman repository, provided best practices, optimizations and data guard and cloning techniques -- restore and recovery.
- Implemented and maintained Oracle 11g Data Guard/standby databases for switch-over and fail-over purposes. Created, relocated and removed Services as needed in an Oracle RAC configuration
- Adding and removing nodes to existing Oracle database RAC configurations
- Worked closely with diverse application development groups and served as single point of contact for testing, tuning and implementing projects / solutions in production environment
- Cloned and maintained multiple Oracle Database environments for Development, Testing & UAT.
- Carried out yearly DR Testing of Oracle ERP Systems / Critical Oracle Databases.
- Applied various database / applications PSU / CPU patches as required. Also applied monthly vertex updates.
- Performed activities like monitoring the database and provide maximum uptime.
- Created and granted users the privileges and roles and resizing the datafiles to manage database growth.
- Defined and implemented database backup and security strategies, tested the backups periodically for consistency and reliability
- Identified long-running database queries, refining queries for better performance, and working with end- users to implement changes
- Created primary database objects (tables, views, indexes) once application developers have designed an application
- Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both Oracle 10g Grid Control & SQL*Plus, as well as UNIX shell scripts.
- Created the database objects such as Tables, Indexes, Views, Database Triggers, Procedures, Functions, etc.,.
Environment: RHEL 4.4, HP-UX, 10g, and 11g, Oracle 10g/11g RAC, ASM, Data Guard, Oracle Enterprise Manager (OEM), RMAN, ASM, STATSPACK, EXPLAIN PLAN, TOAD, ERWIN 7.2, Autosys, Golden Gate, SQL*Plus, PL/SQL, SQL*Loader