Oracle Manager
Resume:
[pic]
Koteswara Rao
[pic] Sr.Oracle Database Administrator
Contact: 720-***-****
E-mail:*******@*****.***
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