| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateName: ARNOLD SERUWAGIContact: PHONE NUMBER AVAILABLEEmail: EMAIL AVAILABLEDBA SKILLS.Databases: Oracle 11g, 12c, OEM, 18cOperating 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 SQLUtilities: 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 PeopleSoftPROFESSIONAL EXPERIENCE.BRAKE PARTS INC - MCHENRY, IL. Nov 2019 CurrentOracle & 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 2019Oracle 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 |
