Pratap R Putha
***** Phone#***** 
SUMMARY
Over  8  years  of  experience  as  Database  Administrator,  providing  24/7  support  of  both
production  and  development  environments,  which  includes  Database  creation,  installation,
configuration, administration, upgrades, patching, performance tuning, backup and recovery, space
management,  security,  cloning,  migration  and  troubleshooting  on  both  Unix  Sun  Solaris,  IBM  AIX,
HP UX  &  Red  Hat  Linux  and  Windows  environments  on  multiple  versions  of  Oracle  Oracle 
9i/10g/11g and 12c  .
  Experience in installation and configuration to support data replication in Oracle Database
environment.
  Expert at tuning SQL queries and PL/SQL  procedures. 
  Proficient with Tuning, SGA, Buffer Cache, Rollback Segments, and Redo Mechanisms.
  Monitored  and  Detected  Alert  Log  Files,  Listener  Log,  Redo  Log  status,  trace  files  for  the
database.
  Experience in creating Flashback Technologies
  Experience in Installing and configuring ASM and RAC for high availability databases.
  Cloned  Database  from  Production  to  Test  and  Development  and  from  Development  to
Production.
  Experience in Upgrade and Migration of oracle database to higher version.
  Experience in maintaining Oracle Data Guard & Standby Database and providing critical
solution with.
  Implemented 3 node RAC and RHEL Servers.
  Created Users and Tablespace with same names as per client requirement.
  Applied PSU Patches for every quarter
  Designed  and  implemented  Backup  and  Recovery  strategies  using  conventional  and
RMAN utilities.
 
  Hands on experience of database backups and recovery methods like Export/Import,  
  Worked on Export and Imports by using Legacy and Datapump also
  Installed 11g and 12c Databases on RHEL
  Configured 11.2.0.3 and 11.2.0.4 Oracle Data Guard on RHEL
  Installed Oracle Golden gate
  Co ordination with Oracle Support.
  Created and Maintained Users and Roles with Appropriate Privileges and Profiles.
  Created Tablespaces for Schema s.
  Experience in Transparent Tablespace
  Co ordination  with  Oracle  Corporation  for  technical  support,  new  products  and  releases,
technical discussion/support.
Certifications:
  Oracle Certified Professional 11g.
Professional Experience:
Johnson 
& 
Johnson, 
NJ  
Nov 2015 to Feb 2016  
Role: Tech Lead.
 Responsibilities:
  Package  Software:  Expertise  in  Informatica  ETL  and  reporting  tools.  Deep  understanding  of
the Data Warehousing SDLC and architecture of ETL, reporting and BI tools.
  Database Migrations from 11g to 12c. 
  Database upgrades from 11g to 12c.
  Implemented 3 node RAC on RHEL Server  
  Implemented Standalone RAC Server
  Strong  understanding  of  Data  Modeling  Relational,  dimensional,  Star  and  Snowflake
Schema , Data analysis, implementations of Data warehousing using Windows and UNIX.
  Installed &configured 12.1.0.1 on different operating systems of AIX and Linux.
  Taking backup of databases using RMAN.
  Responsible for applying PSU patches on most of the production databases
 
  Created a physical standby for Disaster Recovery  DATA GUARD .
  Installed Oracle Golden gate for replication purpose.
  Installed Oracle Enterprice manager on various production environments
Environment  : ETL, Oracle 11gR2 and 12c  11.2.0.4 and 12.1.0.1  on RHEL, Health Care
and Medical.
Ameriprise 
Financial, 
Inc. 
Minneapolis  
Jan 2014 – Nov 2015
Role: Sr. Oracle DBA & SME
Responsibilities:
  Experienced  in  working  and  monitoring  the  databases  by  using  Oracle  Enterprise  Manager
 OEM .
  Supporting both production and development activities.
  Creating of databases for Testing, Development and Production.
  Worked and Export and Imports for refresh activity.
  Provided Daily Health Check Reports for Telecom and Solutions.
  Installation of Oracle version 11g and 12c on Linux.
  Worked on Upgrades and Migrations
  Migration of Database from Non Cloud Server to Cloud Servers.
  Maintenance of Oracle Database. Rebuilding of Indexes, creating and managing Tablespaces
and allocation tables to different tablespaces.
  Worked on Database Encryption.
  Worked on PUS Patches for every quarter.
  Installed Oracle Golden gate on DEV, QA and Prod Environments
Environment:  Oracle  11g,  RMAN,  SQL*Plus,  Oracle  OEM,  Exports  and  Imports,
People Soft, Finance and Siebel.
Motorola Solutions – Illinois

Jan 2013 – Dec 2013
Role: Oracle DBA & SME
 
Responsibilities:  
  Installed 10g, 11g Oracle  database on Linux and AIX.
  Installed Oracle Golden gate for replication
  Configure Oracle Data Guard  Active Data guard  on Linux Servers.
  Good experience on Export and Import by using expdp and impdp
  Applied PSU Patches for every quarter
  Upgraded 10g to 11g Oracle Database
  Migrated Oracle Database from Non Cloud Servers to Cloud Servers
  Provided database related services to their development and QA environments.
  Provided Daily Health Check Reports for Telecom and Solutions.
  Created Users and Tablespaces
  Implemented 3 node RAC on RHEL
  Logical and Physical backup procedures.
  Data exports from production and staging databases.
  Tuned production database performances and was instrumental in SQL tuning that improved
application response.
  Run oracle AWR to tune the databases.
Environment:  Oracle  11g,  IBM AIX,  RHEL,  Window  2008,  Telecom,  Solutions,  Siebel  and
ISM.
Delaware North   NY  
July 2012 to Dec 2012  
Role: Oracle DBA & SME
 Responsibilities:
  Analyzed business requirements and built logical data models that describe all the data and
relationships between the data. Designed and implemented physical database
  Installation and configuration of Oracle 10g database server and their version upgrades.
  Installation of Oracle Applications on HP UX  Single User & Rapid Installation .
  Responsible for performance tuning. Extensively worked SQL tuning, database tuning and 
operation systems tuning.
  Worked and guided the team for analysis, design and testing phases of the project.
  Built this DW using the common architecture for the ETL.
 
  Installed Patches for every quarter.
  Actively  involved  in  code  reviews  and  guiding  the  developers  for  quality  and  timely
deliverables.
  Worked in the knowledge transition to the other team members on the common architecture
of ETL.
   Used several utilities and tools to perform performance tuning & monitoring
  Applied  patches,  successfully  upgraded  Oracle.  Worked  on  Storage,  Network 
configurations.
  Developed PL/SQL procedures, assisted /supported dev team with database related issues.
  Designed and implemented Oracle Database, Back up & Recovery.
Environment: Oracle 10g on AIX, Siebel, OBIEE, Hyperion and Finance
Post Holdings, Inc. Missouri  
Jan 2012   June 2012
Role: Oracle DBA
Responsibilities:
  Installation, Upgradation and Maintenances of Oracle Server on Linux.
  Backup of database Logical and Physical  hot and cold  procedures and also using RMAN
  Provided System support for both development and 24/7 production environment.
  Provided Daily Health Check Reports for JD Edwards
  Taking care of all alerts for space issues and user requests.
  Assisted in configuring optimal Oracle 10gR2 RAC architecture.
  Worked on Migrations from 10g to 11g.
  Managing  database  security.  Creating  and  assigning  appropriate  roles  and  privileges  to
users depending on the user activity.
  Applying  patches  and  Migrations  works  and  work  closely  with  Oracle  to  keep  application
environment up to date. 
Environment: Oracle 10g and 11g on AIX and Linux, JD Edwards, Siebel and ISM.
AARP   CA  
April 2011 to Dec 2012  
Role: Oracle DBA.
 Responsibilities:
 
  Analyzed business requirements and built logical data models that describe all the data and
relationships between the data. Designed and implemented physical database
  Installed 11g Oracle  database on Linux and AIX.
  Provided database related services to their development and QA environments.
  Provided Daily Health Check Reports for OEIEE, Hyperion, Finance.
  Created and Configured Databases on Development, Test and Production Environments.
  Applied PSU Patches in all environments.
  Worked  on  Exports  and  Imports  for  different  schemas.  Designed  and  implemented  Oracle
Database, Back up & Recovery.
Environment: Oracle 10g, IBM AIX, Window 2003, OEIEE, Hyperion, Finance and Siebel.
Eli Lilly and Co   Indianapolis  
Mar 2008   Mar 2011  
Role: Oracle DBA
Responsibilities:
  The work involves overall maintenance of ORACLE database, performance issues, 
tuning, backup,  and other database related activities.
  Worked on Exports and Imports for schema refresh.
  Implemented  Oracle  Replication  to  enable  database  fail  over  incase  of  system  or  database
crash.
  Checking of Alert log and Trace files to monitor the database on a daily basis.  Also wrote
monitoring scripts to check reports for space, Max. Extents, coalescing etc which are kept in
CRONJOB
  Also worked for network management.
  Day to day performance monitoring and tuning of database.
  Installed and Configured Oracle Data guard for Oracle 10g  for the maintenance of Stand 
by database.
  Created Tablespace, Alter tablespace, Datafiles adding, resizing.
  Worked with users to determine system requirements.
  Database  activities  include  allocation  and  maintenance  of  Rollback  Segments,  Automatic
Undo Management, table spaces, data files, redo log files, mirroring of redo log files across
multiple disks.
Environment:  Oracle  9i  and  10g  Legacy  and  Data  Pump  Exports  and  Imports,  CPU  and
PSU Patches, OBIEE and Siebel
 
Education : Bachelor s in Information Technology from JNTU Hyderabad, India.