Oracle cloud SCM
SMA Express Transporation Co
Total years of experience :15 years, 4 Months
20 August 2013 to till date: SMSA Express Transportation Co. Riyadh, KSA,
Project: Oracle supplies chain management: Working in Oracle supply chain management,
Handling Oracle cloud fusion inventory module task, know how to configure and setup inventory module,
, Procurement Setup, OM, Warehouse, Purchasing, And module integration with OM, AR, WIP, BOM, and WS within the Oracle cloud fusion. Setup inventory And bringing the item into inventory. Item category Assignments and Product attribute from PIM (Product Information Management System).
Included having the assistance for making the required setups and also handling the request for schedule the jobs that are to be run and monitoring them on a period basis.
Preformed all setups for OM, Shipping, and advance pricing, Purchasing, INV and other related modules.
Application Setup of inventory Organization: Setup of inventory locations, sub- Inventory activity, item rel
Relationships, shipping networks, Transaction source and warehouse management etc. Purchasing
Module profile, receiving and financial options, location, job and position Flex Fields. Business requirement
Study and designed / documented Functional specification. Identified gap & put collaborative efforts with the technical team to address the same through technical Specification. Prepare the Configuration Document. Coordinated activities with implementation team on creating test plan & Documents, conduct unit testing, correcting bugs and re-testing while meeting project deadlines. Facilitated Discussions with end-users /
Managers to gather functional requirements. Pricing Business Requirement Study and designed /
Documented Functional. Conducting Pre Project Review & Post Project Review. Providing Post Implementation support Knowledge with Approvals Management, Create Oracle Service request.
Manage 7 database instances for our prestigious AYT Group including production, development, & testing databases. Size of databases ranges between 10GB to 1TB running on 10g, 11g version of Oracle. Databases are running on all flavors of UNIX ranging from HP, Linux and MS. Windows platforms.
Availability of database 24* 7.
Installation & configuration of different versions of Oracle on different platforms. Manage Database Character set NLS Support.
Applying recommended Upgrade Patches as well as security patches to the oracle databases
Migration & Up gradation of Oracle 9i and 10g database to Oracle 11g Rel 2
Database cloning with cold backup, hot backup as well as RMAN tape backup.
Tape Backup CA & VERITAS system backup and recovery system.
Managing a high-end critical production Oracle Database and a Disaster Recovery Site.
General database management
Apply Health checks for database performance
Database Creation, Space Management and Database reorganization and User’s Schemas.
Oracle RDBMS 10, 11g, SQL*Net, Oracle Enterprise
Manager Export/Import Management
Database performance tuning.
Troubleshooting database issues.
Capacity Planning for Table spaces.
Developing and implementing strategies for database security
Responsible for Monitoring & providing online support to the branch offices
Oracle Database Monitoring for Performance and Space utilization
Performance Tuning of the database
Server Up-gradation and Disaster & Recovery implementation
January 2009 to March 2010: Miracle Valley, India
Key Role & Responsibilities:
Involved in DBA activities, supporting Production Environments, Installation, creation and Support oracle 9i/10g
Databases in production environments. Monitoring databases which include basic health check, growth of
Objects, performance of the database and giving recommendation how to resolve it. Performing status checks by monitoring the alert log, trace files of the database. Looking into action request (tickets) and resolving issues,
Providing the root cause, providing the permanent fix, Performing backup and restoration.
creating new database under various environments monitoring the table spaces periodically for growth, table
Spaces management, user creation, privilege roles etc. Establishing Schedulers for various database backups,
Automated hot backups using a Combination of incremental, differential & full RMAN backups. Shell scripting
For different type of job scheduling. Participating with Senior team to tracing, troubleshooting, database
Performance & tuning issues. Plan backup/recovery strategies & jobs, maintenance of recovery catalog.
On call support 24x7.
Certification: • Oracle 9i Database Administration Certified Associate (OCA). • Oracle 9i Database Administration Certified Professional (OCP). • Red Hat Certified Technician (RHCT). • Red Hat Certified Engineer (RHCE). Training: • Got training for Oracle 9i from SQLSTAR INTERNATIONAL (HYDERABAD). • Got training for RED HAT from SQLSTAR INTERNATIONAL (HYDERABAD).
Master in computer Application
Bachelor in computer Application
