Resume
Sign in

Manager Oracle

Email
Location:
United States
Salary:
$90,000 Per Annum
Posted:
May 28, 2012
Email:
zxfrgj@r.postjobfree.com
Contact Info:
******@*****.***


C U R R I C U L U M V I T A E

PERSONAL DETAILS

NAME: JOYCE MOTSHIDISI GABORONE

DATE OF BIRTH: 12 FEBRUARY 1974

NATIONALITY: MOTSWANA

ID / OMANG No: 166224005

LANGUAGES: Setswana and English

MARITAL STATUS: SINGLE

SEX: FEMALE

DRIVER’S LICENCE: YES

CONTACT ADDRESS: P O Box 201232
GABORONE, BOTSWANA

CONTACT TELEPHONE: (+267) 73 000 577
(+267) 72 307 939

EMAIL ADDRESS: zxfrgj@r.postjobfree.com

EDUCATION

1997 – 2000 Bachelor of Information Technology
Griffith University (Brisbane – Queensland, Australia)

PROFESSIONAL TRAINING

07 May 2012 – 11 May 2012
Oracle Database 11g: Administration Workshop II Release 2
Oracle University – Bytes Technology Group, Midrand, South Africa

07 December 2009 – 11 December 2009
Veritas Netbackup 6.5 for Unix
Symantec Education Systems – Woodmead, South Africa

07 July 2008 – 11 July 2008
Solaris 10: Systems Administration II Sun Education Systems – Midrand, South Africa
30 June 2008 – 04 July 2008
Solaris 10: Systems Administration I Sun Education Systems – Midrand, South Africa
10 December 2007 - 14 December 2007
Oracle Database 10g: Administration Workshop II Oracle University - NRG Consulting, Sandton, South Africa

03 December 2007 – 07 December 2007
Oracle Database 10g: Administration Workshop I
Oracle University – Midrand, South Africa

26 November 2007 – 30 November 2007
Oracle Database 10g: Introduction to SQL
Oracle University - NRG Consulting, Sandton, South Africa

23 July 2007 – 25 July 2007
Oracle 9i: Advanced Backup and Recovery Using RMAN
Oracle University – Midrand, South Africa
09 February 2004 – 13 February 2004 Sun Solaris 8 Network Administration
Sun Education Systems – Midrand, South Africa
02 February 2004 – 06 February 2004 Shell Programming for System Administrators
Sun Education Systems – Midrand, South Africa
01 December 2003 – 05 December 2003 Solaris 8 System Administration II
Sun Education Systems – Midrand, South Africa
21 November 2003 – 28 November 2003 Solaris 8 System Administration I
Sun Education Systems – Midrand, South Africa

21 July 2003 – 24 July 2003 Fundamentals Of Solaris 8
Sun Education Systems – Midrand, South Africa

26 May 2003 – 30 May 2003 Oracle 9i: Performance Tuning
RPC DATA Training Centre – Gaborone, Botswana

16 September 2002 – 20 September 2002 Oracle 9i: Database Fundamentals II
RPC DATA Training Centre – Gaborone, Botswana

09 September 2002 – 13 September 2002 Oracle 9i: Database Fundamentals I
RPC DATA Training Centre – Gaborone, Botswana

26 August 2002 – 30 August 2002 Introduction to Oracle 9i: SQL
RPC DATA Training Centre – Gaborone, Botswana

03 July 2000 – 07 July 2000 Introduction to Oracle 8i: SQL & PL/SQL
Oracle University – Midrand, South Africa

15 August 1994 – 19 August 1994 IT Service/Help Desk
Digital Software Technology - Gaborone, Botswana

CERTIFICATIONS
• Oracle Certified Associate (OCA) - Oracle Database 11g Administrator
o Oracle University October 2011

• Oracle Certified Professional (OCP) - Oracle Database 11g Administrator
o Oracle University January 2012

PROFESSIONAL EXPERIENCE

May 2011 – Current APPSolve Botswana
Position: Senior Consultant – Oracle Database Administrator
Oracle Database 9i, 10g and 11g

Responsibilities:
Ensuring all databases checks are done and checklists are updated daily
Monitoring and reporting availability for all databases
Provide daily support and maintenance on all the database systems housed at the (Government Department of Information Technology(DIT) - both production, development, test and acceptance databases
Installation, Configuration, Maintenance and Upgrades of all Oracle database software
Database Performance Tuning - monitoring databases; optimizing database performance and use of resources (including selecting optimal physical implementations of databases)
Put in place proper oracle and database documentation, Installation and assessment of enterprise relational database management system software
Ensure database security by putting in place oracle standard access control and user activity audit procedures
Administration of infrastructure management tools
Performing Database Installations and database creation as necessary
Monitoring and maintaining security of databases and database software on corporate, application, database ole, program, and when applicable, table, view and column levels in co-operation with development staff.
Liaising with users and development staff and application analysts on development, testing, report writing and projects to ensure project deadlines are met.
Database capacity planning: processing capacity, storage capacity and back-up capacity.
Administration of the Oracle E-Business Suite (EBS)
Responsible for all functions associated with the design, implementation and maintenance of Oracle databases including security, back-up, logging, reporting and recovery procedures
Assist in client support, setup configurations and data management processes
Maintain panel support via phone and email
Cloning of database and application instances as per system owner requests
Ensure successful Oracle Database and Application(EBS) Backups
Manage all technical aspects of the databases and processes
Manage data from multiple sources including internal, external, and 3rd party data
Assist in maintaining and improving database operational efficiency
Perform daily, weekly, and monthly data maintenance tasks

December 2010 – April 2011 RPC Data Botswana Ltd.
Position: Senior Consultant – Oracle Database Administrator
Oracle Database 9i, 10g and 11g

Responsibilities:
Provide daily support and maintenance on the Government Accounting and Budgeting System (both production, development, test and acceptance databases)
Database creation and maintenance
Installation, Configuration, Maintenance and Upgrades of all Oracle database software
Database Performance Tuning - monitoring databases; optimizing database performance and use of resources (including selecting optimal physical implementations of databases)
Put in place proper oracle and database documentation, Installation and assessment of enterprise relational database management system software
Ensure database security by putting in place oracle standard access control and user activity audit procedures
Monitoring and maintaining security of databases and database software on corporate, application, database, role, program, and when applicable, table, view and column levels in co-operation with development staff.
Liaising with users and development staff and application analysts on development, testing, report writing and projects to ensure project deadlines are met.
Database capacity planning: processing capacity, storage capacity and back-up capacity.
Administration of the Oracle E-Business Suite (EBS)
Cloning of database and application instances as per system owner requests
Ensure successful Oracle Database and Application(EBS) Backups

April 2008 – December 2010 Botswana Telecommunications Corporation
Position: Unix & Database Administration (UDBA) Specialist
Oracle Database 9i, and 10g

PERFORM ALL DATABASE ADMINISTRATOR(DBA) DUTIES AS BELOW
Perform Filesystem and Database backups.
Apply operating system updates, patches, and configuration changes.
Analyze system logs and identify potential issues with the Unix operation system.
Perform routine audits of systems and software.
Install and configure new Operating System(OS) software.
Implement standard OS user access control(security)
Document the configuration of the system.
Answer technical queries and troubleshoot any reported problems.
Perform routine or requested system performance tuning.
Ensure that the network infrastructure is up and running.

July 2001 – April 2008 Botswana Telecommunications Corporation
Position: Database Administration(DBA) Specialist
I am with the Botswana Telecommunications Corporation working as an Oracle Database Administrator (currently working on Oracle 9i version).
Responsibilities:
Provide daily support and maintenance on all oracle databases
Database creation, maintenance, backup and recovery
Installation, Configuration, Maintenance and Upgrades of all Oracle database software
Database Performance Tuning - monitoring databases; optimizing database performance and use of resources (including selecting optimal physical implementations of databases)
Purchasing of new Oracle releases and licenses.
Put in place proper oracle and database documentation
Installation and assessment of enterprise relational database management system software
Ensure database security by putting in place oracle standard access control and user activity audit procedures
Liaising with database users for advice and needs
Facilitating sharing of common data by overseeing proper key management and data dictionary maintenance.
Ensure proper change management process is in place and monitor it.
Ensure proper and successful intergration of billing applications with the Oracle database
Monitoring and maintaining security of databases and database software on corporate, application, database, role, program, and when applicable, table, view and column levels in co-operation with development staff.
Liasing with users and development staff and application analysts on development, testing, report writing and projects to ensure project deadlines are met.
Database capacity planning: processing capacity, storage capacity and back-up capacity.
Configuration, set-up and maintenance of Oracle Recovery Manager (RMAN utility / backup strategy) for backing-up, restoring and recovering Oracle Databases

March 2000 – July 2001 Government Computer Bureau (Operations Section) -
currently Department of IT (DIT)
Position: Database Administrator
On completion of the three-year study of Bachelor of Information Technology Degree, I returned to Government Computer Bureau as an Oracle Database Administrator and put to use my strong Oracle skills, which I attained during my study period at University.
Responsibilities:
Provide daily support and maintenance on all oracle databases
Database creation, maintenance, backup and recovery
Installation, Configuration, Maintenance and Upgrades of all Oracle database software.
Database Performance Tuning - monitoring databases, optimizing database performance and use of resources (including selecting optimal physical implementations of databases)
Installation and assessment of enterprise relational database management system software
Liasing with database users for advice and needs
Facilitating sharing of common data by overseeing proper key management and data dictionary maintenance.
Monitoring and maintaining security of databases and database software on corporate, application, database, role, program, and when applicable, table, view and column levels in co-operation with development staff.
Database capacity planning: processing capacity, storage capacity and back-up capacity.

February 1995 – February 1997 Government Computer Bureau (Ministry Support )
Position: Assistant Systems Analyst
I was moved to an Assistant Systems Analyst Position, main focus being to assist government ministries with all their computer system needs.

Responsibilities:
I assisted different government ministries in developing new computer systems, purchasing computer equipment and tender evaluations.
Analysis of departmental systems needs and making recommendations on the right product to purchase and implement.
Ensuring that all government computer equipment was registered with the bureau and recorded in a database.
Making post-installation checks of new equipment and organizing training for new users.
Liaising with the Supplies Department for old computer equipment that was due for replacement and ensured that it was safely put away.
Liaising with the private companies who had supply and maintenance contracts to ensure all is done appropriately.

July 1994 – January 1995 Government Computer Bureau (Operations Section) - currently called Department of IT
Position: Analyst Programmer
I was employed at the Government Computer Bureau in the Ministry of Finance and Development Planning in the Operations Section. I worked on the ICL Mainframe / ICL VME Operating System.

Responsibilities:
System Administration for different government computerized systems namely, Police Crime Recording System, Payroll System, Immigration, Accounts, Banking and Reconciliation and Education(Examinations). I was also responsible for the High Volume Printing of daily request and jobs as well as ensuring successful Backups (Daily, Weekly and monthly) are taken.

PROJECTS ACHIEVED

o January 2011 – April 2011
Government Accounting and Budgeting System Upgrade
Senior DBA Consultant – Main Project Resource
Encompasses:
o Upgrading the Oracle Database from version 9i(9.2.0.8) to 11g (11.2.0.2)
o Implementing Oracle Application Tablespace Model (OATM)
o Application Upgrade version 11.5.10.2 to latest patch set level
o Payroll upgrade version 11.5.9 to latest patch set level.
o Achieved the assigned project testing cycles 1, 2 and 3 within the specified period (I had to hand over as I was joining a different company).

o August 2010 – December 2010
Mobile Service Providers Interconnect Project
Technical Lead (Unix/DBA) for Interconnect System Project
Encompasses:
- Participate in the requirements gathering process
- Assess and discuss all Application vendor specifications and requirements and request hardware quotations from hardware suppliers following Application Vendor’s recommendations.
- Installation of Oracle 10g (Rel 2) database software on the Interconnect Servers (Test Only, Production servers awaiting delivery).
- Apply Patchset 10.2.0.1.0 to the Software on the server
- Creation of the Interconncect test database and configure it for the application (according to application vendor’s specification).
- Creation of all OS (unix), database and application users
- Ensure all the necessary directories and paths are created as per application specification
- Ensure all scripts are put in place and all the necessary cronjobs are scheduled to run at the required times
- Liaising with the application vendor, application support staff, configuration and testing staff, billing analysts and users throughout the project for requirements clarification, testing and implementation.
- Configure Oracle Recovery Manager (RMAN) backup for the Interconnect system and ensure the database backup runs at the scheduled times.
- Configure filesystem backup, ensure all the specified filesystems are included in the backup set and schedule backup to run at the agreed times.

o August 2010 – December 2010
Revenue Assurance Project
Technical Lead (Unix/DBA) for Revenue Assurance System (RA) Project
Encompasses:
- Participate in the requirements gathering process
- Assess and discuss all Application vendor specifications and requirements and request hardware quotations from hardware suppliers following Application Vendor’s recommendations.
- Installation of Oracle 10g (Rel 2) database software on the Revenue Assurance Servers (Test Only – Production servers awaiting delivery).
- Apply Patchset 10.2.0.5.0 to the Software on the server
- Creation of the RA test database and configure it for the application (according to application vendor’s specification).
- Creation of all OS (unix), database and application users
- Ensure all the necessary directories and paths are created as per application specification
- Ensure all scripts are put in place and all the necessary cronjobs are scheduled to run at the required times
- Liaising with the application vendor, application support staff, configuration and testing staff, billing analysts and users throughout the project for requirements clarification, testing and implementation.
- Configure Oracle Recovery Manager (RMAN) backup for the RA system and ensure the database backup runs at the agreed times.
- Configure filesystem backup, ensure all the specified filesystems are included in the backup set and schedule backup to run at the agreed times.

o April 2010 – November 2010
Fraud Management System Project
Technical Lead (Unix/DBA) for Fraud Management System(FMS) Project
Encompasses:
- Participate in the requirements gathering process
- Assess and discuss all Application vendor specifications and requirements and request hardware quotations from hardware suppliers following Application Vendor’s recommendations.
- Installation of Oracle 10g (Rel 2) database software on the Fraud management Servers (Test and Production).
- Apply Patchset 10.2.0.4.0 to the Software on both servers
- Creation of the FMS databases and configure them for the application (according to application vendor’s specification).
- Creation of all OS (unix), database and application users
- Ensure all the necessary directories and paths are created as per application specification
- Ensure all scripts are put in place and all the necessary cronjobs are scheduled to run at the required times
- Liaising with the application vendor, application support staff, configuration and testing staff, billing analysts and users throughout the project for requirements clarification, testing and implementation.
- Configure Oracle Recovery Manager (RMAN) backup for the FMS system
- Configure filesystem backup, ensure all the specified filesystems are included in the backup set and schedule backup to run at the agreed times.

o July 2007 – March 2008
BTC Mobile Billing Systems Project
Lead DBA for BTC Mobile Telecommunication Systems Project.
Encompasses:
- Installation of Oracle 10g database software on all Mobile Billing Servers.
- Creation of Oracle 10g databases and configure them for the billing application (according to application vendor’s specification).
- Creation of all database and application users
- Liaising with the application vendor, application support staff, configuration and testing staff, billing analysts and users throughout the project for requirements clarification, testing and implementation.
- Configuration and Implementation of Oracle Recovery Manager (RMAN) backup strategy for the whole Mobile systems- intergrated on Veritas Volume Manager

o August 2007
Implementation of Tariff Rebalancing Products
- Part of a team implementing tariff rebalancing products on BTC production Billing System, taking role of Lead DBA. Working with configuration team, test analysts, business analysts and billing analysts and providing all the necessary DBA support.

o April 2005 – February 2006
BTC Sever Consolidation and Billing System Upgrade Project
With role of DBA Project Lead
Encompasses Upgrade of :
- Unix OS (from HP-UX to Sun Solaris 8)
- Oracle (from Oracle8i to Oracle9i)
- Billing Application (from Arbor BP9.1 / OM3.2 to KenanFX)
• Installing Oracle 9i on all the new Sun servers
• Creation of Oracle 9i databases on new servers (Sun Solaris 8)
environment
• Installing KenanFX application (billing application) on Oracle 9i
according to the vendor instructions
• Migrating billing data from previous billing application
environment (running on Oracle 8i) to new application
• Liaising with the application vendor, application support staff, configuration and testing staff, billing analysts and users throughout the project for requirements clarification, testing and implementation.
• Implement RMAN backup strategy - Change from HP-UX Omniback to Oracle Recovery Manager (RMAN) intergrated on Unix Veritas Volume Manager

o September 2003 - November 2003
• Implementation of Tariff Rebalancing Products
• Implementation of ISDN Bundles and Subscription Free Internet Products

o February 2003 - April 2003 Successful Upgrade of Order Management Module for Botswana Telecommunications Arbor Billing System (Test and Production)

o November 2002 - December 2002 Successful Upgrade of Oracle Server and Database (Test/Production from Oracle8 to Oracle 8i) in Botswana Telecommunications Corporation.

o August 2001 - November 2001 - December 2001 Successful Upgrade of Botswana Telecommunications Arbor Billing System (Test and Production – Billing Module and Order Management Module)

REFERENCES

Professor Geoff Dromey
School of Information & Communication Technology
Faculty of Engineering and Information Technology
Griffifth University, Nathan Campus, Brisbane
Queensland 4111
Australia

Telephone: (0617) 373 55040
Email: zxfrgj@r.postjobfree.com

Mr Letshwao Mark Isaacs
IT Manager
Associated fund Administrators
P O Box 1212
Gaborone, Botswana

Telephone: 3650500
Cell: (+267) 71668881
Email: zxfrgj@r.postjobfree.com

Miss Agnes Pekenene
Unix-DBATeam Leader
Botswana Telecommunications Corporation
P O Box 700
Gaborone, Botswana

Telephone: 3958907
Cell: (+267) 73000665
Email: zxfrgj@r.postjobfree.com

Mr. Ganetsang Musa
IT Projects Manager
Botswana Telecommunications Corporation
P O Box 700
Gaborone, Botswana

Telephone: 3958434
Cell: (+267) 73000578
Email: zxfrgj@r.postjobfree.com