Oracle Database

Raghavendra Rao Ramaraju

Oracle Database Administrator

Contact No.: 240-***-**** E-mail: ***********@*****.***

Observing the Technical and Management perspectives of every organization and to learn from the experience of work in day to day activities. This will emerge into a strong build of Organization.

Profile Snapshot

•Master’s in Electrical and Computer Engineering Aug 2012

•Southern Illinois University, Carbondale IL, USA

•Bachelor of Technology in Computer Science and Engineering May 2010

•JNTU (Jawaharlal Nehru Technological University) Hyderabad, AP, India

•Experience in Complex Grid Infrastructure and Database RAC Builds

•Experience in cloning RAC databases using RMAN tool.

•Experienced in Design, implementation and generating documentation of Oracle 10g Data Guard on both physical/logical standby databases in high availability mode.

•Implemented Data guard, creating both Logical and Physical Standby databases in 10g &11g RAC environment for the Production databases.

•Installed Oracle Streams as an enhancement for the Client’s DW method and monitored Streams Issues using Grid Control.

•Possess a clear understanding of the industry, technology trends with the distinction of instituting quality assurance practices to achieve business excellence at the lowest overall cost

•Excellent communication & interpersonal skills with strong analytical, problem solving & organizational abilities

Major Attainments

•To learn constantly at the workplace and use the knowledge thus obtained in adding at least as much value to the organization as I derive from it, without compromising on quality or personal ethics.

•Provide Application Software Support and data base programming on Relational databases (VLDBs) and with Oracle systems

•Utilize data base concepts of objects, normalization, building schemas, partitioning tables and indexes, Online Transaction processing (OLTP) and online analytical processing (OLAP).

•Shell scripts to interface with operating systems, and SQL programming.

•Will monitor and analyze performance bottlenecks, test/debug with scripts, and provide for resolutions.

•Will provide production support, installation, configuration, upgrades, patches, performance tuning, backup and recovery, space management, database security, cloning, migration, shell scripting and documentation.

Work Experience

Professional Experience:

WELLS FARGO BANK NA, NC Sep’12 – till date

Oracle DBA

Responsibilities:

•Installation, configuration, maintenance and tuning of Oracle 11g and 10g on Red hat 5.0.

•Successfully upgraded Oracle 10g (10.2.0.4) to Oracle 11g (11.2.0.3) on IBM-AIX nodes

•Worked as a part of team in Data Center Migration project for 6 months

•Daily database administration tasks including backup and recovery through RMAN, Import/Export

•Performed data transfer using Export/Import using command line as well as in interactive mode and through Data pump.

•Involved in Installation and configuration of Oracle 10g &11g R2 RAC using Cluster ware and ASM

•24x7 remote support and on call Database support for Database developers & end-users.

•Experienced in implementing Oracle Database advanced security practices.

•Implemented Streams replication between RAC and non RAC database environments

•Successfully configured and installed Oracle Golden Gate for replication.

•Maintained the Heart beat tables to check the lag between the sites.

•Worked with application team to resolve conflict handlers and troubleshooted the replication issues.

•Did Sybase to Oracle migration support that includes a complete migration with your new Oracle database which is ready-to-use

•Extracting from the existing Sybase database

•Importing the Sybase data into Oracle

•Reworking Sybase SQL to Oracle SQL compliance

•Oracle database tuning

•Migration of procedural language code into PL/SQL

•Experience in cloning RAC databases using RMAN tool

•Experienced in Design, implementation and generating documentation of Oracle 10g Data Guard on both physical/logical standby databases in high availability mode.

•Implemented Data guard, creating both Logical and Physical Standby databases in 10g &11g R2 RAC environment for the Production databases.

•Installed Oracle Streams as an enhancement for the Client’s DW method and monitored Streams Issues using Grid Control.

•SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.

•Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities)

Environment: Red Hat Linux 5.0,SPARC systems, Oracle 10g and 11g, TOAD 9.0, Oracle Enterprise Manager (GC), RMAN, RAC, Data Guard, SYBASE, ASM,, TKPROF, Explain plan, AWR, ADDM, SQL* Plus, PL/SQL, SQL* Loader.

Ness Technologies, Bangalore, India May’10 –Dec’10

Oracle Developer/ DBA

Responsibilities:

•Developed and modified PL/SQL code to make new enhancements or resolve problems, as per customer requirements.

•Created complex analytical reports using inline view, lexical parameters with Oracle Reports 10g.

•Modified Korn shell scripts as per technical specifications.

•Prepared Data Flow Diagrams for existing PL/SQL code.

•Involved in coding of data extraction scripts as per technical specifications.

•Analyzed the table structures using Analyze command.

•Involvement in all phases of the project life cycle.

•Designed database tables as per technical specifications.

•Translated business requirements into creation and alteration of database objects: tables, indexes, constraints, triggers and stored procedures.

•Implemented automated backup strategy using the UNIX shell script CRON UTILITY.

Environment: Oracle 9i/10g, HP-UX, Windows NT/2000, PL/SQL, SQL Server 2000, T-SQL, Database Tools/Utilities, OPS, Shell Scripting.

Trainings Attended

•Oracle Database 11g Security R2 virtual class at Wellsfargo, CIC Building, Charlotte, North Carolina

•Oracle Database 11g RAC Administration R2 at Wellsfargo, CIC Building, Charlotte, North Carolina

•Oracle Database 11g Perfomance Tuning Experts Summit, Raleigh, North Carolina

•Oracle Database 11g RAC and Grid Infra at Virginia

•Attended training on RCU components setup for Web logic console set up

Education

•2012 Master’s(Electrical and Computer Engineering) from Southern Illinois University, Carbondale IL, USA and secured 3.5 GPA

•2010 B.Tech. (Computer Science) from Jawaharlal Nehru Technological University, Hyderabad and secured 68% marks

Personal Details

Date of Birth: 22nd August 1989

Languages Known: English, Hindi, Telugu

Address: 1600 Ivy Meadow Dr,Apt 818,Charlotte, North Carolina,28213.

Contact this candidate