We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

Evansville, IN

SUMMARY:

  • Extensive experience with Database Cloning and Refreshing pre - prod/dev databases with prod/pre-prod databases.
  • Skilled in developing RMAN scripts for database back up including hot and cold backup options for both RAC and standalone instances.
  • Worked extensively on created development, testing, staging, production, RAC and standby databases for OLTP and Data Warehousing using customized shell scripts and stepwise.
  • Excellent knowledge in Hot/Cold Backup, Recovery, Cloning of databases using RMAN, VERITAS Net Backup and Experienced in Linux and Solaris using 11g network configuration (NETCA) Listeners, PL/SQL,UNIX Shell Programming.
  • Expertise in maintaining Database Security using auditing.
  • Experience in Data Migrations.
  • Performed Upgrade and Migration of Oracle databases from oracle 10g to 11g & 12c.
  • Applied PSU/CPU Patches, ASM Patches, Grid Infrastructure Patches, Online Patches, one-off Patches and rolling patches.
  • Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.
  • Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.
  • Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.
  • Clusters (RAC) and Automatic Storage Management (ASM) and Data guard and Streams.
  • Good exposure of Oracle DBA tasks Installation, Patching, Cloning, and Upgrade of Oracle Databases.
  • Strong Knowledge and experience of Creating Users, Public Synonyms, materialized views, Database Links, roles, profiles, privileges, Audit Triggers and assigning roles to users.
  • Installed RAC 11g on 3 node cluster for large production system and migrated the legacy system from Non-RAC environment to RAC 11g cluster database.
  • Strong experience in migrating database from Non-ASM to ASM and Non-RAC to RAC.
  • Administered Oracle ASM disk groups (mirroring, compatibility) with Oracle ASM Configuration Assistant (ASMCA)
  • Installed and configured EM Central Grid control (OEM Grid) to administer and manage large number of databases and enterprise wide targets.
  • Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.
  • Proficiency with Installation and maintenance of replication tool Golden Gate by creating extract process, extract pump, and replicate.
  • Experience in 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.
  • Laid hands on new tools and experienced features like Data Replay, Log Miner and Flashback data Archive, Schema Management, Data guard and RMAN in Oracle 11g.
  • Highly motivated, excellent team player, enthusiastic, strong initiative and quick learner of new technologies.

TECHNICAL SKILLS:

Operating Systems: HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x. Linux Enterprise Server 9, 10. Windows 95/98/NT/2000

RDBMS: Oracle 12c, 11g, 10g

Languages: SQL, PL/SQL, UNIX Shell Scripting, PERL

Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM. Toad, Putty, NX client, WinScp, SQL Developer, Remote Desktop Connection, VNC, Team Viewer, LogMeIn and Cisco VPN Client

Database Utilities: SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import

PROFESSIONAL EXPERIENCE:

Confidential - Evansville, IN

Oracle Database Administrator

Responsibilities:

  • Oracle HA Stack: Install, Configure, Setup, Maintain and Support Oracle 11gR1, 11gR2, 12c RAC, Physical and Logical Standby database for Test, Development and Production for various home-developed applications like Portfolio Management Systems and vendor applications like SAP Business solutions
  • Involve in 24x7 on-call support for 12 databases of 2.0 TB 4 Node production 10g and 11g RAC databases using Oracle 12c Cloud Control for Alert Monitoring and Notification
  • Migrate to Multitenant Architecture using CDB and PDB of applications that otherwise have their own instances and qualify to be PDBs.
  • Troubleshoot and resolve slowness or performance issues with extensive investigation and follow-up with respective application teams with RCA and proposed solutions.
  • Resolve lock/latch and resource contention issues during production hours
  • Configure Dataguard and Broker for administration of seamless switchovers.
  • Upgrade GI and DBs from 11g to 12c with physical standby DBs in place
  • Utilize SPM SQL Baselines, SQL Profiles and SQL Tuning Advisor for troubleshooting and providing tuning recommendations to application teams.
  • Generate and analyze EXPLAIN PLAN, SQL*TRACE, TKPROF trace files to identify root cause of SQL performance issues.
  • Analyze AWR, ASH and ADDM reports and draw conclusions that aid in troubleshooting performance issues. Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 9i and 10g/11g environments.
  • Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
  • Refreshing Dev and Test instances with data from Production on a regular basis.
  • Monitoring and Troubleshooting GoldenGate Replication issues
  • Day-to-day usage of Oracle 11gR2 features - Real Application Testing, automatic SGA tuning, enhanced RMAN with Flash Recovery Area, Block Change Tracking, Merge backup, Oracle Data Pump, big file tablespaces, new EM Grid Control, Database Control, Studio Control, AWR, ADDM, SQL Tuning/Access Advisors, SQL Performance Analyzer, Database Replay, SQL Plan Management, SQL Tuning Automation, Flashback Database, compression techniques and several others
  • Usage of enhanced features in 12c like - Real Application Testing, Table and partition recovery using RMAN, Invisible columns, DDL Logging, Redo Log reduction on GTTs using temp, undo enabled.
  • Perform LOB Compression, Secure File and Deduplication in a cost-saving effort
  • Experience using enhanced features in 12c like - Real Application Testing, Table and partition recovery using RMAN, Invisible columns, DDL Logging
  • Resolved RAC issues, OCR related issues, rebooting of faulty nodes, relocating the switched over services.
  • Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2.
  • Extensively used Oracle 11gR2 features - Real Application Testing, automatic SGA tuning, enhanced RMAN with Flash Recovery Area, Block Change Tracking, Merge backup, Oracle Data Pump, big file tablespaces, new EM Grid Control, Database Control, Studio Control, AWR, ADDM, SQL Tuning/Access Advisors, SQL Performance Analyzer, Database Replay, SQL Plan Management, SQL Tuning Automation, Flashback Database, compression techniques and several others
  • Monitoring and Troubleshooting of Database Replication issues
  • Performance Tuning of Oracle Database Objects using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, STATSPACK for optimized results
  • Working with Application Development team to address any issues they encounter and provide support and resolution action plan
  • Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).

Confidential - Austin, TX

Oracle DBA

Responsibilities:

  • The work involved overall Maintenance of Oracle Database, Backup, Recovery and other database related activities.
  • Implemented 11g DataGuard Physical using DG Broker, and experienced with 11gR2 Data Guard new features Active Data Guard and Snapshot Standby.
  • Worked on Golden Gate 12c Replication configuration like unidirectional as well as bidirectional as per the requirement and addition of tables for the existing Golden Gate configuration.
  • Performed Data Guard switchover/failover as per the requirements.
  • SQL Queries/Application and Database performance monitoring and tuning using various tools like ADDM, AWR, Explain Plan and Statspack reports.
  • Database Growth and Space management, capacity planning; distributing the tables, redo logs, archived redo logs and rollback segments on different disks to optimize data retrieval.
  • Implemented Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11g R2.
  • Partitioned tables Maintenance, adding new partitions, exchanging one-year-old partitions then archiving of the exchanged partitions, dropping or truncating of old portions.
  • Modified database structures including tablespace, tables, views, triggers, stored procedures as well as configuration and storage allocation to support application enhancement.
  • General DBA daily jobs such as disk usage monitoring, table/index rebuild and reorganization as needed. Used import/export utilities for cloning/migration of small sized databases and Datapump in 10g and 11g environments
  • Monitoring of database for growth and performance.
  • Defined backup procedures using daily hot backups and weekly cold backup.
  • Installed ASM environment and migrated databases from NON-ASM to ASM.
  • Used TOAD for database management.
  • Made optimal use of Oracle Support in resolving the SRs.
  • Worked with latest 10g/11g features Data pump, Flash-Back Recovery, AWR, ASM, ADDM, Grid Monitoring, and Recycle Bin.
  • Extensively used AWR, ADDM and explain plan for periodic performance tuning.
  • Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
  • Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
  • Management of table space growth, monitoring data files additions, extent growth.
  • Constantly monitor the performance of the Databases and viewing Alert log files & Trace files.
  • Using TKPROF, EXPLAIN PLAN for the Better performance.

Hire Now