Oracle DBA
IPKO TELECOMMUNICATIONS
Total years of experience :14 years, 8 Months
Telecommunication databases are the most complex databases to be administered in today's Industry. At IPKO Telecommunication we have prepared databases for development, testing and production usage. Working closely with system administrators to set best practices environment for Oracle databases.
We have worked with 10g, 11g RAC and standalone databases. Upgraded Oracle databases to new releases namely from 10g to 11g. Implementing Backing up and restoring policies. Implementing retention policies and archiving old data.
Responsible for tuning processes/queries, creating packages, procedures and functions.
General tasks:
-----------------
• Administering all database RAC 10g, 11g, from billing, prepaid, postpaid, data warehousing and application DBs
• Implementing retention policies, backups, and restore
• Tuning storage data and maintaining disk spaces.
• Creating SHELL scripts to monitor database activities, performance and availability
• Designing ETL (Extract, Transform, Load) for Data warehouse, and other processing systems used for reporting and fraud
• Updating Universe at SAP systems
Tools/applications used:
Linux, Oracle RAC 10g, 11g, Oracle Standalone, Golden, Toad, EM, SQLDeveloper, vi (linux), Microsoft Word, Microsoft Excel, Secured SRT
Work Description:
Assistant of Database Programming lecturer, assisting on conducting the Tutorial classes.
General tasks:
-----------------
Teaching Students:
1) Designing Database
a. Define the Structure of RDMBS: Tables, Rows, Columns, Keys (such as Primary, Foreign Key)
b. Normalization rules up to 3rd
2) SQL: Basics
a. Writing SQL SELECT Statements,
b. DELETE Statements,
c. UPDATE Statements,
d. ALTER Statements, etc.
3) SQL: Sub queries
a. Sub queries with WHERE or HAVING Clause
b. Sub queries returning multiple row or columns
c. Sub queries using EXISTS, ANY, SOME, ALL operators
4) DML (Data Manipulation Language)
a. Rolling back data
5) Creating Databases, DDL (Data Definition Language)
6) PL/SQL
a. Procedures,
b. Functions
c. Cursors
7) Oracle Forms,
8) Oracle Reports,
9) Helping students with the Semester Final Project
a. Their Project was flight booking
Tools/applications used:
---------------------------
1) Oracle 10g express edition,
2) Oracle 6i,
3) Notepad - for writing sql
Work Description:
Attached in AML Project (Anti-Money Laundering), being responsible for ETL (Extract Transform Load) data into the database, build up procedures and functions to cater the needs of the Users of the AML system. Develop and implement PL/SQL stored procedures and UNIX shell scripts. Troubleshoot and resolve database-related incidents, review complex database queries and/or programs and recommend changes. Create and manage database objects such as tables, indexes, views, procedures, functions etc.
General tasks:
-----------------
Implement and maintain database operational flow and security.
Review and execute routine service requests
Review, sign-off and migrate database changes to Production environment.
Create and submit required DBA reports to designated individuals/groups.
Create and maintain support documentation.
Tune queries, develop procedures and functions, Create conceptual database design - e.g. data modeling; ER diagrams.
Tools/applications used:
Linux, Oracle, SQLDeveloper, vi (linux), Microsoft Word, Microsoft Excel.
Work Description:
I was assigned various tasks during this period. The tasks range from simpler day to day tasks, printing, configuring, fixing and installing to developing, backing up and monitoring.
General tasks:
-----------------
1) System observing, assurance - The ERP System developed (being developed) by the MIS Department got familiar with functionality and features of the system because I will be developing and documenting parts of the system. Therefore it was a chance to notice any bugs on the system.
2) Installing - Linux (Fedora 13, now new version is out already) and get familiar with commands, configuring new Service Pack for Windows 7, and installing Windows XP on the sales laptops.
3) Configuring - The SEAM Framework and JBoss application server to be able for developing in JAVA
4) Backing up - Staff in company had confidential and vital data that needed to be saved time to time. Hence using the ERP System we made a daily back up. Full backup is made in the first time, followed by incremental backup run on daily basis.
5) Developing - The HR Recruitment module. This was a small module that future employees will fill up and give the personal details (like a resume for prospect employees)
6) Training - employees that do not know how to use the system were trained by me. Hence considerable time was spend training sales and engineers on how to use the system.
7) Documenting - I was assigned to establish the site and compile a PDF manual for the system
Tools/applications used:
---------------------------
• SEAM Framework - A Framework that brings together Hibernate and
• PostgreSQL - A very powerful open source data base application
• Microsoft Work - Compiling the manual
• JBoss - Application Server which was used to Develop and Compile JAVA Script
• JAVA - Java Programming
• Linux - Operating system
Database Programing Trainer Programming Contest participant Scholar of Al - Bukhary Foundation