Leo Joy Email & Phone Number

8 plus years of experience in Oracle 12c/11g/10g DBA/Developer and have been involved in complete development life cycle of multiple projects including designing, programming, administering and production support, along-with ongoing maintenance and integration with multiple systems and content management. • Good experience in Gathering and Analysing Business Requirements, Database Design, developing and implementing projects on time.• Experience in Installation, Configuration and Upgrade of Oracle Database on AIX, Solaris OS, Enterprise Linux (RHEL) and Windows. • Experience in Administering Oracle Database using Oracle Enterprise Manager, Toad, PL/SQL Developer.• Experience in configuring Data Guard which included implementing Physical Standby.• Experience in Backup & Recovery techniques of databases running in ARCHIVELOG MODE using RMAN.• Good at Implementing PL-SQL Coding Standards and writing policies and procedures like Hints, Indexes and Views.• Looked at the Performance tuning issues using AWR Report and OEM console.• Detecting and diagnosing production system performance problem by analyzing Oracle trace and log files, AWR, ADDM, analyzing SQL statements, measuring system and database activity and Querying Oracle dynamic performance views.• Worked upon recovering standby database using managed recovery process.• Setup a 2 node RAC environment on Linux and Solaris for testing purposes.• Applied OPATCH for Oracle 10g, 11g and 12c databases. • Managing Database Structure, Storage Allocation, Table/Index segments, Rollback Segments, Undo Segments, and Constraints.• Hands on experience working on High Availability Environments.• Have setup Oracle Streams database configuration.• Working experience on VMWARE.• Experience in applying Patches on database.• 24 X 7 Production Database on Call Support.• Strong analytical and problem solving skills. Willingness and ability to quickly adapt to new environments and learn new technologies.

Listed skills include Java, Sql, C++, C, and 7 others.