Khushhali Microfinance Bank Limited
Department:
Information Technology Department
Location:
Corporate Office, Islamabad
Objective
Assistant Database Administrator will facilitate in designing, installation, monitoring and maintenance of database utilities. Provide support and troubleshooting of database operational issues.
What you will do
Oracle EBS
Install, Configure & Manage EBS RAC Database and related products.
Install, Configure & Manage the Multi Node Application Tier (TOPs) and related products.
Monitoring the application related products like OACORE, OAFM APACHE etc.
EBS application and database upgrade in clustered mode.
Deploying Forms and Reports customization.
Setup the multi node disaster recovery (MAA).
EBS Interfacing/Integration setup, management & maintenance.
Take care of the database design and implementation for the customization.
Implement and maintain database security, encryption & Masking.
Work as part of a team and provide 24??7 support when required.
Perform general technical trouble shooting and give consultation to development teams.
Interface with Oracle Corporation for technical support.
Patch Management and Version Control in HA.
Perform database tuning and performance monitoring.
Perform application tuning and performance monitoring.
Cloning DEV and TEST from PROD.
Database Utilities Maintenance & Upgrades
Deploying Form and Reports customization.
EBS ADOP for single and multi-node patching.
Using ADADMIN utility for compiling java,reports,forms and database object
ADPRECLONE to trace database and application changes for cloning.
FMW and weblogic patching using optach and BSU utility.
Participate in the implementation and maintenance of backup/recovery as per policies and procedures.
Create and maintain database operations handbook for frequently/routinely performed tasks.
Query & Procedures optimization.
Throughput monitoring using DBCC commands, maintenance plans & third party tools.
Writing database procedures, functions and triggers & shell scripts.
Monitoring application related jobs and data replication activities.
Database Support & Troubleshooting
Provide second level support for day-to-day operations to internal departments.
Manage and resolve all concurrent manager issues.
Troubleshoot database and eBiz issues and suggest remedial solution.
Configure workflow managers as required.
Database Implementation
Manage the implementation & configuration of various oracle systems Install Oracle EBusiness suite R12, Oracle databases 12c.
Manage all requirements related to Oracle apps database administration.
Coordinate with teams in the implementation of grid computing and RAC.
What you need
At least Bachelor’s in information technology or in Computer Science with emphasis on database systems
At least 4 years of hands-on database administration experience. Prior work experience in a banking environment would be an added advantage.
Adept with T-SQL or PL/SQL (stored procedures, functions, triggers, cursors).
Proficient in creation of database objects such as tables, index, etc
Strong database backup & recovery concepts.
Good analytical and problem solving skills.
Query Optimization and performance tuning.
Exhibits and upholds KMBL??s values and social performance objectives.
SQL, Query tuning and optimization working knowledge and hands-on experience.
Must have experience in installation, configuration, upgrading, administrating, monitoring, troubleshooting, cloning, Patching, Backup and restore of Oracle EBS Excellent knowledge & understanding of Oracle Core DBA with multi-node RAC
Exhibits and upholds KMBL??s values and social performance objectives.
Additional Skills
HANA
Oracle
MSSQL