Manager Oracle
Resume:
MARTIAL DJOKO
Oracle Database Administrator
*************@*****.***
SUMMARY
Information Technology professional with over 6+ years working experience as an Oracle Database Administrator. I have worked on Oracle, 10g, 11g and 12c versions. I have done database administration duties including production support, installation and configuration, database upgrades, patch management, database migration, backup and recovery, performance tuning, database cloning, golden gate, dataguard, RAC, and security management. Add to that, I have a good experience in networking administration fundamental (level CCNA), a good hands on of hardware, software, and Windows’s environment, Advanced Microsoft Office suite software skills, and network protocols. I am always ready to face new challenges, open to learn and willing to be relocated
P
R
O
F
E
S
S
I
O
N
A
L
S
U
M
M
A
R
Y
6+ years of experience in the field of Database Administration. Experience in high availability solutions like Dataguard, Golden gate and RAC.
Implemented LINUX HUGE PAGES on OEL 5.5 and Redhat Linux 6.7 for Clustered Environments.
Experience include Installation, Configuration, Upgrades, Space Management, System maintenance, patching, data replication, Database security, Performance Monitoring, Performance Tuning, Backup and Recovery and also includes RAC, ASM, Data Guard, Golden Gate, Data Pump and grid control experience.
Supported as Production and development DBA on OLTP, Data warehouse environment. Involved in Change/Release/Patch management and off-shore co-ordination, Product development, data center Migration and Upgrade. Administration including design, deploy, tune, trouble-shoot. Efficient to manage 50+DB.
RAC Installation and Admin on UNIX platform. Load balancing. Manage fail-over. Backup CRS files. Tune cache fusion. Resource utilization on Nodes.
Managed ASM, create and prepare disk for ASM. Create ASM instance. Add/remove disk. Manage space on disk groups. Expertise on asm command line. Handle 10TB database on ASM.
Performed Backup/restore/recover using RMAN and user managed. Create backup/restore strategies. RMAN. Experience in taking Full and partial backups, Incremental and Cumulative backups using RMAN. Logical backup of schema using expdp/impdp. Restore and recover from backup.
PL/SQL objects creation. Create trigger/ function/ stored procedure/ packages. Tune and trouble-shooting PL/SQL codes. Write database Monitoring PL/SQL objects. Create Materialized view.
Experience in Golden Gate to support data replication monitoring, tuning and capacity planning. Experience in bi-directional and broadcast replication from source to target databases using Golden Gate 9.5 and Golden Gate 10.0.
Applying Patches, Critical Patch Update/Patch Set update and One-off Patches using OPatch. Experience in patching RAC databases in rolling fashion to maintain high availability.
Experience in tuning database and memory components for optimal performance using AWR, ADDM and ASH reports.
Good knowledge v$ performance views and command line skills to identify information about sessions, wait events, system performance etc
Involved in tuning applications for optimal response time using SQL /Optimizer Trace at various levels and events, Explain Plan, TKprof, Oradebug and also identifying the poor SQL's, histograms, row chaining & row migrations and tune accordingly.
Exposure to SQL Tuning Advisor, SQL Profiles, SQL Monitoring, SQL Access Advisor, SQL Baselines and SQLTXTRACT tools and utilities.
Implemented various Partition techniques to achieve availability, performance and manageability of large tables and indexes
Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
Extensive experience designing and implementing backup and recovery strategy for databases using Recovery Manager (RMAN), traditional Export/ Import, Export/Import Datapump as well as conventional Hot/Cold Backups.
Implemented various backup strategies for Large / Medium sized databases using RMAN
Worked extensively on Cloning /Duplicate of databases using RMAN.
Experience with various database Backup and Recovery methods like PITR, TSPITR, Export/Import and Flashback Technologies.
Migrated databases from Non-ASM file system to ASM file system using RMAN.
Upgrading and Migration of Oracle database to higher version and other platforms using manual method and traditional Export/Import, datapump & Transportable Tablespace (TTS).
Experience in coding SQL, PL/SQL package, function, stored procedure, triggers, and Materialized view for Oracle database.
Hands on experience with logical backups, Hot/Cold backups, Recovery, and cloning of databases using (RMAN) Recovery Manager, SQL-Backtrack, VERITAS Net Backup.
Disk Space Management involving managing archives, space allocation to various tablespaces and also capacity planning for new applications.
Expertise in Configuring RMAN with Catalog /Nocatalog and worked on Point-In-Time Recovery and flashback.
Plugging the tablespace between different platforms using Cross platform transportable tablespace Utility.
Collecting performance statistics using Statspack/AWR (Automatic Workload Repository) and ADDM (Automatic Database Diagnostic Monitor).
Used TKPROF utility and Explain Plan for tuning SQL queries.
Experience in regular DBA activities such as Upgrades, Patches, TAR support, Cloning, Backups and Recovery Manager, Performance Tuning, Capacity Planning and documentation
Memory tuning by using ASMM (Automatic shared Memory Management). Sort area size, Buffer cache, Shared pool size, Different pools like Recycle pool, Keep pool.
Rebuilding of Indexes for better performance, User Management, Tablespace management, maintenance of Oracle Database.
Installing Oracle patches, Migration of database across releases.
Experience in Monitoring and Tuning system resources associated with the database performance, hit ratios, I/O, lock, and latch contention.
Expertise in loading data from flat files using external tables, SQL* Loader.
Experience with SQL, PL/SQL, UNIX Scripting.
Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, and sessions.
Excellent analytical, problem solving, communication and interpersonal skill
P
R
O
F
E
S
S
I
O
N
A
L
E
X
P
E
R
I
E
N
C
E
M&T - Buffalo, NY
April 2015 – Present
Oracle Database Administrator
Responsibilities:
Upgraded the databases to version 12c from 11g and 10g
Installed, Setup, Configured Oracle version 12c Release2 64 Bit on Solaris 10 and RHEL 6
Up-gradation and Migration of Database from 10g to 11gand then to 12c and also applying patches whenever required.
Applying upgrade patches, maintenance and interim patches on all the databases.
Worked on Automatic storage management (ASM) with EMC storage for managing data in SAN.
Successfully implemented 10g RAC on nodes for high availability.
Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.
Loading data from flat files to database using SQL*Loader, External Tables.
Extensively used AWR, ADDM and explain plan for periodic performance tuning.
Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 9i and 10g/11g environments.
Involved in construction of DR sites for all the Production environments.
Installed 12c database
Worked on Multitenant databases.
Performed Database Refresh from Production to QA, UAT and Development databases.
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.
Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
Extensive experience in RMAN recovery testing, RAC and stand alone database
Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests.
Responsible for the smooth functioning of all ecommerce activities of the organization.
Monitored data transfer between the Database servers using Data Stage, Oracle Streams/CDC
Successfully implemented Backup & Recovery using RMAN which includes hot backups and Cold backups.
Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.
Installed and configured Oracle 12c database and cloud control 12c to monitor all databases.
Worked with T-SQL statements like DELETE and UPDATE statements and also like BULK insert of data into the datable.
Performing monthly and annual performance reports for trend analysis and capacity planning.
Assist in SQL tuning and providing consultation such as creating Materialized views, adding indices, dropping unnecessary indices, using hints wherever possible, amongst others.
Worked on both VMS and UNIX environments.
Troubleshooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.
Knowledge in Oracle Data warehouse DBA skills relating to administration and management of VLDB environments, Oracle OLTP.
Experience in writing UNIX/SHELL scripts for providing the reports.
Installed and configured Oracle 11g database on a test server using Oracle standard procedures and OFA, for performance testing and future 10g production implementation.
CTBC Bank - Edison, NJ
March 2013 – March 2015
Oracle Database Administrator
Responsibilities:
Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.
Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.
Loading data from flat files to database using SQL*Loader, External Tables.
Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.
Extensively used AWR, ADDM and explain plan for periodic performance tuning.
Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 9i and 10g/11g environments.
Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN.
Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
Databases migrated to RAC for improved resiliency and performance.
Security User Management, Privileges, Role, Auditing, Profiling, Authentication. Creating Materialized views and Materialized View Logs for Increased Performance and Data Replication.
Knowledge in Golden Gate installation & Configuration setups in both windows/Linux environments.
Provided valuable inputs for various performance tuning issues.
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. Refreshed/cloned databases using RMAN utility.
Performed Database upgrade from Oracle 9i (9.2.0.7) to Oracle 10g (10.2.0.5) and to Oracle 11g (11.1.0.7) RAC database.
Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
Involved in the installation, configuration and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) with ASM file system on AIX platform.
Involved in converting a single instance database to Oracle 11g, 10g RAC databases.
Installed ASM environment and migrated databases from NON-ASM to ASM.
Used TOAD for database management.
Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).
Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers and Indexes on the tables.
Database refreshes using expdp, impdp, RMAN Duplicate and cloning.
Experienced in cloning the databases using HOT and COLD backups.
Used RMAN Duplicate and HOT/COLD backups to migrate the data from 11.1.0.7 to 11.2.0.3.
Made optimal use of Oracle Support in resolving the SRs.
24 X 7 Production & Development database support and administration.
Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.
T
E
C
H
N
I
C
A
L
Databases: Oracle 10g, 11g, 12c
Database Tools: Oracle (Oracle Enterprise Manager, SQL*Plus, SQL Loader, DB Configuration Assistant) Toad, OEM Grid, RMAN, SQL*Loader, Exp/Imp/Data Pump, Log miner, Statspack/AWR, Top, DBCA, DBUA, ADDM, Remedy, Service now, T-SQL, PL/SQL
Operating Systems: UNIX (Solaris 8/9/10, AIX, HP-UX), LINUX, Windows 2010.
E
D
U
C
A
T
I
O
N
2010: University GAMAL ABDEL NASSER of Conakry (Guinea)
Bachelor degree in computer science
2006 Institute University of Technology (Bandjoun- Cameroon)
Associate degree in Information Technology
2002 Technical High school of NKOLBISSON: degree of GCEA level, option Electronic
Certified OCA- 1z0-062 (12C), SQL fundamental, Cisco Certified Network Associate
(CCNA);
Information Technology Infrastructure Library (ITIL V3 FOUNDATION);
A+;
MCTS (Microsoft Certified Technology Specialist )
Contact this candidate