Data Manager
Resume:
ALBERT FEUZING
*************@*****.***
PROFESSIONAL SUMMARY
Oracle Database Administrator with over 7 years of experience designing, installing, upgrading, and maintaining databases in large-scale UNIX/LINUX environments. I have extensive knowledge and proficiency in database design, monitoring & tuning, Migration, Upgrades, Backup & Recovery, Cloning, Replication, and security Implementations. I have worked on different version of Oracle including 9i, 10g, 11g, 12c, 18c, and 19c operating across different platforms such as Linux, UNIX, Solaris, and Windows. I have a great interpersonal skill and the ability to work as a team player as well as individually. Seeking an Oracle Database Administration position in an organization where I can expand on my knowledge and contribute to the company’s growth.
AREA OF EXPERIENCE
Installation, configuration, capacity planning
Database Security and Migration
Performance Monitoring & Tuning
Backup & Recovery
Database Security and Patching
Disaster Recovery implementation and testing
Manage AWS EC2 instances
Oracle ASM & Grid Control
Oracle Data Guard
Oracle Exadata
Oracle Golden Gate
Data Warehouse
Capacity Planning
TECHNICAL SKILLS AND TOOLS
Installation, configuration, and update of Oracle 11g, 12c using DBCA and DBUA
Worked with various operating systems including MS Windows Servers (2008, 2012, 1014, and 2016), UNIX (Solaris 8/9/10), LINUX (Red Hat, Ubuntu, Centos)
Monitoring and performance Tuning using OEM Console, TOAD, SQL Developer, Grid Control, ADDM, DRA, Dbms monitor
Plugging tablespace between different platforms using Cross platform transportable tablespace Utility
Oracle ASM (clusters) and RAC configuration and administration
Backup & Recovery using RMAN
SQL, PL/SQL, UNIX Shell Scripting
Database migration using Exp/Imp/Data pumps, and SQL Loader
Database Security
Oracle Golden Gate (Data Replication)
Oracle Data Guard installation/administration for High availability and Disaster Recovery
PROFESSIONAL EXPERIENCE
Nucor Steel, Crawfordsville, IN May 2020 – present
Database Administrator
Used RMAN Duplicate and EXPORT/IMPORT data from 9i to 11.2.0.4 and 12.2.0.1
Created a standby database by using RMAN Duplicate to reduce the down time for the PROD database during the migration process.
Upgrading Oracle databases from 12c to 19c
Planned Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
Installation of oracle enterprise manager 12c, oracle management repository and deployed agents.
Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).
Cloning & duplicating databases using scripts as well as RMAN for test and developments instances.
SQL tuning and Database performance tuning has been done based on reports generated by SQL Trace, TKPROF, STATSPACK, Explain Plan, AWR, ADDM and monitor the database performance on daily basis.
Responsible for setup and implementation of 2 Node RAC on Linux in 11g R2.
Implemented Data Guard, creating both logical and physical standby databases in 10g and 11g RAC environment for production database.
Create database Objects, Tablespaces, Schemas as needed.
Database refresh from Production to dev, and test
Zimmer Biomet Inc, Warsaw, IN June 2017 – April 2020 Oracle Database Administrator
Install and configure Oracle 10g, 11g, 12c, and 18c software on LINUX operating system.
Support daily administration, monitoring, tuning, and troubleshooting databases on single instance.
Fix various database performance issues using Automated Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and Active Session History (ASH).
Perform database migration from 10g to 11g and database upgrade from 11g to 12c using RMAN Duplicate and DBUA respectively.
Used SQL Developer to connect to databases, navigate tables inside databases, create tables and other database objects with GUI, insert data into tables, and create reports.
Support DBA utilities, reorgs, index builds, export/import and DBA tools (Oracle Enterprise Manager)
Deploy Database security policy and installation using passwords privileges in user profiles. Used Oracle Transparent Data Encryption (TDE) to encrypt tables and Tablespaces
Install and administer Oracle Physical Standby Database for single and multiple instances to achieve high availability and DR solution (DATA GUARD)
Configure and manage ASM instance on Oracle 11g and 12c.
Plan and perform backup and recovery using RMAN based on SLAs, test backup for corruption.
Perform data and metadata migration to newly installed servers using Data Pump Expdp/Impdp
Kindred Healthcare, Louisville, KY May 2016 – June 2017
Oracle Database Administrator
Performed daily maintenance including monitoring backup, managing disk space, and maintaining database objects
Participated in on-call rotation and worked occasionally after hours or on weekends
Cloned and refreshed databases 05
Monitored and responded to alert from client’s databases
Created databases from Entity Relational Diagrams (ERD)
Configured Oracle tools like SQL*Net to access the database across network
Applied Oracle’s quarterly Critical Patch Update (CPU/PSU application) using Opatch utility to install, test, and deploy patches to all database instances
Interacted with users and troubleshoot problems related to privileges and resources
Created and managed pluggable databases in the multitenant container database of the Oracle 12c architecture.
FINISH LINE Inc, Indianapolis, IN March 2013 – May 2016
Oracle Database Administrator
Cloned/Migrated databases using RMAN and traditional Data pump export/import utilities in Oracle 10gR2.
Implemented recovery strategies and successfully recovered databases using RMAN.
Worked on Installation and maintenance of Oracle 11g, 12C RAC databases.
Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
Provided 24X7 supports for all the production and development databases.
Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using “runInstaller” and perl based utility “opatch”.
Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 10g) allowing users to quickly move a user Tablespace across Oracle databases.
Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 11g, 10g.
Performed Installation and configuration of Oracle 10.2.0.1 database on HP-UX platform.
Successfully performed migrations from Oracle 10g to 11gR2 RAC (Real Application Cluster) Database.
Successfully upgraded databases from 11g to non CDB 12c.
EDUCATION
Bachelor of Science, Indiana University, 2019
Oracle Certified Associate, Oracle University, 2019
SQL Fundament, Oracle University, 2013
Oracle DBA Training, FSTECH Detroit MI, 2012
Contact this candidate