Sr. Database Administrator (Consulting)
CurrentSUMMARY• Over 15 years of experience as an Oracle/SQL Server DBA.• Expert in automation of adatabase management/maintenance/monitoring.• Strong in database trouble shooting and performance tuning.• Expert in scripting of Unix, Linux, SQL, PL/SQL,SKILLS• Oracle 7, 8i, 9i, 10g, 11g. SQL Server 2005, 2008, 2012 TimsTen, Velocis• sqlldr, exp/imp, expdp/impdp, rman, awr, apex, ords, oem, oid, http server, tomcat• Lunix, Unix, ODAEXPERIENCEAbbvie Co. Contractor Database Administrator (2007/12 – current)• Installed Oracle 10g, 11g, OEM, Agent, Apex4, 5, ORDS3, Tomcat, HTTP Server.• Created/upgraded/migrated database in 10g, 11g, ODA.• Setup/configure standby database, DataGaurd.• Applied Oracle patch and patch set.• Support application developer, vender, and end user.• Co-work with team to setup/enhancement standards for database administration.• Monitoring database by using oem, toad, scripts.• Create scripts to monitoring dead jobs, long running jobs, centralized backup report,automated database/schemas refreshing, database/listener status report, tablespace report, semi automation complex database jobs.• Supported wide range of applications including finace, science, documentum, hospital, manufactory, sales, government.• In charge of database part of DR testing.• Managed more than 40 servers and more than 80 databases.
