SUMMARY
• I am Btech graduate with * years of experience as ORACLE APPS DBA with WIPRO Hyderabad.
• Good communication and interpersonal skills. Highly motivated with strong commitment to quality and customer service.
• Sound understanding of oracle database architecture, configuration and administration
TECHNICAL SKILLS
Languages : SQL
ERP Package : Oracle Applications 11i,Oracle Applications R12
RDBMS : Oracle 9i, 10g
Oracle Tools : Oracle Enterprise Manager (OEM), Export/Import, Oracle Database Configuration Assistant (DBCA), Putty, RMAN.
Operating Systems: Linux, Windows NT/XP/vista/win7, windows server 2008
EDUCATIONAL QUALIFICATIONS
• B-Tech from Aurora College of Engg (J.N.T.U) in 2009
• Board of Intermediate from Sri Chaitanya Jr College
-in 2004
• Board of Secondary Education from G.M.H School in 2002
PROFESSIONAL SUMMARY:
• Comprehensive experience in Oracle Database Administration, Oracle Applications DBA Support and Implementations.
• Having knowledge in Oracle R12.
• Proficiency in installation - ORACLE E-BUSINESS SUITE – 11.5.10.2 environment – Database version 9.2.0.6 (single node & multi node Installation).
• Performed Single-Node Rapid & Manual Cloning.
• Applied various Patches to fix bug, maintain & Upgrade
• Performed System Administrator tasks
• Monitoring Database, Application, and OS on a daily basis to ensure availability, Resolve unavailability issues.
• Analyze and administer DB security, Control and Monitor user access to DB
• Working as a part of team and providing 24x7 supports on a Production database and system support environment.
• Ability to Create configured and design new database
• Work with system administrator , Network administrator to ensure oracle related matter are handled properly
PROFESSIONAL EXPERIENCE:
• ORACLE APPS DBA Wipro
Hyderabad, From 01-May-09 till Date.
Project : 1 Support of Oracle Application 11.5.10.2
Customer Smith’s Pharma-Canada
Designation Oracle Applications DBA
Solution Environment Oracle Applications Version: 11.5.10.2
Database Version: 10.2.0.2
Multi-Node, Operating System: Linux 4.0E
Highlights
Installed and maintained Oracle ERP applications version 11.5.10.2
Monitoring alert logs
Knowledge of manual cloning
Analysis and Application of Patches using ad patch.
Configured Rapid Clone.
Performed System Administrator tasks.
Good Knowledge on AD Utilities and their usage.
User account management – creating users, disabling users, responsibility management
Monitoring Database, Application, and OS on a daily basis to ensure availability, Resolve unavailability issues.
Raising, updating and monitoring different Service Request related activities
Managing concurrent managers –ensure system is running smooth, monitoring throughput, watch for long runners.
Purging unwanted request output and log files
Work with system administrator , Network administrator to ensure oracle related matter are handled properly
Support Application Developer with any and all application, database, OS, Oracle Software, and Oracle Connectivity related activity.
Project : 2 Support of Oracle Application R12
Customer British Telecom
Designation Oracle Apps Dba
Highlights:
• Maintained Applications using adutilities like adpatch,admin,admerge,adctrl
• Proficient in applying application patches.
• Proficient in doing cloning using Rapid Clone.
• Good understanding of Database Architecture.
• Creation of development database , sizing of SGA
• Looking into action requests (tickets) and resolving issues, providing the root cause, providing the permanent fix.
• Maintaining Table spaces by resizing, adding, moving data files
• Creating and Assigning Privileges, Roles and Profiles to Users
• Finding Invalid Objects and fixing them.
• Performed database cloning using Rman.
• Developed database backup & recovery strategies using Cold Backup, Hot Backup and Rman Backup.
• Implemented database refresh using full export. Used EXPORT/IMPORT to do table level and full database defragmentation.
• Checking if there is enough disk space for the data file to grow.
• Enabling/Disabling Archive Log Mode
• Checking for errors in alert logs and trace files
ACHIEVEMENTS:
• Managing Committee organizer in ELECTROKZ.
• Won many prizes in Quiz competitions at school and college.
• Participated in college and school level essay competitions and received applauds.
PERSONAL DETAILS:
Name : B. Ajay Kumar
Father Name : B. Prabhakar
Date of Birth : 15-OCTOBER-1987
Languages Known : English, Hindi & Telugu
Nationality : Indian
Hobbies : swimming.