Data Oracle

Sanji Milton

Address : ***** ***** **** *****, ****** Spring, MD, 20906

Phone : 240-***-****

Executive Summary

I am an Oracle DBA with over six years of experience and has worked extensively on migration and upgrade within and outside data-center using data guard. He has experience with RAC, 12c upgrade, data guard, Grid control, ASM, RMAN and Golden Gate monitoring. I have been involved with different teams, including development, testing and QA. I have extensive experience with RMAN, SQL Query tuning, Shell Scripting, DB Console, OEM, RDBMS availability, Storage, ASM and data guard failover and failback over standby databases efficiently. I have been involved in recovery, restore, and data back-up process. I have handled databases up to 2.5 TB size. I have hands on experience on OS i-e AIX, SOLARIS, HP-US, LINUX and Windows servers. I have conducted various team meetings, supervised DBA team and provided the issues, presented them to improvements and solutions.

Experience

Oracle Database Administration

Newedge

February 2015- March 2018

Work with customers for different RAC related issues: [hangcheck timer, split brain, huge pages setup etc].

Troubleshoot performance issues for the RAC instances (GC events).

Install, maintain and tune Oracle 11g RAC databases including ASM and CRS.

Monitor and troubleshoot Database Replication issues using Golden Gate, dealt with conflict resolution and performance issues.

Recover Golden Gate corruptions and managing host/cluster maintenance mode blackouts.

Gain experience with Logical backups EXPDP/IMPDP and extensively used for Re-hosting the application using Golden Gate and worked with conventional EXP/IMP for migrating data from 10g to 11g.

Implement Initial Data Load, Batch/Online replication, Security in Golden Gate and implement Oracle database 12c RAC databases using Oracle Clusterware for achieving high availability.

Work on POC of 12c new features like Redaction policy, adaptive query optimization, multiple indexes on single columns, Restore table through RMAN, etc.

Clone/duplicate of database with RMAN and user-managed (hot/cold) backups.

Resolve the performance issue in database 12c using automatic big data caching, full database caching and In-Memory Aggregation features.

Gain hands on experience in cloning the non-multitenant container database to pluggable database in 12c using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot cloning feature.

Implement two types of standby databases supported by Data Guard, logical standby and physical standby databases in 11gR2 on two node RAC

Resolve/Diagnose Node Eviction issues.

Configure and manage Data Guard extensively for Production databases of sizes ranging from 50GB to 5TB.

Implement Active Data guard, creating both Logical and Physical Standby databases in 10g,11g, RAC & 12c environment for the Production databases for failover.

Install OEM 12c Cloud Control and upgrading the 11g management agents to 12c agents.

Migrate databases to 12c from Oracle 10g & 11g.

Implement Oracle TDE to provide transparent encryption of stored data to support submission efforts with release of Oracle 11gR2.

Work on Network data encryption to improve the security and implemented SSL wallet to secure the connections.

Perform Database Services creation for distributing the applications across multiple nodes, extensively used all command line utilities SRVCTL, CRSCTL, ADR, and ASMCMD.

Redefine tables using DBMS_REDEFINITION, partitioning the tables in the production, re-defining the columns data types, and moving the LOBS to different tablespace.

Partition tables Maintenance, adding new partitions, exchanging one-year old partitions then archiving of the exchanged partitions, dropping or truncating of old portions.

Develop RMAN Backup strategies for cloning the test databases with the production environment and worked on RMAN active-active duplication.

Schedule RMAN backups, purge jobs, Maintenance Jobs using DBMS_JOBS, DBMS_SCHEDULER, Crontab and $UNIVERSE.

Design and implement different backup strategies like Cold, Hot, MAN with Flash Recovery Area and Logical Backups EXPDP/IMPDP.

Handle Chained Rows and Row migration and solved the database performance issues.

Experience with ASM, adding, deleting disks to the disk group.

Support development teams for all the database related issues and handled the critical issues like network failures and ASM DISK group errors and node failures in the RAC cluster.

Generate Statspack/AWR reports using OEM 12C from Oracle 11g database and analyzed the reports for Oracle wait events, time consuming SQL queries, tablespace growth, database growth.

Use Explain Plan, Oracle hints and creation of new indexes to improve the performance of SQL statements. Involved in SQL Query tuning and provided tuning recommendations to Application jobs, time/CPU consuming queries

IT Environment: Oracle RMAN, Oracle 11g (11.2.0.2), DBMS STATS, Datapump, SQL TRACE, TKPROF, EXPLAIN PLAN

Oracle Database Administrator

OSI Pharmaceuticals Inc.

January 2013-January 2015

Tuned performance of RAC and non RAC databases.

Installed Oracle Database 11gR2 with Real Application Cluster (RAC) with CRS and ASM in SOLARIS environment.

Tuned performance of RAC and non RAC databases.

Worked on creation and deletion of RAC resources like listener/instance and database.

Provided technical assistance and guidance to the team in implementing High Availability solutions for the group using features like Real Application Clusters, Flashback, Oracle Streams and 10g Data Guard with Automatic Failover.

Found bottlenecking queries that impede application performance and fine-tuned them.

Tuned databases for memory tuning by adjusting Buffer cache size, log switches and reducing check pointing, increasing sort area sizes, shared pool area, prioritizing Oracle processes and increasing SGA overall.

Troubleshot application SQLs and database performance tuning, table partitioning, table space reorganization and used SQL TRACE, TKPROF, EXPLAIN PLAN, STATSPACK, AWR and ADDM utilities for optimizing and tuning SQL queries.

Used Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM), ASH report, SQL tuning advisor, SQL access advisor, Segment advisor, SQL profiles, SQL baselines, SQLT reports, TOP, SAR, VMSTAT, IOSTAT, GLANCE for Performance tuning.

Coordinated and suggested PM, SA and LOB DBA to allocate and setup disks for data files, backups and achieve log sizes for ASM through SAN storage, SAN storage to setup VOTING and OCR ASM LUNS per cluster, swap storage and shared memory needed per each node.

Tuned ETL process of data warehouse databases to reduce load time.

Periodically cloned multi-terabyte databases to QA and UAT.

Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 11g R2.

Performed data replication using Materialized views and Oracle Streams in Oracle 11gR2.

Cloned/Migrated databases using RMAN and traditional Data Pump export/import utilities in Oracle 11gR2.

Performed RMAN operations (Incremental Backups).

Helped developer to install Oracle Client, troubleshoot and establish the connection to Oracle database through ODBC, JDBC.

Worked on JDBC (JDBC connectivity, 2 phase commit, JDBC Statement, Cursor in Scrollable result set, connection pooling, Locking System in JDBC, Single Concurrent Open statements per connection).

Performed Database tuning, Application Tuning & performance monitoring.

Fine-tuned Initialization parameters, I/O, Memory and Operating System kernel parameters.

Implemented and troubleshot Data Guard (Standby) for high availability/disaster recovery purpose.

IT Environment: Oracle, 11g, HP-UX 11, Sun Solaris 10.0, RAC, Oracle Streams, RMAN, Data Pump, SQL TRACE, TKPROF, EXPLAIN PLANs

Certifications

Government Certificate Examination (GCE) Advance Level (College)

Cameroon Protestant College (CPC) Bali

Government Certificate Examination (GCE) Ordinary Level (GED equivalent)

Kemonde Veteran College Limbe, Cameroon

Education

Bachelor of Science (B.Sc.) in Computer Science

University of Buea, Cameroon

Technologies

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, Shareplex Top, DBCA, DBUA, ADDM, Oracle Migration Workbench, ERwin, QDesigner, Remedy

Operating Systems: MS Windows, UNIX (Solaris 8/9/10, AIX, HP-UX), LINUX

Hardware: Sun Fire 15K, Sun 6320 Storage, Sun Enterprise Servers 890/880/420/450, Sun StorEdge 6320, Hitachi, EMC, Dell Servers, Compaq Servers 6000/3000/1600/800, HP/UX-9000, Red Hat Linux 6.2

Contact this candidate