1.Assist the Senior IT Management team in the development and design of database strategies, monitoring and improving database performance and capacity, and planning for future expansion requirements along with Business Systems Team (BST)for specific BST
1.Evaluating hardware, architecture design, install and upgrade the Database server and application tools in order to ensure optimum performance and identify current and potential bottlenecks.
2.Refine logic data model, allocate system storage and plan future storage requirements for the database system in order to accommodate future business requirement and capacitate system stability and accommodate all users
3.Administering application servers, creating primary database storage structures and objects once application developers have designed an application in order to ensure usability and clarity for users.
4.Modifying the database structure, as necessary, from information given by the application developers, enable data integration between different applications, create new users and ensure that the proper access is given to the users and validate application packaging and maintain utmost system security.
5.Contact Software Vendor for technical support, plan back-up and recovery of database information and ensure optimum performance of the database and compliance with Oracle license agreement.
6.Install, test and ensure that all upgrades and patches as well as oversee backup, clustering, mirroring, replication and failover.
7.Plan for backup and recovery of database, apply patches, make copies of the production ERP server and other updates within the production, development and test environments and monitor the performance in order to ensure smooth and efficient operation of application server infrastructure.
8.Maintain archived data on tape, participate in DR discussions and activities, implement any new changes in the ERP, in coordination with the development team, and provide data integration between various applications in order to ensure that the data is transferred smoothly between various applications.
9.When necessary develop complex DBA scripts, debug programs to suit system environment.
10.Maintain and monitor organization websites related platforms.
1.Works on an on-call basis with responsibilities in resolving problems related to the operational database.
2.Develops application and database upgrade plans and implements these into the operational database environment.
3.Assists the project teams in developing and/or implementing computerized solutions to business needs.
4.In coordination with departmental staff provides the initial orientation and training to system users as required by any system implementation or change.
Bachelors Degree in Computer Science or allied IT discipline having 06 years of experience within an excellent capabilities in Database Management, IT Data Systems & Security domain
OR Two years college Diploma in the related field with 08 years of related work experience
OR Specialized certificate / License in the related field with Secondary School certificate and having 12 years of WY / Aviation experience in similar functions.
Proficient in English (Spoken & Written) & Proficient in MS Office.
Knowledge of Oracle E-business suit & UNIX operating system and networking.
Knowledge of Relational Database Management Systems & Web Application Servers
Troubleshooting and diagnostic ability.