Oracle DBA
Resume:
Ngo Mpondi Marie Florence
Oracle Database Administration
***********@*****.***
Oracle Database Administrator
Dedicated Oracle Database Administrator with over 6 years of experience in developing, designing, and managing databases, including administering to over 400 databases in various environments. Excels at supporting full life cycle development for 10g, 11g, and 12c versions on systems including UNIX, Linux, Solaris, and Windows. Adept at all aspects of database administration including migration, cloning, and replication to ensure data integrity. Areas of expertise include:
OPERATING SYSTEMS AND HARDWARE:
MS Windows
UNIX
Solaris 8/9/10
AIX
HP-UX
Linux
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
DATABASES AND DATABASE TOOLS:
Oracle 10g, 11g, 12c
Oracle Enterprise Manager (OEM)
OEM Grid Control
SQL*Plus
SQL Loader
DB Configuration Assistant
TOAD
RMAN
Export/Import
Datapump
Goldengate
Net Configuration Assistant
Net Manager
Netstat
Log miner
Statspack
AWR
Shareplex Top
DBCA
DBUA
ADDM
Migration Workbench
Erwin
QDesigner
Remedy
RAC
ASM & ACFS file systems
Explain Plan
TKPROF
SQL*TRACE
SQL Tuning Advisor (STA)
SQL* Analyzer
Patch Sets
ASM
Flashback Recovery
Data Stage
Oracle Streams
CDC
PROFESSIONAL EXPERIENCE
M&T Buffalo, NY
Oracle Database Administrator Oct. 2016 – Present
Successfully upgraded and migrated databases from 10g and 11g to 12c, while setting up, configuring and installing 12c on Solaris 10 and RHEL 6 while applying necessary patches
Maintained database security and functionality through application of upgrade, maintenance, and interim patches
Utilized RMAN and RMAN active clone to setup Dataguard and creating backups and rebuild Dataguard
Collaborated with application development team to resolve issues
Used ASM and Scan Listener technology for implementing 11gR2 RAC
Troubleshot and supported all daily user issues and creating roles, privileges, user accounts, and grants
Managed data in SAN with ASM and EMC storage
Extensively used OEM 10g Grid Control to monitor all database and application servers
Used SQL*Loader and external tables to load flat file data to databases
Performed periodic performance tuning using AWR, ADDM, and Explain Plan
Improved performance significantly by reorganizing databases, schemas, and tables with Datapump and export/import
Became experienced with Multitenant databases
Implemented and managed an optimum physical database design and carefully monitored storage, growth, and file system space to analyze database capacity
Recovered massive 1 TB database when UNDO tablespace was corrupted in RAC
Used RMAN for remote server and SRVCTL for RAC database to create a clone database
Implemented high availability and performance configurations for Dataguard and ran Dataguard failover tests
Monitored all data transfers between database servers
Extensively used RMAN to implement hot and cold backups and recovery
Maintained aggregates, compression, partitions, and indexing to performance tune queries
Monitored all databases through skillful installation and configuration of Database and Cloud Control 12c
Created monthly and annual performance reports to analyze trends and capacity plan
Properly diagnosed database performance issues at all levels including SQL, PL/SQL, design, tables, indexes, memory, and java calls
Highly familiar with data warehouse DBA skills regarding administration and management of VLDB environments and OLTP
Provided accurate reports through efficient writing of UNIX/SHELL scripts
Bank of Oklahoma Tulsa, OK
Oracle Database Administrator Mar. 2013 – Sep. 2016
Installed, configured, and maintained all 10g/11g RAC
Created an effective Grid monitoring solution for large databases
Installed Clusterware to configure public, private, and VIP data
Implemented and configured Grid Control on RHEL server
Utilized Crontab to schedule and perform logical backups of critical application database
Created all RMAN catalog databases, registered them in catalog database, and used RMAN duplication to clone production RAC to development and QA systems
Optimized performance by defragmenting tablespace data blocks and partitioning large databases
Reduced complexity inherent in Oracle streams through Goldengate evaluation and configured Oracle Steams for data replication, monitoring them with Grid Control
Skillfully performance tuned queries, DBMS, and individual production databases
Conducted migration review meetings for the application team to devise appropriate migration strategies
Enforced data confidentiality, integrity, availability, and auditability depending on data access controls at database level
Extensively used AWR, ADDM, and ASH to perform SQL and PL/SQL tuning and production database monitoring
Utilized GRID infrastructure on RHEL 5.5 to install, setup, and create 4-node cluster RAC database
Used Dataguard to effectively install and maintain a physical standby database for 11.2.0.3 and 10.2.0.5 RAC databases
Planned maintenance activities to include primary and standby database switchovers
Used 10g Grid Monitoring tool to proactively monitor database health
Tuned databases and performed extensive performance tuning using SQL*TRACE, STATSPACK, Explain Plan, TKPROF, memory (SGA) tuning, net backup, EMC (time finder and SRDF), RAID, and RAW Devices
Setup test and development databases by cloning databases
Oversaw all optimization of queries and application tuning
Aided developers in coding PL/SQL and performed all SQL tuning
Coordinated and collaborated professionally with system administrations, application developers, and other database administrators.
Certifications
Oracle Administration 12 SQL Fundamental
Oracle Certified Associate 12C.
Education
Bachelor’s in information systems management, university of YAOUNDE
Contact this candidate