Candidates About

 

Chuck Augustine Michaels

SUMMARY:

A SME with over 12 years of Oracle experience and some mySQL experience in a challenging and dynamic environment

·        Tune via GRID-CONTROL/CLOUD CONTROL 12c (create recommended indexes, SPA, SQL-PROFILE, compare new/old plan, view top activities, top SQL, etc…)

• Working knowledge of Windows Server 2008/2012/2016 Administration
• Works independently and as a team member (with a diverse group of people)
• Install and configure linux (Oracle linux, RHEL 4 and 5) and Oracle on physical and VM Ware.
• Ability to learn new technologies quickly
• performance tuning of database tables
• Build VM and ORACLE VM VirtualBox
• Expertise in creating/scheduling the Cron Jobs
• A self-motivated person who is able to work on multiple projects
• Effective verbal and written communication skills, high level of initiative, team member, and multitasking ability in a large organization
• Excellent troubleshooting and problem solving skills 
• Excellent attention to detail
• Flexibility and adaptability within a changing and fast-pasted environment
• Administer data bases on various environments (dev, test and production)
• Experience with Virtual servers (install, configure, install OS linux, install ORACLE/create database
• Ability to work on multiple projects simultaneously
• Expertise in data loading via export import, SQL Loader, data pump and external tables
• Good data modeling, skills using ER Win and on paper
• Set up and manage database security by creating new users, roles, profiles, views
• Synonyms and provide required user privileges
• Expertise in database installation, configuration supporting OFA standards, proactive
• Conduct performance monitoring and tuning, migration, storage management, user management 
• Developed enterprise requirements and standards of (backup and recovery, standup new instances, standup standby databases, golden gate replications, how to trouble shoot known issues, similar file system layout on all servers, etc....)

             

 

TECHNICAL SKILLS:

 

MySQL, Strong problem solving skills, Exadata systems, Expert Golden Gate 11g & 12c, RAC, Expert Data guard: logical, physical, active and snap-shot standby databases, Failover, switchover ASM Oracle 12c, 11g,10g, 9i, 8i RDBMS, Shell Scripting, SQL, MS SQL, Streams replication, Enterprise Manager, Grid Control, Sqlplus, Toad, Putty, Exceed, OID/LDAP, SQL Loader, Warehouse Builder 

Operating Systems: DOS, Windows 95, 98, NT 4.0, and 2000, Windows XP, windows 7, UNIX, Solaris 2.x, Linux (RHEL3,4, and 5) and AIX, Installed Linux (Oracle, REDHAT 32/64 bit)

Builded VM and ORACLE VM VirtualBox

Protocols: TCP/IP, FTP

 

WORK EXPERIENCE:

 

 

USPTO 02/2012 current

My day to day tasks at USPTO are support of mission critical patent, trademark and financial databases. Databases sizes are from 3tb to 200tb.  Most production databases at USPTO are high availability (some are two nodes RAC, DATAGUARD… primary has two standbys which are converted into snapshot standby for application/performance testing. ORACLE GOLDEN GATE is our replication tool: (one-way replication/bi-directional replication) we are also replicating (extracting) schemas from a standby (and archived log area) which has to be in an ACTIVE role for this to occur.  In this environment we also replicate (extract site) from a non-standby (reading from online redo logs)

                                                                                                               

·        Strong golden gate skills (tuned hung GG processes, add tables to GG groups, add multiple GG replicat groups for better performance, resolved replicat issues, etc..)

·        Migrated from character set 11g WE8 ISO8859P15 to 12c AL32UTF8 via csscan tool

·        Experience with mySQL

• Created 12C PDB via copying and plugging in (copying files from seed, cloning a PDB locally and remotely[MC(1] ) and (plugging in an unplugged PDB, plugging in a non-CDB as a PDB
• Installed and configured 11g and 12c GOLDEN GATE in production, QA and testing environments
• Upgraded GoldenGate from 11.1 to 11.2  and also installed 12c golden gate on multiple environments
• Configured golden gate replication from 11g to 12c oracle database
• SQL tuning using SPM and sql profile
• Recovered over 300 missing archived log sequences from backup and applied them to standby database to resolve gap issues
• Recoverd missing archived logs for GoldenGate extract process, on the extract site
• Trouble-shot GOLDEN GATE mapping issues (table missing pk on target site,  etc..)
• Perform SQL tuning and instance tuning
• Applied OPatch and PSU to production and test environments
• Tuned golden gate replicat (ggadmin waiting to write, used golden gate tuning parameters, tuned the database for better performance on  replicat site, etc…)
• Tuned golden gate lag time (two weeks lag time down to 0 seconds)
• Configured golden gate to extract from REDO LOGS (non standby database) and ARCHIVED REDO LOG (standby database)
• Trouble shooting data guard issues (primary cannot write to standby, gaps, etc…)
• Set up to three standby which receive logs from one primary database (This way I was able to switch one of the standby to snapshot for testing)
• Configured various data-guard environments (physical, snapshot 11g, active 11g and logical standby)
• Installed data-guard manually (take backup, configure parameters, etc..) and with RMAN duplicate for standby
• Strong data-guard trouble shooting experience            
• Switch physical standby database to snip-shot standby and back to physical standby (This was done for performance testing live data from primary production db
• OID/LDAP: good knowledge of OID/LDAP              
• OID/LDAP: configured over 282+ databases/services into OID/LDAP        
• OID/LDAP: Trouble shot OID/LDAP errors (ORA-28043: invalid bind credentials for DB-OID connection, ORA-12514: TNS, ORA-28030: Server encountered problems accessing LDAP directory service
• Works with 200 Tb database  
• TUNING: strong tuning skill (using performance views ASH etc…, Top performance events, run explain plan, AWR report, ADDM recommendation, SQL Profile, etc…)    
• Adding disk to ASM diskgroup via ASMCA, SRVCTL, ASMCMD, and SQLPLUS         
• Understanding and working with Grid Infrastructure              
• Registered a single-Instance Database in OCR Using SRVTL            
• Administer temporary tablespace/Online Redo logs in RAC environment    
• Enable archive log in a the Oracle RAC Environment              
• Administer and creating services for RAC     
• Administer SCAN listeners    
• Administer Cluster Ready Services
• Oracle RAC backup and recovery       

 

 

VeriSign Dulles, VA: Oracle DBA 06/2011- 02/2012

 Core team supports databases related to domain registration from all registrars in the world. The databases are very large databases as well as performing over 10000 transitions per minute. Also supported scripts that generated reports. 

 

                                                                                                                                                  

·        Data guard/App swing form primary to standby

·        Trouble shooting data guard issues

·        24/7dba (troubleshooting alerts, investigating incidents and fixing it)  

·        User manage backup and recovery

·        Worked with 8 Tb database

 

Monster.com Mclean VA Oracle DBA 10/2009 – 06/2011

 

·        Configured primary and physical standby databases (Data guard)

·        Expertise in performing database refreshes and cloning

·        Resolved dead lock issue (via AWR snip shot of the database and identified top events that were causing dead locks and other performance issues

·        Diagnosed Row Migration & Row Chaining issues and fix them

·        Planed upgrade from development, QA to production.

·        Worked with RAC

·        Created and administer encrypted tablespaces for federal clients

·        Cloned  and renaming multiple databases via RMAN, online RMAN backups,and user manage cloning

·        Provided critical tuning and database recommendations

·        PIT recovery when needed via (RMAN and Flashback technology)

·        Creates restore point, guaranteed restore point (ensure the database will flashback after  the flashback retention period has pass) or RMAN restore to a SCN or past date

·        Installed  Grid Control along with agents ( Registered instances into the OMS)

·        Strong analytical and problem solving skills

·        Shell scripts/Automated and refine regular processes

·        Automated database creations, automate process to tar, gz, and remove obsolete logfiles (oracle, system, RMAN backup logs files) so it does not fill up the file system

·        Set up effective RMAN weekly backup process in the cron table

·        Monitored development, QA and production databases performance via Grid Control.

·        Performed SQL tuning.

·        Loaded data into the databases via sqlldr, datapump (DIRECT IMPORT), and export and  import

·        Performed Database and data migrations.

·        Work with Developers and production release team for production release (support and assistance)​

·        Work with Operations to troubleshoot complex issues related to the entire environment including OS, storage and servers.​

·        Manage, Monitor and Administer database and system performance.​ Including optimization and tuning of data loads, extractions and recommending appropriate procedure, query or package changes and optimizations to ensure and improve system performance and reliability.

·        Provide off hours On-Call support to resolve production issues within the stated SLA.​

·        Automate and refine regular processes, track issues and documented changes

 

 

Global Computer Enterprises (GCE) Reston, VA Oracle DBA 08/2009 – 10/2009

 

·        Configured primary and physical standby databases (Data guard)

·        Planned upgrade from development, test to production.

·        Good knowledge of RAC: Turned single instance into cluster instances

·        Cloned multiple databases via RMAN, recreating control file, and user manage cloning

·        Installed  Grid Control along with agents ( Registered instances into the OMS)

·        Monitored development/production databases via Grid Control.

·        Monitored database for performance issues and tuned SQL.

·        Loaded data into the databases via sqlldr, datapump, and export and import

·        Performed Database and data migrations.

 

 

Computer Science Corporation (CSC) New Carrollton, MD: Oracle DBA 02/2009 –08/2009

 

·        Gathered Statistic and rebuild indexes (Help improve performance) to notified the CBO of changes with in the db.

·        Worked on vmware platform that are hosting Oracle databases

·        Recovered corrupted tablespaces and datafiles

·        Backup and recovery via RMAN/configured Grid Control to backup multiple databases

·        Monitored databases, file system, host performance and application server via OEM Grid Control

·        Installed, upgraded, configured, managed and maintained all non-production and support on production databases

·        Monitored database for performance issues and tuned SQL/instance

·        Loaded data into the databases via sqlldr and PL/SQL scripts

·        Installed, patched and upgraded Oracle binaries and databases

 

VeriSign Dulles, VA: Oracle DBA 10/2006- 01/2009

Core team supports databases related to domain registration from all registrars in the world. The database is a very large database as well as performing 10000 transitions per minute. Also support on tuning and maintaining reports scripts.

 

·        Administered a 4 terabyte database

·        Monitored and administered development and production databases using Grid Control, and Toad

·        Configured and trouble shoot  high availability (Data Guard)

·        Configured  and administered Streams replication ( Schema replication, Downstream and upstream)

·        Put script in place to proactively monitor the performance of the database for resource contention

·        Managed tablespaces/datafiles capacity database migration, patching and upgrading databases

·        Migrated from Dictionary-managed to locally managed tablespaces

·        Installed  Oracle’s software  via response files and Oracle Universal Install (OUI) on Linux, AIX, Solaris and Windows

·        Installed Oracle’s client-only and Instant client via response file and Oracle Universal Installer on Linux, AIX, Solaris and Windows 2008

·        Create database manually (for large environments and extra parameters configurations) and via DBCA

·        Performed backup and recovery, online and offline backup (RMAN or user manage) , set up RMAN’s  recovery catalog, automating RMAN’s backup scripts in crontab export and import and datapump

·        Set up Flash Recovery Area for RMAN

·        used SQL*Loader (Direct or Conventional Path) and External Tables to load data into the database

·        Monitored database for performance issues and tuned SQL (Partitioned tables, Indexes, Table compression, and Materialized views

·        Instance Tuning, configure parameters for optimal usage, worked with ADDM, AWR and Statpack 

       Developed  SQL AND Shell scripts  (Very good SQL and Shell Scripting skills)

       Partitioned tables, added partition to partitioned tables, created partition Index    

·        Work on project lock down for VeriSign (securing and monitoring the listener log for reloads and failed connections, set password for the listener file, check for default username and password in the db that are know to hackers, create profiles, roles, view and enable database auditing )

Chaveran Inc. Bowie, MD: Oracle DBA 01/2005 to 09/2006

 

·        Created, modified, and managed database and objects on Oracle, MS SQL 2000 and 7.0

·        Loaded flat files into the database on UNIX - Solaris 2.x, Linux, and Windows NT platform by using SQL*Loader and External Tables

·        Managed database schema by creating users, roles, profiles, and provide required user privileges in development, test, training and production environments on both Oracle and MS  

·        SQL Server

·        Installed, created and configure Oracle 10g and 9i database on Windows NT and UNIX

·        Created and monitor the usage of indexes

·        Created and manage table-spaces

·        Used Oracle Enterprise Manager (OEM) to schedule database tasks (backing up the full database)

·        Performed offline and online (hot/cold) backups, with RMAN, user manage, data pump, and

·        Performed export and import

·        Performed data modeling, database design 

·        Performed performance tuning, installed statspack, gathered statistics via  

·        Statspack and AWR.

 

Bowie State University, Bowie, MD: Technical Support: 04/2003 to 12/2004 (Intern)

 

·        Created and altered database init.ora file to meet database requirements

·       Installed oracle client software on newly configured Windows XP/NT workstations

·       Assisted new Oracle students/users via creating their accounts

·       Maintained control files, redo log files, for high availability

·       Set up student access to data base (for database classes)

·       Setup computers and assign IP addresses (static IP addressing)

 

FEMA, Hyattsville, MD 01/2002 – 02/2003 (Intern)

·        Prepared presentations and assisted staff member’s pc and application use.

·        Prepared, responded, and recovered for disaster aid victims.

·        Provided infrastructure for effective communication in a fast paced environment

·        Expedited FEMA’s response time to disaster aid victims of federally declared disaster areas

 

 

 

 

EDUCATION:

 

BOWIE STATE UNIVERSITY- Bowie, MD

Degree: Bachelor of Science

Major: Computer Science Concentration: Database Development and Administration Minor: Business

 

 

Awards:

 

Awards

 

Outstanding Performance during the 3^rd Quarter

 

Certificate Of Appreciation