Christian Fotachwi
- Oracle Database Administrator
- Green Bay, WI
- Member Since Apr 26, 2023
Candidates About
Christian Fotachwi
Oracle database administrator certified.
Over 6 years aggregate IT experience with strong troubleshooting skills and 5 plus years of extensive knowledge and proficiency in ORACLE,11g and 12c DATABASE design, administration and systems analysis. I have excellent communication skills and I am a great team player with a fast learning curve. I can work perfectly and effectively under stressful conditions where speed and accuracy are necessary for mission critical databases. My attention to detail and the ability to maximize system resources can be beneficial in the following areas.
• Oracle Installation, configuration, patching and upgrades
• Backup and recovery using RMAN
• Monitoring and Performance tuning (AWR, ASH, AADM, ADVISORS)
• Database Upgrade, patching and Migration
• Job Automation in ORACLE
• Data and database integrity and SECURITY
• Implemented different HA/DR technologies such Oracle RAC, Data Guard
• Experience with data migration and ETL activities
Oracle Database Administrator
Employer: IBR June2017 - Present
Client: US CENSUS Bureau
§ Automated system health reporting using PL/SQL and shell scripts scheduled through Crontab.
§ Maintained sound backup and recovery policies and procedures using RMAN.
§ Monitored backup procedures on a daily basis using scripts scheduled through Crontab.
§ Performed Hot Backups and Cold Backups.
§ Created a recovery catalog to centralize the administration of backups for multiple databases.
§ Performed incremental backups, and complete and incomplete recovery using the Recovery Manager (RMAN) utility.
§ Created and maintained Data Guard physical/logical standby databases.
§ Used Data Pump for export and import.
§ Wrote scripts for database backuAutomated system health reporting using PL/SQL and shell scripts scheduled through Crontab.
§ Maintained sound backup and recovery policies and procedures using RMAN.
§ Monitored backup procedures on a daily basis using scripts scheduled through Crontab.
§ Performed Hot Backups and Cold Backups.
§ Created a recovery catalog to centralize the administration of backups for multiple databases.
§ Performed incremental backups, and complete and incomplete recovery using the Recovery Manager (RMAN) utility.
§ Created and maintained Data Guard physical/logical standby databases.
§ Used Data Pump for export and import.
§ Wrote scripts for database backup and maintenance of archive logs.
§ Streamlined backup procedures and implemented RMAN for backup and disaster recovery.
§ Installed, configured, maintained and supported Oracle 11g and 12c (Multitenant and NON-CDB) Databases.
§ Migrated Oracle databases 11g (11.2.0.4) from Linux servers to an EXADATA database machine using Data Guard switchover and export/ import.
§ Applied Clusterware (GI), Database (RDBMS) Patches i.e. PSU patches and one-off patches (for bug resolution) using opatch.
§ Upgraded RAC and standalone databases from 10g (10.2.0.4 and 10.2.0.5) to 11g (11.2.0.2, 11.2.0.3 and 11.2.0.4) and 11g to 12c to utilize new features.
§ Performed Golden Gate upgrade from 10.4 to 11.2.
§ Responsible for backup and recovery of databases using RMAN; Database Flashback using GRP (Guaranteed Restore Point); and, export and import (Data Pump and normal) for restoring specific objects at the database level.
§ Built Oracle standby databases, both active Data Guard for real-time replication and normal Data Guard for disaster recovery or cloning purposes.
§ Converted physical standby database to a snapshot standby database opened in read/write mode for testing purposes without interrupting the primary production database.
§ Scheduled meetings with application team to review database migration and to gather legacy information such as application type, database options, current configuration, capacity and Oracle outstanding tasks.
§ Developed, revised and implemented policies, standards, procedures and guidelines necessary to effectively administer database environments.
§ Implemented and managed optimum physical database design of tablespaces, datafiles, extents, redo logs, archive logs, and assessed database capacity by monitoring online storage, growth and file system space, in adherence with Optimal Flexible Architecture.
§ Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.
§ Performed RMAN recovery testing for RAC and stand-alone databases.
§ Installed Oracle GoldenGate and configured Manager, Replicate and Extract processes for unidirectional, and bidirectional replication.
§ Performed database refreshes using export/import and Data Pump.
§ Monitored database performance using RDA, ADDM and AWR reports.
§ Used PowerDesigner, and ER/Studio for data modeling; to estimate database size; and, conduct database design reviews.
§ Developed and maintained PL/SQL stored procedures, packages, functions and database triggers.
§ Developed and maintained shell/Perl scripts for setting up batch jobs and managing release scripts.
§ Implemented SQL outline to get better execution plans for offending queries.
§ Coordinated with development team to gather table statistics by setting up scripts to analyze if statistics on tables are stale.
§ Performed database tuning & storage management.
§ Provided capacity planning input to the company’s Growth Plan.
§ Carried out general database administration including tablespace management; undo management; resource management; database security through the management of users, privileges and roles; and, tuning slow-running SQL queries.
§ Diagnosed Oracle bugs and worked with Oracle support to resolve them.
§ Administered RAC using the SRVCTL utility to add nodes and instances; administer storage components; manage parameters; and configure high availability features.
§ Worked extensively on performance tuning of queries by maintaining aggregates, implementing compression, partitioning, indexing, using hints, stored outlines and statistics.
§ Supported development teams by providing SQL statement tuning; optimizing ETL procedures; and, removing load and query performance bottlenecks by using tools such as EXPLAIN PLAN, STATSPACK, and TKPROF.
§ Installed Oracle software using the silent feature and created Oracle databases.
§ Supported & maintained the Production/Development databases on various servers.
§ Worked extensively on setting up auditing in many databases.
§ Managed database structure, storage allocation, table/index segments, rollback segments, undo segments, and constraints.
§ Installed ASM environment and migrated databases from NON-ASM to ASM.
§ Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 12c Grid Control.
§ p and maintenance of archive logs.
§ Streamlined backup procedures and implemented RMAN for backup and disaster recovery.
§ Installed, configured, maintained and supported Oracle 11g and 12c (Multitenant and NON-CDB) Databases.
§ Migrated Oracle databases 11g (11.2.0.4) from Linux servers to an EXADATA database machine using Data Guard switchover and export/ import.
§ Applied Clusterware (GI), Database (RDBMS) Patches i.e. PSU patches and one-off patches (for bug resolution) using opatch.
§ Upgraded RAC and standalone databases from 10g (10.2.0.4 and 10.2.0.5) to 11g (11.2.0.2, 11.2.0.3 and 11.2.0.4) and 11g to 12c to utilize new features.
§ Performed Golden Gate upgrade from 10.4 to 11.2.
§ Responsible for backup and recovery of databases using RMAN; Database Flashback using GRP (Guaranteed Restore Point); and, export and import (Data Pump and normal) for restoring specific objects at the database level.
§ Built Oracle standby databases, both active Data Guard for real-time replication and normal Data Guard for disaster recovery or cloning purposes.
§ Converted physical standby database to a snapshot standby database opened in read/write mode for testing purposes without interrupting the primary production database.
§ Scheduled meetings with application team to review database migration and to gather legacy information such as application type, database options, current configuration, capacity and Oracle outstanding tasks.
§ Developed, revised and implemented policies, standards, procedures and guidelines necessary to effectively administer database environments.
§ Implemented and managed optimum physical database design of tablespaces, datafiles, extents, redo logs, archive logs, and assessed database capacity by monitoring online storage, growth and file system space, in adherence with Optimal Flexible Architecture.
§ Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical I/O and Memory Usage.
§ Performed RMAN recovery testing for RAC and stand-alone databases.
§ Installed Oracle GoldenGate and configured Manager, Replicate and Extract processes for unidirectional, and bidirectional replication.
§ Performed database refreshes using export/import and Data Pump.
§ Monitored database performance using RDA, ADDM and AWR reports.
§ Used PowerDesigner, and ER/Studio for data modeling; to estimate database size; and, conduct database design reviews.
§ Developed and maintained PL/SQL stored procedures, packages, functions and database triggers.
§ Developed and maintained shell/Perl scripts for setting up batch jobs and managing release scripts.
§ Implemented SQL outline to get better execution plans for offending queries.
§ Coordinated with development team to gather table statistics by setting up scripts to analyze if statistics on tables are stale.
§ Performed database tuning & storage management.
§ Provided capacity planning input to the company’s Growth Plan.
§ Carried out general database administration including tablespace management; undo management; resource management; database security through the management of users, privileges and roles; and, tuning slow-running SQL queries.
§ Diagnosed Oracle bugs and worked with Oracle support to resolve them.
§ Administered RAC using the SRVCTL utility to add nodes and instances; administer storage components; manage parameters; and configure high availability features.
§ Worked extensively on performance tuning of queries by maintaining aggregates, implementing compression, partitioning, indexing, using hints, stored outlines and statistics.
§ Supported development teams by providing SQL statement tuning; optimizing ETL procedures; and, removing load and query performance bottlenecks by using tools such as EXPLAIN PLAN, STATSPACK, and TKPROF.
§ Installed Oracle software using the silent feature and created Oracle databases.
§ Supported & maintained the Production/Development databases on various servers.
§ Worked extensively on setting up auditing in many databases.
§ Managed database structure, storage allocation, table/index segments, rollback segments, undo segments, and constraints.
§ Installed ASM environment and migrated databases from NON-ASM to ASM.
§ Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 12c Grid Control.
Oracle Database Administrator
Associated Bank August 2014 - march 2017
Green Bay, WI
Responsibilities
• Database administrator (DBA) designing, coding, migration and testing.
• Oracle Database upgrade from 11g to 12c and patching
• Tune database to ensure acceptable level of performance and availability.
• Backup and Recovery of database using RMAN, Database Migration, Creation of databases, table spaces & tables
• Troubleshooting of issues in various Oracle Products
• Managing Pluggable database in 12c and cloning
• Analysis of objects with tablespace, checking invalid objects of the database, Checking the size of tables and check whether it need partition or not, managing users account, checking alert log
• Checking database size and comparing it to previous size to find the exact growth of the database
• Monitoring backup, troubleshooting and performance analysis
• Collect, review and analyze system data for capacity and planning
• Work with users to gather information about objectives, functions of service and database features to ensure that they meet end-user needs while maintaining compliance with security, Implement plans for data security, retention, recovery, monitoring and response
• Write and maintain comprehensive documentation, including database dependencies, database inventory, and daily database operations documents
• Managing table spaces, data files, redo logs, tables and its segments.
• Designed and engineered the upgrade, re-architecture and migration of databases/applications
• Modified and upgraded SQL Loader scripts for the system, and modified existing code, tables, views, and SQL Loader scripts to meet changed system requirements
• Fine tuning of SQL queries using various performance tuning methodologies for maximum efficiency and performance.
• Oracle RAC (Real Application Cluster) setup and tuning
• Backups and recovery using shell scripting and RMAN
• OEM Oracle Enterprise Manager Installation and configuration
• Oracle database installation, partitioning, patching, and cloning
• Install, configure GOLDENGATE replication and add table to replication
• Involved in designing and implementing Oracle backup and recovery methods and disaster recovery methods using RMAN.
• Successfully implemented physical standby database using Oracle Data Guard feature for High availability configuration.
• Performed Database Refresh in RAC Environment using transportable
• tablespaces, EXPDP, IMPDP on Solaris, Red Hat Linux and UNIX Platforms.
• Successfully Implemented key RMAN 11g features such as block change tracking, use of flashback recovery area and taking incrementally updated backup to meet backup and recovery goals.
• Experience on Performance tuning tools like AWR, ADDM, ASH, Stats packs, TKPROF, Explain Plan.
• Generated DDL statements for creation of new database objects like tables, views, sequences, synonyms, indexes and created triggers, packages, procedures, functions and granted privileges.
• Implemented and monitored all databases using Oracle Enterprise Manager (OEM) for maximum uptime and optimal performance.
• Storage and space management including table spaces and data files.
• Used Oracle 10g Enterprise Manager db console tools such as ADDM, AWR for diagnosing & monitoring events, jobs & performance related problems.
• Certified and applied CPU patches on Solaris, UNIX and Red Hat Linux platforms in RAC and Non-RAC Environment.
• Sound knowledge on refreshes using expdp/impdp.
• Ability to troubleshoot the oracle alerts.
• Migrated database objects from development to production instances.
• Performed Databases Refresh and Schema level refresh as per the User request from Production
• UAT and DEV Environments for testing purposes.
• 24X7 production support and on call rotation.
Oracle DBA
sedgwick CMS Jan 2011 - August 2014
memphis, TN
-
Responsibilities:
• Running scripts and monitoring the load process to avoid any issues in ETL jobs running for a long duration.
• Monitored Database growth and provide Database capacity planning for applications expansion or necessary re-organization of tables and indexes as and when required.
• Performing Database Administration activities like space management, user and roles administration, schema management, checking alert log of all the databases. Installed Oracle 11g on multiple platforms.
• Performed up-gradation of 10g to 11g.
• Performed traditional Cold backup in appropriate environments via OS commands as well as logical exports.
• Automated routine DBA tasks like backup's and stats by using Grid control job's.
• Provided Assistance to application team at the time of SQL tuning in applications. Administration of RAC and DATAGUARD databases in Oracle 11g.
• Oracle DB System Development Life Cycle (SDLC) planning and Oracle DB 3-Tier architecture.
• Setup RMAN solutions for all Oracle Databases -- created rman repository, provided best practices, optimizations and data guard and cloning techniques -- restore and recovery.
• Implemented and maintained Oracle 11g Data Guard/standby databases for switch-over and fail-over purposes. Created, relocated and removed Services as needed in an Oracle RAC configuration
• Adding and removing nodes to existing Oracle database RAC configurations
• Worked closely with diverse application development groups and served as single point of contact for testing, tuning and implementing projects / solutions in production environment
• Cloned and maintained multiple Oracle Database environments for Development, Testing & UAT.
• Carried out yearly DR Testing of Oracle ERP Systems / Critical Oracle Databases.
• Applied various database / applications PSU / CPU patches as required. Also applied monthly vertex updates.
• Performed activities like monitoring the database and provide maximum uptime.
• Created and granted users the privileges and roles and resizing the datafiles to manage database growth.
• Defined and implemented database backup and security strategies, tested the backups periodically for consistency and reliability
• Identified long-running database queries, refining queries for better performance, and working with end- users to implement changes
• Created primary database objects (tables, views, indexes) once application developers have designed an application
• Monitor database systems and provide technical support for database system issues and application performance enhancement/improvement using both Oracle 10g Grid Control & SQL*Plus, as well as UNIX shell scripts.
• Created the database objects such as Tables, Indexes, Views, Database Triggers, Procedures, Functions, etc.
SKILLS
Technical Skills Operating systems: LINUX, SOLARIS, MS-DOS, NT, Windows [ ] 2000, Windows Advanced Servers Databases: Oracle 12c, 11gR2, 10gR2 RAC,Oracle Database Tools: SQL*Loader, TKPROF, Toad, OEM, Grid Control Tools & Utilities: Export/Import, RMAN, Data Pump, Winscp3, ERWIN, DBCA, DBUA, ADDM, Remedy.
Certification
ORACLE 11G certified
Education
Prince George's Community College- Largo, MD
• Earned college credits in Information Technol