Data Customer Service
Resume:
Jason Ndiforchu
Oracle Database Administrator
***********@*****.***
Over 6+ years of strong experience in Oracle database administration in heterogeneous system environment including, UNIX, and Windows, supporting a variety of mission critical applications with Oracle11g and 12c. Proven technical knowledge of infrastructure management (network, systems), combined with outstanding leadership ability and creative problem solving skills. Possessexcellent 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..
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 on working with data guard physical standby databases.
Manage Data Guard,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.
Excellent Written and verbal Communication skills with a customer service oriented attitude..
Operating systems
LINUX,MS-DOS, NT,, Windows Advanced Servers 2000/2003.
Databases
Oracle 11g, Oracle 12c
Oracle Database Tools
SQL*Loader, OEM, SQL Developer, Grid Control
Tools & Utilities
Export/Import, RMAN, Data Pump,ERWIN.
Languages
PL/SQL, SQL, Unix shell scripts.
Web Tools
HTML and XML, SQL NET, ODBC, TCP/IP
Client: Murata Electronics, TX Apr2015 –Present
Role: Oracle Database Administrator
Responsibilities:
Data Guard, Create Physical/logical standby
Provided valuable inputs for various performance tuning issues.
utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain..
Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export and Data pump utilities).
Creating&ManagingDatabase Structures, Storage Allocation, Table/Index segments, Constraints, Database Access, Roles and Privileges.
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.
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: Oracle 9i, 10g, 11g& EBS, RAC, OEM, DATAGUARD, RMAN, Data Pump, Diagnostic and Tuning Advisors.
Client:DONNELLY COMMUNICATIONS, GA Jan 2014– 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,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.
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.
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.
Installed & Configured Oracle 11g Grid Control for monitoring over 200 Prod / Non Prod Hosts. .
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: Oracle 10g/11g RAC, SQL developer 1.3
Client: Convergys Jan 2012 – Jan 2014
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, 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,RMAN, Export/Import, SQL, PL/SQL, SQL*Loader.
Educational Qualifications:
Asc. Psychology, Georgia State Perimeter University - Atlanta, GA (2008-2016)
Bsc Information Systems, Georgia Southern University (2010 –2014)
Professional Summary
Technical Skills
Work Experience
Contact this candidate