Resume

Sign in

Senior Oracle Database Administrator

Location:
Saudi Arabia
Posted:
January 26, 2017

Contact this candidate

*

Khalid-Ur-Rehman

Riyadh, Saudi Arabia

Mobile #: +966 553316892 (Riyadh-K.S.A)

Email: acyhhi@r.postjobfree.com / acyhhi@r.postjobfree.com Objectives

Career in Information Technology Management

Senior Database Administrator (Oracle, MS. SQL-Server & EBS Apps DBA) expert and 14 years of experienced including Database Administration, installations, configurations, creations, patching, migrations, upgrades, audits, backups, disaster recoveries, performance tuning, storage SAN, ASM & Exadata structures, documentation, startup/shutdown, Cluster high availability, Extended Cluster, troubleshooting, system analysis, schema objects, database design, data modeling physical disk storage, user accounts and DB security, change control management and manage and control OS on Windows, HP-UX, Sun Solaris & Linux platform

Skills, Work Experience & Knowledge

Essential:

Extensive and demonstrated ability with hands on experience supporting Oracle Database software and servers

(10GR2 11GR2 & 12cR1): installing, configuring, monitoring, backup and recovery, Cluster high availability, troubleshooting, capacity planning, upgrades (SQL versions/patches/hotfixes) & security.

Advanced user knowledge of UNIX, Linux and Windows. Unix/Windows scripting

Proven abilities to install, configure and manage Oracle Database Server 12cR1 Cloud Control, 11gR2, 10g, 9i & 8i

Install configure and manager Oracle EBS Rel-12x & Rel-11i Application Server and Database Apps DBA technical support

Install configure and manager Oracle WebLogic Server 11g and Oracle Application Server 10g

Oracle RAC Cluster (Oracle RAC Grid Infrastructure 12cR1, 11gR2 & 10g ) high availability solution

Prepare Database for disaster recovery configuration and connect data guard for data replication using technology SYNC / ASYNC. Another replication SAN to SAN SYNC data to disaster and recovery.

Experienced in Oracle Exadata shared storage (Create database, instances and manage data)

Experienced in shared storage SAN LUN’s disks configure, install oracleasm library configuration ASM in OS Linux & Unix Create and manage disk group under ASM as per database requirement

Excellent command of backup & restore recovery procedures using both OS and Oracle Recovery Manager (RMAN) Understanding of Database Administration Production Server Technical Skills Including:

Oracle Database Admin Role

Oracle Grid Control 11G (Oracle Enterprise Manager) and Oracle Cloud Control 12c Installation and Admin level

Oracle Infrastructure 11GR2 & 12cR1

Oracle ASM (shared storage) configure and manage

SQL and Oracle Database Server tuning and performance (Health Check List)

Oracle Utilities (Oracle Datapump, SQL*Loader, OPatch, Oracle Net Manager, EM 12 Cloud Control, exp, imp, orapwd, Oracle ASM / ASMCMD, DBCA, DBUA, ASM Utility (ASMCA), AddNode & etc.)

Oracle Flashback technology enable and disable

Oracle Partitioning (Partition of oracle database, table's and Indexe')

Oracle Data Guard Replication (11gR2 & 12cR1)

Oracle Auditing data level

Mange and Configure Oracle DB Listener and Apps Listener's 2

Manage all DBA task use Oracle Enterprise Manager tool & resolve database slowness issue

Enable and configure oracle archive log to ASM disk destination and setup oracle parameter file

Monitoring and Manage Oracle DB Logs (CRS, RDBMS, LISTENER & ASM) and maintenance Ability to Install, Configure Database Servers and Technical Support:

Working with Oracle database projects within a large corporate project delivery environment in accordance with a recognized methodology

Oracle Enterprise Database Installation and configuration (Physical Server's, VMware and Hyper-V) environments

Oracle Warehouse Builder

Oracle OID

Oracle 12c Database Server (Multitenant PDB CONTAINERS & NLS-Characterset) technical support

Manage Oracle Database instances, schema’s, roles, users security, data security, backup of important schema’s, CRM and sysdba control

Monitoring Oracle Database health check, Configure EM 12c Grid Control database performing, tuning, security, RAC

Oracle 12c Grid Infrastructure RAC multi nodes Installation and configuration under multiple OS platforms

Oracle Architecture and HA Oracle Cluster experience & Oracle Extended Cluster Solution Create Oracle Standby Server

Manage and control connection (Oracle listener server’s & clients)

Create Database, Instances as per requirement

Create Oracle DB Clone Server as per development and test environment

Oracle Data Guard for data replication

Oracle Golden Gate for site1 to disaster recovery site data replication

Apply DB Opatch and Upgrade Patches as per oracle support recommended

Apply ad-patch in Oracle EBS application and database environment and know adadmin, adworker tool for apps support

How to startup and Shutdown (Oracle DB, RAC Nodes & EBS Apps application server and database server)

Upgrade Database Version & Migrate database one MS. Windows OS platform to Linux / Unix OS

Muliti-Nodes Installation and Configuration Oracle DB, RAC and EBS application server & database version Rel-12

Mange Oracle Technical Support (Oracle Support Account) critical Production environment create and manage SR and apply patches to resolve issue

Backup& Recovery Configuration and Support:

Configure RMAN hot backup connection catalog and scripts

Full DB + Archive Backup, Transactional Backup & Difference Backup & Restore

Point in Recover & and Fastest Recovery in Oracle 12c feature

Cold Backup (Oracle Binary Folder's) & Restore

Oracle RAC Nodes OCR backup and restore

Install and configure backup agent and software connect to listener DB under OS MS. Windows, Linux and Unix

Configure tape backup server and library software and connect to Linux and Unix Servers

Configure Oracle RAC both to nodes to tape backup software for SAN - ASM Storage backup

Configure and Manage Backup schedule date and time as per recommendation

Backup and Restore Oracle Standbye serves

Experience in Tape backup software like (CA, HP-Data Protector and NetBackup) Prepare, Review, Test and Execute SQL scripts and comprehensive knowledge of SQL and PL/SQL including:

Database packages and triggers

Database and Table statistic

Help developers to resolve some of SQL-Query and Procedures

Understanding of the process models and relational data modeling

Comprehensive understanding of DML, DDL & DCL

Oracle Third Party Tools Support:

Oracle Toad DBA

Oracle Spotlight for Database Monitoring

Erwin Data Modeling Methodology

Scripts for Oracle Database and RAC health Check

Data Loader for upload data to oracle tables & EBS Apps Tables Manage and control Microsoft SQL-Server 2014, 2012, 2008 & 2005 as Database Administrator

Install and Configure MS. SQL-Server and Client

Create, Configure and Manage Database Instances & Snapshot database

Full control of DBA, Designed and Data Modeling

Integrated other Database Connections and ODBC control

DTS tools for Data Migration.

3

Complete Server Backup & Recovery

Log Shipment, Data Mirroring and Replication

Microsoft SQL-Server Database Support (Contact to support open a ticket to resolve critical issues & patches) Knowledge of software development methods, tools and delivery using ITIL processes for Service Management. Knowledge of current developments in IT.

ITIL: experienced & prepare reports / documents as per ITIL standards like (SLA's, incidents, changes, problems & etc

Experience of 24/7 oncall resolve technical issues / problems

Member of change management CAB approval processes

Experience CA desktop ticket system & MS. ITSM (IT Service Management)

Experience Disaster & Recovery and solution site to DR replication SAN to SAN (SYNC & ASYNC) Using link (STC & Mobile) Fiber Primary Link and Wireless for Backup Link through routers) Employment History

Professional Work

Experience & Key

Role

Job Description &

Technical Support

2015 to till date: Associated with Technology Control Company (TCC) Riyadh-Saudi Arabia as Work with (MOI-NIC) Ministry project (AFIS-ER) as Senior Database Administrator

(Oracle DBA & EBS Apps DBA) Technical Support Engineer. Key Role & Responsibilities:

Sr. Oracle DBA & Apps DBA Technical Support Engineer Database Technical Support:

Oracle Database Administrator, Manage grid infrastructure high availability RAC Database & ASM Storage LUNS disk group. Handling and Mange Projects Ministry NIC and Bio-Metric department work as Senior DBA & Technical Support Engineer Implement solutions of backup & recovery, disaster & recovery, Oracle Database Firewall Security for Data Protection, Oracle OIM technical support for Application Servers (WebLogic Server & JPers Server) Install Oracle 12c Infrastructure RAC Production, Development and Test environment as per software department head requested connected to application servers. Monitor Database Heath Check, Logs and Tuning and performance. Apply patches as per oracle recommendation and support oncall 24/7 resolve any critical issue's on production.

2011 to 2015: Associated with Ministry of Civil Service (Riyadh-Saudi Arabia) as Oracle DBA, & Oracle EBS Apps DBA) Technical Support Engineer. Key Role & Responsibilities:

Database Technical Support:

Sr. Oracle DBA & Apps, Oracle e-Business ERP Rel-12 financial modules technical support engineer. Manage Production Databases, instances, cloning, test DB servers, high availability RAC, Database health check, backup & restore, incident report, upgradation, patching, create new node and install Oracle database, import & export, resolve key users problem, customer support, making daily report for DB-Health, DB replication, Exadata Storage and cloud control container database. Oracle EBS technical support. Oncall 24/7 resolve any critical issues.

2006 to 2010: Associated with Saudi Post (Riyadh-K.S.A) as MS. SQL-DBA and Oracle APPS &e-Business ERP 11i Consultant technical support IT Department. Key Role & Responsibilities:

Oracle Apps DBA Consultant, Oracle e-Business ERP 11i & Rel-12i technical support engineer. Manage RAC and SAN EVA storage and SAN Admin responsibilities. Work with finance department team provide technical assistance, if any problem / issue related to ERP application finance system. Create and manage training servers, cloning application server and database server multi-nodes environment. Oncall 24/7 resolve any critical issues. 2001 to 2005: Associated with Saudi German Hospital Group (Saudia Riyadh-K.S.A) Key Role & Responsibilities:

Oracle DBA & Programmer and Oracle e-Business ERP Financial Modules Support Technical Engineer. Oracle healthcare modules and financial modules project implementations and Software updates, Oracle RAC, Database Cloning, Multi-Nodes Installation and Configuration. Third party software. Oncall 24/7 resolve any critical issues.

4

Academic Education

and Qualification

Degree MCS - Master of Computer Science from Karachi-University Pakistan (1998) Degree BSc. - Bachelor of science Pre-Engineering from Karachi University Pakistan (1994) Certification

Oracle 11i APPS

DBA Certification

Training Courses

Oracle exam IZ0-060 upgrade to oracle database 12c OCP DBA Certified (ID: OC1545420) Oracle 11g OCP Certified (ID: OC1545420)

Oracle 11i Application Certified DBA (ERP / EBS)

- ITIL Foundation Ver. 4 Training and Certified

- Microsoft Operation Framework (MOF) Training Course from Microsoft Riyadh-KSA

- Microsoft SQL Server 2008 DBA Administration Certificate (Microsoft Training Center Riyadh-KSA)

- Microsoft Internet Information Server IIS7 Certificate (Microsoft Training Center Riyadh-KSA)

- Nominated Employee of Month Dec-2010 from Saudi Post Riyadh-KSA

- Nominated Employee of the month -AUG-2004 From Saudi German Hospital Riyadh Personal ‘s

Name: Khalid-ur-Rehman

Father’s Name: Ibad-ur-Rehman

Office Address: Higul Wazarat Riyadh – Saudi Arabia Office Tel #: (+966-11) 9200 14888 Ext: 395

Mobile #: (+966) 553316892

Visa: Work Permit & Residency Visa, Riyadh - Saudi Arabia DOB 15-01-1972

Country Address B-456 Gulshan –e- Iqbal Karachi - Pakistan Country/City: Pakistan / Karachi

Telephone #: (+92-21) 6628631

Nationality: Pakistani Passport No. AQ9159371

Language: English (Full), Arabic (Mid-Level) and Urdu (Full) Status: Married (3 Children's and 1spouse computer professional ) Sports /Hobbies: Cricket & Snooker / Internet, Networks and Database updates Email Address: acyhhi@r.postjobfree.com / acyhhi@r.postjobfree.com References

Available on request.



Contact this candidate