Oracle Management
Resume:
Olajuwon Quadri
**** ********* **, *** **********, MD 20784
Email: **********@*****.*** Contact: +240*******
OBJECTIVE
Bring to bear my wealth of experience, professionalism and knowledge as an Oracle Database Administrator while progressively acquiring new and additional skills, contribute actively to your organization in an effective and efficient manner.
PROFILE
I have over 5 years of hands-on experience as an Oracle Database Administrator with duties involving Database administration, Production support, Installation, Configuration, Upgrades and Patches, Migration, Backup and recovery, Performance monitoring and tuning, Database security, RAC, Data guard, Grid Control, Cloning, Replication, Space and Memory management.
Excellent written and verbal communication skill, strong documentation and interpersonal skills. Self-motivated, great work ethics, team player and an exceptional fast learner particularly with innovative techniques.
PROFESSIONAL SUMMARY
Performing day-to-day database administration tasks like Tablespace usage, checking alert log, trace files, monitoring disk usage, Table/index analyze jobs, database backup logs etc.
Hands-on experience in Oracle (11gR2, 10gR2) 11gRAC, 10gRAC, installation, upgrade, designing, backup, recovery, migration and performance tuning.
Experience in query optimization, cloning, patches, migration, troubleshooting, space management, and UNIX Shell Scripting.
Experience in 24/7 high availability environment RAC environments.
Excellent experience in managing large-scale OLTP databases 5+TB size in HA and DR setup.
Resolved the database performance issues successfully by using various tools and utilities i.e. ORADEBUG, AWR, ASH, SQL Plan Management (SPM), SQL Profile, Real Time SQL Monitoring, Database Tracing (events 10046 and 10053), TKPROF etc
Managed 10TB Oracle 10g, 11g and 12c databases in Data warehousing environment.
Independently built new 11g - 12c Databases from scratch on RHEL, OEL and Windows platforms from planning, testing through Release Management to validation
Worked closely with support teams including Developers, SAS, Network, Backup, Storage, and Security.
Experienced in Installation and Configuration of Oracle Primary and Standby (Data Guard) Database and Switchover/Switchback of Database in 10GR2 /11GR2 RAC
Experience in very large scale database environment and mission critical large OLTP and OLAP systems.
Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
Disk Space Management involving managing archives, space allocation to various tablespaces and capacity planning for new applications.
Highly experienced in Cloning of Oracle databases from multi-node to single-node and single node to multimode.
Enabling Load Balancing in a Multi-Tier Architecture.
Created clone databases for development and test environments using RMAN and User managed cloning and Implementation of Flashback Technology.
Implemented data transfer using Transportable Table Spaces (TTS), Data Pumps and Export/Import utilities.
Enforced Security administration, system monitoring by adding and removing users, configuring quotas, auditing, and analyzing security problems.
Exposure to SQL Tuning Advisor, SQL Profiles, SQL Monitoring, SQL Access Advisor, SQL Baselines and SQLTXTRACT tools and utilities
Generate and interpret Automatic Workload Repository (AWR), Active Session History (ASH), and Automatic Database Diagnostic Monitor (ADDM) reports using OEM.
Excellent knowledge in Flashback Recovery, Hot/Cold Backup and Cloning/Refresh of databases using RMAN. Experience in applying patches/ patch sets to the databases.
Configured & Implemented Data Guard, creating both logical and physical standby databases in 10g and 11g RAC environment for production database.
Implemented ASM on RAC and stand-alone databases. Managing disks and disk groups with ASM.
Participates on project teams as database administration support to ensure that databases are appropriately modified to support new business applications and requirements
Migrated DB2, SQL Server databases to Oracle using SQL Developer.
Installed, patched, and upgraded Oracle 10/11g & 12c to support internal production and test environments.
Installation and customization of 12c OEM
Evaluated Oracle 11gR2 Golden Gate for future purposes, reducing the complexity involved in Oracle Streams.
Collaborated with Oracle my support by submitting Oracle SRs to resolve complex incidents.
Rebuilding of Indexes for better performance, User Management, Tablespace management, maintenance of Oracle Database
Excellent experience as an Oracle DBA on various platforms such as Sun Solaris, Red Hat Linux, Windows etc.
Planned, installed, configured, and performed upgrades of Oracle DBMS software on various platforms.
Implementation of high availability solutions with Oracle 10g RAC, Physical Standby database, Data Guard, Materialized views
Recovery of Databases from Media failure, Block Corruptions, User errors.
Good in Performance Tuning: generating and analyzing reports using STATSPACK, TKPROF, EXPLAIN PLAN, SQL TRACE, AWR, ADDM
Proactive monitoring, identifying areas that need to be improved in the application and database using AWR, ADDM and 11g OEM Grid Monitoring Created development, testing, staging, production, RAC and standby databases for OLTP, DSS and Data Warehousing using customized shell scripts and stepwise.
Monitor and maintain system security and Auditing. Experienced in executing SOX related auditing controls.
Scheduling and Troubleshooting Database performance issues using Stats pack, Automated Workload Repository (AWR) and Automatic Database Diagnostics Monitor (ADDM).
Bulk loads and data migrations (using SQL*Loader, data pump import/export).
Expert in RMAN backups including full, incremental and cumulative.
Experience in virtualization; Creating virtual machines using Solaris, Oracle RHEL.
Hands on experience working with Oracle Virtual box and VMware as well
Experience working in waterfall and agile environment
Strong interpersonal skills, enthusiasm for customer service, excellent communication skills, and the ability to work in an organization of varying diversity in a professional manner.
EDUCATIONAL BACKGROUND
• Oracle Certified Associate (OCA) – Oracle Database 11g Administrator
• Project Management Professional Certification (PMP)
• University of Lagos, Nigeria: Bachelors of Science (Hons)
TECHNICAL SKILLS
• RDBMS: Oracle 10g, 11g, 12c
• Operating Systems: Sun Solaris 2.5, 2.6, 8, 9, 10. AIX 5.1, 5.2, 5.3, 6.1 RHEL 2.1, 3.x, 4.x, 5.x. Linux Enterprise Server 9, 10. Windows 95/98/NT/2000.
• Tools: TKPROF, EXPLAIN PLAN, STATSPACK, AWR and ADDM. Toad, Putty, Winscp, Remote Desktop Connection, VNC, Team Viewer, LogMeIn and Cisco VPN Client
• Database Utilities: SQL*PLUS, Oracle Enterprise Manager, Real Application Cluster, ASM, Transportable Tablespaces, SQL*Loader, RMAN, DataPump, Export/Import.
• Language: SQL, PL/SQL, UNIX Shell Scripting
• Proficient in use of Microsoft Office Suite and project management tools (Word, Excel, MS Project, Outlook & Power Point)
PROFESSIONAL EXPERIENCE
MEMPHIS LIGHT, GAS/WATER, Memphis, TN Jun 2014 – Till date
Role: Oracle DBA
Environment: Oracle 11g/11g RAC/10g, VMS, Sun Solaris, Windows Server 2003, Red Hat Linux, TOAD, RMAN, SQL server, OEM.
Responsibilities:
• Installed, configured, and maintained Oracle 10g and 11g R2 on Linux, and upgraded from Oracle 10g to 11g.
• 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 5 Production databases and more than 30 non-production databases of size ranging from 10GB to 7 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 SOLARIS servers.
• Worked on 11g Grid control and 12C Cloud control and intensively used for Diagnostic & tuning activities.
• Responsible for maintaining ORACLE 11gR2 using SRVCTL, OEM, maintaining Oracle Clusterware using CRSCTL.
• Responsible in tuning long running queries by creating 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.
• 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.
• Executed and troubleshot Transportable Tablespace issues successfully while supporting the data archiving mechanism
• Used the backup and recovery tool RMAN for the backup and recovery operations of the production database (size 7Tb)
• Partitioning strategies for very large tables. Implemented Range, List, Hash and various Sub Partitions, Create and schedule refresh for materialized views.
• Expertise in performance-tuning, SQL tuning services with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE, AWR, and ADDM to collect and maintain performance statistics and improves the database performance.
• Database and Schema REFRESH from Production to Test as needed.
• Experienced in RAC Administration (11gR2) with ASM storage and backup and recovery using RMAN.
• Verifying, troubleshooting and fixing data corruptions.
• Monitoring growth of tables and undertaking necessary re-organization of database, capacity planning
• Clone databases for development and testing from production.
• Assisted in the configuration of Oracle Golden Gate for 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.
• 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).
• Converted physical databases to virtual machines using VMware vCenter Converter.
PHILIPS LIFELINE, Framingham, MA February 2012 – May 2014
Role: Oracle DBA(Jr)
Environment: RHEL 5.X; Windows NT 2000/2003; Oracle 10g, 11g
Responsibilities:
• Installed, configured, and maintained Oracle 10g and 11 g R2 on Linux and also Upgraded from Oracle 10g to 11g.
• Involved in checking and managing tablespace growth, monitoring the data file growth and extents too.
• Involved in export and import of database objects in order to copy them from one database to another & for backup the tables.
• Monitoring and Troubleshooting of Database Replication issues.
• Performance Tuning of Oracle Database Objects using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, STATSPACK for optimized results
• Implemented code changes like DML and DDL by coordinating with Developers and Change Management team.
• Monitored database and SQL performance using Stats pack, OEM, EXPLAIN PLAN and tuned problem areas to enhance performance.
• Worked on application and database security (data access, passwords, network, etc.)
• Handled daily production problems/change requests with Oracle.
• Performed daily database administration tasks: User management, Space monitoring, Performance monitoring and tuning, Alert Log monitoring and backup monitoring.
• Performed Physical backup (hot and cold) as well as Logical backup (Export/Import).
• Proactively managed the databases set up alarms for managing any exceptions in day to day management of the databases pre-empted and prevented issues, disasters from happening.
• Monitoring tablespace issues, creating tablespaces and adding datafiles.
• Securing stored data using Transparent Data Encryption (TDE).
• Involved in session management and monitored the critical wait events, blocking sessions in the database.
• Planning Backup/Restoration Strategy, Planning and scheduling Backups, taking Logical Backups (with Export/Import Data pump utilities).
• Creating & Managing Database Structures, Storage Allocations, Table/Index segments, Rollback segments, Constraints, Database Access, Roles and Privileges.
• Performed SQL and PL/SQL tuning, oracle contention and monitored production database using automatic workload repository (AWR), automatic database diagnostic monitor (ADDM) and Active Session History (ASH).
• Create database Objects, Tablespaces, Schemas as needed.
• Schema migrations from Development to Production via Tech Test environments.
• Database and Schema REFRESH from Production to Test as needed.
• Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers and Indexes on the tables.
• Database refreshes using EXPDP, IMPDP, RMAN Duplicate and cloning.
• Experienced in cloning the databases using HOT and COLD backups.
• Used RMAN Duplicate and HOT/COLD backups to migrate the data
• Created a standby database using RMAN Duplicate to reduce the down time for the PROD database during the migration process.
• Backup/Recovery monitoring and reporting using Oracle RMAN
Contact this candidate