Professional Profile

• I have more than 20 years of experience in the Information Technology Industry. I have worked as a Database Administrator, Programmer/Analyst, Network Administrator, System Administrator and Systems Analyst in the financial, communication, retail/wholesale, banking, services, and transportation and government industries.
• Oracle Database and Application Server Administration Worked for several industries from Communications, Government and Insurance. Involves database design, creation and implementation. Deals a lot in Database installation, maintenance, fine-tuning and performance tuning from version 8 up to the current 11.2.0.3. The Oracle instance resides in different flavors of UNIX, from Solaris, HP/UX, AIX, Oracle Linux and Window Server 2008. Extensive experience in RAC, RMAN and DataGuard for implementations of Physical Standby DB. Designed, installed, configured and implemented Forms and HTTP services using Oracle Application Server. Implementation and maintenance of Pentaho ETL. Experience in Oracle RAC with extensive working experience in OEM and Toad
• Oracle Application Development Single-handedly doing the conversion of the WCIS on-line forms from Oracle 6i to Oracle Web Based Forms 10g. It involves the design, creation and implementation of new Oracle Application Server that resides in a middle-tier MS Windows 2003 Server.
• UNIX/Linux/Network Administration and Development Worked on different flavors of UNIX from HP/UX, Solaris, AIX and Linux. Worked for the Roads and Traffic Authority of Australia the created the Watchdog System that monitored all UNIX Processors connected to the WAN using UNIX shell scripts and C programming. Member of the Environment Group team that involved in the implementation and configuration of the hardware and software for all UNIX related tools including Network configuration and installation.

Areas of Expertise

• Oracle Database Administration
• Oracle Application Server Administration
• Oracle Application Development
• Oracle Database Design/Analysis
• Oracle Performance Tuning
• Application Design/Analysis
• UNIX/Linux System Administration
• UNIX/Linux Shell Programming
• Business Process Reengineering
• Team Leadership
• Entity Relationship Modeling
• Network Support
• Application and Technical Support
• Mentoring and Documentation
• Experience and Skills
• Oracle Enterprise Manager
• Oracle Application Server Control
• Oracle Developer/2000
• Oracle Designer/2000
• C/C , Java and Perl
• RMAN DataGuard
• Oracle Pro C and JDeveloper
• SQL DBA
• SQL Plus, PL/SQL
• Brio SQR
• Merant PVCS
• Appworx
• UNIX, Solaris, Linux

Experience Highlights

Confidential

Oracle DBA

MindLeaders Maintained the Oracle RAC 11g databases under Linux OS and Windows Server. Supports both development and production databases. Monitors and fine-tune the database instances using the combination of OEM and Toad. Designed, configured and implemented the DB backup and recovery procedures using RMAN and DataGuard. Designed and implemented the Standby Database using DG. Implemented and maintained the ETL using Confidential.

Confidential

Oracle Consultant

Worked as an Oracle Consultant that maintains the WCIS Oracle database and application. The maintenance includes the upgrade for both Oracle RDBMS and WCIS Oracle application programs. It involves fine-tuning and optimizing the embedded SQL script for both batch and online screen using Oracle tools like TKPROF, Explain Plan, Quest Toad and Oracle Enterprise Manager. Upgraded the WCIS online system from Oracle Forms 4.5 to Oracle Forms 6i and currently finalizing the upgrade to Oracle Forms 10g.

Confidential

Oracle Database Administrator

Created, maintained and supported both Customer Relationship System Confidential and Sales and Marketing System SAMID development and production development team. This involves creation and upgrade of Oracle databases for all development instances.

Confidential

Programmer/Analyst

Worked on the User Support System USS used to administer advanced 800 service. USS supported service provisioning, network data administration, network management and service maintenance aspects of advanced 800 service outbound International Toll Free Calling ITFC . Analyzed, designed, coded and tested programs using C and K Shell for all USS sub-systems. Designed, coded and implemented programs regarding data transfer to and from different Confidential systems.

Confidential

UNIX and Network Administrator

Worked on the DRIVES Project, a UNIX-based FUJITSO 780 series Mainframe running ORACLE RDBMS V 6.0. Part of the environment group involved in the implementation and configuration of the hardware and software used by the Project. Designed and coded C-programs needed for system monitoring. Documented installation procedures and user's guide.

Confidential

Oracle DBA/ Oracle Application Server Administrator

Workers' Comp designed, installed and configured the bureau's Confidential system. The Confidential system was based on a client-server environment and I spearheaded the upgrade to Oracle 10g using Oracle OAS web-based system.

Confidential

System Analyst

Conducted a feasibility study to purchase a new computer system to be used by the Department of Transportation and Communication in its new systems implementation. Supervised the overall systems development with emphasis on the proposed new hardware set-up. Designed and reviewed the proposed hardware and software set-up. Set-up and conducted the benchmark to evaluate the performance of different proposed systems.

Confidential

Oracle Database Administrator

Worked with the interface between different existing systems in automating the transfer or sharing of data, using Snapshot, SQL ProC and SQL Net. Maintained the Interface Manager which controls the Confidential interface and definitions of the Confidential existing set-up. Created a script to maintain the database integrity. Affected all the database changes in the development and the production machine. Generated the database DDL using Oracle Case Generator. Designed and created scripts in the transfer and sharing of data. Monitored the database usage and fine-tuned the production database according to the proper DDL parameters.

Confidential

Oracle Database Administrator

Worked for the Confidential Project system that automated and stored the Telstra's RIM configuration. Maintained and updated the schema including the E-R diagram tables, indexes, constraints, snapshots, views, grants and synonyms . Designed coded and implemented a mirror offsite database to ensure the availability of the database during production.

Chronology of Experience

Confidential

Position: Oracle Database Administrator

Environment: Sun Solaris, Oracle Linux, Windows Server 2008,

Tools: Oracle RDBMS 10g and RAC 11g Oracle Enterprise Manager, UNIX Shell Script, Perl, JavaScript, Java 2, SQL Plus, PL SQL, SVN, Eclipse, Tomcat, Pentaho ETL, Erwin

Currently maintain the Oracle 10g and 11g databases under Linux OS and Windows Server 2008. Supports both development and production RAC databases. Maintains monitors and fine-tune the database instances using the combination of OEM and Toad. Designed, configured and implemented the DB backup and recovery procedures using RMAN and Data Guard. Using Standby DB and weekly Hot-Backup for DB backup. Using imdp and expdp for development data refresh. Supports the Development team in fine-tuning SQL and PL SQL code. Monitor the database servers responses for the main web application using OEM, TOAD and UNIX commands. Implemented and working on Pentaho ETL. Makes and maintains the scripts using Perl and JavaScript for daily jobs that is being invoked by Oracle Scheduler. Also backup the DB using NetApps for Oracle. Used Erwin tools for Diagramming and Physical Logical transformation. Migrated all Oracle DB from Solaris to Oracle Linux and Window Server 2008.

Confidential

Position: Programmer/Analyst

Environment: Sun Solaris, IBM AIX, Linux, Windows 2000

Tools: Oracle RDBMS 7/8i/9i, Oracle Enterprise Manager 2.2, Oracle Developer/2000, SQL DBA, SQL Plus, SQL Forms, PVCS, UNIX Shell Script, Perl, SQR, VISIO, C/Pro C, Java 2, MS Excel, Erwin, MS SharePoint, Visual Basic, Xerox Elixir

Worked as an Oracle Consultant that maintains the WCIS Oracle database and application in various OS. From IBM AIX to Linux. Designed, installed, implemented and monitored the Oracle Applications Server using Web Based Forms Services and HTTP services. The maintenance includes the upgrade for both Oracle RDBMS and WCIS Oracle application programs. It involves fine-tuning and optimizing the embedded SQL script for both batch and online screen using Oracle tools like TKPROF, Explain Plan, Quest Toad and Oracle Enterprise Manager. It also involves the maintenance of the WCIS online screen using Oracle Developer 2000. Designed and configured the whole WCIS batch processing flow using Appworx that also includes UNIX shell programming. I am also spearheading the upgrade of Appworx, PVCS and Brio SQR. Used Erwin tools for Diagramming and Physical Logical transformation.

Confidential

Position: Programmer/Analyst

Environment: Sun Solaris, Windows 2000, PC/LAN

Tools: Oracle RDBMS 7/8i/9i, Oracle Enterprise Manager 2.2, Oracle Developer/2000, SQL DBA, SQL Plus, SQL Forms, PVCS, UNIX Shell Script, Perl, SQR, VISIO, C/Pro C, Java 2, MS Excel, Visual Basic, Xerox Elixir

Developed new online and batch modules for the Workers Compensation Insurance System Confidential. Upgraded the version of the Confidential online screen from SQL Forms 4.5 to Forms 6i. Maintained the Workers Compensation Insurance System WCIS and optimized the embedded SQL script for both batch and online screen. Provided programming tips using Developer/2O00 and Oracle Confidential tuning techniques.

Confidential

Position: Oracle Database Administrator

Environment: Windows 3.11, HP/UX, Solaris 2.6, UNIX

Tools: Designer/2000, C, Oracle 7.2.3, Server Manager/SQL DBA, SQL Plus, Oracle Pro C

Supported the Customer Relationship System CARS development team of 10 people.

Created the development database and test database. Maintained and supported the Confidential production database using various Oracle database tools such as SQL DBA, SQL Plus, PL/SQL and PRO C. Created and maintained the CARS environment using Designer/2000, including generation of modules and DDL. Fine-tuned the development database by adjusting the unit parameters. Created and tested database triggers and stored procedures to be used for updating remote database. Provided technical supports for creating an optimized SQL statement. Maintained and updated the schema including the E-R diagram tables, indexes, constraints, snapshots, views, grants and synonyms . Made library functions and modules using C/C and PL SQL. Designed coded and implemented a mirror offsite database to ensure the availability of the database during production. Worked with different teams to optimize and give advice on the proper way to code and fine tune an Oracle application SQL. Applied patches to fix an Oracle bug. Created scripts to monitor the database segments and adjust as necessary.

Confidential

Position: Software Engineer

Environment: Windows NT4.0, HP/UX, HP Open View, UNIX

Tools: Developer/2000, C, Pro C, PL SQL, Oracle 7.2.3, EasyCASE

Member of a 10-person team that produced the software module in a fully automated warehouse distribution system called WMS, which controlled and maintained the warehouse physical inventory. Analyzed, designed and created the User Security sub-module using EasyCASE for data modeling and Developer/2000 front-end code generation.

Confidential

Position: Oracle Database Administrator

Environment: DG-UX, Windows 95

Tools: Designer/2000, Developer/2000, Unix/C, Oracle 7.1.6, Server Manager/SQLDBA, SQL Net, PL SQL, SQL Loader

Worked for the Offender Management System 4 project as a Developer and DBA. OMS 4 was a new development that used new tools from Oracle. Both the Designer/2000 and the Developer/2000 were created to replace the older version of Confidential. Generated Forms modules through Case without any post generation coding. Designed, analyzed and generated Forms 4.5 modules using the Designer/2000 and Developer 2000. Made packages, functions and procedures using the repository and PL SQL. Constructed Forms 4.5 template and Reports 2.5 template to be used during module generation. Administered the repository and performed frequent backups and exports of the repository to be transferred to Canada. Assisted the department's DBA and gave advice and consultation on aspects of database administration.

Confidential

Position: Programmer Analyst

Environment: Windows NT4.0, UNIX

Tools: Oracle Forms 4.0/4.5, Pro C, PL SQL, Oracle 7.0.13, EasyCASE

Designed the Confidential total system flow and User's Guide. Made program specifications to conform to PPS and Telecom GUI standards. Coded programs using Oracle Forms 4.0.13/ 4.5.5, SQL Report Writer 2.0./2.5, SQL Menu and SQL ProC. Created and tested library procedures that are used as one of the standard procedures.

Confidential

Position: Oracle Database Administrator

Environment: HP-UX9000, Amdahl, Windows 3.11, TCP/IP

Tools: HP Open View, UNIX/C, Oracle 7.0.3, Server Manager/SQLDBA, PRO C, SQL NET, SQL Loader

Worked with the interface between different existing systems in automating the transfer and sharing of data using Oracle Snaphsot, SQL ProC and SQL Net. Maintained the Interface Manager that controls the SCEP interface between different Oracle databases. Affected all the database changes in the development and production databases and generated the DDL using Oracle Case Generator. Monitored the database usage and fine-tunes the production database.

Confidential

Position: Oracle Database Administrator / Developer

Environment: AT T 3B2-700, AT T Star Server, Amdahl UNIX MF, UTS/M, TCP/IP

Tools: Oracle v 6.0, SQL Plus v3, PRO C, C, SQL Forms 3.0, OS/s 2.0

Analyzed, designed, coded and tested programs of all background and supporting processes involved in updating the database of the HRMS using C, PRO C, SQL Plus and Unix Shell programming. Installed AT T UNIX 3.2.3 Operating System in a 386 LAN Server that served as a development machine. Installed Oracle RDBMS 6.0 system after installing the UNIX Operating System. Worked on the User Support System USS used to administer advanced 800 service. Designed, coded and tested a program that will be used by the SURROUND System.

Confidential

Position: Software Engineer

Environment: FACOM M-780, SCO UNIX 3.2, OS/2, UTS/M, TCP/IP

Tools: Oracle RDBMS v 6.0 SQL Plus v 3.0

Created the Watchdog System that monitored all UNIX Processors connected to the Wide Area Network. The system used UNIX built-in systems performance monitoring to extract data from all the Registries Processors and store in Oracle database using SQL Loader to be processed using SQL Forms. Designed and developed the entire system and developed the database using SQL Forms v 3.0 and C.

Confidential

Position: Network Administrator

Environment: IBM/PS2, IBM Token Ring, Novell Netware, Facom M-780, Bridge CS/1, TRW ACU 2000

Tools: X-talk, C, PC/TCP, Informix

Designed and created the LAN Management System using Informix - Rapid Development System. This system provided convenient access to all the department's network configuration and equipment, using Informix - 4GL with Informix - Forms. Configured the LAN and carried out the installation of network facilities and provide technical assistance to the office's network users. Rationalized the allocation of ASCII terminals, terminal server ports and gateway rotaries. Carried out the specification and installation of network facilities and provided technical assistance to the office's network users.

Confidential

Position: Analyst/Programmer Database Administrator

Environment: UNIX, FACOM M-780, IBM/PC, TCP/IP

Tools: Oracle 6, Cobol, VSAM, C, UNIX Shell script

Analyzed, designed, coded and tested programs of all background and supporting processes involved in updating the database of the PIS using C, PRO C, SQL Plus and Unix Shell programming. Designed the PIS total system flow and User's Guide. Installed the Oracle 6 RDBMS and created and implemented the backup and recovery procedure.