Worked as Sr. Oracle DBA on Integrated Property Tax System. Managed the production, test, training and development database for 24X7X365 support Developed Perl scripts for data migration, cold backup, hot backup, export of the database Developed Unix scripts for monitoring the health of the database which is run by cron and in case of any failure script generates e-mail notification
Cloned the databases.
Set up cron job to check alert log for any ORA- errors, Check listener up, Disk usage Implemented complete RMAN backup and recovery solution for full and incremental backup and recovery. Developed shell scripts to perform automatic RMAN backup using crontab and script notifies in case of failure. Tuned a SQL and brought down the response time from 13 minutes to less than a minute.
Environment: Oracle 10g, Sun Solaris 10, WebLogic 9.2, Savvion 7.0, J2EE, Eclipse, Windows 2003, MS SQL Server 2000