Manager Oracle

Tekang Check

Oracle Database Administrator

Lanham, MD 20706

***********@*****.*** - 202-***-****

Willing to relocate: Anywhere

Authorized to work in the US for any employer

WORK EXPERIENCE

Oracle Database Administrator

Pearson - Iowa City, IA - January 2016 to Present

Responsibilities:

• Installed, configured, and maintained Oracle 10g and 11gR2 on Linux and also Upgraded from Oracle 10g to 11g.

• Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.

• Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.

• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using "runInstaller" and perl based utility "opatch".

• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF

• EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O.

• Experienced in configuration of ASM for RAC and NON- RAC environments.

• Configured Repository and clients for GRID Control and also implemented DB Control for some databases.

• Utilized Oracle streams to Capture, Propagate and apply the transfer of data, transactions and events within managed Databases.

• Scheduling and maintaining level 0 and level 1 RMAN (Recovery Manager) backups.

• Test backups periodically to ensure minimal recoverability time to meet business objectives.

• Used cross platform transportable table space (TTS) to transport table spaces across platforms.

• Data Refresh in Test and Integration Databases using Transportable Table spaces.

• Performed conversion Non RAC single instance to Real Application Cluster (RAC) database instances.

• Using Oracle Data Pump utility making faster exports/imports on large databases and saving lot of time.

• Performed patching on Oracle Database Server 10g and 11g using O patch utility.

• Implemented Data Guard, Physical Standby database in 10g and 11g RAC environment for the Production databases for Active and Passive cluster.

• Excellent troubleshooting skills to identify root causes and resolve problems related to application and systems functionality.

• Used AWR, ADDM and statspack Reports for troubleshooting performance issues and Capacity Planning. Extensively used Explain Plan, Tkprof and SQL Trace.

• Used Grid Control extensively and set up Rules for alert notification and schedule RMAN backups with Failure notification

• Wrote shell scripts for purging trace files, alert log and network log files in Linux boxes which is used as standard script across all the databases

• Expertise in PL/SQL, SQL and UNIX Shell Scripting (Implemented UNIX Scripts using CRONJOB for Day- to-Day activities and Windows Task Scheduler)

• Installed the Oracle software using silent feature and also created databases

• Worked on designing, installing & maintaining OCR, 11gRAC and Dataguard components of Oracle.

• Writing SHELL SCRIPTS for the system and database for effective functionality and report generation

• Supported & maintained the Production/Development databases on various servers

• Extensively worked on setting up auditing in many databases we supported

• Managing 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.

• Database reorganizations and refresh schema-using Export/Import. Creating the database, table spaces, tables, indexes, setting privileges and user logins

• Used hints for SQL tuning and optimization

• Performed Explain Plan analysis for Query Optimization and SQL tuning Environment: Windows, RHEL, Oracle 11g, Oracle RAC (11g), Data Guard, Oracle Grid Control, RMAN, ASM, STATSPACK, SQL Developer, TOAD, SQL*Plus.

Oracle Production Support Database Administrator

Express Scripts Inc - St. Louis, MO - March 2014 to December 2015

• Installation, configuration and maintenance of Oracle 10g/11g Real Application Clusters (RAC).

• Implement Grid based monitoring solution for large Databases and Installation of Cluster ware, configuring public, private and VIP.

• Extensively worked in various areas of Data guard i.e. Installation, Recovery, RTA (Real Time Apply), Patching, Tuning, Switchover, Switchback and Failover.

• Implemented and configured 11g grid control on RHEL.

• Performed Logical backup of critical application databases using EXPDP/IMPDP with a scheduled jobs (Cron Job).

• Responsible for creating RMAN catalog Database and Registering the Databases in Catalog Database and Cloned production RAC instances to development and QA systems using RMAN duplication.

• Experience in using 11g features such as Data Pump, Flash Back Recovery, ASM, AWR, and ADDM.

• Involved in Defragmenting data blocks of table spaces for optimized performance. Also partitioned large tables to increase performance. Evaluated Oracle 11gR2 Golden Gate for future purposes that is for reducing the complexity involved in Oracle Streams.

• Configured Oracle Streams on Oracle 11g, 10g databases for data replication and monitored them using Grid Control.

• Performance tuning of Queries by maintaining Aggregates, Compression, partition, Indexing

• Performance tuning and diagnosing DBMS and individual Production databases, organized various migration review meetings with the application team to discuss the migration strategy based on their requirements.

• Performed policies on data confidentiality, integrity, availability, and auditability, based on Access controls for Access to Data at the database level.

• Performed SQL and PL/SQL tuning oracle contention and monitored production database using Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM) and Automatic Session History

(ASH).

• Efficiently performed installation, setup and creation of four node cluster RAC with Oracle 11.2.0.3 database using GRID infrastructure with ASM file systems on RHEL 5.5.

• Maintenance of Oracle 11gR2 Real Application Cluster (RAC) Database for High Availability, Scalability and Performance by determining the best Cluster architecture, choosing the best hardware configuration for Oracle RAC.

• Successful in installation/maintenance of Physical Standby database using Oracle Data Guard for Oracle 11.2.0.3 and Oracle 10.2.0.5 RAC databases.

• Implemented switchovers on primary and standby databases as a part of planned maintenance activities.

• Implementing Datapump, 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 9i and 10g/11g environments.

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

• Used TOAD for database management.

• Made optimal use of Oracle Support in resolving the SRs.

• 24 X 7 Production & Development database support and administration. Environment: Oracle 11.1.0.7, 10.2.0.5, IBM AIX V6.1, RHEL 5.2, RAC, ASM, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM, TOAD 10.0.

EDUCATION

Bachelor of Science

Howard University

SKILLS

DATABASE (3 years), DATABASES (3 years), OEM (3 years), ORACLE (3 years), PERFORMANCE TUNING (3 years)

ADDITIONAL INFORMATION

Professional Skills

• Experienced Oracle DBA with 3 years of experience in Oracle Database Administration in large-scale production environments across multiple platforms.

• Ability to provide expert-level technical support in all aspects of database administration including installation, configuration, upgrades, patching, migration, capacity planning, performance tuning and backup & recovery Hands-on experience with Oracle Real Application Clusters (RAC) and Data Guard.

• Ability to work both as an individual contributor and as a member of a team.

• Performance tuning of the database - SQL Tuning, Used Tuning utilities like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O, Sizing of tables and indexes.

• Experience in configuring Data Guard. Implemented Physical Standby in latest project.

• Expertise in implementing data refreshes (at database, schema & table level) using RMAN utility and Datapump, conventional Export/Import of Oracle 11g, 10g.

• Implemented Hot/Cold physical backups (Incremental and full), cloning, duplicating of databases using RMAN with VERITAS Net Backup & IBM TSM.

• Experienced in using 10g features like 10g RMAN, Data pump Flash-Back Recovery and ASM.

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

• Expertise in maintaining Database Security using auditing.

• Experience in Data Migrations.

• Experience in doing upgrades including maintenance & monitoring implementation.

• Extensive knowledge in UNIX platforms includes HP, SOLARIS, AIX, and LINUX.

• Knowledge in configuring ASM (Automatic Storage Management)

• UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.

• Worked with EXP/IMP, EXPDP/IMPDP to refresh the schemas and to

• Database Performance Tuning Diagnosing using AWR (Automated Workload Repository) / Stats pack and ASH (Active Session History) reports, ADDM (Automatic Database Diagnostic Monitor) analysis.

• Proactive database monitoring via automatic Email and Text alerts of Alert.log, Listerner.log and Space errors to DBA cell phone

• Experience in Upgrading databases, applying patches.

• Managing Security Management, Schema Management, Instance Management, Storage/Space Management.

• Checking and resolving Database corruptions using DBVERIFY utility. Configured Manager, Replicate and Extract processes and implemented unidirectional, bidirectional replication using Oracle 11g Golden Gate on RHEL 5 platform.

• Experience in Backup & Recovery techniques of databases running in ARCHIVELOG MODE using RMAN. Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 11gR2 Grid and 10g on ASM and OCSF2 file systems.

• Highly experienced in Oracle 11g, 10g Automatic Storage Management (ASM) required to fulfill the storage needs.

• Installation and configuration of oracle Golden Gate.

• Experience in using Golden Gate to support data replication in the Oracle database environment.

• Experience in applying PSU patch on standalone as well as RAC databases.

• Experience in Golden Gate upgrade from 10.4 to 11.2.

• Installed, configured and maintained Physical, Logical, Active standby databases supported by Data guard on Oracle 11g, 10g RAC servers for the purpose of disaster recovery procedures.

• Configured Manager, Replicate and Extract processes and implemented unidirectional, bidirectional replication using Oracle 11g Golden Gate on RHEL 5 platform.

• UNIX shell scripts for hot backups, SQL*Loader, export and import of database.

• Proficient with Database Cloning, Migration, and Patching of Oracle Databases.

• Installed Oracle 11g with ASM and OCFS2 File systems.

• Extensive Experience with RMAN Backups, Hot Backups and Logical Backups.

• Extensively implemented Datapump, conventional Export/Import (Oracle 11g, 10g) for migration and logical backup of database.

• Strong skills in applying security patches (Patch set, Critical Patch Updates (CPU) / Patch Set Updates (PSU), One-off Patch) using "runInstaller" and perl based utility "opatch".

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

• UNIX Systems Administration - Database and application integration efforts. Heavy UNIX shell scripting, CRON jobs.

Technical Skills

Tuning Tools TKPROF, EXPLAIN PLAN, STATSPACK, AWR, and ADDM. Tools and Utilities RMAN, OEM, SQL*Loader, EXP, IMP, Data pump,, TOAD, Oracle SQL Developer RDBMS Oracle 9i, 10g, 11g

Operating Systems HP-UX 10.x, 11.x, 12c, Sun RHEL 2.1, 3.x, 4.x, 5.x.Linux Enterprise

Contact this candidate