Coordinator, Database Administration Team/Senior Oracle Apps DBA
King Fahd University of Petroleum & Minerals
مجموع سنوات الخبرة :14 years, 8 أشهر
• 10+ years of experience in Oracle E-Business Suite, Ellucian Banner ERP and Database administration
• Excellent onsite 24/7 Database Support and maintenance
• Excellent written and oral communication skills
• Proactive in identifying issues and make sure services are meeting SLA
• Worked for leading Education sector customer and handled technical roles such as DBA Team Coordinator, Oracle Apps DBA, Oracle RAC DBA, MS SQL DBA, Ellucian Banner DBA and System Analyst
• Experience on wide range of products such as Oracle E-business suite, Oracle RAC Database Cluster, Ellucian Banner ERP, PostgreSQL DB, Oracle WebLogic application Servers and Microsoft SQL Server Always on Cluster
• Oracle Certified Professional
• Proficient in Installation, configuration, cloning, patching of databases Oracle 11g/12c/19c, Oracle E-business suite R12.2/R12.1.3 and Ellucian Banner Student ERP
• Expertise in setup of Oracle RAC, physical standby Dataguard, Oracle ASM, Oracle Multitenant CDB and PDB’s, WebLogic on different platforms
• Highly skilled in backup, recovery, performance tuning of Oracle 11g/12c/19c and EBS Applications
• Proficient in working with technical and functional teams
• Skilled in databases MS SQL servers 2019, 2014, Clustering and Always on feature in MS SQL
• Skilled in Symantec NetBackup backup/recovery for oracle/SQL databases and flat file systems
• Well adhere to ITSM/ITIL process like change control, problem management, incident management (ISO 27000)
Presently I am working as a Coordinator/Team Lead of Database administration team comprising of 3 members. I have worked on multiple projects in IT Operations and Engineering department at KFUPM and I am responsible for administration of critical systems.
Responsibilities:
Oracle E-Business Suite Administration: End-to-end administration of Oracle e-business suite R12(12.2/12.1.3)
• Applications maintenance and administration
• Installation and configuration of applications R12
• Concurrent manager administration, ad utilities
• Configuring workflow mailer
• Applying application patches such as One-off, Mini-patch, Rollup Patch, CPU patches
• Cloning of single and multi-node EBS test instances
• Tuning of EBS database and applications
• Configuring parallel concurrent processing
• Work with Oracle Support on high severity level issues
• User management of Oracle Application users
• Auditing and monitoring application users
• Data objects creation, modification, addition and deletion
• Purging concurrent manager logs, gather schema statistics, Compiling invalid objects
• Scheduling cronjobs on OS level for databases, file-system backups, monitoring and alerts
• Support for custom application deployment and configuration
Oracle RAC and Standalone Database Administration: End-to-end administration of Oracle Databases 11g/12c/19c and Oracle RAC 11g/12c cluster administration
• Installation and configuration of Oracle single instance databases 11g/12c/19c and Oracle RAC 11g/12c cluster
• Database migration and upgrades
• Patching RDBMS and GRID homes
• Cloning of database, RAC to RAC --- RAC to NON RAC
• Administration and monitoring of RAC, ASM
• Performance Tuning of databases and OS
• Database backup and restore using RMAN and expdp/impdp utilities
• User management, Auditing and monitoring database users
• Database objects creation, modification, addition and deletion
• Schedule cronjobs on OS level for database, file-system backups, monitoring and health check alerts
• Set up Oracle data guard physical standby databases for high availability and disaster recovery
Completed my MS Thesis
B.Tech in Electronics and Communications Engineering with first class and distinction. Secured First class with distinction