My Professional Summary
- Over FIFTEEN years of extensive experience in the IT industry, with 9+ years of experience as an Oracle Database Administrator. Involved with the databases from designing, developing, implementing and administering, 24x7x365 OLTP, as well as mission critical Data Warehouses (DSS), which includes installations, support, space management, backup & recovery, networking, monitoring & managing of users, performance tuning of applications, as well as the databases; Oracle 11g/10g/9i/8i/8.x/7.x; using SQL, PL/SQL, SQL*Plus, Sql Developer, RAC/OPS (Oracle Parallel Server), Data Guard/ Standby Database (Physical/Logical), DataPump, Oracle Enterprise Manager, OMS & Oracle Grid on Unix/Linux & Windows platforms.
- Expert in all phases of Business Intelligence (DW) development lifecycle; Business Modeling => Data Modeling => Data Sources => ETL => Data Warehouse => Data Marts/OLA
- Strong Understanding of different variants of UNIX; HP UNIX, AIX, Sun Solaris and Linux.
- Having very good understanding with the front‐end tools, Developer 2000/6i, Visual Basic & Java.
- Proficient in use of ERWIN/Visio for Logical and Physical database design.
- Experienced in designing & implementing education, training & mentoring sessions/programs for junior DBAs, the end users, as well as clients.
- Team player with excellent communication and problem solving skills; helps to bridge the gaps, between all the concerned parties (on‐site/off‐site IT, as well as non‐IT‐business/management)
- Good exposures to the complete project life cycle (SDLC) support, using advanced system management tools.
Databases:
Oracle 11g/10g/9i/ 8i/ 8/ 7, MySql, PostgreSql, DB2, Sql Server, MS Access, FoxPro
Languages:
SQL, PL/SQL, Java, XML, Perl, C++, Visual Basic, Cobol, and GW Basic
Oracle Products:
Sql Developer, Oracle Applications 11.0/11i, 9iAS, Designer 6i, Developer 2000/6i, Forms 5/4.5/3, Reports 3/2.5, WebDB 2.2, Oracle Express Server 6, ASM/OMF, Import/Export, DBMS Packages, Oracle Diagnostics and Tuning Pack, Enterprise Manager/Grid Control, RMAN, AWR, SQL* Loader, OPS (Oracle Parallel Server/RAC)
O.S:
Linux, AIX5L64bit, HP UNIX, Solaris, SCO, Windows 2000/NT, Novell Netware
Designing tools:
Erwin, Visio 2001, Designer 6i
Other Applications:
DBArtisan, TOAD, Business Objects, Data Stage, Exceed, Legato, SAM, CDE
Hardware:
Dell PowerEdge, HP‐9000 series, Sun Sparc/Fire V440, T2000, IBM Risc‐6000, Digital Alpha, Compaq Proliant (1500, 2000, 1200), Compaq Prosignia 300.
Certifications:
- Oracle 9i, 8i, 8 & 7.3 Certified Professional Database Administrator
- IBM Certified Specialist DB2 UDB Version 6/7
Milestones:
~ 11gR2 RAC implementation on Suse 10 Enterprise Server ~ Datapump refreshes across databases via db link ~ Intense SQL profiling & tuning ~ Manual Upgrade from 9207 to 10203 ~ Automatic Statistics gathering ~ Partition Maintenance automation ~ Resource Manager Configuration ~ MySql refreshes using pipe