We provide IT Staff Augmentation Services!

Oracle Dba Resume

Peoria, IL

SUMMARY:

  • Over 8 years of IT experience and 8 plus years of Oracle RAC DBA experience
  • Build Managed and Administered 11g and 12c RAC.
  • Build and manage 12c/13c Cloud Control.
  • Worked as a lead in Data Center Consolidation on large database systems.
  • Mentors the team on technology concepts and ensures team compliance to best practices for design
  • Participates in code and design reviews to ensure quality and conformance to product standards
  • Helps motivate team members to get the best out of team.
  • Worked as a Primary support for database related issues with clients.
  • Worked on multiple projects in parallel to daily DBA activities.
  • Worked extensively on ASM Builds and management of ASM Filesystem.
  • Implemented Disaster Recover Site with Data Guard and maintained Active Data Guard.
  • Performed Database Tuning & Performance, Storage Management, Plan growth and changes (capacity planning), Database Monitoring, Security Management and Tuning SQL queries.
  • Worked on Oracle Materialize Views, Oracle Golden Gate and Oracle Active Data Guard.
  • Build 13c OEM Cloud Control and managed OMS and OMR.
  • Configure 11g Active Data Guard.
  • Managed databases on Exadata.
  • Proficiency in analysis, design, development, testing, implementation and maintenance of applications in Oracle Application Express (APEX) and client/server configurations.
  • Worked on Hybrid Columnar Compression (HCC) that provides dramatic reductions in storage for large databases
  • Participated in analysis and designing of Oracle Exadata Server for infrastructure and related projects.
  • Assisted in integration of Exadata applications into current IT actionable events and solutions.
  • Migrating databases to Oracle Exadata Database Machine for different clients
  • Analyzing database performance and tuning database on Oracle Exadata using Real Application Testing (RAT)
  • Implementing Best Practices for migration E - Business Suite and regular databases to Oracle Exadata
  • Installing, configuring and maintaining Enterprise Manager Cloud Control to monitor and manage Exadata and regular databases
  • Used tools like TOAD, DB Console, Confio, and Grid Control to monitor database performance.
  • Build and administer SQL Server 2005 and 2008 standalone and cluster databases.
  • Provided analysis to other teams and keep them informed for better resource management.
  • Evaluated Oracle features and Oracle related products to leverage existing hardware/software/incenses.
  • Build, configured and managed 8i to 12c databases.
  • SQL Access Advisor, Performance Analyzer, Plan Manager, Automatic SQL Tuning, SQL performance analyzer, Table compression and SQL access advisor, SQL plan management and Database replay
  • Table compression enhancement,
  • Worked with Network team for SCAN listener
  • Build and managed container and pluggable 12c databases.
  • Worked on Upgrade projects.
  • Worked on Migration projects.
  • Participated in design, document and deployment of database/
  • Provides technical assistance for many platforms, during issues and/or outages. Areas include but are not limited to Oracle, Peoplesoft, homegrown monitoring applications, operating systems, hardware components and the network infrastructure.

TECHNICAL SKILLS:

Operating Systems: Windows NT/2000/XP, Sun Solaris, HPUX, Redhat Linux, AIX

Languages: SQL, PL-SQL

RDBMS: Oracle 12c/11g/10g/9i, MS Access, MS SQL Server 2000, DB2

Tuning Tools: TKPROF, EXPLAIN PLAN, STATSPACK, ASH, AWR, ADD

Tools:: RAC, OEM Grid Control, SQL* Loader, ASM, SQL Server, Export/Import, RMAN, NETCA, DBCA, TOAD, Patch Management, SQLNET, ODBC Export/Import, Data pump, DataGuard, VERITAS Net Backup, VMware

PROFESSIONAL EXPERIENCE:

Confidential, Peoria, IL

Oracle DBA

Environment: Oracle 11g, 12c, Exadata, AWS, GoldenGate

  • Supported database on Exadata X7
  • 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
  • Involved in 24x7 support for production RAC databases with on-call pager
  • Supported production, development and testing databases of Multi Terabytes DB sizes.
  • Configuration, troubleshooting GoldenGate issues
  • Setup Uni-directional GoldenGate setup.
  • Setup and managed replication using Oracle GoldenGate
  • Worked on Data Migration project.
  • Migrated databases from Windows platform to Linux.
  • Upgraded from 11g to 12c.
  • Migrating database from NON-ASM to ASM.
  • Migrated databases to AWS
  • Build new servers on AWS
  • Worked on project to migrate databases to AWS instance
  • Set up oracle instances on AWS cloud
  • Maintained databases and alerts from 13c cloud control (OEM)
  • Migrated standalone databases to RAC on Exadata
  • Oracle DBA in 12c, 11g, with 9+ year's professional IT work experience
  • Worked on 12c Multitenant databases
  • Setup unidirectional GoldenGate replication
  • Rolling install oracle patch in Oracle RAC 11g and 12c
  • Upgraded database from 11g to 12c R2
  • Cloned databases using RMAN Duplicate
  • Installation of 11g, 12cclients/databases on Solaris and Linux.
  • Complete Build of 4-node 12c RAC Cluster on RHEL
  • Skilled with statspack, AWR, ADDM, SAR to check health of database & hardware.
  • 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.
  • Experienced with all kinds (Status, Performance, and Trend Analysis) of DB Monitoring.
  • Index management for better performance, maintenance of Oracle Database
  • Developed RMAN scripts for database backup and recovery
  • Responsible for administration and supporting oracle 11g, 12c databases
  • Performed large batch jobs and tuning of SQL queries and database systems.

Confidential, Irving, TX

Oracle DBA

Responsibilities:

  • 24x7 product database support
  • Installed and maintained 10g/11g databases for testing, development and production
  • Database Monitoring and administration of database using Enterprise Manager Grid control OEM
  • Upgraded Oracle Database from 9i to 10g, 10g to 11g.
  • Migration of the database from HP-UX to Linux.
  • Planned and implemented Oracle 10g RAC, 11g RAC, Standby databases for High Availability and DR solutions
  • Cloning of the database from Production to the Test and Development environments using RMAN and conventional methods.
  • Applied security related CPU and One-off patches using Opatch utility, Applied RDBMS Patch set Utility PSU
  • Installed and configured oracle grid control.
  • Used Oracle Streams for replications of data between remote databases
  • Performed Cold backup, hot backup using conventional backups and RMAN, recovered various and critical Production databases.
  • Prepared backup schedule which include offline, online and logical backups.
  • Used Export/Import, Data Pump Utilities to move the data between different databases and for backups.
  • Worked on transportation of Table spaces, Data Archival, Re-organization of tables and restoration.
  • Tuning of Shared Pool, Library Cache, and Data Dictionary Cache.
  • Monitor CPU usage, I/O contention, memory paging on UNIX server. Identify resource and performance bottleneck. Provide technical direction to system administrators
  • Rebuilding of Indexes for better performance, maintenance of Oracle Database.
  • Generated performance reports and Daily health check up of the database using utilities like AWR, Stats pack and ADDM to gather performance statistics.
  • Identified and tuned poor SQL statements using EXPLAIN PLAN, SQL TRACE and TKPROF, Analyzed tables, indexes for improving the performance of the Query.
  • Analyzed SQL statements, re-organized database objects and created indexes to improve the performance of the queries.
  • Partition of tables to improve performance.
  • Created users and allocated appropriate table space quotas with necessary privileges and roles for all databases.
  • Worked with Oracle Support for resolving the database related unresolved issues.
  • Worked on SQL Loader to load data from flat files, Checking for Row Migration and Chaining on Highly used transaction tables.
  • Configured TNSNAMES.ORA and LISTENER.ORA for SQL NET connectivity.
  • Created DB links across databases and Solved Database connectivity issues by continuously monitoring the status of the listeners and instances.
  • Monitored overall system performance and Database growth.
  • Served as a member of 24-hour on call support staff.
  • Checked alert logs and background trace files on daily basis and resolved problems.
  • Scheduled jobs in the database using CRON Jobs and DBMS JOBS.
  • Implemented backup for production database. Simulated few possible crucial recovery scenarios using the current available backups to check the effectiveness of the backup plans and also to get a rough estimate of the recovery time involved.
  • Automated shell scripts and scheduled batch jobs.

Environment: Oracle 9i/10g RAC/11g RAC, Red Hat Linux, Windows, HP-UX, Sun Solaris, AIX, SQL Server, PL/SQL, Shell Scripting, RMAN, Grid control, Data Guard, SQL Loader, EXP, IMP, Data Pump, TOAD, TKPROF, EXPLAIN PLAN, AWR, STATSPACK, ADDM, ASH.

Confidential, St. Louis, MO

Oracle DBA

Responsibilities:

  • Oracle DBA duties involving development and production support such as installations, configurations, backup/restore & recovery, database monitoring & operating system configurations, database performance tuning, assisting in the logical/physical database design, applications profiling, tuning queries and providing support to developers.
  • Performing Hot/Cold backups of the database through RMAN or User Managed method.
  • Setup and configured Oracle Physical Standby database (Data Guard), where the standby database was used for disaster recovery.
  • Generated and analyzed STATSPACK reports and monitored statistics for performance tuning of the database.
  • Review alert logs and dump files to check for any problems related to the database.
  • Perform database cloning/exp/imp to setup identical databases in the production and development environments.
  • Create and maintain users, roles and privileges.
  • Upgrade/Migrated the production and development databases from 11.2.0.3 to 11.2.0.4
  • Involved in discussions with the management regarding the advantages/disadvantages and upgrade plans.
  • Setup and configured 2 node Oracle 10g RAC with ASM.
  • Used Oracle 10g AWR & ADDM to monitor database activities and performance tuning.
  • Involved in Database sizing, Capacity Planning.
  • Installation and configuration of OEM Grid Control 12c.
  • Perform Space Management & Troubleshooting the database issues.
  • Upgrading OEM Repository and Installing OEM 10Grid Control to monitor all the databases.
  • Configured and managed agents to work efficiently with Grid Control.
  • Lead coordinator between technical operations team (DBA) and applications users/information systems/processing specialists
  • Setting up privileges to create local and remote objects
  • Create materialized views to refresh data at regular intervals.
  • Using materialized view logs to reduce the replication time costs for fast refreshes.
  • Configuring Oracle databases to effectively use the DISM (Dynamic Intimate Shared Memory) to dynamically shrink / grow the SGA.
  • Upgrading/Migration from Oracle 8i databases to 9i and to 10g.
  • Installing of quarterly security patches on all non-production and production servers.
  • Cloning/replicating/refreshing production databases to test/ development environments using RMAN scripts.

Environment: Oracle 9i, 10g /11g with RAC, Oracle Golden Gate, Oracle Data Guard, HP-UX 11i v3,, Sun Solaris 10, RHEL 6.x, TOAD, SUSE 10,11, Control-M, Autosys, PCS, SRDF Replication

Hire Now