Provide technical subject matter expertise to IBM clients in designing, implementing and support of Oracle Applications, IT Business alignment, IT re-organization & setup, Disaster recovery planning and IT infrastructure areas

• Installation, administration, maintenance and configuration of Oracle Database and tools.


• Day-to-day administration and maintenance of databases under windows.


• Creating Standby Database environment.


• Responsible for ensuring best practices related to database configuration, storage, backup and user management.


• Working closely as the software team for system performance and availability.


• Roll out of database patches in both production and development environments.


• Assisting application support teams in optimization of database queries.

• Providing technical assistance to the Oracle Application and Sidat Hyder financials teams.


• Involved in the customized application development and support.


• Closely working with the customers for the errors, bugs and new requirements.


• Roll out of patches in both production and development environments.


• Data migration from non-oracle database using SQL*Loader.


• Export and Import of database objects


• Involved in the design and development of Forms and Reports using Developer2000.


• Involve in the development of new coding standards for the forms and reports.


• Designed the new GUI screens for the new product as per customer requirements


• Designed and developed the database code including new tables, triggers, procedures, indexes, sequences and packages.


• Performance tuning of the procedures and functions.

Apps Admin Role:


• Defining Responsibilities and Users


• Defining menus and request groups


• Attaching responsibilities to users


• Defining and Implementing position hierarchy


• Add and remove functions from applications


• Assisting the Implementation team


• Defining concurrent Requests and Report sets


• Scheduling concurrent requests


• Defining value sets


• Adding customized forms and reports with oracle applications


• Data Loading


• Defining key Flex fields to the user defined modules


• Defining descriptive flex fields for the user defined modules


• Enabling the flex fields from Oracle applications


• Applying patches


• Perform cloning


• Running utilities like ADADMIN, ADCTRL, ADPATCH


• Support to functional team on implementations, TARS and all activities


• Involved in Oracle APPS installation


DBA Role:


• Installation, administration, maintenance and configuration of Oracle Applications, Database, Oracle tools, Oracle Apps Tools.


• Creating Standby Database environment.


• Day-to-day administration and maintenance of databases under windows or Linux.


• Responsible for ensuring best practices related to database architecture, configuration, storage, backup and user management are adhered to within all environments.


• Playing an advisory role during design and implementation project phases.


• Defined and documented scenarios to validate backups taken via centralized backup solution.


• Carried out database security hardening exercise for all databases.


• Roll out of database patches in both production and development environments.


• Troubleshooting performance related issues using various tools such as AWR, ADDM and Statspack reports.


• Assisting application support teams in optimization of database queries.