LINUEL TEBIT

Database Administrator

US CITIZEN

Email: adi1xj@r.postjobfree.com

Tel: 240-***-****

SUMMARY

Dedicated professional with 5 years of hands-on experience on Oracle 18c, 12c, 11g, 10g, and SQL Server 2016. Responsible for Patching, Installation, Upgrades, Backup and Recovery, Cloning, Replication, and Database Security for Enterprise environments. Worked on high availability and disaster recovery solutions including RAC, Golden Gate, and Data Guard. Performed recovery using RMAN of critical and non-critical files. I have performed data migration using expdp/impdp data pump, transportable table space from oracle to other RDBMS. Implemented performance tuning strategies using in built performance tuning tools like AWR, ADDM, ASH, EXPLAIN PLAN and TKPROF. Strong collaborator and team player with excellent communication skills and expertise in analytical problem solving.

PROFESSIONAL SKILLS

ORACLE

• Experienced with all facets of Oracle DBA day-to-day activities like production support, database monitoring, Backup & Recovery using RMAN, Cloning, Troubleshooting production issues, and Physical Database Design.

• Successfully upgraded the databases from 11g to non CDB 12c.

• Successfully migrated 12c Non CDB databases to pluggable databases.

• Created Oracle Wallets and implemented Tablespace level TDE security.

• Installed & configured Oracle Management Server (OMS) & Oracle Grid Control.

• Installation, Administration of 11gR2 RAC on HP-UX. Configured ASM, and RAW devices for storage.

• Experience as 24x7 productions DBA as well the application (development) database administrator.

• Team lead in configuring high-availability systems like Data Guard in a physical standby mode and effectively configured and managed the Data Guard Broker utility.

• Implemented planned quarterly switch over and fail over on Data Guard standby databases for DR.

• Highly Experienced in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.

• Knowledge of Database Recovery Techniques and implementation of those recovery techniques to ensure business continuity.

• Extensively implemented Data pump, conventional Export/Import (Oracle 11g, 12c, 18c) for migration and logical backup of database.

• Worked on Data transferring with Export/Import utilities and Data pump.

• Highly experienced in implementing Oracle's Transportable Tablespace (TTS) feature using Data pump Export/Import allowing users to quickly move a user Tablespace across Oracle databases.

• Worked extensively in Performance Tuning at various levels including instance tuning, Query tuning, Database performance tuning using tools like EXPLAIN PLAN, TKPROF, AWR, ADDM, STATSPACK, SQL TRACE, and tuning of initialization parameters.

• Experience in PL/SQL and SHELL SCRIPTING

• Extensive Experience in working with the Tools such as OEM, AWR, ASH, ADDM Expdp/Impdp, SQL Tuning Advisor, SQL Plan Baselines.

• In depth knowledge of Oracle Database Architecture, Data Structures, Automatic Partition Management, Database Backup/Restore, and DR Planning, Change Management and Monitoring Utilities.

• Good Experience in applying patches like Critical Patch Updates (CPU), Patch Set Updates (PSU), and One- Off Patches, Interim patches, DST, Patch sets as per the Oracle recommendations.

• Extremely comfortable using ASM for creating disk groups, adding additional storage (DISKS) and troubleshooting ASM issues.

• Extensive knowledge in maintaining Oracle Cluster ware using Srvctl, Crsctl, ocrconfig, cluvfy, Private IP, public IP, SCAN IP and Virtual IPs along with NAS and SAN for ASM storage.

• Successfully installed Oracle Real Application Cluster (RAC) including Grid infrastructure (Cluster ware and ASM) and Oracle RDBMS software on a 2 nodes RAC architecture in development and UAT running oracle.

• Troubleshooting RAC clusters, node eviction, CRS resources failure. Running Queries in parallel, setup inter instance parallelism, Load balancing. Resource utilization on each node. Fix corrupted OCR disk.

• Tuning of RAC environment. Managing fail-over of instances. Configure table for parallel load.

• Experience as 24x7 productions DBA as well the application (development) database administrator.

• Prepare the Documentation for all the project level work.

• Experience in installation, configuration, performance tuning and troubleshooting Oracle Golden Gate in Oracle to Oracle homogeneous environments and heterogeneous environments.

• Firsthand experiences in setting up Oracle Golden Gate one-way, two-way/bi-directional, active-to-active, and active-to-passive data replication with conflict detection and resolutions. Extensive skills in upgrading Golden Gate 11g to 12c.

SQL SERVER

• Performed basic administrative tasks such as creating databases and managing users as well as performance health checks.

• Creation of indexes to enhance performance.

• Developing reports, maintaining report definitions, maintaining report manager portal using SQL Server Reporting Services (SSRS).

• Developing and maintaining OLAP cubes using SQL Server Analysis Services (SSAS).

• Developing ETL packages using SQL Server Integration Services (SSIS) and bulk-loading utilities.

• Develop and maintain shell scripts to automate provisioning and patching of SQL Server database and tools. WORK EXPERIENCE

CareSource – DAYTON, OHIO

August 2017 – Present

Database Administrator

• Installed and configured Oracle 12c database and cloud control 12c to monitor all databases

• Created and implemented database designs and data models

• Modified existing databases to meet unique needs and goals determined during initial evaluation and planning process

• Worked with application team, developers, change management team and DBA team to ensure smooth life cycle progress from development through testing and production implementation

• Maintaining sound backup and recovery policies and procedures using RMAN together with performing hot and cold backups while monitoring scheduled backup procedures daily

• Experienced in handling database Performance tuning issues using OEM as well as command prompt

• Scheduled meetings with application team for database migration review to gather legacy information such as type of application, database options, current oracle configuration, capacity, and oracle outstanding tasks

• Constantly performing refreshes on Development, Test and UAT environments with production data as per customer's request

• Maintaining sound backup and recovery policies and procedures using RMAN

• Monitoring the scheduled backup procedures for daily basis using crontab

• Experienced in handling database issues using OEM as well as command prompt

• Expertise in upgrading databases from lower versions to higher versions (11g, 12c, 18c) using manual scripts and DBUA and applying patches whenever required

• Installed ASM environment and migrated databases from NON-ASM to ASM

• Used Oracle Enterprise Manager (OEM) 10g & Grid Control (11g), 12c, 13c cloud control for database monitoring/performance/diagnostics

• Performed Schema as well as Table level Replication using GOLDEN GATE 11g, 12c

• Part of a team that Installed and configured High Availability Oracle Golden Gate (OGG) systems on Oracle 11gR2

• Upgraded Oracle Golden Gate from 11gR2 to 12c

• Implement Golden Gate 12c new features in mission-critical production environments

• Manage all aspects of the Golden Gate design, implement and support in Development, UAT and Production environments

• Identify and resolve Golden Gate problems occurring in all database environments including performance related issues (Database & SQL tuning), and Troubleshooting typical Golden Gate technical problems such as unique key violation / long transaction by using GGSCI / Log dump / discard file analysis etc.

• Experience in troubleshooting RAC environment, performed various tasks like Adding nodes and instances, Administering Storage Components, Parameter Management, and Configuring High Availability Features for RAC

• Resolved issues involving RAC, OCR, Faulty node rebooting, and switched over service relocation

• Hands on experience in troubleshooting RAC environment, using srvctl, crs_stat, and crs_profile, and performed various tasks like Adding nodes and instances, Administering Storage Components, Parameter Management, and Configuring High Availability Features for RAC

• Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO, Memory, PL/SQL Packages, using tools such as EXPLAINPLAN, SQLTRACE, TKPROF, AWR, ASH and ADDM

• Extensively worked on setting up Auditing in many databases

• Experience supporting a mission-critical database environment with 24x7 On-Call Support JUICE PLUS - COLLIERVILLE, TN

October 2015 – July 2017

Database Administrator

• Successfully installed and configured Oracle 11g, Oracle 12c databases on Linux platforms

• Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 12c Grid Control

• Used AWR, ADDM and explain plan for performance tuning

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

& TKPROF, EXPLAIN PLAN

• Support developers for efficient SQL query and Identifying long running queries and optimizing

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

• Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases

• Installed, configured, and implemented DATA GUARD for Disaster recovery, configured physical standby databases.

• Implemented Maximum Performance and Maximum protection mode on Data Guard environments for Disaster recovery

• Performed Fail-over and Switchover using Data Guard Broker and manually as and when required

• Performed LOG GAP resolution in Data Guard environments

• Participated in Disaster Recovery Drills (RMAN), documented database, and application validation steps

• Used Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitor (ADDM) in RAC for Performance Tuning

• Created users, roles and granted privileges according to the business requirements together with implementing advanced security using TDE

• Generated scripts for daily maintenance activity like analyzing the tables/indexes, monitoring their growth rate, monitoring the effective use of SGA.

• Perform production system problem analysis and recommend corrective measures in a timely manner

• Installed ASM environment and migrated databases from NON-ASM to ASM CERTIFICATIONS

Oracle Cloud Infrastructure 2019 Architect Associate Oracle Database 12c Administration

TECHNICAL SUMMARY

Operating

Systems

Linux Red Hat 7.4, Solaris, Windows

RDBMS Oracle 10g, 11g, 12c, 18c, SLQ Server 2016

Languages SQL, PL/SQL, Shell Scripting

Tools TKPROF, STATSPACK, EXPLAIN PLAN, AWR, ADDM, ASH, AWR, TOAD, PUTTY, OEM, NAS, SQL Tuning Advisor

Database

Utilities

RMAN, DATA PUMP, SQL*LOADER, ASM, Transportable Tablespace, DATA GUARD, GOLDEN GATE, OEM, ASM, SSIS, SSAS, SSRS,

Contact this candidate