We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

Denver, CO

SUMMARY:

  • 6+years working experience in the field of Database Technology in designing, developing, implementing database technologies. Supported database on full SDLC including development, test, UAT and Production support, installation, configuration, upgrades, performance tuning, golden Gate, data Guard, RAC, backup and recovery, cloning, migration, space management, and database security. Have extensive support in 10g, 11g and 12c versions on Sun Solaris, Red Hat Linux, AIX, and Windows Platform.
  • Installed Oracle Golden Gate 11g, Implemented unidirectional and bi - directional replication.
  • Create extracts, data pumps and replicates on production servers, splitting replicates for efficient data transfer between servers, performance tuning using BATCHSQL, KEYCOLS, HANDLECOLLISIONS, CHECKPOINTSECS &troubleshooting extract/replicate ABEND issues.
  • Experienced in Installation and Configuration of Oracle Primary and Standby (Dataguard) Database.
  • Simulate Failover and did Switchover of Database for maintenance reasons.
  • Installed,Configured and Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 12cCloud Control.
  • Knowledge in Exadata for high performance and improve throughput.
  • Experience with large databases for OLTP and OLAP applications.
  • Excellent experience in OLTP/OLAP, implementing and managing large Oracle databases, Data modeling, Logical and Physical databases design using tools like Erwin.
  • Knowledge in AWS Cloud computing and deployment service.
  • Experience in multi-node and RAC environments including configuration of PCP.
  • Troubleshooting the production databases (RAC, Non-RAC) within less time.
  • Highly Experience in Tuning database in RAC / Non-RAC environment for better Performance.
  • Import/Export and data pump Expdp/ Impdp utilities.
  • Monitor nightly Database backup Jobs and necessary actions for failed backup jobs including script corrections, disk space monitoring and Database availability.
  • Setup procedure for Database statistics gathering - Frequency, Best Time of the day to execute stats gathering jobs, correct level of gathering statistics.
  • Extensively worked on monitoring and optimizing the database by performance tuning.
  • In-depth understanding on oracle utilities SQL Trace, Explain Plan, TKPROF, Statspack, AWR, Analyzer and DBMS STATS in Performance Tuning.
  • Performance tuning of the database (Memory Allocation Tuning, I/O Tuning, and Tuning Contentions) using TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM.
  • Collecting performance statistics using ASH, Statspack/AWR (Automatic Workload Repository) and ADDM (Automatic Database Diagnostic Monitor).
  • Used TKPROF utility and Explain Plan for tuning SQL queries.
  • Upgrading and Migration of Oracle database to higher version and other platforms using manual method and traditional Export/Import, datapump& Transportable Tablespace (TTS).
  • Database Backup and Recovery using RMAN including duplicating/cloning Databases across with point-in-time recovery option.
  • Hands on experience with logical backups, Hot/Cold backups, Recovery, and cloning of databases using (RMAN) Recovery Manager, SQL-Backtrack, VERITAS Net Backup.
  • Expertise in Configuring RMAN with Catalog /Nocatalog and worked on Point-In-Time Recovery and flashback.
  • Backups and Recovery Manager, Performance Tuning, Capacity Planning and documentation.
  • Creating roles, profiles, privileges and assigning roles to users.
  • Hands on experience with various tools like SQL*Loader, TOAD, Oracle SQL Developer and Oracle Enterprise Manager (OEM).
  • Enabling Load Balancing in a Multi-Tier Architecture.
  • Extensive experience in Installations, configuration, Cloning, Security, Patching, Upgrades.
  • Proactive Monitoring identifying areas that need to be improved performance in the application and database using OEM database control and OEM Grid control.
  • Database Upgrades, Migrations using traditional (DBUA, Manual and export/import) as well as non-traditional way (Transportable table spaces).
  • Migrated databases from Non-ASM file system to ASM file system using RMAN.
  • Experience in coding SQL, PL/SQL package, function, stored procedure, triggers, and Materialized view for Oracle database.
  • Implementation of Enterprise wide Database Monitoring enabling Oracle 12c Enterprise Manager Cloud Control. One stop solution for monitoring every single Oracle Database within the global enterprise.
  • Disk Space Management involving managing archives, space allocation to various tablespaces and also capacity planning for new applications.
  • Plugging the tablespace between different platforms using Cross platform transportable tablespace Utility.
  • Experience in regular DBA activities such as Upgrades, Patches, TAR support, & cloning.
  • Database Technology: Microsoft SQL Server.

PROFESSIONAL EXPERIENCE:

Confidential - Denver, CO

Oracle Database Administrator

Responsibilities:

  • Worked on designing, installing & maintaining11gOracle Dataguardconfiguration.
  • Supported& maintained the Production/Standby databases on various servers.
  • Used ASH, ADDM and AWR reports to monitor the database performance.
  • Tuning SQL queries when the performance is poor.
  • Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
  • Scheduled meetings with application team for database migration review to gather legacy information such as type of application, database options, current oracle configuration, capacity and oracle outstanding tasks.
  • Ensure databases adhere to corporate standards and policies. Worked with application team, developers, change management team and DBA team to ensure smooth life cycle progress from development through testing and production implementation
  • Developed, revised and implemented policies, standards, procedures and guidelines necessary to effectively administer the database environments.
  • Upgraded the databases to version 12c from 11g and 10g
  • Installed, Setup, Configured Oracle version 12c Release2 64 Bit on Solaris 10 and RHEL 6
  • Migration of Database from 10g to 11gand then to 12c and also applying patches whenever required.
  • Applying upgrade patches, maintenance and interim patches on all the databases.
  • Other activities like applying RDBMS patches, security patches, sox reporting proactive monitoring of databases and applications.
  • Monitoring and maintaining 2/3 node RAC database on Red Hat Linux. Providing support to the development team and handling release schedules.
  • Experienced in handling database issues using OEM as well as command prompt.
  • Worked on Automatic storage management (ASM) with EMC storage for managing data in SAN.
  • Successfully implemented 10g RAC on nodes for high availability.
  • Experience in Working with RAC Databases.
  • Hands on experience in troubleshooting RAC environment, using srvctl, crs stat and crs profile.
  • Installed ASM environment and migrated databases from NON-ASM to ASM.
  • Diagnosed Oracle bugs and coordinating with Oracle support to resolve them in timely manner.
  • Responsible for setup and implementation of 2Node RAC on IBM-AIX in log
  • Performed various tasks like Administering RAC using SRVCTL, Adding nodes and instances, Administering Storage Components, Parameter Management, and Configuring High Availability Features for RAC.
  • Performed Online and Offline backups with RMAN, export/import and expdp/impdp.
  • Maintaining sound backup and recovery policies and procedures using RMAN. Monitoring the scheduled backup procedures for daily basis using crontab.
  • Database refreshes using export /import and datapump.
  • Implemented Point in time recovery using RMAN.
  • Implemented downstream capture at the destination database.
  • Worked with T-SQL statements like DELETE and UPDATE statements and also like BULK insert of data.
  • Oracle OEM (Oracle Enterprise Manager) Grid Control.
  • Expertise in SQL and UNIX Shell Scripting (Implemented UNIX Scripts using CRONJOB for Day-to-Day activities and Windows Task Scheduler) and PL/SQL.
  • Installed the Oracle software using silent feature and also created databases
  • Extensively worked on setting up auditing in many databases we supported
  • Managing Database Structure, StorageAllocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.
  • Installed,Configured and Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 12cCloud Control.

Environment: RHEL 5.X, 6.X; Windows NT 2000/2003; Oracle 10g, 11g, 12c

Confidential - Edison, NJ

Oracle Database Administrator

Responsibilities:

  • Implemented Data Guard with maximum availability and performance configurations for production databases
  • Worked on Active data guard, Fail over and Switch over cases.
  • Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.
  • Administered and monitored over 150 databases both on 10g/11g on prod/test/dev environments
  • Administering Oracle Databases 10g/11g of sizes ranging from 100GB to 5TB
  • Up-gradation of single instance databases from 10.2.0.4 to 11.2.0.3 on Linux
  • Migrated databases from File-system to Automatic Storage Management (ASM)
  • Involved in migrating applications from Solaris 10g/11g to Linux 11.2.0.3 using Transportable Tablespace, RMAN Convert
  • Responsible for using Flashback query mechanism along with automatic undo management
  • Experience in Creating Physical and logical database design Data Models using Erwin Tool.
  • Installed 12C grid control and Used Oracle Enterprise Manager Grid control 11g/12c for monitoring databases.
  • Programming in shell to create shell scripts that automate the database backups and maintenance.
  • Involved in Mass Agent Deployment using Oracle Enterprise Manager 12c
  • Implementing Datapump, conventionalexport/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
  • Applied Bug fixes patches, Quarterly Security Patches for RAC and non-RAC servers for issues when upgrading, DR switchover testing.
  • Reconfigured the OCR, public and private interconnects, modifying the VIPs and the subnet masks for 2, 3, 4 Node RAC Clusters and Upgraded single instance 10g databases to 11gR2 RAC.
  • Setup, reconfigured and monitored 2, 3 Node RAC Primary to 2, 3 Node RAC Dataguard for DR.
  • Tested the Dataguard (DR) SWITCHOVER of RAC to RAC Dataguard as part of the migration.
  • Created new databases/instances on 12c/11g RAC and single instances using customized scripts, DBCA.
  • Handled all daily DBA activities and excellent experience with SQL scripting, PL/SQL coding, stored procedures, functions, packages, triggers to enforce the referential integrity constraints
  • Performance monitoring and Database/Instance/clustered Application tuning using Dictionary views, AWR (Statspack), ADDM, ASH reports, and used notification to send the alerts in the OEM Grid Control, tuned SGA/PGA parameters, initialization parameters and reorganized physical objects (tables & indexes) and tablespaces to improve the performance.
  • Redesigned table and index partitioning strategies, using HINTS to improve the query performance.
  • Developed, modified and optimized very complex queries to data retrieval using Explain Plan, SQL Trace, TKPROF, parallel processing and partitioning techniques.
  • Monitoring the CPU, memory usage, I/O contention on servers using top, iostat, sar, glance, vmstat etc.
  • Oracle Database monitoring, troubleshoot, resolve the issues, monitoring alert log, trace files.
  • Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes
  • Designed daily, weekly Backup and Recovery procedures for production, non- production databases using RMAN backups taking periodic Complete, cumulative and differential Incremental Backups.
  • Migrated VLDB multi-terabyte databases around 1TB and redesigned the RMAN backup Strategy.
  • Data Refresh/Cloning from Production environment to setup QA/ DEV using RMAN Duplicate.
  • Scheduled UNIX scripts in crontab jobs to automate daily tasks like backups, monitoring the alert logs, backup logs, cleaning the old archive logs, old log files, tablespace monitoring to send notification emails.
  • Migrated data to a new ASM Diskgroup to improve the IO performance of the database.
  • Export/Import, Datapump, Transportable tablepsaces to migrate databases from one database to another.
  • Data aggregation and replication setup using Oracle Streams and Materialized views for reporting.

Hire Now