JOEY ANAGHO
Cincinnati,Ohio
Summary
Oracle Certified DBA with over 15 years+ of IT experience in Oracle (19c, 12c,11gR2,11g, 10gR2,10g, 9i), installation, design, security, backup, recovery, migration, performance tuning, streams, upgrade on a variety of platforms like UNIX (Solaris, HP-UX, AIX) and LINUX. Goal oriented individual with excellent leadership, work ethic and communication skills. High-performing professional with extensive experience managing large-scale, complex databases. Skilled in SQL and database management systems. Strong understanding of database design and data modeling with excellent troubleshooting skills. Smart and committed to staying up-to-date with new technologies and advancements.
Overview
16
16
years of professional experience
1
1
Certification
Work History
Oracle Database Administrator
BOEING
Cincinnati, Ohio
01.2013 - Current
- As a member of a 24/7 team of database administrators responsible for supporting and managing production and development databases running on Sun Solaris, IBM AIX, Linux red hat and Windows NT/2000 platforms, with sizes ranging from 100gb to multiple terabytes
- Part of the overall strategic planning & redesign of databases: Requirements gathering, Analysis, Design, Test and Implementation through the phases of System Development Life Cycle
- Assist other team members and the project managers in setting client expectations regarding the efforts necessary to achieve change
- Worked with application developers to address and clarify data requirements to resolve technical and functional issues
- Installed, configured and managed multiple Oracle Cloud Infrastructure and PeopleSoft ERP databases
- OCI Data migration using Import/Export, import/export data pump, SQL
- Loader, External tables
- Managed EDB Postgres databases in On-Prem and in the Cloud
- Experience in Oracle cloud Infrastructure platforms- AWS, MongoDB, Postgres EDB, AZURE and Google Cloud from install, configuration, monitoring and maintenance
- Upgrade existing databases by applying Patches, Oracle Diagnostics and Tuning Packs to various versions of Oracle
- Install/upgrade Oracle, PostgreSQL software, create databases, Design OS and Storage requirements on various platforms (sql server and oracle databases)
- Maintain IT infrastructure including Server hardware, Data storage, switching and routing, backups
- Experience with multiple nodes RAC environment and GRID infrastructure
- Database Change Management, Code governance & ensure best practices are followed
- Ability to perform Root Cause analysis for issues and address them timely
- Experience with implementation of Data At Rest (DAR) encryption, including creating/configuring wallets
- Experience with implementation of Data in Transit (DIT) encryption
- Patching: patch set installation using OUI and Oracle fleet
- Oracle CPU, PSU, Interim installation using Opatch
- OEM automated patching of both OJVM and RDBMS (cloning existing Homes and patching) Migrated databases/schemas from windows to Unix using export/import, data pump Utilities on both SQL Server and Oracle on RAC configuration (Real application Cluster)
- Reorganize databases: Defragmenting, turning Archiver on/off, rebuilding and/or relocating indexes, and undo segments
- Deploying 10g, 11g,12c and 19c Grid Agents to target servers Installation, Configuration and Administration of Oracle 10g 11g, 12c and 19c container databases includes Database cloning from development to test environment and to production
- Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 12c Grid Control
- Refreshed schema using Export/Import
- Created the database, table space, tables, indexes, set privileges and user logins
- Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies
- Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases
- Good knowledge of AWR, ADDM and explain plan for periodic performance tuning
- Implementing Data pump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance
- Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data between 10g and 11g environments
- Implemented proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace & TKPROF, EXPLAIN PLAN
- Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager)
- Monitored and effectively tuned the 19c,12c, 11g and 10g database instances by utilizing own scripts, Oracle Statspack utilities
- Enforced corporate business rules through adequate user/resource/object management
- 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues
- Participating in adhoc meeting planning and designing implementation strategy to meet with database growth and upgrade
- Experience with OEM 12c administration and database management at the Grid control level
- Knowledge of Ansible PlayBook, Git and jira for automation and standardization of deployment changes
- Understanding of Golden Gate application for replication.
Oracle Database Administrator
BLUTECH INC.
Clarksville, MD
02.2008 - 12.2012
- As a member of a team of senior database administrators responsible for supporting and managing over 60 production and development databases running on Sun Solaris (5.9, 5.10), Linux and Windows NT/2000 platforms, with sizes ranging from 20M to about 1/2 terabyte
- Also worked with SQL Server 2005 and 2008
- Concerted with system administrators to define software and hardware requirements for oracle database systems
- Install and configure Oracle 19c,12c, 11g and 10g on both Windows and UNIX platforms using OFA standards
- Install and configure Oracle 19c,12c, 11g and 10g and Enterprise Manager Grid Control (OEM) on UNIX and Windows NT platform
- Create and configure Oracle Databases using Oracle Database Configuration Assistant, manually by using custom SQL Scripts which invoke CATALOG.SQL and CATPROC.SQL; implementation of system security and the organization and easy identification of database files using the OFA database configuration method
- Experience in Oracle Encryption , install and configure Keystore and wallet management
- Create database objects, Tablespaces, Application Users, Database schemas, profiles, granting privileges and roles, and create database links
- Installed and used sql developer in test environment
- Analyzing Tables, Indexes and Clusters against chained and migrated rows and providing solutions Resizing, relocating and duplexing redo logs to either reduce log switching or eliminate contention
- Reorganization of database by recreating the control file
- Resizing, cloning, moving, Partitioning and striping tablespaces, Tables, Indexes and rollback segments depending on the situation
- Executed Remote Diagnostic Agent (RDA) to gather information to troubleshoot and to document the system
- Proactive monitoring, troubleshooting, restructuring, tuning, and tracking database load, fragmentation, contention, and overall performance for optimal performance of the existing database
- Monitored database growth, created objects, administered users and recommend the tuning of top and expensive SQL statements using EXPLAIN PLAN and SQL TUNING ADVISOR
- Generate Automatic Work load Repository and Automatic Database Diagnostic Monitor Reports to assist in troubleshooting and resolving bottlenecks
- Performed load balancing operations to reduce I/O and contention
- Collect optimizer statistics for tables, indexes and clusters using dbms_stats package
- Documented the structure of existing and new databases using Erwin 3.5.2 to generate ER diagrams
- Monitoring/managing database space utilization and growth, tablespace usage and extents, to include allocating and planning disc storage, modifying database structure
- Capacity planning of tables, indexes, tablespaces and databases to allow for growth potential
- Designed, tested and implemented backup and recovery solutions including automated daily hot backups and cold backups depending on criticality of the Database
- Established backup and recovery procedures and maintenance including hot and cold backups to support point-in-time recovery of the database which includes using RMAN and shell scripts
- Performed database import/export as well as datapump and load utilities for various maintenance and logical backup and recovery procedures
- Configure Flashback recovery area for database, flashback as needed
- Configure block change tracking with RMAN for Fast or Merged incremental backups
- Configure Standby databases (Data Guard) and maintaining Active DATA GUARD environment
- Managing/modifying database security and database schema
- Implementation of organizational database security policies involving: Security procedures, strong password authentication, assigning various roles for users based on their job activities, establishing access Control and granting privileges
- Implement organizational policies on a per-table basis through fine-grained access control, roles, grants, views etc
- Table- and backup-level security with RMAN using Transparent Data Encryption (TDE) Experience with Oracle virtual private databases, partitioning, and replication
- Security implementation through basic and advance security techniques like applying recent security patches and upgrades (PSUs), appropriate user grants, permissions and profile management
- Provide a 24/7 coverage and technical support through the use of emails, cell phones, and PDA’s for mission critical Databases
- Properly configure the password and system resources for the Oracle database to be consistent with corporate password policy
- Ensure users are restricted in accessing database using vendor provided default usernames/password (default database user accounts are disabled/locked/removed and or until passwords have been changed)
- Designed, tested, corrected, documented and implemented database migration procedures including export/import, migration utility.
Education
Bachelor of Arts - International Relations -
Yaoundé University
Associate Degree - Computer science -
MDC
Skills
- End-User Training
- Documentation
- Microsoft tools
- Microsoft Project
- Unix System
- Linux
- Solaris
- PLSQL / SQL
- Oracle
- LDAP
- OID
- RAC
- RMAN
- Client/Server Architecture
- ASM
- Database Administration
- Quality Assurance
- SharePoint
- Requirements Analysis
- Data Warehousing
- Needs Assessment
- Process Improvements
- Troubleshooting
- Problem Solving
- Team Management
- OEM
- ATP
- OCI
Certification
- OCA 10G/11g Certified Associate
- ENGLISH
- FRENCH
- GERMAN CLEARANCE -NACI
Timeline
Oracle Database Administrator
BOEING
01.2013 - Current
Oracle Database Administrator
BLUTECH INC.
02.2008 - 12.2012
Bachelor of Arts - International Relations -
Yaoundé University
Associate Degree - Computer science -
MDC