Prasanth Dusi
Oracle DBA, Phoenix I.T Solutions Ltd
A competent professional with nearly 4 years of experience in IT as Oracle DBA and in Project Management. Proven abilities in project management in utility sector including project planning, scoping, estimation, status tracking & ensuring implementation & delivery as per agreed deadlines. Expertise in Oracle Enterprise Manager (OEM) and experience of 11g advanced features like ASM, FLASHBACK, AWR, and ADDM.
Adept in installation, configuration of databases, performance tuning of database, instance, SGA, I/O, toad, and explain plan, up-gradation and formulation & implementation of disaster recovery strategies and creation of database objects. Strong abilities in analyzing Oracle diagnostic reports, trace files and alert logs. Well versed on Real Application Cluster (RAC) and Raw Devices. Extensive usage of RMAN, export/import and Data pump utility. Proficient in raising tar with Oracle Support and using Metalink to resolve the bottlenecks in the database environment. Possesses excellent interpersonal, communication and organizational skills with proven abilities in team management, vendor/customer relationship management and planning.
Installing, configuring and upgrading server software.
Mentoring physical database design & creation. Devising strategy for backups, recovery & fine-tuning.
Creating tablespaces, rollback segments, user maintenance, and database security imposition by creating & granting roles & privileges, performance tuning, backups using RMAN.
Applying the patches using AD Patch Utility on Application File System and Technology Stack using Opatch Utility on Database.
Handling activities pertaining to:
▪ Installation/configuration & upgrade of Oracle databases Oracle 9i/10g (R 1&2) 11g RAC (R1) on different operating systems like Linux and various Windows Operating Systems.
▪ Performance tuning of Database, Instance, SGA, I/O,TOAD, and Explain Plan.
▪ Writing and debugging complicated SQL and PL/SQL.
▪ Handing Terabyte Database (TB).
▪ Reorg/Reindex of Database Objects.
