CARL A. EBAI
Oracle Database Administrator
******@*****.*** 469-***-****
Over 6 years of strong experience in Oracle database administration in heterogeneous system environment including Solaris, UNIX, and Windows, supporting a variety of mission critical applications with Oracle 10g, 11g and 12c. Proven technical knowledge of infrastructure management (network, systems), combined with outstanding leadership ability and creative problem solving skills. Posses’ excellent communication /documentation skills and strong aptitude to analyze and resolve problems.
Supported as Production and development DBA. Involved in Change/Release/Patch management and off-shore co-ordination, Product development, data center Migration, Upgrade and Integration. Administration including design, deploy, tune, trouble-shoot. Efficient to manage 50+DB. VLDB size in 5 TB.
Management of schemas, objects, USERS and PRIVILEGES 10g OEM Grid Monitoring.
Upgrade databases from 10g to 11g and 11g to 12c. Apply PSU and bug fix patch. Trouble-shoot upgrade process.
PATCHING: regular PSU patching, Bug Fixes, in Standalone and cluster environments for 10g/11g RDBMS.
Expertise in Database Space Management, experience in troubleshooting and performance tuning.
Excellent analytical and problem-solving skills, Sound judgment and use of initiative.
Recovery of Databases (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption etc.)
Experience in using OEM, TOAD, Data Migrations using export/import.
Experienced in using 10g features Data pump, Flash-Back Recovery, AWR, ASM, ADDM.
Database performance tuning using STATPACK, Explain Plan, AWR, ADDM, ASH.
Experience on working with data guard physical standby databases.
Created 12c multitenant container database using DBCA
Configured non-pluggable 12c database into pluggable container database.
Applied various patch sets released through critical patch updates.
Expertise in maintaining Database Security using security compliance auditing, expertise in loading data from flat files using external tables, SQL*LOADER.
Manage Data Guard, Create Physical/logical standby. Detect archival gap. Fail-over, switchover. Open physical standby. Flashback of database. Configure 11g Active data guard.
Performed Backup/restore/recover using RMAN and user managed. Create backup/restore strategies. RMAN, UNIX script for backup. Logical backup of schema using expdp/impdp. Clone database.
PL/SQL objects creation. Create trigger/ function/ stored procedure/ packages. Manage cursor. Tune and trouble-shooting PL/SQL codes. Handle run-time errors. Write database Monitoring PL/SQL objects.
Performance, Tuning of databases using ADDM, AWR, explain plan, stats pack, TKPROF and dictionary views. Gather statistics, de-fragmentation of table, re-organize structure. Monitor memory, index, Schedule jobs, Partition pruning for big table. Top sql/session, bottle-neck issues. Tune init parameter. Full table scan and Index usage.
Loading data using Import/export/ sql loader. Purging /cleansing data. Used Data Pump. Estimate timing for imp/exp. Refresh schema.
Scripting - Shell, PL/SQL, SQL. Write script for Monitoring, maintenance. Audit and as per required.
Experience with mid-tier architectures, OEM, TOAD, Oracle grid-control.
Excellent Written and verbal Communication skills with a customer service oriented attitude. Knowledge on Oracle Support processes for technical requests with Metalink.
Operating systems
LINUX, SOLARIS, MS-DOS, NT,, Windows Advanced Servers 2000/2003.
Databases
Oracle 11gR2, 10gR2 RAC,
Oracle Database Tools
SQL*Loader, TKPROF, Toad, OEM, SQL Developer, Grid Control
Tools & Utilities
Export/Import, RMAN, Data Pump, Winscp3, ERWIN.
Languages
PL/SQL, SQL, Unix shell scripts.
Web Tools
HTML and XML, SQL NET, ODBC, TCP/IP
Client: Murata Electronics, TX Apr 2015 – May 2016
Role: Oracle Database Administrator
Responsibilities:
Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, AWR and also Cluster Interconnect Tuning (RAC)
Provided valuable inputs for various performance tuning issues.
Proficient in performance tuning using Explain Plan, STATSPACK, TKPROF, AWR, ADDM. Performance Tuning of the database (Memory Tuning, I/O Tuning)
Expertise in Performing Tuning Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK (perfstat), SQL*Trace, TKPROF.
Expert in Performance Tuning and Monitoring of Oracle Databases on Unix/Linux platform using database tuning, Tkprof, Explain plan, AWR and ADDM reports, Advisors as SQL Tuning, SQL Advice, Undo, Segment, MTTR, Memory.
Created indexes to facilitate easy user interface implementation and tuning.
Involved in construction of DR sites for all the Production and IST environments.
Performed Database Refresh from Production to IST, UAT and Development databases.
Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export and Data pump utilities).
Creating & Managing Database Structures, Storage Allocation, Table/Index segments, Constraints, Database Access, Roles and Privileges.
Performance tuning of Queries by maintaining Aggregates, Compression, partition, Indexing and use of Hints, Stored outlines, Statistics for the same.
Implemented and managed optimum physical database design (tablespaces, datafiles, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the Optimal Flex Architecture.
Cloned schemas, objects and data on new server using exports from 10g database and imported in 11g using data pump.
Installed and applied various patches which includeCritical Patch Update (CPU), Patch Set Update (PSU) andOne-off patchesusing OPatch and runinstaller, also involved in upgradeoracle database 9i to 10g and 10g to 11g.
Experience on working with data guard physical/logical standby databases.
Used Data Pump for export and import. Wrote scripts for Backup of databases, maintenance of archive logs for databases. Streamlined backup procedures and implemented RMAN for backup and disaster recovery.
Designed, developed and maintained UNIX shell scripts to collect and monitor database metrics and Statspack snapshots and reports.
Monitored and provided weekly reports on the server’s memory, disk and CPU I/O using HP tools and UNIX command-line utilities.
Provided maintenance of user accounts, privileges, profiles and roles.
Involved with OLTP relational databases system analysis, design, implementation and management.
Upgrade/Migration of Databases from Oracle 9i to 10g, Cross platform migration from different platforms.
Administered (11g RAC) environments adding and removing nodes to the cluster and handled performance tuning using AWR.
Supported off-hour on call support for database related issues.
Documented the Standard Processes for peers to follow.
Environment: IBM-AIX, Windows 2003/NT, Oracle 9i, 10g, RAC, TOAD, OEM, DATAGUARD, RMAN, Data Pump, Diagnostic and Tuning Advisors.
Client:Motorola Solutions, IL Jan 2013 – Apr 2015
Role: Oracle Database Administrator
Responsibilities:
Provide day-to-day databases support for users & application teams. Implementing database backup & restorations
Implemented new features of Oracle 11g like Automatic Memory Management, Automatic SQL Tuning, AWR Baseline Enhancements, Case Sensitive Passwords, Data Recovery Advisor, Database Replay, Query Result Cache, Read-Only Tables, Secure Files, SQL Access Advisor, SQL Performance Analyzer, and SQL Plan Management, Statistics Collection Enhancements, Table Compression Enhancements, Tablespace Encryption, Tablespace Enhancements to the Dev/TST/PROD environments successfully.
Perform other regular DBA activities including space management and performance monitoring.
Keeping the databases up to date with respect to Latest PSU's and very comfortable in applying patches.
SQL tuning and Database tuning has been done based on reports generated by SQL Trace, TKPROF Reports, Statspack, Explain Plans and monitor the database performance on daily basis.
Creation, configuration and setting up of RMAN catalog databases and registering target databases with the catalog.
Worked on this project as Oracle Core DBA. Planning and scheduling Backups, Database Recovery, taking Logical Backups (with Export /Import), Database backup (Hot & cold)
Proficient in managing Oracle Instance, database storage structure, schema objects.
Experienced with SRVCTL, CRSCTL, OCR and Voting Disk of 10g RAC.
Installing ASM environment and migrating database from NON-ASM to ASM.
Involved in process improvement, Oracle Server Installations / Upgrades/Patches,
Installed 11g Physical Data Guard in Maximum Performance Mode. Verify the Redo Generation, Redo Transfer and Redo Apply Services between the primary and standby database. Performed the Switchover, Switchback and Failure tests of the primary and physical standby and verified the successful catching up of standby with the primary DB.
Installation, setup and configuration of physical Standby Database using Active data Data Guard.
Recovering the database from Block corruption, Objects-drop and using TSPITR.
Setup DEV/TEST/UAT/QA environments from Production database using Snap mirror and RMAN.
Installed & Configured Oracle 11g Grid Control for monitoring over 200 Prod / Non Prod Hosts.
De-fragmentation/Reorganizing of database using Export/Import, Rebuild Index and move table.
Experience in migrating large databases up to three TB
Used Oracle streams
Analyzing tables and indexes for performance tuning. Optimizing database objects and streamlining applications.
Taking Periodic Backup of the databases and the software using RMAN.
Flash Recovery of Database (Recovering from Media Failure, Recovering tables dropped accidentally, Recovering data files, Recovering from Block Corruption).
Performance tuning which includes creating indexes, analyze, explain plan, optimizer hints.
Environment: Sun Solaris 9.0/10.0, Oracle 10g/11gRAC, TOAD 9.0, sql developer 1.3, Informatica 8.6, Business objects 11.5, Database Tools/Utilities, Enterprise Manager, TKPROF, Explain plan, ERWIN 4.x, DBArtisan.
Client: Lloyds Bank, UK Jan 2010 – Jan 2013
Role: Junior Oracle DBA
Responsibilities:
Performance tuning of application and database, identification and resolution of contention, defining and implementing Backup Recovery policy, and day-to-day monitoring of the Production database
Worked on the physical and logical designing of the database, which includes the distribution of data- files on different disks
Controlled and monitored user access to the database. Optimized the performance of the database. Tuned SGA data dictionary and set database parameters
Defined and implemented database backup and security strategies, tested the backups periodically for consistency and reliability
Identified long-running database queries, refining queries for better performance, and working with end- users to implement changes
Created primary database objects (tables, views, indexes) once application developers have designed an application
Worked with Oracle Diagnostics tools such as Explain Plan, SQL Trace, TKPROF Used to analyze timing and execution plan for SQL query to tune the SQL statements
Reorganized data files, identified and eliminated contention factors like I/O, buffers and locks
Allocated the separate rollback segments for the Batch processing jobs in order to speed up processing
Reorganized data files, identification and elimination of contention factors like I/O, buffers
Environment: Oracle 10g and 9i, Sun Solaris, RHEL 5.3, Windows 2003 with Active Directory, OEM, RMAN, Export/Import, SQL, PL/SQL, SQL*Loader, TOAD, Erwin, STATSPACK
Educational Qualifications:
MSc, Management of Information Systems, University of Nottingham, UK (2007-2009)
BA, Economics and Information Technology, University of West England, UK (2003-2006)