Database Administrator Oracle
Resume:
Sheka Zion Tarawallie
*******************@*****.***
ORACLE DATABASE ADMINISTRATOR
SUMMARY
●I am a proactive DBA with over 5 years of hands-on experience as an Oracle/ PostgreSQL Database Administrator. I support a complete SDLC life cycle environment. I have extensively worked on Oracle 12c, 11g, 19c,and 10g versions and PostgreSQL 9.x – 10.x versions. I have worked on different operating system platformsincluding AIX, Solaris, LINUX and Windows. Areas of DBA specialization include Dataguard, Goldengate, RAC, upgrades, patches, migration, cloning, security, backup and recovery, performance tuning. Provided 24X7 support for all the production, test and development databases.
SKILLS SUMMARY
●Excellent experience in managing large-scale OLTP databases in High Availability and Disaster Recovery setup.
●Solid experience in oracle database migration, upgrades, applying patch sets, code reviews, database release and deployments and data center consolidation activities. Proficient with Database Cloning, Migration, and Patching of Oracle Databases.
●Experience in installing and patching Oracle RAC on Solaris and Linux platforms.
●Expertise in setting up Data Guard Fail-Over/Switch-Over/Read-Only scenarios. Fabricated multiple CLONING databases using traditional method and RMAN utility for High availability configuration.
●Cloning and Upgrade of Oracle Databases and Grid Infrastructure.
●Experience in using transportable tablespace, materialized view, RMAN incremental backup and bitmap indexes in data warehouse environment.
●Experience in Oracle Golden Gate 10.x/11.x installation, configuration, and troubleshooting Golden Gate issues.
●Expertise in Analyzing data Quality checks using shell scripts. Upgrading, installing, and configuring PostgreSQL servers.
●PostgreSQL Installation, Configuration, Migration, Upgrades and Patches. Server versions ranged from PostgreSQL 8.2 to 9.5.
●Zero downtime migration using oracle datapump and Golden Gate between Oracle 10g and 11g with Linux, Solaris, and Windows platforms.
●Highly experienced in performance monitoring/ tuning/troubleshooting.
●Oracle Database performance-tuning services with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE. Applying patches under UNIX platform.
●Worked on setting up/installation and configuration of release 11g R2 RAC with ASM on 11g.
●Installed 12c Databases and responsible for upgrading Oracle 11g RAC to 12c RAC.
●Planned and Implemented Disaster Recovery (DR) and HA using RAC, Data Guard.
●Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 12c) for migration and logical backup of database.
●Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch).
●Worked on Oracle's Transportable Tablespace (TTS) feature using Datapump Export/Import (Oracle 11g, 12c).
●Proactive database monitoring via automatic Email and Text alerts of Alert.log, Listerner.log and Space errors to DBA cell phone
●Expert knowledge in Security Management, Schema Management, Instance Management, Storage/Space Management.
●Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.
●Performance Tuning of the database (Memory Tuning, I/O Tuning)
●Expertise in Performing Tuning Database -
●Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.
●Expertise in maintaining Database Security using auditing.
●Checking and resolving Database corruptions using DBVERIFY utility. Configured Manager, Replicate and Extract processes and implemented unidirectional replication using Oracle 11g Golden Gate on RHEL 5 platform.
●UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs
PROFESSIONAL SUMMARY
Sun Products Corporation - Salt Lake City, U
January 2018 – Present
Oracle Database Administrator
●Defining the standards, to maintain the health of the server. RAC to RAC physical standby configuration of data guard for Disaster recovery requirement.
●Ensuring load balancing in RAC by creating services for different purposes based on the application requirement and also defined TAF policy for RAC instances.
●Configure Oracle Data Guard as disaster recovery approach.
●Use Active Data Guard feature to offload reporting duty from production database.
●Implement Oracle Golden Gate (OGG) to replicate data from front-end OLTP databases to back-end Data Warehouse systems.
●Create database services for distributing the applications across multiple nodes by extensively using all command line utilities, such as SRVCTL, CRSCTL, ADR, and ASMCMD.
●Set up test databases for development team by using RMAN duplicate tool.
●Responsible for configuring, integrating, and maintaining all Development, QA, Staging and Production PostgreSQL databases within the organization.
●Responsible for all backup, recovery, and upgrading of all of the PostgreSQL databases. Monitoring databases to optimize database performance and diagnosing any issues.
●Develop, implement, maintain policies and procedures and document database architecture to ensure the security and integrity of the databases.
●Setup and maintenance of Postgres master-slave clusters utilizing streaming replication. Cross-datacenter disaster recovery and backup architecture
●Performing schema management, database sizing, maintaining privileges.Data migration while upgrading database versions ranging from 8.2 to 9.5.
●Extensive experience with Warm Standby (PostgreSQL 8.x and earlier), and Hot Standby (PostgreSQL 9.x and greater)
●Installing pivotal-support packages to monitor performance like (gpsupport and mem_watcher.. etc)
●Installing and configuring connection pooling tools like Pgbouncer and pgpool etc.
●Installing and monitoring PostgreSQL database using the standard monitoring tools like Nagios etc.
●Configuring log analyzation tools like pgfouine and pgbadger etc.
●Monitoring and maintaining 2 node RAC database on Red Hat Linux. Providing support to the development team and handling release schedules.
●Maintaining sound backup and recovery policies and procedures using
●Creating, granting and monitoring user access rights and privileges through roles and profiles.
●Automatic Shared Memory Management (ASMM) for Performance diagnosis/tuning and Automatic Segment Space Management (ASSM)
●Supported development effort by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools Explain Plan, SQL Trace, TKPROF, TOAD and Oracle Enterprise Manager.
●Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.
●Refreshing Dev and Test instances with data from Production on a regular basis.
●Generated and automated Statspack/AWR reports from Oracle database and analyzed the reports for Oracle wait events, time consuming SQL queries, table space growth, and database growth.
●Addressed developers/testers requests to clone production databases for the purposes of testing using RMAN.
●Extensively used Datapump, conventional export/import utilities for loading data to & from databases, logical backups and migration of databases.
●Monitoring rollback segment and temporary table space use.
●Performing housekeeping tasks like checking log and trace files.
●Setup and maintenance of Physical Standby Database using Data Guard Broker and active Data Guard for faster Disaster Recovery.
●Daily Health Checkup of all the Databases using Oracle Enterprise Manager 12c.
●UsedDatabase Configuration Assistant (DBCA), Database Upgrade Assistant (DBUA) for upgrading Oracle10gR2 to the latest Oracle 11gR2 and applied patches as required.
●Performed full and incremental backups using RMAN for development and production databases.
Equifax - Atlanta, GA
August 2014 – December 2017
Oracle Database Administrator
●Performed Installation and configuration of Oracle 12c database on HP-UX platform.
●Successfully performed migrations from Oracle 11g/12c to 11gR2 RAC (Real Application) Database.
●Implemented Logical and Physical Standby Databases for RAC cluster on Sun Solaris platform using Data Guard feature of Oracle 11g R2 and 12c
●Successfully performed data replication using Materialized views and Oracle Streams in Oracle 11gR2.
●Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups.
●Supported off-hour on call support for database related issues.
●Created logical and physical design installed and upgraded databases.
●Constantly monitor the performance (V$ dynamic performance views at peak load) of the Databases and viewing Alert log files & Trace files.
●Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 11gR2.
●Responsible for Datacenter Migration from old Datacenter to new datacenter and Migrated and upgraded single instance database to multiple instance databases using export/import, data pump.
●Configure Data Guard on both standby and primary for 45 production databases.
●Refresh schema using export/import, Creating the database, table spaces, tables, indexes, setting privileges and user logins.
●Experience in migrating from multiple Oracle 10gR2 database to oracle 12cR2 on virtual machine (VM Ware).
●Hands-on experience in working with virtual machine (VM Ware) under different operating system like Linux, sun Solaris and windows.
●Setup RMAN solutions for all Oracle Databases -- created rman repository, provided best practices, optimizations and data guard and cloning techniques -- restore and recovery.
●Experience in Implementation of High Availability solutions with Oracle 10g &11g RAC, Physical Standby Databases (Data Guard). Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled jobs.
●Applied patches to 11g and 12c databases.
●Used to run the scripts to check the status of databases such as growing table sizes, extent allocation, free space, used space, fragmentation etc.
●Performed space management, capacity planning, disaster recovery and overall maintenance of the databases.
●Used SQL TRACE, TKPROF, EXPLAIN PLAN utilities for optimizing and tuning SQL queries.
●Maintained the data integrity and security using integrity constraints and database triggers.
EDUCATION
EDUCATION AND CERTIFICATIONS
2016-2021 Oracle Certified Professional (OCP)
2016-2021 PregresSQL
2018-2021 Oracle Certified Associate – 12c(OCA)
Security +(plus) certification-CompTIA
Billing and Coding(six months)
Larock Healthcare Academy- Ohio.
2019-2021 Statistic,Mathematics, Communication Skills,
Anatomy and Physiology and Chemistry.
Central Ohio Technical college(COTC) Newark
2008-2012 Bsc Accounting
Njala University- Sierra Leone
03-2009 Associate Degree in Information Technology and Microsoft Office
Sulisha Institute of Management and Computer Studies-Freetown, Sierra Leone.
REFERENCES
(AVAILABLE UPON REQUEST)
xxxxxxxxxxxxxx
xxxxxxxxxxxxxxxxxxxxx
Contact this candidate