Database and Application Team Leader
Kifiya Financial Technology PLC
Total years of experience :8 years, 11 Months
• Plan and review database storage requirements
• Training staff on oracles SQL fundamentals, Administration, security,
auditing, RMAN backup etc…
• Co-ordinate and work as part of a team and provide full support
when required to achieve the vision and the goals of the company
• Organizing weekly report and submitting to division manager
• Responsible for proactive monitoring and maintenance of database.
• Monitor database performance, diagnose performance problems, and tune
the database as necessary.
• Monitor alert log entries
• Check all crons and Oracle Jobs are completed without any error
• Support the roll-out of new applications
• Maintaining confidentiality of work related information and materials
• Maintain confidentiality with regard to the information being processed,
stored or accessed.
• Document system problems and resolutions for future reference
• Comply with standards and policies and procedures
• Maintain database integrity and security
• Support development team in relevant issues
• Help users through a series of actions, either face to face or over the
telephone to resolve issues.
• Generate relevant reports
• Configuring and managing Oracle Stream replication
• Communicating product venders when support is needed and providing them with necessary information they need.
• Responsible for the technical and administration aspects of the companies Oracle
and SQL Database infrastructure.
• Configuring and managing replication systems through Talend (ETL) tool
• Designing database based on design methodology
• Design and implement necessary modifications to enable databases
accommodate newly introduced structures or changes
• Tuning the Jboss application server.
• Designing a report by using jasper I report tool
• Monitoring the functionality and performance of application servers.
• Checking the users’ session and taking corrective actions as required.
• Checking free spaces of the table spaces in the database and the directories
on the server.
• Verifying /checking that all instances are up and running
• Monitor database performance, diagnose performance problems, and tune
the database as necessary.
• Monitor alert log entries
• Check all crons and Oracle Jobs are completed without any error
• Migrating oracle database from Standard Edition to Enterprise Edition.
• Migrating MS SQL server 2008 database to oracle 11g.
• Taking the backup of the databases (logical and physical)
• Support the roll-out of new applications
• Maintaining confidentiality of work related information and materials
• Maintain confidentiality with regard to the information being processed,
stored or accessed.
• Document system problems and resolutions for future reference
• Comply with standards and policies and procedures
• Maintain database integrity and security
• Support development team in relevant issues
• Help users through a series of actions, either face to face or over the
telephone to resolve issues.
• Installing and Configuring J2ee application Server and deploying flex cube
application (FLEXCUBE oracle application server).
• Creating multiple oc4j instances and tuning them.
• Monitoring the functionality and performance of application servers.
• Checking the users’ session and taking corrective actions as required.
• Checking free spaces of the table spaces in the database and the directories
on the server.
• Co-ordinate and work as part of a team and provide full support
when required to achieve the vision and the goals of the bank
• Promoting team spirit and cooperation between the team
• Verifying the Oracle Services are running
• Responsible for proactive monitoring and maintenance of database.
• Taking the backup of the databases (logical and physical)
• Validating the backups by using different RMAN commands.
• Restoring and recovering RMAN backup on different server to test the
validity of the backup.
• Tuning Performance of the database by tuning crucial instance parameters
that have high performance impact on database.
• Automating deletion of unnecessary logs.
• Maintaining confidentiality of work related information and materials
• Maintain confidentiality with regard to the information being processed,
stored or accessed.
• Document system problems and resolutions for future reference
• Enrolling the system users and granting them the necessary role
• Verifying the Oracle Services are running
• Creating different views and triggers
• Generating various reports by writing different queries and giving
data for both internal and external customers based on their
requirements and format.
• Work with software development and other team when it is needed
• Developing good backup and recovery strategies using oracle utilities
like RMAN, Data Pump and original import and export
• Taking the backup of the databases (logical and physical)
• Validating the backups
• Controlling the security of the databases
• Setting up new users' accounts and profiles and dealing with password
issues
• Managing replication systems using HVR replication tool.
• Doing recovery when it is necessary
• Allocating system storage and planning future storage requirements
for the database(capacity planning)
• Checking the availability of free space on the hard disk and in table spaces
• Checking for the log and trace files
• Proactively monitoring and optimizing the performance of the
database.
• Maintaining confidentiality of work related information and materials
• Installation of Oracle 10g/11g software.
• Creating both test and production databases
• Enrolling the system users and granting them the necessary role
• Verifying the Oracle Services are running
• Taking the backup of the databases (logical and physical)
• Validating the backups
• Checking the availability of free space on the hard disk and in table spaces
• Checking for the log and trace files and many more
• Maintaining confidentiality of work related information and materials
• Supporting tax payers on different issues
• Joining new computers to the network of the company
• Trouble shooting network and printer problems
• Formatting end users’ computer on demand and installing different
software and Anti-viruses
• Installing oracle clients software and configuring oracle forms and reports
• Training end users on how to use the systems.