Profile Snapshot
Rijo is based out of Bangalore & has studied ME-Mechanical Engineering, BE BTech-Bachelor of Engineering or Technology from Year 2006-2011 in BCET-Bangalore College of Engineering and Technology, Visveswaraiah Technological University.
Rijo S Roy is Skilled in Oracle DBA, Oracle 10g, Oracle 11g and other talents.
Talents
-
Red Hat Linux... among 0 users in Bangalore…among 0 users worldwide -
Risk Analysis... among 0 users in Bangalore…among 0 users worldwide -
Creative Problem Solving... among 0 users in Bangalore…among 0 users worldwide -
Disaster Recovery... among 0 users in Bangalore…among 0 users worldwide
Professional Path
Oracle Database Administrator
Pricewaterhousecoopers Pvt Ltd
Full Time
Apr-2013 To
present
13 years 5 months
- As an Oracle DBA my activities include
• Disaster Management and RCA, Creating SR’s & Co-ordinating with Oracle Support in resolving issues.
• Daily DB Health monitoring / Server monitoring
• DBPITR/TSPITR using RMAN
- Pro-active Monitoring of CPU metrics and no. of sessions
- Partitioning of Tables
- Shell Scripting
- RAC health checkups using RACCheck and scripts
- Generation & Analysis of AWR,ASH & ADDM report
- Administration of DB using OEM
- Scheduling jobs
- Query Performance Tuning using explain plan/ SQL Advisor and coordinating with the developers for following the best practices
• Monthly Cloning/Duplication of Database to a Duplicate DB for testing the backups from production env
• Backup & Recovery using RMAN. Well versed with imp/exp as well as datapump.
• Usage of Segment Advisor
• Provide 24x7 on-call support for mission critical database systems and applications
• Actively involved in understanding client requirements and DB problems - Reduced load over the network and intermittent node eviction which caused huge business loss for the client by implementing Jumbo Frames over the interconnect as well as effective table partitioning.
Oracle Database Administrator
CMC Ltd
Full Time
Dec-2012 To
Mar-2013
3 months
- Performing Daily as well as incremental backups. Maintenance of database & session’s statistics, memory statistics, load statistics to obtain optimal performance, alert logs and dump log files using STATSPACK,AWR,OEM etc. User account management and Installation of patches. Configuration of Linux HugePages.
- Implemented Huge Pages and thereby reduced the load over the Linux machine where Production Database of the clients HQ which holds data of more than 1200 Regional Offices
Oracle Database Administrator/ Developer
CMC Ltd
Full Time
Apr-2011 To
Dec-2013
2 years 8 months
- 1) Database migration from 8i to 11g
3) Data upload and download on AS and database using Webutil
Package.
4)Installation of Weblogic as well as Oracle Database11g software in RHEL 5.6 as well as Windows environment
5) RAID configuration.
6) Configured Data Guard Functionality in 11g
• Actively involved in understanding client requirements and DB problems.
• Modified and Developed Procedure, Function and Package.
• Debugging errors
• RMAN backup and restoration in live as well as backup servers.
• Performing Hot and cold backups.
• Prepare Technical Documentation.
• Involved in Unit Testing.
Visited client sites like CAG-Gwalior, Raipur, Punjab &Haryana for project environment setup, testing of application as well as debugging errors. - Configured DataGuard Functionality which ensured data availability in one of the client sites where DATA loss was a recurring issue
Qualifications
Bangalore College of Engineering and Technology
Bachelor of Engineering or Technology Mechanical Engineering
2006-2011
60%
Extra-Curricular Interests
Football
Music
My Story
I have 2.9 years of experience currently working as an Oracle DBA for PricewaterhouseCoopers Pvt Ltd. I have got good exposure in Oracle 10g/11g Core Database Administration activities such as Monitoring, Migration ,Cloning/Duplication,hot and cold backup, 10g RAC administration, Data Guard and hands on experience in RedHat Linux Administration.
Contact details are visible to employers.
Log in or sign up as an employer
