INFORMATION TECHNOLOGY SPECIALIST Summary An organized DBA professional 6years hands-on experience supporting Oracle databases, Sql Server databases AWS infrastructure. Equipped excellent communication interpersonal skills; highly organized individual team player possesses strong analytical problem solving skills, committed delivering quality services customers/clients. Experience Information Technology Specialist 03/2018 Current Company Name City State Primary responsibilities include production support, installation configuration, migration, backup recovery, performance tuning, cloning, security, upgrades, patches. Planned, installed upgraded multiple Oracle databases 11.2.0.4 12.2.0. Added targets OEM 13c used OEM 13c monitored databases. Created rules, security profiles using OEM 13c. Performed Hot/Cold Backup, Recovery Cloning databases using RMAN Planned implemented Backup strategies, used RMAN Crontab schedule backup. Installed upgraded databases MySQL 5.6 5.7 implemented mysqld_multi better performance. Migrated databases on-premise AWS using Database migration services. Launched maintained RDS EC2 instances AWS. Created Snapshots, Elastic IPs, EBS Volumes, Security Groups per clients/costumers request. Performed cross region replication S3. Created security groups manage inbound outbound rules. Database Administrator 12/2014 Current Company Name City State Troubleshot resolved web application issues escalated customer support departments 100% success rate. Worked clients analyze computing network needs implemented appropriate solutions within department's budget. Analyzed performance monitoring/tuning/troubleshooting Oracle database performance tuning services EXPLAIN PLAN, TKPROF, STATSPACK, AWR SQL TRACE. Installed, configured maintained Physical, Logical, Active standby databases supported Data guard Oracle 11g, 10g RAC servers purpose disaster recovery procedures. Generated ASH, ADDM AWR Reports using OEM Oracle 10g, 11g 12c database analyzed reports Oracle wait events, time consuming SQL queries, tablespace growth, database growth. Implemented database re-organizations required improved performance ensure maximum up-time database; implemented SQL Access SQL Tuning advisers recommendations. Launched maintained RDS EC2 instances AWS. Created Snapshots, Elastic IPs, EBS Volumes, Security Groups per clients/costumers request. Planned implemented high availability solutions Real Application Cluster (RAC) Oracle 11gR2 Grid 10g ASM ACFS file systems. Migrated multiple stand-alone databases RAC databases using Rconfig, RMAN OEM. Migrated single instance databases NON-ASM ASM file system improve performance. Installed Oracle 10g, 11g 12c software created multiple databases including Plug-able container databases oracle 12c. Implemented TDE, Data Redaction database Auditing improved data integrity security. Applied PSU standalone TEST environment using OPatch PSU (Grid RDBMS Patching) production cluster using OPatch Auto. Replicated data real time using Oracle Golden Gate Oracle streams. Analyzed, interpreted troubleshot Golden Gate related issues. Designed implemented different backup strategies like Cold, Hot backup using RMAN Flash Recovery Area Logical Backups EXPDP/IMPDP. Scheduled RMAN backups, purge jobs, Maintenance Jobs using DBMS_JOBS, DBMS_SCHEDULER, Crontab OEM. Implemented managed logical backup/recovery Datapump Export/Import utilities. Cloned databases using RMAN Manually using scripts. Implemented Point In Time Recovery one tablespaces recover lost table(s) eliminating time database. Installed SQL Server EE 2012 windows created databases, triggers, tables, procedures, functions database diagrams. Upgraded databases 10g 11g 12c using DBUA, Datapump, Manually, Transportable Tablespace Oracle Dataguard. Oracle Database Administrator 07/2012 10/2014 Company Name City State Prepared technical architecture proposals enhancements migrated existing standalone database RAC database. Provided senior technical support Developers troubleshot performance issues maintained high availability security databases. Analyzed tuned Database identify potential database bottle necks response delay, locking contention, wait event using tools like STATSPACK, EXPLAIN PLAN, TKPROF. Collaborated worked together development operations staff resolved problems quickly efficiently. Maintained Physical, Logical, Active standby databases supported Data guard Oracle 11g, 10g RAC servers purpose disaster recovery procedures. Installed, configured, deployed monitored different databases application servers using Oracle OEM 12c Grid Control. Worked efficiently Database administration activities User management, Space management, Monitoring, Creating Database, Managing Oracle Instance Database security Materialized views. Maintained administered high availability solutions Real Application Cluster (RAC) Oracle 11gR2 Grid 10g ASM file system. Planned applied PSU/CPU patches upgraded multiple databases 10g 11g. Replicated data real time using oracle Golden Gate. Increased data security; implemented TDE database auditing created threshold database metrics set alert stronger security. Maintained Active Data guard, creating Logical Physical Standby databases data disaster recovery solutions. Worked 24/7 environments, supported, monitored, managed troubleshot database related issues 300 oracle 10g, 11g 12c databases sizes 300G 2TB. Implemented backup strategies used RMAN incremental/full backup Datapump backup logical components. Education Training Bachelor Science Civil Engineering University Of Buea City State Cameroon Civil Engineering Technical Environment Databases: Oracle 10g, 11g, 12c, MySQL 5.6, 5.7, Sql Server 2008, 2012 Platforms: Oracle Enterprise Linux 5.11, 6.7, 7, HP-UX 10.x, 11.x. Sun Solaris 2.5, 2.6, Windows Server 2008 Tools TKPROF, EXPLAIN PLAN, STATSPACK, AWR, ADDM Toad, Putty, X-wing32, WinSCP. Database Utilities Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export, Import Languages ·SQL*PLUS, PL/SQL, UNIX Shell Scripting, Ksh, bash