EPAENETUS KONA

able2a@r.postjobfree.com

972-***-****

Experience Summary

Over 7 years of information technology experience which includes Oracle

Database Administration on 24x7 critical production and large databases of

over 6-10 TB using Oracle 11g(RAC), 10g(RAC), 9i, 8i.

. Experience providing 24X7 on-call support to maintain all Databases up

and running in Production environment.

. Implementation of High Availability solutions with Oracle 10g RAC,

Standby Database Data Guard, Replication.

. Experience in Installing, tuning the general performance of the Oracle

Products.

. Have worked of 6+ years on UNIX environment.

. Experience with Upgrading the Database from 9i to 10g and 10g to 11g.

. Good experience on Oracle DBA/PL-SQL.

. Have good Experience on IBM-AIX Operating System to handle Oracle

Databases.

. Have experience with DB Architecture design, physical and logical

design.

. Good Experience in PL/SQL Programming. Was responsible for the PL/SQL

tuning too.

. Have good Expertise in Labeling for security purpose.

. Have experience with DB performance tuning.

. Expertise in Database Capacity Planning for the maintenance of the

system.

. Have Worked with OEM tools like Grid Control used for the performance

tuning of the database.

. Experience with database refresh tools like RMAN.

. Experience with network related issues, as how to configure and setup

the network.

. Have experience with PL/SQL programming.

. Experience with design, development and maintenance of the SaaS

database system.

. Extensive programming skills in C, C++, Java etc.,

. Expertise in interface implementation for application/database

connectivity.

. Ensure the database components are in sync with the specifications.

. Experience with utilities to perform automated problem shooting and

other optimization tasks.

. Experience with Oracle Architecture and Installing and configuring the

Oracle Database.

. Experience with OLAP and Data Mart designs and concepts.

. Experience with Large Databases like Multi-Tera Byte Instance

management and Partition management.

. Experience with SQL - PL/SQL, Stored Procedures and triggers and

Oracle Tools.

. Experience in developing and Maintaining Custom Applications for

Oracle.

. Experience in installing Third Party Tools for Oracle Environment.

. 6+ years of Experience Working with Oracle, understanding the

Architecture and process of Oracle Server( 9i, 10g, 11g).

. Experience with RMAN CLOING, RMAN HOTBACKUP etc.

. Have experience with import/export of the database for schema update.

. Experience with development of Large scale, complex applications

involving on-line and batch environment.

. 5+ years experience on PL/SQL SCRIPTING.

. Experience in Transition of System, transfer of knowledge and

mentoring.

. Worked on MS SQL 2000, 2008.

. Experience in contacting the oracle support for oracle bugs(TAR) .

. Have Good Knowledge of SYSBASE Database systems.

. Experience in working with vendors for application support and

database design.

. 5+ years of experience with scripting manual database tasks.

. Have good implementation skills with tasks that related to DBA

envirnoment.

. Experience with Data Migration tools & techniques, Data Migration

tools like Data Stage.

. Installations of Oracle 9i /10g/ 11g on Sun Solaris/Red Hat Linux

AS/HP-UX/IBM-AIX/Windows platform.

. Had experience with streaming and replication.

. Experience with Oracle Data guard - Physical & Logical Standby

databases.

. Database migrations from UNIX to Linux of size up to 10TB.

. Experience working with Export/Import, Data pump.

. Experience with Oracle 9i and 10g Partitioned Tables.

. Experience in managing large data warehouse databases.

. Working experience in OLTP and DSS environments.

. Backup of Databases (Making Backup Schedules depending upon Business

Strategy: Daily Backup, weekly Backup etc.)

. Recovery of Databases (Recovering from Media Failure, Recovering

tables dropped accidentally, Recovering data files, Recovering from

Block Corruption etc.).

. SQL Development & Troubleshooting included file groups, data access,

odbc, indexes, stored procedures, triggers and table structures for

application behavior manipulation.

. Database performance tuning using STATSPACK, TKPROF, SQL Trace,

Explain Plan.

. Expertise in maintaining Database Security using auditing.

. Extensive performance tuning experience, specializing in instance

tuning, Oracle9i and 10g RAC tuning and SQL optimization.

. Expertise on Oracle 9i RAC, 10g RAC installation, upgrade.

. Knowledge of OEM, TOAD, Oracle grid-control

. Instance Cloning, Code migration processes.

NON TECHNICAL SKILLS:

> Having good communication skills.

> Capable of building and maintaining a positive relationship with

the client.

> Flexibility in prioritizing and completing tasks assigned.

Technical Summary

Databases : Oracle 7.x/8i/9i/10g RAC/11g RAC, MS SQL 2000,2008, MS

2008 entreprise

ERP Applications : Oracle Applications 11i

Operating Systems : HP-UX 10.x, 11.x, Sun Solaris 2.5, 2.6, 8, 9, 10,

IBM-AIX 5.1, 5.2, 5.3

RedHat Linux RHEL 2.1, 3.x, 4.x

and Windows ME/NT/2000/XP/7, windows office

suites.(word,excel).

Languages : SQL, PL/SQL, UNIX, Visual Basic.

Oracle Tools : RMAN, OAM, OEM, TOAD, SQL*Loader

Hardware/Storage : Sun E4500, Sun E10K, HP9000, RS6000, NetApp, EMC,

Veritas NetBackup, Tivoli

Storage Manager (TSM).

Data Modeling : Erwin, Informatica, ArgoUML, altova DB

design.

Education

. Bachelor of Engineering(Computer Science), JNTU, India.

Employment History

Client: Verizon, Tampa, Florida

May 2009 - Till Date

Role: Sr Database Administrator, Sr. Data Analyst.

Technologies: Oracle 9i and 10g RAC, RedHat Linux, AIX, Shell Scripting,

RMAN.

Responsibilities:

. Monitors performance and performance tuning and balancing application

needs on shared platforms.

. Worked with application team to get the correct design for the

application.

. Experience with RAC environment, as how to configure and maintain it.

. Have worked on OEM tools like Grid Control.

. Have experience with IBM-AIX Operating System.

. Upgraded the Oracle Database from 10g Version to 11g.

. Have Good Experience on Advanced Security methodologies.

. Experience with Network operations, responsible for maintenance of the

companies database.

. Hands on experience with PL/SQL, SQL, Stored procedures, Triggers,

Data mining.

. 6+ years of experience in scripting, analytic reports and SQL ad-hoc

queries, by urgent requests from various business units,

using SQL*Plus.

. Dealt with Data Vaulting for the maintaining the historical data.

. Always updated the new oracle parameter for the performance enhancing

of the database.

. Have Experience with Data-Sourcing and Data Validation Activities.

. Contacted the oracle support for oracle Bugs.

. Optimizing the size of the temporary and undo tablespaces as per the

future growth.

. Migrated the database from 2 node SUN 880 Cluster to 3 node SUN V490

cluster.

. Have experience with Database Program Design.

. Experience in the design, creation, and maintenance of computerized

databases.

. Develop solutions to complex problems with ingenuity and innovation.

. Experience supporting clients and improving technical solutions

. Defined data model sources to provide platforms for the design

complex.

. Upgraded database from 9i RAC to 10g RAC.

. Upgraded databases from 9i to 11g R1.

. Standby Database (Data Guard) setup and configuration.

. Managing, troubleshooting and resolving oracle database, RAC and

applications issues.

. Performing the upgrade process many times to refine the process.

. Created shell scripts to automate some common processes.

. Using Export/Import and Data pump for migration of databases.

. Performing monitoring and performance tuning.

. Used the AWR reports to tune the performance of database.

. Writing Shell Scripts for managing day-to-day activities and

automation of backup.

. Installation and configuration of Oracle Client software and Tools.

. Developed several reports using like Profit and Loss and Balance sheet

to support the Financial users of the company.

Client: Fedex, Memphis, TN Aug 2007 -

Apr 2009

Role: Sr Database Administrator, Data Architect.

Technologies: Oracle 9i and 10g RAC, HP-UX, Sun Solaris, Perl, Shell

Scripting, RMAN.

Responsibilities:

. 24x7 Oracle Production Database Administration including Oracle 10g

RAC.

. Worked as a Oracle database Engineer to help the developing team with

innovative solutions.

. Installed, configured and maintained Oracle Databases and

Applications.

. Good experience in Labeling Concepts.

. Have worked on OEM tools like Grid Control for monitoring the

database.

. Experience on IBM-AIX operating System.

. Have worked on Security issue of the database using the Advanced

Security concepts.

. Coordinated with business architects in developing analysis

compositions.

. Major tasks were Performance tuning of the Database and PL/SQL

statements.

. Experience with Unix OS and Solaris.

. Good experience with RAC environment, having 3 to 4 nodes on it.

. Experience in maintaining utilities to automate problem indication and

monitoring activities.

. Developed new ways of handling data storage and strategies.

. Good experience with Data Vaulting for maintain the data of various

relational databases.

. Worked on Technical Problems, analyze and resolve them, on Object-

Oriented applications and infrastructure relating to Datatbase

Technology.

. Analyzed data access, integration, and storage requirements for

databases efficiency.

. Worked closely with an application development team to make sure the

database tier is used the right way.

. Worked with developing team to come out with efficient solutions to

increase the performance of the database.

. Consults and advises users on access to various databases.

. Worked with financial application like Oracle Financial.

. Have worked on MS SQL 2008 Entreprise edition.

. Installing and configuring ASM.

. Managing, troubleshooting and resolving oracle database, RAC and

applications issues.

. Refresh/Cloning of Database and applications for development and

testing purpose.

. Involved in Upgrade/Migration of the oracle databases from Oracle 9i

to Oracle 10g.

. Migrated databases from HP-UX to IBM-AIX.

. Experience using Export/Import and Data pump for migration of

databases.

. Working with Oracle 9i and 10g partitioned tables.

. Standby Database (Data Guard) setup and configuration.

. Working alongside programmers and contributing to the development

process; Enabling and analyzing trace files

. Performing monitoring and performance tuning

. Planning and recommendations for optimum performance

. Defining and Setting backup and recovery procedures.

. Configuration of backup.

. Tuning the database using stats pack and custom scripts

. Capacity Planning

. Responsible for continuous database monitoring and reorganization for

ensuring performance

. Partitioning large objects to improve the performance and

manageability

. I/O Tuning and balancing I/O by monitoring file system and tablespace

I/O statistics.

. Tuning SGA, I/O Tuning, Identifying contention, waits and tuning.

. Experienced in Tuning SQL statements using Explain Plan, SQL Trace,

TKPROF and STATSPACK

. Writing Shell Scripts for managing day-to-day activities and

automation of backup.

. Optimal Space utilization in tablespace by avoiding fragmentation

. Usage of Partitions to improve the query performance and

manageability.

. Installation of Oracle RDBMS server software and version upgrades.

. Backup of Database (Making Backup Schedules depending upon Business

Strategy: Daily Backup, weekly Backup etc.)

. Recovery of Database (Recovering from Media Failure, Recovering tables

dropped accidentally, Recovering data files, Recovering from Block

Corruption).

. SQL and PL/SQL Programming

. Installation and configuration of Oracle Client software and Tools.

. Developed a program to extract customer transaction data.

.

Client: Sewell Automotive Companies, Houston, Tx.

Dec 2005 - Jul 2007

Role: Sr Database Admin, Finance and Insurance Manager.

Technologies: Oracle 9i and 10g RAC, Red Hat Linux, HP-UX, AIX, RMAN, SQL,

Shell Scripting.

Responsibilities:

. Ability to be a self-starter as well as cultivate and develop customer

relationships.

. Installation, Configuration, Upgrade, patching of Oracle RDBMS and

applications.

. Refresh/Cloning of Database and applications for development, testing

. Performance Tuning of the database (Memory Allocation Tuning, I/O

Tuning, Tuning Contentions)

. Create table spaces, tables, and users for custom applications.

. Maintain user security.

. Assist Programmers and Developers with Oracle problems.

. Write UNIX shell scripts to monitor and maintain the Oracle

Applications database.

. Answer users' questions on an ongoing basis.

. SQL and PL/SQL Programming. Involved in developing PL/SQL functions,

procedures, packages, and triggers. Involved in creating tables, views

etc.

. Cloning databases and partitioning tables.

. Define process and procedures for uploading legacy data to interface

tables.

. Write SQL, PL/SQL to load legacy data to interface tables

. Backup of Database (Making Backup Schedules depending upon Business

Strategy: Daily Backup, weekly Backup etc.)

. Recovery of Database (Recovering from Media Failure, Recovering tables

dropped accidentally, Recovering data files, Recovering from Block

Corruption).

. Partitioning strategies for very large tables. Partitioned

large objects to improve the query performance and

manageability.

. Writing PL/SQL procedures for Extraction Transformation and

Loading of data.

. Generated trace files to tune database.

. Created and executed stats pack to generate report.

. Applied all the latest patches for Oracle database.

. Maintained databases with OEM.

. Restored database from backups when required.

. Refreshed with data from other environments.

. Fixed database, user and applications problem.

. Cloned the databases.

. Created user, roles and granted appropriate privileges.

. Installed the Oracle 9i and application tools on Redhat Linux AS

. Involved in the meetings and discussions relating to the midrange

infrastructure

. Implemented storage parameters of database objects like tables,

indexes etc

. Implemented user security and authentication within the development

database environment

. Developed future storage requirements for production database

. Involved in maintaining system security, auditing database objects and

system privileges and managing system privileges and roles

. Monitored sessions using Oracle Enterprise Manager

. Trouble shooting performance issues using Explain Plan, SQL Trace and

TKPROF

. Involved in synchronizing the development database with production

database

Client: GE Capital Information Systems, Hyderabad, India

May 2003 - Oct 2005

Role: Sr Oracle DBA

Technologies: Oracle 8i, Oracle 9i, Oracle Applications 11.5.7, PL/SQL, SQL

Plus, RMAN

Responsibilities:

. Worked on Database admin tasks like cloning the Production instance to

other instances like Development, QA and Test.

. Experience with SQL, PL/SQL, stored procedures, triggers.

. Refreshed the TEST Databases from the Production database for testing

purpose.

. Applied Patch sets and Patches to the various Oracle environments.

. 24 X 7 Production database administration, support and monitoring to

ensure a proactive problem recognition and resolution of database

issues

. Installed and configured Oracle RDBMS on UNIX and Windows

environments.

. Creating primary database storage structures (table spaces, rollback

segments, etc).

. Applied patches, keeping applications software bug free, and improving

data integrity.

. Developing, Testing and Implementing Sound backup and Recovery

Strategy.

. Developing Hot, cold and logical backup scripts to automate the backup

procedures.

. Planning for storage spaces requirements and placing them for optimum

I/O performance.

. Tuning the databases for optimal performance.

. Maintained all documents of Oracle database operations. Prepared

documentation of database backup and recovery standards.

. Performing all daily Maintenance tasks. Interacting with Oracle

Customer service as and when required.

. Writing scripts for the system and database for the effective

functionality and report generation.

REFERENCE : Available upon request.

KONA EPAENETUS.

Contact this candidate