We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

Chesterfield, MO

SUMMARY

  • Extensive Experience in very large scale database environment and mission critical large OLTP and OLAP systems.
  • Experience with MySQL on both Linux and Windows
  • Extensive experience in providing 24x7 on call support for Test, development and production databases using Maximum Availability Architecture using RAC and Dataguard
  • Expertise in Implementing Oracle 11gR2 and 12c RAC implementation on ASM
  • Administration and troubleshooting 10g, 11g and 12c RAC clusterware using clusterware logs
  • RAC utilities: raccheck, orachk, oratop, TFA Collector, ocrconfig, OSWatcher, Srvctl and Crsctl
  • Performed various tasks in RAC Cluster: pinning nodes, used ocrconfig to backup OCR, OLR and voting files, creating services using Srvctl, changing scan port number, Multiplex Voting files, Mirroring OCR on different ASM disk groups, Tuning Node Evictions by setting disk timeout, reboot time, miss count, Creating New VIP to manage high availability, Configuring TAF and used different parameters, Configuring ACFS and configuring for Automatic failover
  • Applied Patches in rolling fashion and Upgrading Oracle GRID infrastructure 11g, 12c
  • Expertise in configuring and implementing ASM and proficiency in using ASMCMD and ASMLIB and configuring ASM disk groups using ASMCA and SYSASM
  • Experience in Uni - directional, Bi-directional and Integrated Capture data replication using golden gate.
  • Troubleshooting Golden Gate issues such as process abending, and lag on replication environments
  • Troubleshooting Golden Gate issues in both development and production environments
  • Migrating and upgrading Oracle Database from 10gR1 on Solaris/Windows to 11gR2 on Linux environment using Datapump and Golden Gate replication
  • Expertise in Dataguard Configuration, Implementing and Maintaining physical standby databases in 10g/11g/12c on Solaris, AIX, RHEL
  • Expertise in configuring Active Dataguard, Snapshot standby and troubleshooting issues and configuring Service Level Agreements for query’s accessing standby databases
  • Expertise in analyzing database objects, DB-links, creating indexes, creating materialized views, writing packages, Stored Procedures, Functions, Views, Database Triggers, exception handling using SQL and PL/SQL in Oracle
  • Troubleshooting Dataguard using Views, troubleshooting missing archive log scenario, patching Dataguard environment, Applied logs with delay Configured Dataguard Broker and managed standby databases using DG broker
  • Experience in cross platform Migration from Solaris to Linux and Upgraded database from 11g to 12c using Golden Gate with Zero downtime.
  • Used Logdump utility, Defgen utility in GoldenGate environment and Installed Goldengate in dev, test, and prod environment configured Golden Gate wallet for security purposes
  • Expertise in implementing database Backup and Recovery concepts using RMAN utility.
  • Experience in logical backups and Database migration tools with Data Pump, Export/Import and Transportable Table-spaces
  • Good experience in Patching PSU and CPU Patches Quarterly and Up gradation of databases from versions from 10g,11g to 12c
  • Expertise in Upgrading databases from 10g to 11g and 11g to 12c and applied patches accordingly
  • Tuning Instance, and Tuning Disk Usage
  • Used Data masking to protect private and confidential data by replacing sensitive information with dummy data, knowledge on Physical and Logical structure of database
  • Worked on Exadata Database Machine X2-2 Half Rack, X3-2
  • Implemented new Exadata Machine features like smart scan, Flash Logging, Storage Index, HCC and enabling Smart Scan on Exadata Databases
  • Migrated databases into Exadata Machine with minimal downtime using Data guard
  • Developed database monitoring and health check alert scripts for database uptime and downtime status, and sizing issues using grid control (OEM)
  • Mass deployment of agents from OEM, patching OEM, performing administrative tasks using OEM, generating reports, scheduling jobs using Auto sys, RMAN, SQL tuning advisor to tune sql’s on database
  • Excellent Communication skills, co-ordination and Communication with system administrators, business data analysts and development teams
  • Have Ability to function independently and plan, evaluate and design solutions to problems as they occur and Ability to work well in a group environment and Good ability to mentor other DBAs in the group

TECHNICAL SKILLS

Operating Systems: HP-UX 10.x,11.x, Sun Solaris5.8,8,9,10, AIX 5.1,5.2, Red Hat Linux 4.x,5.x,6.x and windows 2003/2005

RDBMS: Oracle 12c/11g/10g/, Oracle 11g Real Application Cluster (RAC), ASM

Oracle Tools and Utilities: Data Guard, GoldenGate, Logdump, Defgen, Web logic server, OBIEE, WebSphere, RMAN, OEM, Tuning Advisors, TOAD, SQL*Loader, Export/Import, Data pump, AVAMAR, RMAN, RAC TOOLS ORACHECK, oratop, TFA collector, OSWATCHER

Languages: C, SQL, PL/SQL, AWK Scripting, Perl

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ADDM, AWR, SQL Tuning Advisor

Ticketing Tools: Web Portals, BMC Remedy, HP Quality Center, HP Java ITO (OVO) console, JIIRA, Service Now

PROFESSIONAL EXPERIENCE

Confidential, Chesterfield, MO

Oracle Database Administrator

Responsibilities:

  • Experience in Identifying the queries utilizing high system resources and advising the solution for those.
  • Used Attunity tool for Migration of Databases.
  • Handled over 30 Production databases, includes Oracle 11g RAC and NON-RAC, which are of minimum 1TB size
  • Performed Database performance issues, capacity issues, replication, and other distributed data issues
  • Monitored daily database activities and overall performance, growth and tuning configurations as well as the security of the database
  • Implemented and supported Administration tasks such as backup and recovery procedures, database utilities, and data replication technologies for both PROD and NON-PROD environments
  • Responsible for all corrections to the database infrastructure and for repairs, maintenance and periodic reorganization of oracle databases and Resolve database performance issues, capacity issues, replication, and other distributed data issues
  • Provide technical support and troubleshooting assistance to application development teams for Oracle related issues scheduling and tracking all changes using change management system tools
  • Data masking sensitive data in production databases using OEM 12c and Scheduled Oracle Jobs using DBMS SCHEDULER
  • Data guard: Configured Physical Standby databases using data guard in maximum performance & availability and Converted Physical standby to Snapshot Standby 11g, 12c according to Business
  • Configured Active Data guard 11g Troubleshooting Out of sync issues in Data Guard environment and Configured Data guard Broker and used for switchover and stopping and Starting Media recovery process and Performed Disaster Recovery testing
  • Used Crontab utility for scheduling jobs
  • Worked on Service now Ticketing system to resolve the incidents based on Severity.
  • Created Users with limited rights as per specific module under specific client. Granting roles and profiles as per system study to users.
  • Perform Daily Monitoring ofOracleInstances, monitor users, and Table spaces, Memory Structures, Rollback Segments, Logs and Alerts
  • Creation of database objects like Tables, Indexes, Views, Users, and DB Links etc.
  • Applied patches and database re-organization using oracle enterprise manager (OEM).
  • Rebuilding indexes when needed to avoid fragmentation and improve performance, monitoring index usage and removing unused indexes.
  • Good at managing and monitoring grants, roles, privileges to users, analyze tables to generate and gather stats including verify daily alert logs
  • Database Capacity Planning & configuration (redo and stream sizes), design staging schema
  • Installed, configured and maintained Oracle 12cR2 Real Application Cluster (RAC) 3 node RAC, Migrating single Instance Databases to 3 Node RAC environments
  • Created standby databases and involved in converting Physical to snapshot standby and Active Data guard.
  • Implemented scheduling full, incremental, cumulative and hot, cold backups writing, editing UNIX Shell Scripts for RMAN

Environment: oracle11g/12c, service now, toad, Mobaxterm, Jira, Service now, RMAN, Data guard, RACCHECK, Attunity, Data pump, AWR, ASH,Putty,Linux

Confidential, Nashville, TN

Oracle Database Adminstrartor

Responsibilities:

  • Grant, control and delete database access based on security requests
  • Hands on experience on table promotions
  • Monitoring the daily backups
  • Monitor database performance through (AWR) Automated Workload Repository and optimize when appropriate
  • Monitor system for invalid objects.
  • Perform Daily Monitoring of Oracle Instances, monitor users, and table spaces, Memory Structures, Rollback Segments, Logs and Alerts.
  • Worked in the client location.
  • Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc., configured network components like TNSNAMES, Names Server, Connection Manager, etc. for easy and effective management of Oracle networking. Configured listener for external procedure calls
  • Create and manage documentation for databases and processes
  • Security provisioning for the users on the daily basis
  • Evaluate all Performance tuning tools used by the team including Toad, SQL Developer, and OEM
  • Performs general database administrative tasks including user account management, access control, database optimization and error resolution
  • Perform Daily Monitoring ofOracleInstances, monitor users, and Table spaces, Memory Structures, Rollback Segments, Logs and Alerts.
  • Created User accounts, Roles and granting required access permissions and privileges
  • Excellent knowledge in using Oracle Golden Gate including maintenance and performance monitoring
  • Worked on Service now Ticketing system to resolve the incidents based on Severity
  • Excellent communication, interpersonal, analytical skills and strong ability to perform as a part of a team. creating table partitions and dropping partitions when required, creating index’s and rebuilding indexes for maintenance, creating new DB-links for new environment
  • Extensively used of Oracle Data Pumps utility for moving data among the servers and used data-pump at schema level and Database level for refreshes.
  • Efficient in using the Oracle Tools like OEM, SQL* Plus, SQL* Loader, TKPROF, LOGMINER, STATSPACK, SQL*Net, IMPORT/EXPORT, and RMAN
  • Created audit vault triggers for the tables
  • Involved in migration of databases.
  • Promoting the tables from UAT to DEV environment.
  • Experience on changing the database passwords in a monthly rotation manner. .
  • Migration of database from one server to another server.
  • Creation of database objects like Tables, Indexes, Views, Users, and DB Links etc.
  • Created and configured database manually using Oracle Database Configuration Assistant.
  • Used to take the backup of databases using RMAN catalog. The restore capability included the restoring via stored RMAN tapes and using the RMAN database and tablespace restore and / or recover capability of RMAN

Environment: ora11g/12c, service now, toad,sql developer, data guard, data pumpOracle patching, patch, putty, Red hat Linux, oracle enterprise manager, opatch, OEM 11G/12c/13c, TKPROF, AWR, ADDM, ASH, RMAN, Dataguard including DG Broker setupOracle Golden gate 11.2.

Confidential, Louisiana, LA

Sr. Oracle DBA

Responsibilities:

  • Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment
  • Performed the 12c Upgrade of RAC cluster ware from 11g.
  • Duplicated issues and tested solutions to make sure problems were resolved properly.
  • Assisted Development and Business analyst teams by capacity planning and cloning of databases to the test environments so they could develop custom applications and perform a variety of tests for quality assurance and issue resolution
  • Installed the 3 node RAC for the 12c database and administered the 12c databases on these RAC server’s.
  • Managed testing, assisted Developers, and created backups by Exporting and Importing tables when needed.
  • Established performance tuning best practices used by the DBA and Development teams.
  • Performed the Instance caging for the Exadata databases.
  • EBS DBA on numerous Oracle E-business Suite (11i/R12) implementations
  • Enabled Flashback for database to create restore points and supporting DDL changes
  • Applied PSU quarterly on 11g/12c GRID & RDBMS homes using Opatch auto and Up-gradation of 11g/12c databases and Implementing catalog backup from RMAN
  • Daily Health Check Up of the Database and SQL Queries and Performed large batch jobs, and tuning of SQL queries and database systems
  • Excellent knowledge in using Oracle Golden Gate including maintenance and performance monitoring.
  • Performance tuning Golden Gate replication and used Log dump and report files for troubleshooting.
  • Installation and configuration of oracle Golden gate on 12c & 11g.
  • Configuration and troubleshooting of Golden Gate EXTRACT, Unidirectional and BIDIRECTIONAL REPLICAT issues
  • Evaluate all Performance tuning tools used by the team including Toad, SQL Developer, and OEM
  • Worked on Exadata Production databases and providing the Technical support to Application Support team for performance and database related issues
  • Up gradation of GRID infrastructure from 11.2.0.x to 11.2.0.4 and from 11.2.0.4 to 12.1.0.2
  • Performed health checks of RAC Cluster-ware components OCR, voting files and backups using ocrconfig and Troubleshooting Issues using Clusterware logs in 12C
  • Used RAC Tool orachk to scan different stack of layers and finding potential risk and reconfiguring RAC cluster and Creating and Managing services using RAC Tools SRVCTL and Cluster-ware resources using CRSCTL..
  • Performed daily maintenance tasks like space management, rectified locking problems, managed quotas etc., configured network components like TNSNAMES, Names Server, Connection Manager, etc. For easy and effective management ofOraclenetworking. Configured listener for external procedure calls.
  • Also configured database cloning using RMAN.
  • Worked with offshore team and coordinating database monitoring, scheduled calls to discuss database issues
  • Responsible for database administration and worked in all phases of Software Development Life Cycle (SDLC), and systems analysis procedures

Environment: Oracle 11g/10g/12c, HP-UX 7.x/11.x, IBM AIX-6.1, RHEL 5.x, 6.x, OEM 11G/12c/13c, RAC11gR2, 12c, ORACHK, RACCHECK, OCRCONFIG, SRVCTL, CRSCTL, Database10g/11g/12C, RMAN, DATAPUMP, 10g/11g, Goldengate11g, 12c, orachk Defgen, Logdump, ASH reports, Oracle Patching Opatch, Data Pump, putty

Confidential, MARYLAND, MD

Sr. Oracle Database Administrator

Responsibilities:
  • Upgraded GoldenGate from v10 to v11 while upgrading Oracle databases
  • Replicated tables to different Instances to support DDL changes and support applications 24x7, replaced materialized views using GoldenGate
  • Performed Various tasks in GoldenGate: Troubleshooting errors using report and ggserror.log, configured DDL, DML replication, Configured Bi-Directional Replication, New setup from scratch for Migration, Configured Extract, Pump and Replicate and replicated tables to different Instances using GoldenGate
  • Upgradation of databases from 11.2.0.2 to 11gR2 and Applied patches to databases 10g/11g
  • Configured Disaster recovery databases using Dataguard: configured Active Dataguard, Dataguard Broker and snapshot standby databases, Troubleshooting Issues in Data Guard Environment, missing archive log, performance of Standby databases using stats pack, applied logs with delay, Tuning Media Recovery process, Performed DR testing
  • Performed Data Refresh from Production to Test and Development environments using RMAN Backup and RMAN Duplicate Database
  • Configured backup & recovery solutions using RMAN and NetBackup, Troubleshooting RMAN failed and resolved issues, performed Block Recovery, Data file Recovery
  • Planning Recovery Procedures and Performing backups in Both Archive log backup using RMAN and No archive log Back mode using Exports and Import utilities
  • Configured repository database for setting up OEM 12c, used 10g,11g for monitoring databases, created administration group, template design, Black out, Database Administration, AWR, ASH, ADDM, SQL Tuning Advisor, monitoring performance of databases etc. using OEM 11g, 12c
  • Created User accounts, Roles and granting required access permissions and privileges
  • Extensively used of Oracle Data Pumps utility for moving data among the servers and used data-pump at schema level and Database level for refreshes
  • Used 11g new features Invisible Indexes, and turn off indexes temporarily to check how queries perform without Index’s and Worked on Oracle Database Appliance, patching
  • Creating table partitions and dropping partitions when required, creating index’s and rebuilding indexes for maintenance, creating new DB-links for new environment.

Environment: Oracle 11g/10g, Oracle 12c(Testing), Oracle Goldengate 10.4, Oracle Goldengate 11.2, Oracle Enterprise Manager Grid Control, Oracle Enterprise Manager (OEM), Sun Solaris, Red Hat Enterprise Linux (RHEL) and Oracle Enterprise Linux (OEL).

Confidential, Kansas City, MO

Sr. Oracle Database Administrator

Responsibilities:

  • Implemented Oracle Database 11gR2 2,3,4 node RAC Clusters on RHEL Linux Severs
  • Performed health checks of OCR, voting-disk, Interconnect and RAC instances and managed resources using Crsctl & Srvctl, creating services using Srvctl, relocating services and patching RAC cluster and troubleshooting 10g, 11gR2 cluster
  • Worked on Exadata X2-2 and x3-2 machines and migrated application databases using Expdp, GoldenGate and Dataguard
  • Worked on different Features on Exadata x3-2: Hybrid column compression, Smart scan, Flash Logging, DCLI, create and drop Flash disks, Flash Logging, Enabling Flash Cache Compression, Cell monitoring and Alerts, Cell Offload Efficiency, Hybrid columnar compression, controlling database resources using IORM plan
  • Performed various tasks on ASM, Installed standalone servers on ASM, used asmcmd to manage disk groups in ASM environment and Performed various tasks on ASM, creating a disk group, adding a disk to disk group, making disk Online and Offline and troubleshooting issues in ASM, tuning ASM parameters for better performance
  • Upgraded GoldenGate from v10 to v11 while upgrading Oracle databases
  • Replicated tables to different Instances to support DDL changes and support applications 24x7, replaced materialized views using GoldenGate
  • Performed Various tasks in GoldenGate: Troubleshooting errors using report and ggserror.log, configured DDL, DML replication, Configured Bi-Directional Replication, New setup from scratch for Migration, Configured Extract, Pump and Replicat and replicated tables to different Instances using GoldenGate
  • Upgradation of databases from 10.2.0.4 to 11gR2 and Applied patches to databases 10g/11g
  • Performed Data Refresh from Production to Test and Development environments using RMAN Backup and RMAN Duplicate Database
  • Created User accounts, Roles and granting required access permissions and privileges
  • Extensively used of Oracle Data Pumps utility for moving data among the servers and used data-pump at schema level and Database level for refreshes

Environment: RHEL-4.x,5.x, Sun-Solaris 9, OEM 10g-11g, Oracle 10g,11g, RAC 10g,11g, Srvctl, Crsctl, ocrconfig, ASM, ASMCA, Dataguard, Active Dataguard, snapshot standby, GoldenGate v10, v11, Exadata x3-2, x2-8, Migration, TKPROF, AWR, ADDM, ASH, RMAN, Data pump, Opatch, Materialized views, Toad, Putty

Confidential

ORACLE DBA

Responsibilities:
  • Setup physical standby’s (DATAGUARD) for several Databases running 11g well(Container level and Non-CDB)
  • Improved the database integrity and increased data accuracy for end-users and management by proficiently using SQL language to troubleshoot, query, insert, update, and delete table data.
  • Configured Data guard broker between the primary and standby databases, perform Switchover/Failover and monitor the data guard status via command line and GUI
  • Assisted in keeping a daily log of Share point issues and submitting that log each week to IT management
  • Converted physical standby to Snapshot standby and back to physical standby
  • Involved in Availability testing of several Production databases before going Live which involved Node level failover testing, Listener/Scan level failover testing and database failover testing.
  • Configure and build Golden Gate Extracts/replicate for multiple databases, Configure and build heartbeat monitoring in Golden Gate
  • Converted single Instance Databases to RAC databases using RCONFIG, DBCA and Manually.
  • Data pump including database links and network links. Upgrade the binaries by applying patch Set and interim patches using Opatch and Opatch Auto
  • Provided Instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.
  • Configured and implemented Oracle Streams (Advanced Replication) for high availability
  • Tested database performance issues (monitoring and tuning) to ensure database optimization Involved in gathering requirements from end users
  • Estimate growth of database size by detail analysis of the company's future policies and generating reports for the management to act in advance
  • Replication was configured to run even at the time of failover (Data Guard) of the source database
  • Providing technical support to Application Support team for performance and database related issues
  • Effective Production Support and off hour support, support ha5ndover

Environment: Oracle 11g, Red Hat Linux 5.8, OEM 12c, RAC, Oracle Advanced Security, Pluggable databases, Dataguard including DG Broker setup, RMAN, Partitioning, Compression, DBFS, Performance tuning, Opatch Auto, TOAD for oracle 12.1/11.6, Storage Migrations

Confidential

Junior Oracle DBA

Responsibilities:

  • Experience in moving the data from one server to another server using SFTP, FTP and SCP
  • Schema Refreshing of databases using normal copy method and exp /imp utility
  • Involvement in space management, rectification of lock problems, user management
  • Regular Data Refresh from Production to Test and Development environments using RMAN
  • Duplicate Database or Data Pump utility for oracle 10g and 11g servers
  • Created and Managed users, roles, schemas, tables, views, indexes and rebuilding Indexes
  • Grant and Revoked user privileges and roles as per requirement and killed blocking session
  • Created and managed database objects like table spaces and increase the size of the table space by resizing and adding the data files
  • On-Call 24x7 DBA support for production databases.

Environment: Oracle 10g, Red Hat Linux, SQL, Oracle Enterprise Manager 10g,Quest Software (5.0),Putty

Hire Now