Post Job Free
Sign in

Oracle Manager

Location:
Chicago, IL
Salary:
$70/hr c2c
Posted:
April 21, 2015

Contact this candidate

Resume:

SUMMARY OF SKILLS:

o Over * years of experience as an Oracle Database Administrator.

o Good knowledge on Oracle Apps 11i & R12, Oracle Database 8i, 9i, 10g

and 11g.

o Expertise on Installation, Upgradation, maintenance and administration

of Oracle 9i, 10g RAC, 11g RAC Database.

o Supporting for Exadata machines

o Expertise on implementation golden gate for replication.

o Expertise in installing different versions of Oracle on Linux and

Solaris.

o Good knowledge on Oracle advanced Technology RAC, Data guard, OEM,

Grid Control, ASM and Replication using Materialized Views, Oracle

Streams.

o Good in Migrating databases

o Good knowledge on VERITAS, NetApp Backup's, BCV and EMC Storage

Backups.

o Configured Golden Gate.

o Upgraded the database from 9.2.0.1 to 10.2.0.1 and 10g to 11g.

o Installed oracle 11g client and server software.

o Having experience in database cloning using RMAN,HOT,COLD backups

o Working in 24X7 on-call production database support and maintenance

including remote database support.

o Experienced in development and production on Stand Alone and RAC

o Extensive knowledge in Oracle standalone, RAC database architecture.

o Delivering Oracle Database performance-tuning services for customers

with EXPLAIN PLAN, TKPROF, STATSPACK, AWR, SQL TRACE.

o Having experience in applying patches for database and applications.

o Capable of troubleshooting the troublesome sql statements.

o Generated ADDM for taking the advisories of a database performance.

o Configured Data guard and tested for failover and switchover

o Monitoring index usage and Performed Rebuilding of Indexes.

o Performed table and table space level defragmentation.

o Having experience in cloning and migrating database from Linux to

windows.

o Applied latest patches and bug fixes for 11g .

o Experienced in taking regular off-line, online and logical Backups.

o Good Knowledge on languages C, Java, SQL, PL/SQL, UNIX Shell and Perl.

o Experienced in taking an RMAN backups to tape and disk.

o Experienced in assigning user level issues.

o Good Exposure on Performance Tuning and database design.

o Proficiency in creating business and technical project documentation

o Expertise is working with distributed and global project teams

o Project Resource planning and allocation

o Ability to work as a strong team leader to ensure quality and timely

project execution

TECHNICAL SKILLS:

Databases Exadata, Oracle 9i,10g RAC, 11g RAC, 12c, MS Sql

Server.

Operating Systems OEL, RHEL 2.1, 3.x, 4.x, 5.x, 6.x, Sun Solaris 9.0/10.0,

HP 10.x, 11.x, AIX 5.3, 5.2, 5.1 and Windows200X/NT/98.

Programming& SQL, PL/SQL, C, C++, UNIX Shell Scripting, JAVA

Scripting Languages

Tools & Utilities EXADATA,RAC, Golden Gate, Shareplex, OEM, Toad, Tidal,

Site Scope, SQL Navigator, SQL* Loader, ASM, SQL

Server,Export/Import, RMAN, TOAD, Patch Management, SQLNET,

ODBC, Export/Import, Data pump, Data Guard, VERITAS Net

Backup, VMware, Logminer, CronTab, Remedy, Client

ticketing systems

Tuning Tools ADDM, AWR, TKPROF, EXPLAIN PLAN, STATSPACK

Terminal Emulation Putty, Telnet, FTP

Applications Oracle applications R12

EDUCATIONAL QUALIFICATION:

Bachelor of Science from Nagarjuna University, India.

PROFESSIONAL EXPERIENCE:

Project#1

Client United states Gypsum, Chicago, IL

Role Sr. Oracle DBA

Duration January 2014 to Till date

Environment 10g and 11g with RAC, Exadata

Linux, Solaris, Aix,Golden Gate, Oracle

applications R12.

Responsibilities:

o Supporting for Exadata machines and Golden Gate.

o Supporting for oracle application R12.

o Installation, Configuration and administration of Oracle 11g/10g

database on Red Hat Enterprise Linux (RHEL) and also Upgradation from

Oracle 10g to 11g.

o Configured 3-node Real Application Cluster (RAC) and monitored RAC

instance with Oracle Enterprise Manager Grid Control.

o Installed and Configured Oracle Enterprise Manager Grid Control 11g.

o Upgradation of Grid Infrastructure and Oracle Databases from 11.2.0.1

to 11.2.0.3 on 3-node RAC environment.

o Migration of database from one server to another server with zero

downtime.

o Migration of Application Databases from SQL to Oracle.

o Implemented Data guard, creating physical standby databases in 10g and

11g RAC environment for production database.

o Installed, Configured and Administered Golden gate.

o Configured parameters for the Bi-directional replication.

o Performed conversion Non RAC single instance to Real Application

Cluster (RAC) database instances.

o Using Oracle Data Pump utility making faster exports/imports on large

databases and saving lot of time.

Project 2

Client Time Warner Cable,Charovelott, NC

Role Sr. Oracle DBA

Duration August 2011 to January 2014

Environment 10g and 11g, Exadata, Linux, Solaris, Aix,Golden Gate, shareplex,Oracle applications .

Responsibilities:

o 24x7 Production database and applications support

o Managing multiple production, testing, QA and development databases.

o Installation, configuration and administration of Oracle RAC and

Standby Databases (DataGuard) for High Availability and Disaster

Recovery.

o Supporting for Exadata machines and Golden gate.

o Patching and upgrading to 11g

o Monitoring and maintaining cluster DB's for their Optimal

Performance and

o Trying to ensure 100% availability of the DB's.

o Implemented 4-Node RAC with raw devices and ASM Library Interface.

o Allocating and reorganization of tablespaces.

o Incorporating user's requests as per Emails.

o Job scheduling using dbms_job and crontab.

o Backup database using export/import.

o Taking backups using RMAN.

o Performed Database Cloning from Production to Test environment.

o Performance monitoring and tuning using STATSPACK, TKPROF, SQL

Trace, Explain Plan, AWR, ADDM..

o Maintenance of Database and Listener.

o Moving data between databases using utilities like Import, Export,

SQL loader

and Transportable Table spaces.

o Checking Alert log, trace files, listener log and other database job

logs.

o User creation and providing necessary Roles, Privileges and quota as

per the

requirement.

o Implemented RMAN backup strategy.

o Administered the RAC database by using srvctl & crsctl utilities

o Moving data between databases using utilities like Import, Export,

SQL loader

o and Transportable Table spaces

o Preparing scripts to automate the jobs.

o Housekeeping of arch files and trace files.

o Taking the online and offline backups according to the manager

approval.

o Preparing AWR report for database health checkup and for performance

improvement.

o Creating DB links, resizing of table spaces, allocating quota for

users.

o Decommissioning of Schemas as per approved requests.

o Consistently interacted with client and team in resolving the

queries.

o Working on Tickets to handle the sev 1/2/3/4 issues.

Project 3

Client dbaDIRECT, USA

Role Oracle DBA

Company SLK Software services Pvt Ltd

Duration September 2010 to August 2011

Environment 9i,10g and 11g,oracle R12

Linux, Solaris, Aix and Windows

Responsibilities:

o 24x7 Production database and applications support

o Managing multiple production, testing, QA and development databases.

o Installation, configuration and administration of Oracle RAC and

Standby Databases (DataGuard) for High Availability and Disaster

Recovery.

o Supported for both oracle databases and applications.

o Providing *24/7 Support on production instances

o Configuration Recovery Manager (RMAN), Dataguard, Distributed

Database

o Database version Upgrades from 10.2.0.1 to 10.2.0.4

o Moving the Database across the platforms

o Cloning databases through RMAN with Auxiliary

o Configured the Clone databases from Production to reporting

databases

o DBA support for Production, QA and Development teams.

o Perform regular database activities like space management, database

health check-up etc. Troubleshooting and resolving numerous

production issues.

o Implementation of Scheduled Change Control requests on Productions.

o Involved in migration of database from 9i to 10g.

o Allocating system storage and planning future storage requirements

for the database system.

o Refreshing test database with production database when required.

o Administered databases remotely.

o Monitoring Alert log & System log files.

o Created users & privileges with appropriate roles and levels of

security.

o Troubleshooting Oracle connectivity issues.

o Implementation of Backup and Recovery Strategies.

o Planning & performing hot and cold backups.

o Moving data between databases using utilities like Import, Export,

SQL loader and Transportable Table spaces.

o Installed & configured 2-Node RAC using OCFS as cluster file system

and ASM lib.

o Configured high availability services for Transparent Application

Failover(TAF)

o Taking backups using RMAN

o Performed Node Eviction issues

o Patched and upgraded 10.2.0.1 databases to 10.2.0.4.

o Performed Database Cloning from Production to Test environment

o Monitoring and maintaining cluster DB's for their Optimal

Performance and

Project 4:

Client Allianz General Insurance Co. Ltd, Hyderabad,

India

Role Jr. Oracle DBA

Duration December 2006 to August 2008

Environment 9i,10g and 11g

Linux, Solaris, Aix and Windows

Responsibilities:

o Monitoring and maintaining cluster DB's for their Optimal Performance

and

o Trying to ensure 100% availability of the DB's.

o Allocating and reorganization of tablespaces.

o Incorporating user's requests as per mails.

o Job scheduling using dbms_job and crontab.

o Backup database using export/import.

o Taking backups using RMAN.

o Creation of DB_LINKS.

o Performed Database Cloning from Production to Test environment.

o Monitoring and optimizing the performance of the Database through

Stats pack/AWR.

o Maintenance of Database and Listener.

o Moving data between databases using utilities like Import, Export,

SQL loader

and Transportable Tablespaces.

o Checking Alert log, trace files, listener log and other database job

logs.

o User creation and providing necessary Roles, Privileges and quota as

per the

requirement.

o Decommissioning of Schemas as per approved requests.

o Resolving user's day-to-day issues.

o Consistently interacted with client and team in resolving the queries.

o Working on Tickets to handle the sev 2/3/4 issues.

Project 5:

Client Axis Bank, Hyderabad, India

Role Associate Oracle DBA

Duration August 2005 to December 2006

Environment 8,9i,10g and 11g

Linux, Solaris, Aix and Windows

Responsibilities:

o Providing *24/7 Support on production instances

o DBA support for Production, QA and Development teams.

o Perform regular database activities like space management, database

health check-up etc.

o Troubleshooting and resolving production issues.

o Refreshing UAT & QA with Production Database.

o Implementation of Scheduled Change Control requests on Productions.

o Involved in upgradation of database from 9i to 10g.

o Administered databases remotely.

o Monitoring Alert log & System log files.

o Created users & privileges with appropriate roles and levels of

security.

o Managing privileges and roles to ensure database security.

o Troubleshooting Oracle connectivity issues.

o Implementation of Backup and Recovery Strategies using RMAN.

o Planning & performing hot and cold backups.



Contact this candidate