Description
Department: Information Technology
Location: Corporate Office, Islamabad
What You Will Do
Manage all aspects of Application database administration including configuration, autoconfig, product upgrades, capacity planning, backup and recovery, DR Drills, evaluating patching requests, communicating constraints, issues and timelines for deployment.
Oracle EBS
Install, Configure & Manage EBS single/multi node, RAC Database 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) HA + DR.
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
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
Required Education & Experience
Minimum qualification Bachelors in Information Technology or in Computer Science.
Minimum 3 years of hands-on database administration experience. Prior work experience in a banking environment would be an added advantage.
Skills
Expert in HANA, Oracle, MSSQL
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.
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.
