Name: ARNOLD SERUWAGI

Contact: 202-***-****

Email: adl684@r.postjobfree.com

DBA SKILLS.

Databases: Oracle 11g, 12c, OEM, 18c

Operating Systems: Linux, Centos7, Windows HP-UX, AIX, RHEL Tuning Tools: TKPROF, EXPLAIN PLAN, AWR, and ADDM, Cluster control, Ansible, PgAdmin4, PgHero, PgBadger, OEM, PEM, Crontab, SqlLoader, MTK, Ora2pg, DMS, AWS SCT, Jira, Service Now, RMAN, Shell/Bash, PL/PGSQL, Sql workbench, Dbeaver, Languages: PL/PLSQL, PG SQL

Utilities: RMAN, OEM, SQL*Loader, EXP, IMP, Data pump, TOAD, Oracle SQL Developer Crontab.

PROFILE SUMMARY.

• 7+ years IT experience

• Oracle DBA(10g,11g,12c,18c),Postgress (9,10,11)

• AWS

• Backup and recovery

• Production support

• Dataguard

• RAC

• Golden Gates

• Performance tuning

• Cloning

• Shell scripting

• Installation-upgrade-patching

• Data security

• Bash Scripting

• ETL

• EBS

• PeopleSoft

PROFESSIONAL EXPERIENCE.

BRAKE PARTS INC - MCHENRY, IL. Nov 2019 – Current

Oracle & postgress Database Administrator

• .Configured PgBouncer for connection pooling and PgBadger for stats reports.

• Participated in 24 X 7 Production & Development database support and administration.

• Configured and monitored streaming replication between primary and target.

• Ran maintenance auto vacuum jobs and customized vaccuum on certain tables.

• Championed database migration from Oracle to PostgreSQL on premises and on AWS, using Migration Tool Kit, Ora2pg, DMS and SCT.

• Rewrote and implemented a backup strategy following company SLA; execution of backup schedule for both physical using Pg_base_backup and Pg_backrest and Pg_dumpall and Pg_dump for logical backups.

• Deployed Database security policy and installation, using passwords, privileges and user profiles, Enabled Encryption for databases.

• Cloned databases using creation templates and pg_dump for testing purposes.

• Performed database Refreshes from production environments

• Performed PL/PGSQL errors fixes for application issues.

• Tuning of SQL statements, optimize stored procedures, analyze query plans, write advanced PL/pgSQL

• Performed patching and upgrades of Databases using AWS minor versions upgrades, pg_upgrade, pg_dumpall and logical replication

• Participated in a weekly on call rotation and run packages during off peak hours.

• Installed and configured PG versions 9.7,10.7 and 11.4

• Supported daily administration, monitoring, tuning, and troubleshooting of clusters and single instances on Unix/Linux and AWS Console (Database sizes range 100GB to 25TB)

• Monitored CPU utilization, memory, Database Connections and storage space daily using pg_stat_activity, PEM, Pg_view and AWS CloudWatch alarms. Also use customs shell scripts deployed on crontab to monitor performance and resources.

• Revised logs for unusual events and performance issues and took appropriate action

• Implemented table and index partitioning to improve query speed.

• Participated in capacity planning meetings to meet the demands of the dynamic aspects of storage and memory for the databases

• Worked with the Data pump to take the logical backups of databases and Experienced in performing Point in time recovery using RMAN.

• Used oracle configuration assistants like: DBCA (Database Configuration Assistant) for Creating databases, DBUA (Database Upgrade Assistant) for Upgrading databases, and NETCA (Network Configuration Assistant) for creating Client-Server environment using Listener, TNS names etc.

• Extensively used AWR, ADDM and explain the plan for periodic performance tuning.

• Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF.

• AWR, ADDM, ASH, TOAD and Oracle Grid Cloud monitoring.

• Configured Oracle Data guard for Oracle Disaster recovery.

• Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.

• Implemented Flashback technology of the Oracle 12C, 11g, 10g along with Recycle bin for a faster recovery of the databases and database objects.

• Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.

• Refreshed/cloned databases using the RMAN utility.

• Made optimal use of Oracle Support in resolving the SRs CenturyLink Inc - Monroe, LA Jan 2016 – Oct 2019

Oracle Database Administrator.

Created tablespaces, tables, indexes, set privileges and user logins on oracle databases.

• Perform maintenance activities like checking auto vacuum jobs, and customized vacuum on certain tables.

• Supported Oracle DB backups (online/offline), logical backups and UNIX scripts, created clone databases, performed DBA day-to-day activities

• Implemented shell-scripts for automation of day to day activities.

• Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both OEM (client), Oracle 10g database control & SQL*Plus, as well as pre-developed UNIX shell scripts.

• Applied Critical Patch Updates (CPU) and Patch set updates (PSU) on Oracle databases and interim patches for various bugfixes on database products.

• Created and managed PL/SQL packages, procedures, triggers, functions, Indexes and Collections to implement business logic using SQL developer and SQL navigator.

• Hand on experience in cloning the non-multitenant container database to pluggable database in 12c using the PDB Metadata clone, PDB Remote Clone and PDB Snapshot cloning feature.

• Backed up and recovered/Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 10gR2 and 11g.

• Backup Oracle DBA for two major projects involving periodic administration, troubleshooting & tuning of 10 Oracle databases (10g & 11g single instances running on both IBM AIX 5.3, SunOS 5.8 & HP-UX B.11.11.

• Used to run scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.

• Created Physical Standby databases, performed Failover and Switchover using Data Guard Broker and manually when required.

• Involved in Oracle Golden Gate installation, configuration, and monitoring.

• Designing/developing/maintaining database schemas.

• Developed, modified, and optimized very complex queries to data retrieval using Explain Plan, SQL Trace, TKPROF, parallel processing and partitioning techniques.

• Implemented Oracle database 12C RAC databases using Oracle Clusterware for achieving high Availability.

• Oracle Installation, Configuration, Migration, Upgrades and Patches. Server versions ranged from Oracle 10g – 19c.

• Disaster recovery planning or Emergency Recoveries and Ensuring Recoverability of Databases.

• Experience working on POC of 12c new features like Redaction policy, adaptive query optimization, multiple indexes on single column, Restore table through RMAN. ALLIANZ - Minneapolis, MN. Mar 2014 – November 2015 Oracle Database Administrator

• Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.

• Oracle Production Support Database Administrator

• Administered and monitored over 150 databases both on 10g/11g on prod/test/dev environments.

• Administering Oracle Databases 10g/11g of sizes ranging from 100GB to 5TB.

• Migrated databases from Filesystem to Automatic Storage Management (ASM).

• Involved in migrating applications from Solaris 10g/11g to Linux 11.2.0.3 using Transportable Tablespace, RMAN Convert.

• Up-gradation of single instance databases from 10.2.0.4 to 11.2.0.3 on

• Installed 12C grid control and Used Oracle Enterprise Manager Grid control 11g/12c for monitoring databases.

• Programming in shell to create shell scripts that automate the database backups and maintenance.

• Installed and set up High Availability Oracle Golden Gate (OGG) systems on Oracle 11g and 12c environments. Upgraded Oracle Golden Gate (OGG) systems from 11g to 12c.

• Have implemented two type of standby databases supported by Data Guard, logical standby and physical standby databases in 11gR2 on two node RAC

• Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN.

CERTIFICATIONS/EDUCATION.

• BSc. (Hons) Economics & statistics Kyambogo University, Uganda May 2013.

• AWS Solutions Architect certified.

• Database 12c: SQL Fundamentals.

• Oracle Database 12c Administration

• Oracle Cloud Infrastructure Architect Associate

• Oracle Autonomous Database Cloud Specialist

• COMPTIA Security + ce

Contact this candidate