Bachelors in IT plus OCP

Extensive Eleven (**) years of IT experience, including as DBA in SAP development and production environments. Currently assigned Oracle Database Support

Ensure Oracle database systems operate efficiently and securely.

Manage internal databases, from planning and testing stages through implementation and support.

In-depth understanding of security and backup procedures to ensure database integrity.

Superior communication, presentation, analytical and problem solving skill. Work well with all levels of business.

Ability to multi task & prioritize under ever changing & challenging workloads

Other Strengths

Self motivated

Interpersonal skills

Team work

Good analytical skills

Ambitious

Ability to work with or without minimum supervision

Database Administration

Exceptional expertise in Oracle Database 11g Administration.

Exceptional expertise in Mysql Database Administration.

Ability to develop appropriate backup and recovery procedures addressing any business needs

Able to diagnose and recover from numerous failure scenarios

Offloading Business processes such Reporting, querying, testing and backups to standby database

Ability to implement Oracle Active Data Guard, Far Sync, rolling upgrades and snapshot standby databases

Use Oracle Database features to meet the security, privacy and compliance requirement of any Organization

SQL skills

Familiar with RAC, ASM, NAS and SAN Storage using IBM DS3400/V7000 storwize.

Oracle Solaris Administration

Interactive Installation of the Solaris 11 OS, verify the OS installation and establish the system baseline.

Booting and Shutting down x86 and SPARC systems for general OS maintenance.

Managing services that are responsible for keeping system running to ensure that business processes that are run on the system continue uninterrupted.

Making sure that OS has the latest features, feature updates and bug fixed by configuring an IPS client to access the local IPS repository, Manage package publishers, software packages and signed packages properties.

Managing Boot Environments.

Updating the OS by Using IPS.

Administering ZFS storage pools, file systems, properties, snapshots and clones as required for storage by business application data

Administer a datalink configuration, Network interface and a profile network configuration.

Configure a virtual network, verify network operations and manage resources on the network.

Configure Oracle Solaris Zones and perform necessary Administration on an Oracle Solaris Zone.

Configure the data storage environment based on your company’s data storage requirement as well how to administer the environment after it is in place.

Plan for system and file access control. How to control user, group and superuser access to the system and to files. Configure and use secure shell to control remote access to systems and files.

Comprehensive approach to managing users and groups that includes setting up new accounts, maintaining accounts, and ensuring that the users have access to the system and system resources that they need to do their work.

Managing System Processes such as able to determine the processes running on the system, the state the processes are in, resources the processes are using, control processes, terminate the unwanted.

Scheduling of System administrative tasks that occur once or on the regular basis.

Systems Administrator (SAP- Database Administrator) 13th March 2013 (8 Years) to date

Kakira Sugar Limited

Responsible for the technical and administration of the company’s Oracle Database reporting to Senior Database Administrator.

Duties:

Creating and maintaining all databases required for development, testing, education and production usage.

Taking part in the preparation and execution of technical tests.

Use appropriate database tools to replicate and maintain production database for SAP sandbox, Development and Quality databases.

Populating a database with new information or transfer existing data into it.

Creating primary database storage structures (tablespaces) after application developers have designed an application.

Maintaining indexes and table to keep the SQL performing at optimal.

Creating and maintaining primary objects (tables, views, indexes) to ensure optimal performance.

Modifying the database structure as required and conforming to the information given by application developers.

Create new database users and maintaining system security as required.

Perform database tuning and performance monitoring.

Use Data Guard to achieve a high available Oracle Database.

Offload Business processes such Reporting, querying, testing and backups to standby database.

Implement Oracle Active Data Guard, Far Sync, rolling upgrades and snapshot standby databases to meet the business needs.

Plan, implements and maintain appropriate backups and recovery procedures of the Oracle database to ensure disaster recovery, business continuity and protection of critical data service.

Diagnose and recover from numerous Database failure scenarios.

Working with Oracle support troubleshoots and diagnose problems regarding the databases and applications.

Maintain the most current updates and patches production database and its environment.

Systems Support Officer 10th Sep2010 – 13th March 2013 (3 Years)

Kakira Sugar Limited

To establish an IT support role, providing first line support liaising with the IT Manager/Mgt all the times.

Providing support to Company’s network and standalone desk services to over 200 different users.

Installing, configuring, testing and implementing hardware and software applications.

Ensure adhere to safety, health & environment policies of the company.

To rectify problems relating to the malfunction of Computer Hardware and other components.

Perform preventive maintenance duties on IT hardware.

To maintain an inventory of Computer hardware and Software (maintenance history and licenses).

To monitor and keep log of all breakdown and alteration to the network.

Follow proper backup, virus protection and security procedures noting risks to IT systems and suggest the best precautions.

Actively participate in a wide variety of ongoing and other IT new projects.

Performing any other related duties as may be assigned to you by the IT Manager/Management from time to time.

Senior Computer Operator 27th July 2009 – 10th Sep 2010 (one year)

Kakira Sugar Limited

To establish an IT support role, providing first line support liaising with the IT Manager/Mgt all the times.

Supervising daily weighbridge activities

Computing farmers ledger accounts

Preparing SAP master data

Updating the software’s

Assembling computer hardware’s

Training Computer end users

Organizing, compiling and maintaining farmer’s records.

Prepare Security Overview report for major production Databases (Assessments currently on-going)

Complete preparation of Oracle Linux 7 environment for SAP Solution Manager Installation

Deploying Data Guard 11g on Oracle Sun Server X4 – 2 and enabling automatic failover and switchovers using Data Guard Broker within Data Recovery Center (DRC) environment for Agriculture Management System (AMS).

Fully participated in updating and migration of Agriculture Management System (AMS) Application and production database from 10g Sun fire T200 SPARC running SOLARIS 10 to 11g on Oracle Sun Server X4 – 2 with Intel Xeon running Linux 6.5

Designing and developing of MySQL database applications in PHP.

Database planning, designing database structures and creating database schemas

Developing and implementing data backup strategies for the developed database

Modify database objects in accordance with new system requirements

Implementation of data entry validation mechanisms using javascript

Establishing an application's security measures during and after development

Bachelors Degree in Information Technology (IT) 2006-2009

Kampala International University

Uganda Advanced Certificate of Education (UACE) 2003-2004

Jinja Secondary School

Uganda Certificate of Education (U.C.E) 1999-2002

Bunya Secondary school

Primary leaving Education (P.L.E) 1992-1998

Magamaga Primary school

Red Hat Enterprise Linux 01st February 2021

Oracle Solaris 11 edition 5: System Administration 03rd July 2017 – 7th Jul 2017

Oracle Database 11g: Security 02nd May 2016 – 8th May 2016

Oracle Database 12c: Data Guard Administration 22nd April 2016 – 29th Apr 2016

Oracle Database 11g: Backup & Recovery Workshop 30th November – 11th Dec 2015

Oracle Database 11g: Administration II 2nd November – 30th Nov 2015

Oracle Certified Professional (OCP): Oracle Database 11g Administration

Oracle Certified Associate (OCA): Oracle Database 11g Administration

WASIGE ALAMANZAN

RESUME

Professional Summary

Core Qualifications/Skills

Working Experience:

Key Project

Education & Training

Certifications

Contact this candidate