We provide IT Staff Augmentation Services!

Oracle Dba Resume

Austin, TX

SUMMARY

  • Proficient in maintaining 10g, 11g, 12c,18c and 19c databases
  • Data Guard (Standby Databases)
  • Real Application Cluster (RAC)
  • Automatic Storage Management (ASM)
  • Exadata x7
  • Golden Gate Replication
  • MS SQL Server
  • Backup and restore/recovery using RMAN
  • Administration of Oracle 10g, 11g, 12c to18c to 19c RDBMS
  • Cloning / Refreshing database objects using Data Pump and RMAN
  • OEM / SQL Developer / TOAD
  • Patching, PSU, RU, One - off patches, CRU Bundle patches
  • Performance Tuning / ASH / AWR / ADDM / SGA / Tracing / Wait events
  • Database Migration
  • Database Upgrades
  • Shell Scripts
  • Automating jobs
  • Cloud AWS (Amazon Web Services) / EC2 instances
  • Intermediate Linux Administration.
  • Good understanding of OS Windows, Linux, AIX, Solaris
  • Installation, Configuration, Upgrading, Migration and Maintenance.
  • Configure, maintain and deploy the Data Guard and grid control.
  • Installing and maintaining Oracle GRID CONTROL
  • Configured Workload Management, JDBC, FAN, TAF, ASM, and RMAN for maximum performance.
  • Worked extensively on Oracle Streams.
  • Troubleshoot OCFS2 install issues and working with Enterprise Manager.
  • Design and implement Auditing and other security features for the existing Production systems.
  • Raised SR and TAR with Oracle Support.
  • Used Oracle Enterprise Manager (OEM) for administering several databases
  • Backup of database Logical and Physical (hot and cold) procedures and using RMAN.
  • Migration from Linux to Solaris and 32 bit to 64 bit.
  • Restore and Recovery of database in case of database crash, disk/media failure.
  • Applying patches and works closely with Oracle to make Application environment up to date.
  • Monitored databases using 13c cloud control and via shell scripts
  • Backups & Recovery Maintenance, Databases Performance Tuning.
  • Typically involved in database Designing, creation and maintenance.
  • Good working knowledge of SQL, PL/SQL, and shell scripting.
  • Created users and grant privileges according to the requirements.
  • Working knowledge on UNIX administration on AIX server.
  • Provided System support for both development and 24*7 production environments.
  • Performed automated backups and scheduling using scripting.
  • Responsible for migration of databases.
  • Worked with Data pump to take the logical backups of databases and Experienced in performing Point in time recovery using RMAN.
  • Involved in designing logical and physical data models using Erwin.
  • Good experience in 24/7 Production Environment Support.
  • Provided 24/7 on-call support.
  • Worked with offshore DBAs

TECHNICAL SKILLS

OS: RHEL, AIX, Windows, HP-UX, Solaris

RDBMS: Oracle 19c/18c/12c/11g/10g/9i, SQL Server 2005 / 2008

High Availability: RAC, Data Guard, ASM, GoldenGate, Materialize Views, Active Data Guard, Exadata, AWS

Languages: SQL, PL/SQL, UNIX Shell scripting, T-SQL

Tools: RMAN, OEM, sqlldr, exp, imp, expdp, impdp, ERWIN, TOAD, dbconsole

Tuning Tools: SPA, ASH, AWR, ADDM, SQL Tuning Sets, tkprof, Explain Plan, Statspack, SQL Advisor, performance analyzer, Invisible Indexes.

PROFESSIONAL EXPERIENCE

Oracle DBA

Confidential - Austin, TX

Responsibilities:

  • Involved in 24x7 support for production RAC databases with on-call pager
  • Administered databases on Exadata
  • Performed database cloning to setup test and development database
  • Maintaining schemas and partitioning tables
  • Monitored databases using 13c cloud control and via shell scripts
  • Developed RMAN scripts for database backup and recovery
  • Tablespace management Performed Silent installation on Exadata.
  • Applied patches on computer nodes, Exadata home and storage cells.
  • Migrated standalone databases to Exadata
  • Implement disaster recovery with use of Exadata Setup and managed replication using Oracle Golden Gate
  • Worked on Data Migration project.
  • Migrated databases from Windows platform to Linux
  • Expertise in User and profile management
  • Database performance analysis using ASH, AWR and ADDM reports
  • Refreshed database using export import and Data Pump
  • Adding a New Node to RAC cluster and Installed Oracle RDBMS software on a new node of the cluster, Created ASM Volume using ASMCA and Created ACFS for GoldenGate 12c.
  • Configured Physical Standby databases using data guard for maximum performance & availability and Converted Physical standby to Snapshot Standby 11g, 12c,18c and 19c.
  • Configured Active Data Guard 11g Troubleshooting Out of sync issues in Data Guard environment and Configured Data Guard Broker, fast-start failover and used for switchover and stopping and Starting Media recovery process and Performed Disaster Recovery testing.
  • Configured SLA for Query’s accessing standby database and managed Active Data Guard.
  • Worked with VMWARE team in building new servers, performed Clusterware installation, RAC RDBMS installation, RAC Database creation, Grid Control installation,
  • Resolved DB performance issues.
  • Worked as primary on-call DBA.
  • Used TOAD for various database Administration tasks.
  • Used SQL*Loader to move data from flat files into an Oracle database.
  • Used SRVCTL utility for managing multiple instances and nodes.
  • Worked with Real Application Cluster (RAC) databases.
  • Applied various patches which includes quarterly critical patch.
  • Upgraded oracle clients as per application needs.
  • Applied DST patches on multiple platforms.
  • Expertise in grants, permissions, roles and privileges
  • Developed views, materialized views, functions, procedures, triggers, packages using PL/SQL & SQL to transform data between source staging area to target staging area
  • Resolved gaps on standby databases
  • Worked with offshore DBAs
  • Written Shell scripts to automate jobs
  • Written Technical documents
  • Applied PSU patches on RDBMS homes
  • Perform Backup and Recovery thru RMAN
  • Full fill developers request to refresh schemas daily
  • Resolved DB performance issues
  • Worked as primary on-call DB
  • Used TOAD for various database Administration tasks
  • Used SRVCTL utility for managing multiple instances and nodes
  • Worked with Real Application Cluster (RAC) databases

Oracle DBA

Confidential - Brookfield, WI

Responsibilities:

  • Involved in 24x7 support for production RAC databases with on-call pager
  • Supported production, development and testing databases of Multi Terabytes DB sizes.
  • Installation of 12c and 18c clients/databases on RHEL and OEL
  • Complete Build of 4-node 12g RAC Cluster on OEL 7 from scratch.
  • Migrated 11g databases to 12c to 18c
  • Skilled with stats pack, AWR, ADDM, SAR to check health of database & hardware.
  • Used Performance tuning tools such as tkprof, explain plans, oradebug and tracing
  • Administered databases on Exadata x7
  • Performed database cloning to setup test and development database.
  • Migrated databases to different data datacenter.
  • Handled RAC Node hangs and node eviction issues.
  • Maintaining schemas and partitioning tables.
  • Migrated databases to AWS
  • Setup DR using Oracle Standby on Amazon cloud.
  • Monitored databases using 13c cloud control and via shell scripts.
  • Index management for better performance, maintenance of Oracle Database
  • Developed RMAN scripts for database backup and recovery
  • Responsible for administration and supporting oracle 11g, 10g and 9i databases
  • Created, upgraded, and cloned Oracle databases for Development and testing databases.
  • Tablespace management
  • Expertise in User and profile management
  • Build Data Guard using Maximum Performance Mode.
  • Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.
  • Performed administrative maintenance, monitoring on Oracle database systems in a global
  • Provided 24x7 operational support.
  • Involved in gathering requirements from end users.
  • Experience in performance tuning using different tools and methods.
  • Install databases using silent install and via scripts.
  • Database performance analysis using ASH, AWR and ADDM reports
  • SQL Trace and Execution Plan.
  • Database cloning using RMAN
  • Refreshed database using export import and Data Pump

Oracle DBA

Confidential, Madison, WI

Responsibilities:

  • Installing ASM environment and migrating database from NON-ASM to ASM.
  • Configure and manage tablespaces, tables, and users for custom applications.
  • Developed views, materialized views, functions, procedures, triggers, packages using PL/SQL & SQL to transform data between source staging area to target staging area
  • Performed various user management tasks.
  • Expertise in managing user profiles
  • Expertise in grants, permissions, roles and privileges.
  • Experienced with Space Management and Security.
  • Experienced with GUI and CLI to manage database farm house.
  • Rebuilding of Indexes for better performance and maintenance of Oracle Database.
  • Tuning high - resource queries introducing hints and creating indexes/parturitions
  • Configured and Maintenance of SQL Server databases
  • Implemented and managed 11g Data Guard
  • Resolved gaps on standby databases.
  • Worked with offshore DBAs.
  • Written Shell scripts to automate jobs
  • Written Technical documents.
  • Helped development team in optimizing queries
  • Applied PSU patches on grid and RDBMS homes.
  • Troubleshoot networking issues between primary and standby site.
  • Implemented Oracle high availability solution using oracle RAC, Physical Standby
  • Importing data from flat files into database using SQL loader and External Tables
  • Written shell scripts to automate the tasks
  • Physical and Logical database design.
  • Database sizing, Capacity Planning.
  • Worked on relational modeling using ERWIN.
  • Worked very closely with development and application team
  • Worked with offshore DBA team in India
  • Perform capacity planning required to create and maintain database environments.
  • Supported 24/7 on-call pager support for mission critical financial databases.
  • Involved in designing new structures/procedures/views/functions for development and data migration from production to reports.
  • Created users, roles and granted privileges according to the business requirements.
  • Data Modeling, Database Design and creation using Erwin.
  • Configuring TNSNAMES.ORA and LISTENER.ORA for SQL*NET connectivity.
  • Experience with pre-production and production of Oracle 10gR2 with multi node RAC with ASM
  • Automated the replication process using materialized views for reporting databases.
  • Applied latest patches as per evaluation requirement.
  • Implemented Oracle database backup & recovery solutions using RMAN.
  • Extensive use of Oracle Data pump, Exports/Imports utility for moving data among the servers.
  • Performed large batch jobs and tuning of SQL queries and database systems.
  • Created indexes to facilitate easy user interface implementation and tuning.
  • Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic
  • Perform Backup and Recovery thru RMAN.
  • Full fill developers request to refresh schemas daily.
  • Resolved DB performance issues.
  • Worked as primary on-call DBA.
  • Used TOAD for various database Administration tasks.
  • Used SQL*Loader to move data from flat files into an Oracle database.
  • Used SRVCTL utility for managing multiple instances and nodes.
  • Worked with Real Application Cluster (RAC) databases.

Oracle DBA

Confidential, Menomonee Falls, WI

Responsibilities:

  • Installing, upgrading and maintaining Oracle RDBMS on UNIX, Linux platforms.
  • Maintaining databases from all the environments from all pre-production to production which are on RAC and monitoring the Analytics environment using Oracle Streams.
  • Experienced in ORACLE 10g installation, configuration, and upgrading.
  • Experience with rolling upgrade to Oracle 11G RAC.
  • System Development Life Cycle (SDLC) methodology for designing, analysis, development and implementation.
  • Worked with lead DBAs for preparing cluster, configuring, installing Cluster ware and Oracle
  • 10g RAC on AIX and HACMP.
  • Installation, Configuration, Upgrading, Migration and Maintenance.
  • Configure, maintain and deploy the Data Guard and grid control.
  • Installing and maintaining Oracle GRID CONTROL
  • Configured Workload Management, JDBC, FAN, TAF, ASM, and RMAN for maximum performance.
  • Worked extensively on Oracle Streams.
  • Troubleshoot OCFS2 install issues and working with Enterprise Manager.
  • Design and implement Auditing and other security features for the existing Production systems.
  • Raised SR and TAR with Oracle Support.
  • Used Oracle Enterprise Manager (OEM) for administering several databases
  • Backup of database Logical and Physical (hot and cold) procedures and using RMAN.
  • Migration from Linux to Solaris and 32 bit to 64 bit.
  • Restore and Recovery of database in case of database crash, disk/media failure.
  • Applying patches and works closely with Oracle to make Application environment up to date.
  • Backups & Recovery Maintenance, Databases Performance Tuning.
  • Typically involved in database Designing, creation and maintenance.
  • Good working knowledge of SQL, PL/SQL, and shell scripting.
  • Created users and grant privileges according to the requirements.
  • Working knowledge on UNIX administration on AIX server.
  • Provided System support for both development and 24*7 production environments.
  • Performed automated backups and scheduling using scripting.
  • Responsible for migration of databases.
  • Worked with Data pump to take the logical backups of databases and Experienced in performing Point in time recovery using RMAN.
  • Involved in designing logical and physical data models using Erwin.

Hire Now