Agwa L. Tanyi

Database Administrator

240-***-****

aczq1u@r.postjobfree.com

Ability Summary

Complex Problem Solving -

A Couple of Years of Programing AS/400 Cobol and a few years as Oracle Database Administration. Experience in implementing, Design, Development, Testing and Production support in all industry verticals /exclusively Health Care, Pharmaceutical, Insurance Industries.

Critical Thinking -

Worked with development and operations staff in resolving problems quickly and efficiently. Used logic and reasoning to identify the strengths and weaknesses of alternative solutions, conclusions or approaches to problems

Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g,11g RAC servers for the purpose of disaster recovery procedures. Recently work with a team of IT staff to successful install and Configure Oracle 12c,

Considering the relative costs and benefits of potential actions to choose the most appropriate one.

Monitoring - .

Maintained strong and dependable backup system of both Hot/Cold Backup, Recovery and Cloning of databases using RMAN

Experienced in Linux and Solaris using 11g network configuration Listeners, PL/SQL, UNIX Shell Programming.

Maintained an excellent tuned system. Worked on many projects with Performance tuning tools of oracle databases such as Oracle Grid Control, AWR, ADDM, TKPROF, and STATSPACK. For the tuning of SQL scripts tools such as SQL Trace, Explain Plan, and Hints.

Substantial in the monitoring/assessing performance of yourself, other individuals, or organizations to make improvements or take corrective action.

Active Learning -

Understanding the implications of new information for both current and future problem-solving and decision-making.

Active Listening -

Giving full attention to what other people are saying, taking time to understand the points being made, asking questions as appropriate, and not interrupting at inappropriate times.

Reading Comprehension -

Understanding written sentences and paragraphs in work related documents.

Operations Analysis -

Analyzing needs and product requirements to create a design.

Speaking –

Talking to others to convey information effectively.

Language-

Native languages French and English.

Systems Analysis -

Determining how a system should work and how changes in conditions, operations, and the environment will affect outcomes.

Employment History

Database Administrator (DBA)

Maximum health care

Millersville, MD

1/3/2014 – April/2016

Work with healthcare record as a Database Administrator; Responsible for designing, planning, implementing and administering databases, including security, access, and documentation.

Participated in the design, maintenance, enhancement, coding, and administration of relational databases.

Analyzed and determined information needed for data relationships and attributes, data flow and storage requirements Etc.

Coordinated new data development ensuring consistency and integration with existing data warehouse structure.

Reviews business requests for data and data usage, researches data sources for new and better data feeds.

Participates in continuous improvement efforts in enhancing performance and providing increased functionality, including performing proactive maintenance such as ensuring continued space availability, monitoring activity, and documenting problems, changed, and solutions.

installation of oracle 12c, Fusion Middleware, ODAC

Working Knowledge of configuring SSL/TLS listeners for Oracle database and middleware

Testing and implementation of the new designed applications.

Provided guidance and work leadership to less-experienced Analysts.

UNIX shell scripts for hot backup, SQL*Loader, Export and Import of data.

Working experience with setup and maintenance of Data Guard and Active Data Guard, both manually and via OEM.

Migrated from BD3 and other relational Database to oracle 8i with great result.

Created and implemented application called application used by my company.

Database reorganizations and refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins.

Creating physical databases with multiple table spaces from logical and physical data model

Monitored and performed database sizing, tablespace management and rollback tablespace management, transaction management and security administration

Database Administrator (DBA)

Forestville Nursing

Beltsville, MD

09/22/2010 – 12/04/2013

Worked with the installation of Oracle on different platforms, loaded user data to reproduce the problem, applied new Oracle patch, managed database backup using RMAN, upgraded Oracle database 10.2.0.4 to 11.2.0.1.

Worked successfully on projects; Deploy Oracle Database 12c and Oracle Fusion Middleware 12c (WebLogic, OBIEE, ODI) platforms on SLES hosts.

Establish backup/recovery procedures, Disaster replications, and Developed solutions to replicate data from active standby database to a warehouse data store. Work vigilantly to deploy solutions to a secure and productive environment.

Work with users some time train them on one or one base some time their sharing their screen depending on their locations.

Database reorganizations and refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins.

Creating physical databases with multiple table spaces from logical and physical data model

Monitored and performed database sizing, tablespace management and rollback tablespace management, transaction management and security administration

Data migration between databases using both Oracle11g and 11g export/import utility and Oracle 11g data pump.

Data migrating from 11g to 12c RAC with Flex ASM option.

I very comfortable with the creation of DMU Diagnostic Packages on oracle database 12.1.0.1

Prepared scripts to tune developer SQL codes to maximize result return time

Wrote scripts to create tables, views, indexes and synonyms required meeting developer needs. Working with Java J2EE developers to develop and formulate capacity planning for 11g databases.

Performed cold and hot backup using Oracle's Data pump.

Troubleshooting, Restructuring and tuning for optimal performance of existing databases that were poorly designed for heavy hits.

Cloned databases using scripts as well as RMAN. Installation, setup and configuration of Data guard

Involved in design and enforcing of standards in place to ensure that all application design and code is produced with proper integrity, security and performance

Education and Training

Issuing Institution

Location

Qualification

Course of Study

University of the District of Columbia

UMBC

Washington DC, DC

Columbia, MD

Bachelor's Degree

CERTIFICATION

Computer information sc.

ORACLE12C

Occupational Licenses & Certificates

Certification Title

Issuing Organization

Completion Date

Expiration Date

License Practical Nurse

MD Board of Nursing

05/2004

08/2018

BBA INOF. TECH,

Oracle DBA/ Application Developer 8i

UDC

Computer Inst.

01/1990

01/1999

SQL, PL/SQL, Oracle DBA 12C UMBC 12/2015 -12/2016

Contact this candidate