[pic]

Koteswara Rao

[pic] Sr.Oracle Database Administrator

Contact: 720-***-****

E-mail:acoguy@r.postjobfree.com

OBJECTIVE

Professional Objective: Seeking as a Oracle Database Architect/ Oracle

DBA/Oracle RAC DBA / GoldenGate DBA/ Oracle Developer/ Data Modeler.

PROFESSIONAL PROFILE

. Having around 10 years of experience in managing RDBMS&NoSQL database

systems on various platforms.

. The extensive experience in database support, upgradations and

migrations from Oracle 8i/9i/10g and 11g/12c in mixed environments and

cross OS platforms (Linux, Solaris, HPUX, AIX, and Windows Server).

. Installed different versions of Oracle on Linux, Solaris and Windows

operating systems.

. Experienced in complex data models and logical database deigns.

. Extensively used Erwin to design Logical/Physical Data Models,

forward/reverse engineering.

. Upgraded Oracle Databases from 9.2.x/10.1.x to 11.2.x/10.2.x and

Migrated From 10.1.x/11.1.x to 10.2.x/11.2.x.

. Involved in Implementation of Oracle 12c/11g/10gRAC (Real application

cluster), Using OCFS2, ASM as well as RAW devices.

. Expertise in Oracle 12c databases setup on Linux and UNIX

environments.

. Configured OEM 12c for databases monitoring.

. Performed day to day Oracle 12c databases support.

. Configured GoldenGate Replications and performed date to date support

activities.

. Performed GoldenGate migration activities from 11.2.0.2 to 11.2.0.4

. Involved in configuration of goldengate and Streams.

. Expertise in Migration of database from Non RAC to RAC.

. Upgraded Oracle RAC from 10g to 11g

. Implementing the TAF and RMAN backup in RAC, Load balancing.

. Expertise in configuration of Disaster Recovery databases using oracle

11g as active dataguard and Physical Standby Databases,

. Expertise in cloning of the database Using cold backup, hot backup and

RMAN.

. Expertise in Hot backup & cold backup And Logical backup (Exp/Imp &

Expdp/Impdp).

EDUCATION & CERTIFICATIONS

> B-tech (Electronics & Communications) from JNTU.

> Oracle Certified Professional.

> ITIL V3 Certified.

Technical Skills

Databases Oracle RDBMS/ORDBMS 8i,9i,10G,11G,12c (RAC,ASM

and Data Guard, Flashback Database

Features),OracleGoldenGate,

OracleStreams,MSSqlServer,MySql,NoSqlDB,MongoDB,

Cassandra.

OS Linux, Solaris,HP Unix, IBM AIX, Windows Server

Oracle Technologies RAC, GoldenGate,Streams,replications,ASM, Data

Guard, Standby database, Transportable

Tablespace, External Tables, Partitioning,

Materialized views and snapshots, partitioning,

Oracle Flashback, Datapump, Oracle Streams,

asmlib, ocfs/ocfs2

Programming Languages PL/SQL, T-SQL, SQL, SHELL (sh, bash, ksh)

Development/Administratio RMAN with recovery catalog and without, SQL

n/ Plus,

Performance Tools and STATSPACK, AWR/ADDM,TKPROF, EXPLAIN

Utilities PLAN,Oracle SQL Optimizer, hints, TRACE

Analyzer,

Quest TOAD,Oracle Enterprise Manager, Remedy

Unix Tools/Commands cron, at, vi, sed, awk, other Unix, Linux

commands and utilities, Informatica Power Center

9.0.1, Power Exchange, Force.com, Apex Explorer,

SQOL, Netezza, SQL/PL SQL, Oracle 10g, Visio

2010, Erwin, & UC4,SSIS.

PROFESSIONAL EXPERIENCE

Company:Cognizant Technology Solutions Position:Associate

Operations Manager

Client: WesternUnion, Denver, CO Duration:

June'14 to Till-Now

Role and Responsibilities:

. Installed / configured Oracle 11.2.0.2 Golden Gate and implemented bi-

directional replications.

. Configured Datapump, Extract and Replication Processes in GoldenGate.

. Performed day to day GoldenGate activities

. Configured custom scripts for GoldenGate for the extract and replicate

process.

. Migrated the GoldenGate from 11.2.0.2 to 11.2.0.4

. Worked on veridata configuration for GoldenGate to compare records

between source and target.

. Upgraded RAC databases from oracle 10g to 11g

. Applied PSU patches for RAC databases.

. Configured active dataguard and performed DR activities.

. Expertise in Oracle 12c databases setup on Linux and UNIX

environments.

. Configured OEM 12c for databases monitoring.

. Performed day to day Oracle 12c databases support.

Environment:

Operating system : Sun Solaris, AIX, Linux, HP-Unix, windows

Databases

:Oracle9i/10g,OracleRAC10g/11g/12C,GoldeGate,Replicati

ons,

Informatica8.6/9.1,SqlServer,NoSQL,MongoDB,Cassandra.

Scripting : UNIX shell, SQL/PLSQL

E Business Suite : 11.5.9, 11.5.10.2, R12.

Utilities : RMAN, SQL*Loader, TKProf, Export,

Import.

Tools : Remedy, TOAD, TSM, OEM, Grid, Informatica Power Center 9.0.1, Power

Exchange, SQL/PL SQL, Oracle 10g, Visio 2010, Erwin

Client: JPMorganChase Bank - Columbus, OH

Designation:Database Architect

Duration: Oct'13 to May'14

Role and Responsibilities:

. Expertise in process improvement, normalization/de-normalization, data

extraction, data cleansing, data manipulation.

. Closely worked with BAs and converted from BRD to Technical documents.

. Experienced in complex data models and logical database deigns.

. Extensively used Erwin to design Logical/Physical Data Models,

forward/reverse engineering modeled the Data Warehousing Data marts

using Snow/Star Schema.

. Performed Data Modeling and Logical, Physical structure setup for the

databases.

. Expertise in Oracle 12c databases setup on Linux and Unix

environments.

. Configured OEM 12c for databases monitoring.

. Upgraded oracle RAC databases from 10g/11g to 12c.

. Expertise in Performance tuning the production database towards

optimal performance based on the changes in the database storage

structures due to application change requirements. Monitoring and

optimizing the performance of the Database through Database Tuning -

Tuning Applications, Tuning Memory, Tuning Disk Usage and Tuning OS.

. Implemented High availability using GoldenGate Replication. Implanted

Bi-directional replication using golden gate.

. Configured GoldenGate and developed custom scripts for data

replications.

Environment:

Operating system : Sun Solaris, AIX, Linux, HP-Unix, windows

Databases : Oracle9i/10g, 10g/11gRAC,GoldeGate, Streams,

Replications, NoSQL, MongoDB, Cassandra.

Scripting : UNIX shell, SQL/PLSQL

E Business Suite : 11.5.9, 11.5.10.2, R12.

Utilities : RMAN, SQL*Loader, TKProf, Export,

Import.

Tools : Remedy, TOAD, TSM, OEM, Grid, Informatica Power Center 9.0.1, Power

Exchange, SQL/PL SQL, Oracle 10g, Visio 2010, Erwin.

Company: CenturyLink Designation: IT Project

Coordinator-I(Lead DBA)

Clinet: CenturyLink,Denver,CO Duration:

May'2010 to Oct'2013

Role and Responsibilities:

. Provided Oracle databases support for production, development and test

environments.

. Installed Oracle11g/10g/9i/8i software and created database on Sun-

Solaris, HP-Unix, Linux,

. Managed Logical And Physical Database Design.

. Requirement study, Installation of Oracle 11g/10g/9i/8i, Data

Modeling, Database design & creation.

. Configured oracle 10g/11g dataguard and performed day to day

activities.

. Configured Oracle GoldenGate and performed date to date support

activities.

. Installed and configured MongoDB Database 2.6 on Linux.

. Expertise in troubleshooting of NoSQL systems.

. Migrated oracle standby databases to oracle 11g RAC

. Built the Warehouse databases in oracle 10g/11g and Supported ETL

activities on warehouse.

. Configured Oracle 11g Dataguard and performed day to day activities.

. Expertise standby database configuration and performed day to day

activities.

. Expertise in configuration and support of Bigdata databases like

MongoDB systems.

. Performed day to day maintenance activities for Bigdata/NoSQL systems.

. Migrated databases from Sqlserver to Oracle.

. Database backups using sql Backtrack for hot backup&cold backup.

. Experienced in Memory Tuning, Query Optimization, SQL Tuning &

Database Tuning.

. Written and Implemented PL/SQL Scripts to check the performance of the

database.

Environment:

Operating system : Sun Solaris, AIX, Linux, HP-Unix, windows

Databases : Oracle9i/10g, 10gRAC, GoldeGate,

Replications, NoSQL, MongoDB, Cassandra

Scripting : UNIX shell, SQL/PLSQL

E Business Suite : 11.5.9, 11.5.10.2, R12.

Utilities : AD Utilities, SQL Backtrack, RMAN,

SQL*Loader, TKProf, Export, Import.

Tools : Remedy, TOAD, TSM, Informatica Power

Center 9.0.1, Power

CenturyLink Custom Tools: DBASG, DATAPOINT, CSC, CMSVIEWR, LOSDBLODER

Company: HCL Comnet Ltd Designation: Specialist-

DBA

Client: EFH-ONCOR, Dallas, TX

Duration: April'2009 to May'2010

Roles and Responsibilities:

. Installed and configured Oracle 10g RAC high availability.

. Implemented 4 Node 10g RAC on SUN Solaris cluster and Linux cluster.

. Migrated Databases from Non-RAC to RAC.

. Creation of development database using manual methods and using DBCA.

. Supporting/Troubleshooting existing 10g/11g RAC databases on SUN

Solaris cluster.

. Configured GoldenGate and performed date to date support activities.

. Configuring public and private network and VIP for new RAC databases.

. Experienced with SRVCTL, CRSCTL, OCR and Voting Disk of 10g/11g RAC.

. Converting Single Instance databases to RAC databases.

. Upgrading RAC/NON RAC databases from 9i to 10g and from 10g to 11g.

. Converting the single instance database to RAC database for test

instance.

. Maintaining RAC and non-RAC databases, adding ASM disks on prod and

non-prod RAC databases.

. Configured highly volume of data replications in the production

databases and performed day to day activities.

. Performed Cloning of the databases (Cold, Hot and RMAN).

. Applied patches as per the requirements.

. Configured RMAN backup for all the Production databases.

Environment:

Operating system : Solaris, AIX, Linux, HP-Unix, windows

Databases : Oracle 9i/10g/11g, 10g RAC

Utilities : SQL Backtrack, RMAN, SQL*Loader, TKProf,

Export, Import.

Tools : Remedy, TOAD, Sentry, Informatica

Power Center 9.0.1, Power Exchange, Force.com, Apex Explorer, SQOL,

Netezza, SQL/PL SQL, Oracle 10g

Company: HCL Comnet Ltd

Designation:Specialist-Systems

Client: Deutsche Bank,NY Duration:May'2008

to March'2009

Role and Responsibilities:

. Upgraded Oracle Databases from 9.2.x/10.1.x to 11.2.x/10.2.x and

Migrated From 10.1.x/11.1.x to 10.2.x/11.2.x.

. Involved in Implementation of Oracle 10gRAC (Real application cluster)

on ASM.

. Upgraded Oracle RAC from 10g to 11g

. Implementing the TAF and RMAN backup in RAC, Load balancing.

. Expertise in configuration of Disaster Recovery databases using oracle

11g as active dataguard and Physical Standby Databases,

. Performed cloning of the database Using cold backup, hot backup and

RMAN.

. Performed database Hot backup & cold backup And Logical backup

(Exp/Imp & Expdp/Impdp).

. Managing the cluster ware files i.e., OCR files & voting disk.

. Converting the single instance database to RAC database for test

instance.

. Adding ASM disks on prod and non-prod RAC databases.

. Taking logical backups (export/import).

. Implementation of backup and recovery strategies.

. Performed Cloning of the databases (Cold, Hot and RMAN).

. Applied patches as per the requirements.

. Configured RMAN backup for all the Production databases.

Environment:

Operating system : Solaris, AIX, Linux, HP-Unix, windows

Databases : Oracle 9i/10g/11g, 10g RAC

Utilities : SQL Backtrack, RMAN, SQL*Loader,

TKProf, Export, Import.

Tool : Remedy, TOAD, Sentry,

Informatica Power Center 9.0.1, Power Exchange, Netezza, SQL/PL SQL, Oracle

10g, Visio 2010, Erwin.

Company: IBM GSDC,Brno,CZ,Europe Designation:IT-

Specialist

Client:Freanch Team,Brno,CZ Duration:03/2008 -

04/2008

Roles and Responsibilities:

. Understanding customer requirements.

. Doing customization for the client needs.

. Analysis, development of the application.

. Installation, configuration, connectivity and trouble shooting of

Oracle 9i databases on Sun-Solaris, IBM-AIX.

. Provided Database support for the databases in a Development, Test and

Production environment.

. Installed & Upgraded from 9.2.0.2 to 9.2.0.5 on Sun Solaris.

. Install / configure and support management system.

. Design, develop, install and administer Oracle 10g - in OLTP / Data

Warehousing environment

. Identified source systems, their connectivity, related tables and fields

and ensure data suitability for mapping.

. Worked with cross-functional teams and prepared detailed design documents

for production phase of current customer database application

. Participate in review of models - performing presentations

. Plan and implement partitioning, replication, backup and recovery of the

Oracle databases performance

. Perform capacity planning and implement database security - applying

hardening rules and patching

. Monitor/perform ongoing tuning of the database instances and capacity

planning

. Perform data analysis and mapping of source/target databases

. Developing and maintaining PL/SQL code - packages / procedures /

functions / triggers and standalone SQL scripts

Environment:

Operating systems : Sun Solaris, AIX, HP UNIX

Databases : Oracle 8i/9i/10g

Utilities : OEM, SQL*Loader, TKProf, Export, Import, RMAN

Tools : Lotus Notes, TOAD, Remedy.

Company:Reliance Communications

Designation:AssistantManager(OracleDBA-1)

Clinet:RCOM,Mumbai,India

Duration: Jan'2008to Mar'2008

Role and Responsibilities:

. Upgradation of Oracle Databases from 9i to 10g.

. Creation of database objects, e.g. tables, indexes, views, etc

. Implemented Partitioning on huge tables to improve the performance.

. Created and managed the Rollback Segments which includes controlling

the size of the Rollback Segment, defining the optimal parameter,

enabling different RBSs for different operations

. Database links were created to access the data from remote databases.

. Backups Includes both logical (Export/Import) & Physical (Hot & cold)

. Database Refreshes activity as Full database From Production to Non

prod and Schema level refresh

. Applied patches to the database for security purpose.

. Must be available 24/7 Production support and Contact Oracle for

Technical support.

Environment:

Operating systems : Sun Solaris, Linux AS4.0

Databases : Oracle 9i/10g, Oracle10g RAC

Utilities : OEM, SQL*Loader, TKProf, Export, Import, RMAN

Company:GVR Infra Pvt Ltd Designation:DataBase

Administrator

Client:GVR Infra, Chennai,India

Duration:May'2005 to Jan'2008

Roles and Responsibilities:

. Identified source systems, their connectivity, related tables and fields

and ensure data suitability for mapping

. Design and support ODS, Data warehouse

. Engineering of legacy systems to derive physical models for further

analysis and work

. Analyze business/functional requirements to derive logical models

. Analyze data-related and system integration opportunities and challenges

and make recommendations.

. Installed and configured Oracle 9i, 10g on HP UNIX.

. Created logical and physical standby databases using Data-guard and

converting physical standby to snapshot for testing purposes.

. Performed HOT/COLD backups using RMAN and Logical backups using

data-pump.

. Configured Recovery Manager (RMAN) and performed Hot and Cold

backups for production databases using RMAN.

. Created user accounts, roles and granting required access

permissions and privileges to the database based on the application

they are accessing.

. Conducted daily routine checks on alert logs and trace files for

database errors and taken necessary actions to resolve the issue.

. Addressed issues involving data mapping / cleansing on source and target

systems

. Participate in review of models - performing presentations

. Install, configure and tune Oracle databases in VMware on Solaris

platforms in a RAC environment

. Perform capacity planning and implement database security - applying

hardening rules, CPUs and PSUs

. Implement database level hardening for compliance with security standards

. Developing and maintaining PL/SQL code to meet requirements - packages /

procedures / functions / triggers and standalone SQL scripts.

Environment:

Operating system : Sun Solaris, AIX, Linux

Databases : Oracle 8i/9i/10g, MySQL V2/V3

Utilities : SQL*Loader, TKProf, Export, Import, RMAN

Contact this candidate