SHRAVAN KUMAR
Mobile: +91-995*******;
Email: *************@*****.***
Bhagyanagar Colony,Kukatpally,Hyderabad-72
ORACLE DATABASE ADMINISTRATOR
• Accomplished Oracle Database Administrator Professional with almost 3+ years of
experience in Oracle Database Administration on all UNIX/LINUX Platforms.
• Responsible for Oracle logical and physical databases design, implementation and
maintenance on LINUX. Installed, upgraded and patched Oracle software.
• 3+ years of experience in providing Oracle Support to thousands of users worldwide,
earning a solid reputation for productivity, complex problem resolution and
professionalism.
• Excellent communication and diagnostic skills consistently solve problems and rarely
escalate issues.
• Proactive self-starter known to initiate process and system improvements to increase
system stability and staff productivity.
• Over 3+ years of IT working experience with a proven background of technical problem
solving.
• A self-motivated, responsible and reliable team player with a set of very strong technical
skills.
EXPERIENCE
Fosters Tridentz Techonologies . Hyderabad. 08/2011– Till Date
• Experience on Oracle Database (10g & 11g).
• Extensive Knowledge on Oracle Architecture.
• Installation, configuration and maintenance of Oracle Databases on Red Hat Linux.
• Good Knowledge on Database Creation on Windows and Unix/Linux environments.
• Created and maintained different database entities included tablespaces, data files, redo
log files, rollback segments and renaming/relocating of data files on servers.
• Good knowledge on managing Tablespaces, Users, Online redo log files, Archive log files
and Control files.
• Worked on managing Undo Tablespace.
• Monitoring space related issues of (data files, table spaces).
• Oracle Database Backup and Recovery using Manual method, RMAN (Recovery
Manager).
• Good knowledge in Exports & Imports utilities (normal/Datapump).
• Refreshed development and test databases from production using logical backups (export
and import).
• Performed Full Database and Schema level refreshes of database on Weekly basis and on
customer request.
• Good knowledge on Oracle Database Cloning.
• Physical Standby database Configuration and maintenance using Data Guard.
• knowledge on High Availability solution like Dataguard (physical and logical standby)
and Patching.
• Worked on Oracle Performance Tuning like locking, deadlock, hang, AWR etc.
• Coordinating with Support/development team for query tuning.
• Upgradation of Oracle 9i, 10g and 11g databases.
• Monitoring of High CPU loads, Tablespace Usage, Critical Table Growths, Invalids and
Alerts logs of database on daily basis.
• Automated UNIX shell scripts and scheduled batch jobs.
• Contributed in migration of servers.
• Provided on-call production database support.
• Tested and documented some Oracle new features, such as duplicate database using
RMAN from both disk and tape, setup name server.
• Created materialized views.
Key Accomplishments
• Managed a high-volume workload within a deadline-driven environment. Resolved most
of the tickets and consistently met performance benchmarks in all areas (speed, accuracy,
volume).
• Became the lead "go-to" person for new DBA’s and particularly challenging calls as one
of the company’s primary DBA’s.
• Helped company attain the highest customer service ratings (as determined by external
auditors).
Rogers Tridentz Technologies . Hyderabad. 6/2010– 08/2011
• Extensive Knowledge on Oracle Architecture
• Installing, configuring and supporting different Oracle Databases Versions on Red Hat
Linux.
• Good Knowledge on management of Tablespaces, Users, Redo Log files, Archive Log
files, Control Files and Rollback segments.
• Monitoring space related issues of (data files, table spaces).
• Monitoring and adding space to tablespace.
• Oracle Database Backup and Recovery using Manual method, RMAN (Recovery
Manager).
• Setup and Configure RMAN/Recovery Catalog for databases for backup & recovery.
• Performing logical backup using export utility.
• Developed or modified some Oracle backup and recovery scripts. Used Oracle backup
utility RMAN to implement Oracle backup and performed a disaster recovery.
• Implemented database refresh with the hot backup using DUPLICATE or full export.
Used EXPORT/IMPORT to do table level and full database defragmentation.
• Cloning the instances for making the respective instance for testing as well as for Backup.
• Performed various database Upgrades.
• Configuring Oracle Data Guard(10g & 11g - both logical & Physical Standby)
.Performing the role transition as required and troubleshooting dataguard/standby issues
• Installing, configuring and Supporting Oracle Databases Versions (10g & 11g) on Red
Hat Linux.
• Identifying the locks on the database pro-actively taking measure.
• Monitoring of High CPU loads, Tablespace Usage, Critical Table Growths, Invalids and
Alerts logs of database on daily basis.
• Database Performance Tuning.
• Troubleshooting various Database and Application Level issues on daily basis.
• Developed some Unix Shell scripts to automate database operation and database
monitoring.
• Provided on-call production database support.
• Trained a new DBA in our environment.
• Experience with Oracle 10g maintenance and support.
EDUCATION
• MCA From Princeton P.G college, Ramanthapur,Hyderabad, 64%.
.
• B.SC. (MPC) From Vignanabharathi college,Mahabubabad, 77 %
• Intermediate (MPC) From A.P.S.W.R Jr. College, Stn Ghanpur, 77%
• SSC From A.P.S.W.R School, Narsampet, 81%
SKILL SET
• Operating Systems: UNIX/Linux,OEL,Red Hat Linux.
• OracleArchitecture,RMAN,DataPump,Logminer,DBlinks,DataGuard,Materialized views,
Sql loader, AWR.
• Quick learner with ability to translate complex ideas and processes into technical facts or
persuasive non-technical presentation.
• Excellent organizational skills and ability to prioritize workload.
• Attention to detail and precision, solid work ethics concerning meeting deadlines and
reliability.