| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Candidate's Name
Oracle Database Administrator
EMAIL AVAILABLE PHONE NUMBER AVAILABLE
_________________________________
PROFESSIONAL SKILLS
I have 4 years of experience as an Oracle Database Administrator. I possess complete life cycle
knowledge including Installation and configuration. Worked on Oracle 12c, 11g, and 10g versions. Daily
database administration tasks include production support, database upgrades, patch administration,
migration, installation and configuration, backup and recovery, performance tuning, database
cloning, and security management.
Experienced in Performance Tuning using EXPLAIN PLAN, TKPROF, and STATSPACK.
Expert in implementing High Availability solutions with Oracle 11g RAC, Oracle Data Guard
and replication using Streams.
Experience in Oracle (12c, 11g, 10g) Multi-tenancy, DataGuard, ASM, RAC database, Grid,
OEM, CPU patches, Oracle installation, database Upgrades, Migration, Backup, Recovery,
troubleshooting, SR (TAR) support, Golden Gate, configuring new & leas-rolling.
Proficiency with Installation and maintenance of replication tool Golden Gate by creating
extract process, extract pump, and replicate.
High ability to analyze and understand the AWR reports and can fine tune the databases for
maximum performance.
Experience in system Monitoring and Database Performance Tuning using Explain plan,
SQL Trace, TKPROF, AWR and also Cluster Interconnect Tuning (RAC)
Provided valuable inputs for various performance tuning issues using AWR, ASH and ADDM.
Performance Tuning of the database (Memory Tuning, I/O Tuning)
Expertise in Performing Tuning Database - Tuning involved I/O, Memory, CPU utilization,
SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's
regular performance tuning tools like Explain Plan, STATSPACK (perfstat), SQL*Trace,
TKPROF.
Installed, configured, and maintained Oracle 10g and 11gR2 on Linux and also Upgraded from
Oracle 10g to 11g.
Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
sky
1
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)) using "runInstaller" and perl based utility "opatch".
Independently built new 11g - 12c Databases from scratch on RHEL, OEL and Windows
platforms from planning, testing through Release Management to validation
Worked closely with support teams including Developers, SAs, Network, Backup, Storage and
Security
Collaborate with Oracle my support by submitting Oracle SRs to resolve complex incidents
Automated routine DBA tasks like database backup and db stats by using Grid control /Crontab.
Upgraded Oracle Databases from 10g to 11g and 10gRAC to 11gRAC.
Created RAC Database on Test Hosts refreshed them with the latest snapshot of data from Prod
Environment. Recovering the database from Block corruption.
Performed SQL and PL/SQL tuning oracle contention and monitored production database using
Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) and
Automatic Session History (ASH).
Experience in applying oracle patch set, Patches, Critical Patch Update (CPU)/Patch Set
Update (PSU) and One-off Patches using OPatch and run Installer.
Upgrading and Migrating Databases from lower versions to higher versions.
Experience in database migration by designing and implementing database logical and
physical storage structures.
Performance Monitoring and Tuning of Database, Application, System Global Area, I/O,
Rollback segments using self-developed scripts, Oracle Enterprise Manager, Spotlight on
Oracle, Toad, AWR, ADDM, ASH reports and Application tuning using Explain Plan, SQL
Trace,Tkprof Utilities and statspack.
Experience in optimizing database access and allocates/re-allocates database resources for
optimum configuration, database performance and cost.
Extensive experience in daily batch and report monitoring, space management, index rebuilds,
statisticscollection and other Oracle housekeeping tasks.
Developed database support processes and automated tasks through tools, PL/SQL and
UNIX Shell Scripting. Oracle SQL*Net, SQL, PL/SQL, writing triggers, functions and PL/SQL
procedures, Functions, creating Tables, Views and Indexes.
Expert in RMAN backups including full, incremental and cumulative.
Excellent knowledge in Flashback Recovery, Hot/Cold Backup and Cloning/Refresh of
databases using RMAN. Experience in applying patches/ patch sets to the databases.
Extensively worked on Import/Export and Data Pump Import/Export tools.
Knowledge in configuring ASM (Automatic Storage Management)
UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell
scripting, CRON jobs.
Knowledge of Database Recovery Techniques and implementation of those recovery techniques
to ensure business continuity.
Expertise in maintaining Database Security using auditing.
TECHNICAL SKILLS
sky
2
HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1
Operating Systems RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise Server 9, 10. Windows
95/98/NT/2000
RDBMS Oracle 12c, 11g, and 10g
Languages SQL, PL/SQL, UNIX Shell Scripting, PERL
TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM.Toad,
Tools Putty, NX client, Winscp, Remote Desktop Connection, VNC, Team
Viewer, LogMeIn and Cisco VPN Client
SQL*Plus, Oracle Enterprise Manager, Real Application Cluster, ASM,
Database Utilities Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export,
Import
PROFESSIONAL EXPERIENCE
Cardinal Health - Dublin, OH APRIL 2015 Present
Role: Oracle Database Administrator2
DBA supporting three major projects from Development to Production via Tech-Test environments,
involving daily configuration, administration all running on IBM AIX 5.2 & 5.3. Database sizes
range from 4GB to 2TB (in ODS & EDW environments).
Responsible for Build Work in various servers which has 3 Node RAC & Non - RAC, High
Availability, Golden Gate Technologies.
Experienced in Golden Gate Installation and Configuration for database replication purpose.
Solid experience with different versions of Golden Gate installation, configuration,
Administration, heartbeat monitoring etc.,
Supported 400+ databases including RAC production database, a Data warehouse database and a lot
of Development and Test databases and upgraded from 10g to 11g.
Provided Production & test environment support while coordinating with Unix Team and
storage team to configure the OS infrastructure for Oracle Databases.
Worked on setting up/installation and configuration of release 11g R2 RAC with ASM and Raw
Devices and 11g CRS on IBM AIX 6.1.
Performed conversion of Single Node Instance to multi node RAC with ASM, and adding
instance to existing RAC.
Installed and configured 6 node oracle 11gR2 RAC for production environment.
Installed 12c Databases and responsible for upgrading Oracle 10g RAC to 11g RAC.
Involved in Oracle Golden Gate installation, configuration, troubleshooting Golden Gate
EXTRACT and REPLICATE issues.
Implemented and administered Oracle Golden Gate (v10) for Database Replication between
production and reporting node, by using Oracle Streams in parallel to secure data and having
the availability of the database during regular the upgrade or maintenance operation.
Implemented Data Pump, Export and Import on day to day basis as per development and test
servers.
Responsible for Performance Monitoring and analysis of 11gRAC (Real Application Clusters)
with AWR (Automatic Workload Repository) reports and ASH (Active Session History).
Monitoring database performance and database operation to prevent downtime and slowness
of the services.
sky
3
Worked closely with the system operations team on database deployment processes and database
capacity planning.
Implemented backup and recovery procedures (Cold/Hot backups, RMAN Incremental
backups & Import/Export).
Cloning RAC to RAC and RAC to NON RAC using hot backup and RMAN.
Expertise in configuring and managing the Concurrent Managers, Workflow Notification
Mailers and monitoring their operation
Strong experience in Space and User Management, Capacity planning, standby setup, Backup
& recovery (Import/Export, Datapump, RMAN)
Delivering Oracle Database performance-tuning services for customers with EXPLAIN PLAN,
TKPROF, AWR, ADDM, SQL TRACE and SQLT
Handled Physical and Logical Corruptions and recovery using RMAN (Recovery Manager).
Applied database patches using Opatch utility & building Clone instances for Development
and Test teams.
Maintained and monitored various production servers with Oracle 11g R1, 11g R2, 10g, and exadata
servers.
Scheduled database maintenance tasks such as tables/indexes analysis, index rebuild, materialized
views refresh and db exports.
Maintained DATA GUARD to provide high availability by implementing physical stand-by
database and snapshot-standby and worked with Oracle 11g features 11g Grid Control and
Automatic Storage Management (ASM).
Troubleshooting Space Management & User accounts and privilege issues while coordinating
with Unix and application teams.
Performed proactive database maintenance procedures to ensure optimal performance and uptime
and implemented shell scripts for automation of day to day activities.
Identify Top SQL that are consuming heavy resources and provide support to the development
team in identifying SQL queries that are consuming high resources and interact with the
development team to see if these queries can be fine-tuned further.
Regular Security Patching and Critical patch Updates (CPU) and Patch set updates (PSU) on
Oracle databases and interim patches for various bug fixes on database products.
Production support for Oracle database 10g/11g RAC.
Implemented and configured of Oracle Enterprise manager OEM 12C and Oracle
Management Server for maintenance and monitoring of production databases.
Managing Users, Roles, privileges, profiles, schemas, SQL Monitoring, SQL Advisor, SQL
tuning and Metrics, using Grid Control of Oracle Enterprise Manager (OEM) 12C.
Creating and Managing Primary Objects like Custom tables, Procedures, Packages, Triggers,
Alerts & Functions. Views, Indexes, user accounts, roles, grants and performing day-to-day
operations.
Expert in monitoring database using Oracle Enterprise Manager (OEM).
Tools Used: Oracle RMAN, Oracle 10g (9.2.0.8), DBMS STATS, Data pump, SQL TRACE, TKPROF,
EXPLAIN PLAN
Weis Market Inc - Sunbury, PA Jun 2013 Dec 2014
Role: Jr Oracle DBA
sky
4
Running scripts and monitoring the load process to avoid any issues in ETL jobs running for a long
duration.
Monitored Database growth and provide Database capacity planning for applications expansion
or necessary re-organization of tables and indexes as and when required.
Performing Database Administration activities like space management, user and roles administration,
schema management, checking alert log of all the databases. Installed Oracle 10g and 11g on
multiple platforms.
Performed up-gradation of 10g to 11g.
Performed traditional Cold backup in appropriate environments via OS commands as well as logical
exports.
Automated routine DBA tasks like backup's and stats by using Grid control job's
Provided Assistance to application team at the time of SQL tuning in applications. Administration of
RAC and DATAGUARD databases in Oracle 11g.
Oracle DB System Development Life Cycle (SDLC) planning and Oracle DB 3-Tier architecture.
Setup RMAN solutions for all Oracle Databases -- created rman repository, provided best
practices, optimizations and data guard and cloning techniques -- restore and recovery .
Implemented and maintained Oracle 11g Data Guard/standby databases for switch-over and fail-
over purposes. Created, relocated and removed Services as needed in an Oracle RAC
configuration
Adding and removing nodes to existing Oracle database RAC configurations
Worked closely with diverse application development groups and served as single point of contact
for testing, tuning and implementing projects / solutions in production environment
Cloned and maintained multiple Oracle Database environments for Development, Testing &
UAT.
Carried out yearly DR Testing of Oracle ERP Systems / Critical Oracle Databases .
Applied various database / applications PSU / CPU patches as required. Also applied monthly
vertex updates.
Performed activities like monitoring the database and provide maximum uptime.
Created and granted users the privileges and roles and resizing the datafiles to manage database
growth.
Defined and implemented database backup and security strategies, tested the backups periodically
for consistency and reliability
Identified long-running database queries, refining queries for better performance, and working
with end- users to implement changes
Created primary database objects (tables, views, indexes) once application developers have designed
an application
Monitor database systems and provide technical support for database system issues and application
performance enhancement/improvement using both Oracle 10g Grid Control & SQL*Plus, as well
as UNIX shell scripts.
Created the database objects such as Tables, Indexes, Views, Database Triggers, Procedures,
Functions, etc.,.
Environment: RHEL 4.4, HP-UX, 10g, and 11g, Oracle 10g/11g RAC, ASM, Data Guard, Oracle
Enterprise Manager (OEM), RMAN, ASM, STATSPACK, EXPLAIN PLAN, TOAD, ERWIN 7.2,
Autosys, Golden Gate, SQL*Plus, PL/SQL, SQL*Loader
EDUCATION
sky
5
PGCC
-Information Technology
sky
6
|
