Resume

Sign in

Manager Oracle

Location:
Laurel, Maryland, United States
Posted:
January 31, 2018

Contact this candidate

Sylvie Nji

Oracle Database Administrator

240-***-****

ac399o@r.postjobfree.com

I have over 5 years of extensive experience as an Oracle Database Administrator. I have worked on Installing, configuring Oracle 12c, 11g and 10g databases. Very current on Patch Installation, Migration, Upgrades, Replication, Database Security, Memory Management, Backup and Recovery, Cloning. Supported oracle on AIX, Linux, UNIX and Windows environments. Experienced in configuring and managing Data Guard and Golden Gate for Oracle High Availability. I have the ability to work both as an individual contributor and as a member of a team and very enthusiastic when it comes to learning new technologies.

MOST RECENT EXPERIENCE

Genco - Pittsburgh, PA Dec ’15- Dec 17

Oracle Database Administrator(remote)

Performed database tuning using Explain Plan, TKPROF, Statspack, Automatic Workload Repository (AWR), Active Session History (ASH), and Automatic Database Diagnostic Monitor (ADDM) and SQL Trace.

Maintaining and scheduling Cold Backups, Hot Backups, and Export Dumps. Maintaining backups of Archive logs and automating cleaning of archive logs. Deploying RMAN to automate backup and maintaining scripts in recovery catalog.

Upgraded Oracle 10g database version to 11g.

Upgraded Oracle 11g database version to 12c version

Provided database related services to their development & QA environments.

Good experience with Installation and configuration of RAC (Real Application Server) on different nodes with ASM (automatic storage management).

Upgraded various databases from 9i to 10g, 10g to 11g, 11g to 12c and minor version upgrades

Upgraded 10g and 11g Standalone databases to 11g and 12c 2-node RAC

Applied Oracle Patches (CPU/PSUs and One-off patches)

Strong skills in SQL* PLUS, PL/SQL, SQL* Loader, UNIX Shell scripts (KSH and CSH), Import/Export Server Manager. Implemented switchovers on primary and standby databases as a part of planned maintenance activities.

Implemented Dataguard, 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.

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.

Configured, administered, and monitored a Streams environment using various tools like OEM console.

Installation, maintenance and tuning of 11g RAC databases including ASM and CRS.

Set up, configured and maintained data guard (primary and standby databases) to ensure disaster recovery, high availability and data protection.

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

Automated the Data Replication process using Materialized Views for reporting databases.

Used Oracle Enterprise Manager (OEM) 11g Grid Control for monitoring multiple database and notification of database alerts, and configured EM agents on multiple database servers.

Implementing Datapump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.

Dynamics Resources - Chicago, IL Mar ’13 – Oct’15

Oracle Production Support Database Administrator

Successfully installed and configured Oracle 11.1.0.7, Oracle 10.2.0.5 databases on AIX platforms.

Monitored different databases and application servers using Oracle Enterprise Manager (OEM) 10g Grid Control.

Loading data from flat files to database using SQL*Loader, External Tables.

Automated the processes like moving files, managing alert log, efficient backup by developing UNIX scripts.

Involved in the installation, configuration and extended support to Oracle 11g, 10g two Node RAC (Real Application Cluster) with ASM file system on AIX platform.

Involved in converting a single instance database to Oracle 11g, 10g RAC databases.

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

Used TOAD for database management.

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).

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 from 11.1.0.7 to 11.2.0.3.

Made optimal use of Oracle Support in resolving the SRs.

24 X 7 Production & Development database support and administration.

Extensively used AWR, ADDM and explain plan for periodic performance tuning.

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.

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).

Experience in implementation of enterprise databases on enterprise Storage Solutions using Storage area Networks (SAN) and Network attached storage (NAS).

Documented the Standard Processes for peers to follow.

Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.

Implemented Flashback technology of the Oracle 11g, 10g along with Recyclebin for a faster recovery of the databases and database objects.

Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.

Refreshed/cloned databases using RMAN utility.

Performed Database upgrade from Oracle 9i (9.2.0.7) to Oracle 10g (10.2.0.5) and to Oracle 11g (11.1.0.7) RAC database.

Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.

Achieved optimized performance for the databases by rebuilding indexes, on tables and indexes.

Used import/export utilities for cloning/migration of small sized databases and Datapump import/export to move data on the same platform and different platforms.

Applying upgrade patch, maintenance and interim (opatch) patches on all the databases.

Refreshing Dev and Test instances with data from Production on a regular basis.

Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts.

Thorough knowledge in setting up infrastructure for databases in huge datacenters.

Installed Oracle 11g on Linux platform using ASM.

Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.

Worked extensively in Performance Tuning at various levels including instance tuning, Query tuning, Database performance tuning.

Experienced in performing Database related activities using GRID, Multitenant Architecture, OEM, Data Pump, SRVCTL, RMAN, SQL*Loader, datapump, Export, Import, PL/SQL, SQL*Plus, SVRMGR, SQL*Net/Net8, Listner, AGENT Tuning using explain plan, SQL Trace, AWR, ADDM, SGA tuning, Statspack and tuning of initialization parameters.

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 proactive monitoring using Tuning Pack, Diagnostics Pack, and STATSPACK, SQL Trace, EXPLAIN PLAN.

Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).

TECHNICAL SKILLS

Operating Systems

HP-UX 10.x, 11.x. 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 2008, 2010

RDBMS

Oracle 10g, 11g, 12c

Languages

SQL, PL/SQL

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

PROFESSIONAL SUMMARY

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

Installed Oracle 11g with ASM and OCFS2 File systems.

Highly Experienced in Hot/Cold Backup and Recovery and Cloning of databases using RMAN.

Data guard - configure primary -standby using duplicate from active database command of 11g.

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

Apply SCN-based Incremental backup to sync standby after loss of Archivelogs on primary.

Measure data loss based on latency/lag. Cross-platform migration using Data guard.

GoldenGate - Involved in GoldenGate setup and monitoring. Hands on Troubleshooting replication errors & reading Trail files to identify replication issues. Performance/Latency test of GG. Hands on GoldenGate director experience.

Write parameter files for EXTRACT/DATAPUMP/REPLICAT process to perform Replication/Transformation /exception handling.

Knowledge in Golden Gate installation & Configuration setups in both windows/Linux environments.

Experience in system Monitoring and Database Performance Tuning using Explain plan, SQL Trace, TKPROF, AWR and also Cluster Interconnect Tuning (RAC).

Provided valuable inputs for various performance tuning issues. Proficient in performance tuning using Explain Plan, STATSPACK, TKPROF, AWR, ADDM.

Performance Tuning of the database (Memory Tuning, I/O Tuning).

Expertise in Performing Tuning Database - Tuning involved I/O, Memory, CPU utilization, SQL Tuning, SGA tuning, Shared Pool tuning, Buffers and Disk I/O tuning using Oracle's regular performance tuning tools like Explain Plan, STATSPACK (perfstat), SQL*Trace, TKPROF.

Expert in Performance Tuning and Monitoring of Oracle Databases on Unix/Linux platform using database tuning, Tkprof, Explain plan, AWR and ADDM reports, Advisors as SQL Tuning, SQL Advice, Undo, Segment, MTTR, Memory.

Experienced in performing Database related activities using GRID, Multitenant Architecture, OEM, Data Pump, SRVCTL, RMAN, SQL*Loader, datapump, Export, Import, PL/SQL, SQL*Plus, SVRMGR, SQL*Net/Net8, Listener, AGENT Tuning using explain plan, SQL Trace, AWR, ADDM, SGA tuning, Statspack and tuning of initialization parameters.

Experience as 24x7 productions DBA as well the application (development) database administrator.

Planned and implemented high availability solutions such as Real Application Cluster (RAC) in Oracle 11gR2 Grid and 10g on ASM and OCSF2 file systems.

Experienced in working with very large 24x7 Oracle RAC 10g & 11g databases on ASM of nearly 80GB to 2TB.

RAC- Administration/Trouble-shooting of 3 Node cluster on Oracle 10g/11G R2. Configuring Grid Infrastructure SCAN Listeners on 11gR2.

Migrate OCR files to ASM. Trouble-shoot Resource related issues. Cluster-wide Resource management such as create resource plan, Service configuration, parallel instance group, Application Isolation. Stress testing, benchmarking of clustered database.

Managed ASM storage. ASM cloning. Prepare/Add/remove ASM disks. Tuning of I/O on ASM based databases. Troubleshoot ASM crashes & memory problem.

Experience in database patching, cloning, upgrade, migration & maintaining standby db server (DR).

Experience with database backup, recovery, and setting up disaster recovery Database servers.

Experienced in writing and designing the SQL queries as well as have extensive knowledge of Relational Database Management Systems. (Normalization, De-normalization, Entity Relationship diagram, DFD etc).

Experienced in resource management like data files with ASM (Automatic Storage Management) (Trouble shooting, Add, Remove Files etc.), online redo log files, control files. Allocating logical storage structures like tablespace, schema and extents as well as configuring Oracle databases on Multi-Threaded Servers Implemented Hot/Cold physical backups (Incremental and full), cloning, duplicating of databases using RMAN with VERITAS Net Backup & IBM TSM.

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 database.

Worked on Data transferring with export/import utilities and Data pump.

Highly experienced in performance monitoring/tuning/troubleshooting.

Oracle Database performance-tuning services with EXPLAIN PLAN, TKPROF, STATSPACK, SQL TRACE. Applying patches under UNIX platform.

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

EDUCATION

BSc



Contact this candidate