Personal Details
Name : Rama Rao s/o Samamoorthy
Sex : Male
IC No : 760901-05-5431
Address : No 8, Jalan 10/2C Taman Putra Permai, Putra Heights, Subang Jaya.
Contact Info.
Email Address: [Send email using form at bottom]
HandPhone No : +6016-302 4147
Skilled on performance tuning on Oracle database 8i, 9i and 10g.
Objective
A position with a progressive organization in which I will be able to contribute
new and creative ideas that will utilize my current skills to their fullest
potential while providing me with opportunities for technical, professional, and
personal growth.
SUMMARY
7 years experience in Database Administration in large production enviornment.
Basic Unix , Linux, Solaris, NT/2000 administration. Experience in doing hot/cold
backup, Standby Databases (Dataguard), Performance Tuning, STATSPACK, AWR, RMAN
(Recover Manager), Oracle Enterprise Manager, SQL*Trace, SQL*Net , Import/Export,
Server Manager, Network Administration in Oracle, Names Server, MTS, Enterprise
Manager (OEM), Shell Scripting, SQL, PL/SQL, Stored Procedures and Triggers.
Quest TOAD.
Education
SRP 1992, Grade A , Sek. Men. Engku Hussain.
SPM 1994, Grade 2 ,Sek. Men. Engku Hussain.
Diploma In Computer Science, Cambridge University.
Advance Diploma In Computer Science, Oxford University.
Bachelor in Information Technology, University Southern Queensland.
Technical Skills
Operating Systems: Red Hat Enterprise Linux, HP-UX, UNIX (SUN Solaris), AIX,
Windows XP, 2000, DOS
Languages & Other Software: UNIX (Korn, Bourne) Shell Scripting, TOAD QUEST, HP
Data Protector, Visual Basic, PL/SQL, SQL*Plus, DOS batch scripting, Windows
Host Scripting.
Experience: UNIX and Windows System Administration, Oracle Database
Administration on 7.3.4, 8i, 9i, 10g and 11g.
Professional Experience
Hewlett Packard Nov 2008 - Present
Oracle Database Administrator
Key Responsibility
• Involved in various projects within HP.
• Assist developers in various activities in regards to Oracle Database. Guide
them in improving application design in the perspective of Oracle database.
• Apply patches upgrade databases.
• Perform health check and proactively monitor databases for any possible issue
that might impact database performance and availabilities.
SHELL IT August 2007 – Nov 2008
Oracle Database Administrator
Key Responsibility
• Support various database issues as incidents.
• Support Oracle databases on main Unix platforms (AIX, HP-UX, Solaris) and
Linux.
• Apply patches upgrade databases.
• Handling customers request such as create user, create new databases,
duplicate databases from production to test environment.
• Perform day-to-day administration tasks such as database capacity management,
troubleshoot any database related problem like database recovery.
• Produce backup report to ensure the backups were all successful and
troubleshoot if the backup was not successful and finding the root cause of
failed backups.
• Performed day to day DBA tasks, such as taking automating backups, performance
tuning, managing accounts etc.
• Monitor functional inbox to respond to various customer queries and technical
issues.
DELL July 2006 – July 2007
Oracle Database Administrator
Key Responsibility
• Responsible for over 2000 production Oracle databases, running mostly on Linux
and some Windows and Sun Solaris.
• Implemented and managing 10g RAC database environment on Red Hat Enterprise
Linux (RHEL)
• Implemented Oracle Data Guard Physical standby on 9i and 10g, also experience
in troubleshooting various issue related on the Data Guard.
• Performed day to DBA and System Administration tasks, such as taking
automating backups, performance tuning, managing accounts etc.
• Developed various SQL scripts, cater for day to day database issues, such as
locking, performance and etc
• Monitored database healthy status including space usage, response time and
backup status
• Troubleshoot performance issues on production database environment.
• Experience in using Statspack and AWR report to investigate database
performance related issues.
Dutch Lady Milk Industry August 2005 – July 2006 Database Administrator
Achievement
Improved the response time to generate reports from 38 seconds to 11 seconds.
My duties.
• Maintaining ERP BAAN server which is running on HP 900***-
• Periodically monitor the performance of ERP server including the utilization
for server resources.
• Performed day to DBA and System Administration tasks, such as taking
automating backups, performance tuning, managing accounts etc.
• Developed backup and recovery policy for the critical production Database
server using Oracle Recovery Manager (RMAN) backup on HP Data Protector.
• Performed database migration from oracle 7.3.4 to 9i.
• Analyze and optimize the SQL statements that over utilizing server resources.
• Storage tuning with proper RAID configuration settings for the database
server.
• Perform table and index reorg.
• Troubleshoot oracle performance issue. Trace oracle session and analyze the
session with tkprof utility.
• Developed UNIX scripts that run periodically to collect system statistics.
• Consolidate multiple smaller databases into one large instance as different
schema
September 2004 – July 2005 Technical Consultant (EMERIO) HP System & Network
Monitoring Center – Output Services.
Achievement
Awarded as a Top Engineer of the month from EMERIO Consultant
My duties
• Troubleshoot on various printing issues. Including Windows and UNIX platform
• Support DAZEL printing systems
• Install printer drivers according to the printer model
• Help customer troubleshoot on their printing issue over telephone or via
remote desktop.
• Maintain Win2k DHCP server and DNS Server by assigning MAC address to DHCP
Server or Bootp Server (HP-UX) for each printer in the network.
September 2000 – August 2004 MIS Executive (ERNST & YOUNG)
Key Responsibility
• Conduct technical support on Lotus Notes Client, Windows 2000 Servers and
Professional, Windows NT, and Windows 95.
• Configured DHCP servers and given dynamically IP addresses to clients.
Configured network file sharing.
• Setup new computer for users and complete configuring with Office 2000 and
other applications like Norton Anti-Virus, Lotus Notes Clients and so on.
• Assist user via phone on how to solve certain problems which is related to
Windows 2000, Notes Client, Office 2000 such as, account lockout, unable forward
mails, unable archive mail and so on.
• Involved in projects to setup new servers for outstation branch offices.
• Provide deployment strategic for windows 2000 professionals to all the
workstations.
• Define security group policy for Windows 2000 Professionals.
• Developed many VB scripts that deploy security patches to the end-user
workstations.
• Migrate from Novell 3.11 and Windows NT 4.0 to Windows 2000 servers.
• Create User IDs for Win2k Active Directory, MS SQL Server 2000 and assigning
roles for the specific SQL Server user.
• Administer Microsoft Internet Information Server 5.0 for local intranet.
Jan 2000 – August 2000 System Operator (British American Tobacco)
Achievement
Successfully developed a script that detects network availability. This is a DOS
shell script that alerts the system operators as when there is network packets
loss detected. This improves the service level and being more proactive when
there is an issue with network connectivity.
My Duties
• Schedule Backup and check the tape labels from the console.
• Find the root cause the backup fail.
• Well-understood on handling DDS2 tape drive and Magstar tape drive (3570)
• Install Peripheral devices such as hard disk, memory sound card, Network
Interface Card (NIC) and configure their IRQs.
• Monitor the Servers performance and their response time on SAP/R3. Liaise with
SAP Basis team when the AIX UNIX server hit performance issues.
• User account creation and modify the access control using NetWare
Administrator utility.
• Evaluating Performance software.
• Doing DOS Shell programming to detect network availability.
Reference
Name : Noel Teng(Technology Specialist Manager in Microsoft)
Tel : 012-2820130
E-mail : nwkteng@microsoft.com
Reference
Name : Fung Han Ping (Software Architect in HP)
Tel : 012 – 6678119
Email : Hanping.fung@hp.com
Specialist
A highly skilled in performance tuning on Oracle database 8i, 9i and 10g.
Experienced with in depth knowledge in Oracle Dataguard recovery.
|
