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.