Sql Developer Database Administrator

ATUD DERIC NDI

Email: ********@*****.***

Tell: 716-***-****

Address: ***** ******* ** **, *******, MN,55304

SENIOR DATABASE ADMINISTRATOR

PROFESSIONAL SUMMARY

Highly accomplished, deeply driven, Senior Oracle Database Administrator (SDBA)with over 7 + years of experience with extensive knowledge in Oracle database administration. Oracle Certified Associate

(OCA) in Oracle 12c SQL Fundamentals, proficient in Oracle 10g and 11g, Windows, and Red Hat Linux. Expertise knowledge in database configurations and installations, Database Design and development

(SDLC), Monitoring & Tuning, Migration, Upgrades, Backup & Recovery and Security Implementations. Enthusiastic, proactive team player who is fast at picking up new technology with great attention to detail with strong organization, verbal and written communication skills able to multitask successfully and thrive in a dynamic fast paced and versatile work environment. SKILLS AND COMPETENCIES

. Installation, configuration and . Oracle Data Guard configuration and upgrade of Oracle 10g, 11g and 12c Administration

using OUI, DBCA, DBUA

. Monitoring and performance tuning . Database Migration using Data using AWR, ADDM, OEM console, Pump utility

Grid Control, SQL Developer,

Explain Plan, Optimizer Statistics . Database security including DTE

. Database Security and Migration . Oracle RAC and ASM

. Upgrades and Patching . MS SQL Server Management Studio

. Work with various operating systems . SQL, PL/SQL, T-SQL, UNIX Shell including UNIX(Solaris8/9/10), scripting

LINUX(Red Hat) and MS Windows

Servers 2008, 2012, 2014 and 2016 . Bash/Unix shell scripting and

. Backup and recovery using RMAN Automation

and Maintenance plan Wizard

WORK HISTORY:

GAF COPERATION MINNEAPOLIS, MN February 2014 – Present Oracle Production Support DBA

. Install and configure Oracle 10g, 11g and 12c software on UNIX/LINUX operating system.

. Fixed various database performance issues using Automated Workload Repository

(AWR), Automatic Database Diagnostics Monitor (ADDM) and Active Session History

(ASH).

. Strong in analyzing how Oracle resources are being used during SQL executions.

. Identify long-running database queries, refine queries for better performance, and working with end- users to implement changes.

. Involve in session management and monitored the critical wait events, blocking sessions in the database.

. Experience in database upgrade using both DBUA and manual method, and database patching.

. Experience in managing Oracle RAC for high availability.

. Successfully configure and manage Data Guard for disaster recovery, data protection and high availability.

. Performed Data Guard failover as required for maintenance. This includes coordinating with application owners and sys admins to when the failover can be performed.

. Perform data and metadata migration to newly installed servers using Data Pump Expdp/Impdp.

. Experience in data replication using snapshot, materialized views and dblinks.

. Create database objects like views, procedures, functions, triggers, tables, synonyms and indexes.

. Plan and perform Backup/Recovery using RMAN base on SLAs, test backup for corruption, Work with Flash Recovery Area as well.

. Extensively worked on complete & incomplete recoveries of the databases including Point in time recovery (PITR) and Tablespace point in time recovery (TSPITR) using RMAN utility.

. Clone production databases as needed for testing, development using RMAN.

. Work on database security including Auditing (standard auditing, fine grain, valued based and statement auditing), Encrypting (Transparent Table Encryption).

. Hands on experience in UNIX scripting.

. Apply Oracle quarterly patches and Interim patches to databases using Opatch utility.

. Experience in monitoring oracle instances and maintaining databases performance using OEM (Oracle Enterprise Manager 12c).

. Use SQL Developer to connect to databases, navigate tables inside databases, create tables and other databases objects with GUI, insert data into tables and create reports.

. Involved in each phase of the lifecycle (SDLC) including requirement gathering, technical design, development, system integration phase, quality assurance phase, development, and production support activities.

. Part of the 24/7 on call production support team. AMAZON LTD,SHAKOPEE

Minnesota, MN, MN March 2012 - February 2014

Oracle DBA production support

Experience working with Oracle 10g and 11g.

. Experience in applying patches such as CPU/PSU patches, One-Off Patches, Interim patches as per the oracle recommendations.

. Good knowledge in setting parameter files (both Pfile & Spfile).

. Monitored and performed database sizing, tablespaces and data files management.

. Performed administration activities like user creation and administration, profiles, privileges and roles administration, space and schema management.

. Performed Database Backup using RMAN utilities for physical backup and Data Pump utilities for logical backup.

. Resolved database network problems using Oracle Net Configuration Assistant (NETCA)

. Monitored the state of the listener by checking the status of listener and restarting listener.

. Constantly monitored data files, control files, redo log files for space and availability.

. Refreshed databases from Production to Test environments using a hot backup and data pump.

. Cloned databases in Test, Dev, QA environments.

. Used Automatic Workload Repository (AWR) and Automatic Database Diagnostic onitor (ADDM) reports for turning database performance issues and applying recommendations.

. Automated the processes using CRONTAB.

. Created and managed database objects such as tables, indexes, materialized views and referential integrity constraints.

. Interacted with users and troubleshoot problems related to privileges and resources.

. Monitored databases activities and files usage, ensured databases function properly by removing or deleting old or obsolete files.

. Performed capacity planning for databases.

EDUCATION:

Bachelor’s in enviromental science,

University of Buea Cameroon

Oracle Certified Associate (OCA)

Work Authorization Status: U.S. Citizen

Contact this candidate