RONNET L NDE- Oracle Database Administrator, OCA Certified
A proficient Oracle Database Administrator with over 7 years of extensive knowledge in assortment of technologies including Oracle 9i, 10g, 11g and 12c databases in production, test and development environments. Demonstrate proficiency in Oracle Enterprise Manager (OEM) for monitoring and performance tuning, database design and modeling, Replication, backup and recovery using RMAN, database security (TDE), data migration using Data Pump, upgrading, cloning and patching. Added experience in Linux, Unix, RAC and Data Guard. Possess remarkable communication and detail-oriented skills with a great aptitude for problem solving.
•Oracle database installation, configuration and administration of 11g and 12c
•Planning and scheduling backup and recovery strategies using RMAN.
•Perform database integrity and Advanced security implementations using TDE.
•High-speed migration of data and metadata using Data Pump expdp and impdp
•Database cloning, upgrade and patching.
•Monitoring and Performance tuning using OEM Console, AWR, ADDM, Explain plan and SQL Tuning Advisor.
•Ensure high availability through Flashback and Data Guard
•Proficiency in Unix(solaris), Linux (Red Hat 7.5) and Windows Server (2008,2012,2014)
CentraCare Health St. Cloud, MN July 2014 - Present
ORACLE DATABASE ADMINISTRATOR
•Ensure daily data concurrency and consistency on production, test and development databases.
•Strong enforcement of database security through Authentication, Authorization, Auditing and TDE for advanced security.
•Monitor and manage the performance of the database using OEM to avoid a single point of failure.
•Perform database creation and design.
• Plan and schedule Backup/Recovery Strategy using RMAN for availability and reliability following the company SLA
•Table space monitoring, Performance monitoring and tuning for performance improvement.
•Grant roles and privileges to end users. Monitoring resource usage or resolving password and connectivity issues.
•Perform SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) reports and automatic session history.
•Create database users as well as user profiles, role and privileges bases on their responsibilities.
•Create primary objects (tables, views, indexes, synonyms, procedures, functions and triggers) to help application developers with the application design.
•Perform database Refreshes from production environments
•Perform data transfer using expdp and impdp (Data pump).
•Apply patches and worked closely with Oracle to make Application environment up to date.
•Work hand in gloves with the IT team to ensure high availability, and no data lose through data guard.
• Create and manage pluggable databases in the multitenant container database of the oracle 12c architecture.
MEDTRONIC, Minneapolis, MN September 2011 – 2014
ORACLE DATABASE ADMINISTRATOR
•Managed user privileges, roles, profiles, schemas and passwords
•Responsible for configuring and backing up databases using RMAN (Incremental backups, conventional hot and cold backups, physical and logical backups).
•Troubleshoot Design and develop logical and physical database structures, standards, and procedures
•Capacity planning (planning of tables, indexes, tablespaces and database) to allow for growth potential and analyze data growth trends for capacity and resources.
•Monitored the databases to identify and correct performance problems
•Configured database and table-level encryption of data-at-rest. Implementing Oracle Advanced Security
•Created, maintained, and allocated database storage and storage structures
•Evaluated the system database needs, installed and configured Oracle RDBMS
•Performed data modeling, logical and physical database design, resolved database issues with the help of RMAN and OEM
•Assisted in planning and coordinating data replication and migrations of databases.
•Implemented table and index partitioning and materialized views to minimize DB time, increase disk load balancing, improve query speed and enable faster parallel query.
•Created databases Entity Relation Diagrams using Oracle SQL Developer.
•Experience in data migration using Datapump(expdp and impdp) from development, test and production environment.
•Oracle Database 12c Certified Associate (OCA)
•REFERENCES available on request