Management Oracle
Resume:
EFEMENA JONATHAN
****H East summit point, Norcross GA 30092.
***********@*******.***
CAREER OBJECTIVE
Seeking a position as an ORACLE DBA to leverage my 6+ Oracle database experience on Oracle (11gR2, 10gR2) 11gRAC, 10gRAC, 12C installation, upgrade, designing, backup, recovery, migration and performance tuning and data guard with the utilization of my hands-on technical training and work experience to work interdependently with existing staff in the Information Technology industry striving to achieve organizational goals and objectives.
SKILLS:
SQL, PL/SQL, 10g, 11g, 12c, RAC, VMWare, Virtual Box, Data Guard, ASM, Performance Tuning, SQL Tuning, Instance Tuning, Dynamic Views, Dictionary Tables, Export Import, Data Pump, User Management, TNS networking, ASH, AWR, ADDM, SPA, SQL Tuning Sets, Linux, Solaris, Windows, OEM, DB Console, Grid Control, Cloud control, Patches, Upgrades, Migration Manager (OEM), ADDM for performance tuning
• 6+ years of experience as Oracle Database Administrator.
• Experience in administering and managing Oracle 10g 11g & 12c on Linux, Solaris and Unix Platform.
•Installed and configured Linux/Unix operating system on Vmware and Virtual box.
Software Installation, Upgrade, Patch implementation on Oracle versions 10g 11g & 12c and on all operating platforms including Linux, Solaris.
• Setting up Data Guard for replication. Failing over, switchover, and configuring broker etc.
• Experience in Unix Shell Scripting and SQL scripting.
• Good understanding of security and backup strategies to ensure database integrity, and excellent knowledge in database Backup & Recovery, and Database Cloning/Refresh.
• Experience in Capacity Planning and Space Management.
• Knowledge and experience of database administration tools like Oracle Enterprise Manager, data loading using SQL*Loader, mining using Log Miner & logical backup using Datapump.
• Experience with Oracle database version upgrade from 10g to 11gR2, conversion of non ASM database to ASM database and cross platform migration (Solaris to Linux).
• Migrating databases from 11g to 12c PDB
• Setting up OMS server and adding targets.
• Expertise in applying Patch Sets and Interim patches.
• Review overall physical database structures for data integrity, performance quality, recoverability, maintenance, and space requirements.
• Experience in Performance Tuning of SQL statements and Database using tools like Explain Plan, ADDM, SQL Trace, AWR, System state dumps, STRACE, RDA, Errorstack etc.
• Worked in 24x7 production support environment and provided on-call and day-to-day support
• Experience in working in ITIL process environment, also completed certification in ITIL foundation.
• Expertise in working on Oracle Database Appliance (ODA) and Exadata.
• Experience of setting up a two 2 node RAC clusters on VM. Implemented Dataguard between them and setup OEM for monitoring.
PROFESSIONAL EXPERIENCE
Concentrix cop (APPLE) Jan 2014 - 2016
Norcross GA - 678-***-****
Oracle DBA Application Support
Projects:
• Installed, configured, and maintained Oracle 10g and 11g R2 on Linux and also Upgraded from Oracle 10g to 11g.
• Implemented code changes like DML and DDL by coordinating with Developers and Change Management team.
• Worked extensively with stored procedures, triggers, functions, packages, UNIX Shell scripting, Partitioning, and Indexes and excellent experience in installations, configurations, administration, and tuning of Oracle 10g, 11g, 12c and ASM for high available databases.
• Worked on administering 10 Production databases and more than 40 non production databases of size ranging from 10GB to 5 TB on Solaris/AIX/LINUX servers.
• Installed 11g/12c software and created databases in RAC and non RAC environments for new projects by interacting with multiple application teams.
• Participates on project teams as database administration support to ensure that databases are appropriately modified to support new business applications and requirements
• Install, patch and upgrading Oracle 10/11g & 12c to support internal production and test environments.
• Installation of 12c OEM and customize it to our needs.
• Installing Oracle Golden gate on RHEL and setup table level replication as well as DDL replication too.
• Done migration of non ASM database to ASM database.
• Implemented, and configured 12C cloud control, agents and registered 11g/12c databases on Linux servers.
• Worked on 11g Grid control and 12C Cloud control and intensively used for Diagnostic & tuning activities.
• Implemented Real Application Testing (RAT), RMAN new compression algorithm and tested active standby data guard.
• Responsible for maintaining ORACLE 11gR2 using SRVCTL, OEM, maintaining Oracle Clusterware using CRSCTL
• Responsible for tunning of long running query's by creating B-Tree and BITMAP indexes.
• Resolving issues related to Network Congestion, Memory (SGA and PGA), CPU & IO and other oracle related issues.
• Effectively made use of PL/SQL features such as Bulk Collections/Exceptions/Inserts, Bulk Binding, Ref-Cursors, Multi Table inserts, SQL Types in Bulk Operations for better performance and readability, Query optimization, PL/SQL Performance Tuning using Oracle Cost based Optimization techniques, Explain Plan, Trace, Hints and Tkprof, SQL, PL/SQL and UNIX shell scripting.
• Disaster recovery of Exadata Dataguard Physical Standby. Failover/Switchover/Loss of service/Rebuild/Corruption/Loss of datafile testing.
• Creating, maintaining, and tuning standby databases, disaster recovery using data guard.
• Implemented transparent data encryption (TDE). Used TDE with encrypted columns and data pump.
• Applied quarterly released CPU patches to update and security fixes to Oracle database 11g.
• Backup and recovery of the Oracle databases using RMAN and by logical backups using data pump.
• Provided sr. level technical expertise in system administration, application administration and automation using UNIX shell scripting.
• Expertise in performance-tuning, SQL tuning services with EXPLAINS PLAN, TKPROF, STATSPACK, SQL TRACE, AWR, and ADDM to collect and maintain performance statistics and improves the database performance.
• Experienced in RAC Administration (11gR2) with ASM storage and backup and recovery using RMAN.
• Implemented DATA GUARD (Standby) for disaster recovery (DR) purpose and also fail-over and switch-over processes.
• Verifying, troubleshooting and fixing data corruptions
• Clone databases for development and testing from production.
• Setting up Golden Gate replication
• Using RAT(Real Application Testing) to Capture production work load and replay in a test system and SPA(SQL performance Analyzer) - to identify performance divergence between workloads on source and target platforms.
• Worked as a member of production DBA team in perfect coordination with seniors and team members.
Environment: Oracle 10g/11g, Sun Solaris, HP-Unix, UNIX, Linux 4.0.,VMware RMAN, DBCA, DataGuard, EXPLAIN PLAN, Cloning, OEM, STATSPACK, and TKPROF, Toad, PL/SQL.
WIPRO TECHNOLOGIES (2012 -2014)
Dallas Texas
Oracle Dba
Installing Oracle Software and creating database (Single Instance and RAC).Administering RAC databases. Managing table spaces, data files, tables, indexes and constraints. Creating user profiles, maintaining roles, permissions etc.
• Handling backup and recovery using RMAN and User Managed Backups. Export & Import. Checking database health by running & analyzing Stats pack Report and AWR. Database Upgrading.
• Managing Archive Log Files. Managing & solving connectivity issues. Performance Tuning. Database Cloning with RMAN and User Managed Hot backup. Applying PSU Patches. Configured Alerts to send Emails for database issues, failed scheduled jobs and to monitor disk space
Configuration & Administration of Red Hat Linux 3.X/ 4.X at various client servers and service provider using vmware
• Configured ASM with Normal and External Redundancy. Used Oracle data pump/ export import for complete logical backup of database and also for individual schemas. Provide advice, support, and guidance to vendors, programmers, developers, application engineers, application support personnel and other DBAs with database SQL, object tuning and optimization efforts
• Worked on Auditing and security with Oracle databases. Configured standby databases as physical standby databases. Configured ODAs. Pro-actively monitored database using Performance Monitor tool Creation and Management of database schema/objects. Creating Table spaces. Creating Tables, Indexes, Views, Sequences, Procedures etc. Creating Users, Roles and Profiles. Managing User accounts. Implementing Security features as specified by the Client's Security policy. Performed Logical/Physical Backups using Export/Import utilities, RMAN and OS commands.
• Database performance optimization by performing various health checkup and tuning techniques like increasing buffer hits, optimizing CPU Utilization. Tested various New Features in Oracle 11g including automatic memory management. Performing regular database backups. Monitoring space, wait events, locks and long operations running on the database .Monitoring the alert log for the database performance and resolving the performance issues. Partitioning big tables and Indexes for optimal performance. Archiving the data from the tables and backing up the archived data for the Business requirement.
• Implemented scripts to monitor and get information on free space, CPU Utilization and alert log errors. Reorganizing the database objects by archiving the data and moving the tables within the table space, rebuilding the indexes. Managing Users, Monitoring sessions related to users specific, Sessions related to application specific for tuning the performance of the database. Managing batch processes running against the database, Cron jobs placed within the oracle server. Migrating the databases from one server to the other using RMAN utility.
• Analyzing health check reports and implementing a structural change that needs to be made in production databases. Design and Implement data retention/purge strategy. Change Management and Problem Management activities. Monitoring Database Space/Disk Management. Space Forecasting and adding space according to it during Freeze period.SAN estimation tasks and ask Application team to ask SAN accordingly Setting up and monitoring of maintenance Jobs. Activities involved in creation of backup jobs, maintenance plans
• Automation of production monitoring tasks and maintenance jobs. Performance tuning and optimization of databases and SQL queries that run on databases. Analyzing health check reports and implementing structural changes that needs to be made in production databases
• Design and Implement data retention/purge strategy. Change Management and Problem Management activities. Monitoring Database Space/Disk Management. Space Forecasting and adding space according to it during Freeze period.
ZENITH BANK PLC 2008 – 2011 (Lagos Nigeria)
Database and Operating System Administrator
The project involved setting up the pre-production environments and supporting the production environments and provide rotating 24x7 support and administration. Install different applications and work with the application team to maintain the performance of both the applications and databases. Solve the violations in the databases to maintain database security.
Responsibilities:
• Involved in the design, review, implementation, testing, and release of databases, design specifications, and application software.
• Installed, up-graded Oracle (9i, 10g, 11g) software in different environments, creating and maintaining Oracle development and test databases.
• Clone the databases using RMAN
• Created users, granted roles and privilege management. Maintained user accounts and privileges to maintain application security.
• Installed the DataMart, Siebel, OBIEE applications in the databases based on the requirements
• Work with the application team and the business team in determining the requirements and solving all kinds of database and data issues
• Administering GoldenGate processes extracts pumps and replicates.
• Configured the Manager process and the checkpoint tables in the source and target databases for active sync of logical standby through GoldenGate.
• Work closely with the vendor to get the required fixes and patches to the application
• Work closely with the Business Objects and DDE team to get the required reports generated
• Manage the databases using OEM
• Developed the shell scripts to load the data coming from the vendor into the databases
• Involved in online and offline backups, and recoveries of various oracle databases using export and import utility
• Planned and implemented DR & high availability solutions using Oracle 11g RAC & 10g RAC, Standby Database (Oracle Active Data Guard).
• Provide guidance to the Production DBA on how to work on the databases
• Used Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) for performance tuning.
• Ensured security of the database by creating profiles for each user and monitored the user sessions.
• Automated the running of jobs through Control M
• Interacted with development team in fine tuning the SQL and PL/SQL code.
• Wrote PL/SQL Scripts for running application specific monitors through Sitescope
• Worked on Oracle External Tables
• Extensively worked with performance tuning and memory (SGA and PGA) tuning, optimizing and troubleshooting of databases.
• Work on and manage the DR tests both from application and database standpoint
• Analyzed tables and indexes of Oracle database periodically for better performance.
• Migrated the code as well as the data from one environment to another depending on the Application team's request
• Worked on documenting various database activities like up upgrade, migrations, change control activities, partitioning of tables, performance tuning activities and provided on-site production support. Configured Red Hat Linux 3.X/ 4.X at various client servers and service provider using vmware
ENVIRONMENT: Oracle 8i/9i/10g/11g, SQL, PL/SQL, VMWare, Virtual Box, ERwin, TOAD, OEM, SQL Developer, SQL
Loader, RMAN, Statspack, Data Guard, Golden Gate, Shell Scripts, RAC, Grid Control, AWR, ADDM, Siebel, OBIEE, Datamart,, HTML, DHTML and XML
EDUCATION
2016 DBA Workshops: ORACLE CERTIFIED ASSOCIATE (OCA)
2015 – 2016 Georgia State University (Masters International Business)
2007 – 2014 Delta state University (Bachelor of Science) Accounting
Member of world Affairs Council of Atlanta.
REFERENCE
Sylvester Ekpere Oracle DBA
MBlox Corporation
More References on request.
Contact this candidate