Resume

Sign in

Manager Oracle

Location:
Bowie, Maryland, United States
Salary:
98,000
Posted:
November 03, 2018

Contact this candidate

Resume:

STACEY BABI

Personal Information

Professional Summary

609-***-****

ac7lb2@r.postjobfree.com

US Citizen

Over 5+ years’ of strong experience in Oracle database administration in heterogeneous system. Environment includes UNIX, and Windows, supporting a variety of mission critical applications with Oracle 11g and 12c.

Experience in upgrading databases from 10g to 11g and 11g to 12c using DBUA (oracle database upgrade assistant) and manual method.

Extensive knowledge on database administration for Oracle 12c, 11g, 10g, 9i with experience within a very large scale database environment and mission critical large OLTP systems in a variety of environments like Linux, HP-UX, RHEL and Windows.

Expert in planning, creation, administration and troubleshooting of Oracle OLTP (multiple instances)/OLAP databases.

Expertise in setup, installation, configuration, maintenance and troubleshooting of several Oracle tools and utilities like Oracle Grid Control, Cloud Control, Oracle Enterprise Manager (OEM), Oracle SQL Developer in various versions.

Experience in Real Application Clusters (RAC) setup, configuration and cluster interconnection with Automatic Storage Management (ASM), configured user log on load balancing and failover on RAC database for high availability.

Strong experience in migrating database from Non-ASM to ASM and Non-RAC to RAC.

Have Hands on experience in Oracle 10g, 11g 3-Node RAC implementation & administration (Oracle Clusterware setup and configuration, RAC installation using ASM, Configuration and Patching, RAC Backup and Recovery).

Management of database security with managing users, grant user privileges on data dictionaries, schemas, tables and table spaces, creating roles and profiles, password authentication, table partitioning, indexes, grant quotas for users.

Writing scripts in the UNIX based environments for managing the users roles and privileges, scheduled backups (using data-pump /cold backups), manage statistics, Disk space management.

Experience on Oracle monitoring tools including Oracle Application Server monitoring and Oracle Linux monitoring using NMON and TOP commands.

Performance tuning of the database - SQL Tuning, Used Tuning utilities like AWR, ADDM and Tuning of SGA, Distribution of disk I/O, Sizing of tables and indexes.

Expertise in using EXPLAIN PLAN for query optimization and Performance diagnostic tools like SQL Trace and TKPROF.

Experience in application and memory tuning with explain plan, TKPROF, STATSPACK, SQL trace, SQL optimization utilities, SQL tuning advisor, SQL access advisor and SQL planned management.

Experience in using tools like AWR (automatic workload repository), ADDM (automatic database diagnostic monitor) and ASH (active session history) for database performance reports

Proven technical knowledge of infrastructure management (network, systems), combined with outstanding leadership ability and creative problem solving skills in both strategic and tactical areas as well as excellent communication /documentation skills and strong aptitude to analyze and resolve problems.

Strong experience in migrating database from Non-ASM to ASM and Non-RAC to RAC.

Administered Oracle ASM disk groups (mirroring, compatibility) with Oracle ASM Configuration Assistant (ASMCA)

Experience in installation, upgrade and maintenance of RAC (Real Application Cluster) 10g and 11g databases to support online applications.

Configuring Automatic Storage Management (ASM) which includes creating disks and disk groups for oracle 10g and 11gR2 RAC databases.

Experience in monitoring oracle instances and maintaining databases, performance using OEM (Oracle Enterprise Manager), Oracle GRID-control and database monitoring using 11g Grid monitoring tool.

Responsible for RMAN backups, and improvement to backup with incremental back by adding block change tracking feature of Oracle 11gR2.

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.

Data transferring with export/import utilities and Data Pump and SQL* Loader.

Performing complete and incomplete recovery during disasters, failures and user errors.

Configuring user creation, their roles and privileges profiles to control access over database objects.

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 as well as database upgrades

Installed and maintained Real Application Clusters (RAC)

Extensive experience in database production support.

Database backup concepts and options such as user-managed backup, RMAN-managed backup with or without catalog, operating system backup, cold and hot backup, full backup, incremental and cumulative backup. Implementing backup and recovery strategies.

Deployed Standby databases using Data Guard 11G (Maximum Performance).

.

Areas of Expertise

Databases

Oracle 12c,Oracle 11g, Oracle 10g

Oracle Database Tools

SQL*Loader, TKPROF, OEM, TKPROF, EXPLAIN PLAN, AWR, ADDM, ASH, SQL Developer, Grid Control

Operating Systems

Solaris 10/9/8, Sun Sparc, RHEL 5.X/4.X, OEL, HP UX 11i, Windows 2000/2003 server

Education

M.A. Law and Governance with concentration in Peace Studies and Conflict Resolution

Montclair State University, Montclair, NJ

B.A. Political Science

Rutgers - The State University of New Jersey, New Brunswick, NJ

Experience Summary

Whichman, Inc. – Greenbelt, MD

August 2015 – Present

Oracle DBA

Primary DBA for 100+ databases of Oracle 10g/11g/12c on Linux REHL, HP-UX. Worked as per ITSM/Remedy Incident ticket/Critical Response Time (CRT) call.

RAC- Administration/Trouble-shooting of 3 Node cluster on Oracle 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.

Data guard - configure primary standby using duplicate from active database command of 11g. 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.

Performed incremental backups using Recovery Manager (RMAN). Created recovery catalog, performed complete and incomplete recovery using RMAN.

Installation of 3 nodes 10g RAC on Linux & Solaris with veritas cluster. Configured ASM, OCFS and RAW devices. Troubleshooting & tracing of RAC processes & CRS components. Relocate service. Tuning of RAC environment. Managing fail-over of instances. Resource utilization on each node. Monitor top objects in cache fusion and traffic.

Backup by RMAN and data pump. Consistent backup using datapump. Diagnose and repair block level corruption using RMAN. Script and test RMAN backup/restore. Optimizing backup by compressing. Troubleshooting RMAN restore. Used RMAN convert command to transfer datafile from ASM. Duplicate database on remote host using 11g active database command.

Audit database performance using ADDM reports, AWR snapshot and diagnostic SQL scripts. Identify and tuning of ad-hoc queries, PL/SQL code which are high intensive resources. Tuning instance by init parameter. Used explain plan and stats pack/TKPROF utility to Improve response time of query. Create/manage local partitioned and bit-map indexes.

Developed, modified and optimized very complex queries to data retrieval using Explain Plan, SQL Trace, TKPROF, parallel processing and partitioning techniques.

Monitoring the CPU, memory usage, I/O contention on servers using top, iostat, sar, glance, vmstat etc.

Designed daily, weekly Backup and Recovery procedures for production, non- production databases using RMAN backups taking periodic Complete, cumulative and differential Incremental Backups.

Migrated VLDB multi terabyte databases around 10TB and redesigned the RMAN backup Strategy.

Data Refresh/Cloning from Production environment to setup QA/ DEV using RMAN Duplicate.

Intensively used latest 10g/11g Automatic Workload Repository (AWR) & Automatic Database Diagnostic Monitoring (ADDM) reports for the health check of the databases, and used the notification tool to send the alerts in OEM Grid Control.

Scheduled UNIX scripts in crontab jobs to automate daily tasks like backups, monitoring the alert logs, backup logs, cleaning the old archive logs, old log files, tablespace monitoring to send notification emails.

Tuning performance using Advisors, AWR, ADDM, SQL tuning etc.

Performed Online and Offline backups with RMAN, export/import and expdp/impdp.

Implemented Point in time recovery using RMAN.

Experience using like - Real Application Testing, Table and partition recovery using RMAN, Invisible columns, DDL Logging

Extensively used Oracle 11gR2 features - Real Application Testing, automatic SGA tuning, enhanced RMAN with Flash Recovery Area, Block Change Tracking, Merge backup, Oracle Data Pump, big file tablespaces, new EM Grid Control, Database Control, Studio Control, AWR, ADDM, SQL Tuning/Access Advisors, SQL Performance Analyzer, Database Replay, SQL Plan Management, SQL Tuning Automation, Flashback Database, compression techniques and several others

Performance Tuning of Oracle Database Objects using tools like EXPLAIN PLAN, SQL*TRACE, TKPROF, STATSPACK for optimized results

Configuration and implementation of Oracle for high availability.

Performed Schema as well as Table level Replication using Oracle Streams.

Implemented downstream capture at the destination database using Oracle Streams.

Installed and Configured Oracle OEM (Oracle Enterprise Manager) Grid Control.

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.

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.

Environment: RHEL 5.X, 6.X; Windows NT 2000/2003; Oracle 10g, 11g, 12c

Essex County College – Newark, NJ

April 2011 – August 2013

Database Administrator

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

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

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

Have set up the cronjobs for runalert, spacewatch monitoring, RMAN backup (level_0 and level_1) and recovery, archive log purge, deletion of archive logs and AWR reports on AIX-5.3.

Golden Gate Heterogenous replication using Log miner utility.

Monitoring and Troubleshooting of Database Replication issues using Golden Gate dealt with conflict resolution and performance issues.

Monitor and maintain security by managing roles/privileges for users of the databases.

Apply the PSU patches and RMAN patches to the binaries as well as to the databases.

Cloned/Refreshed Oracle Databases and Oracle Applications for development and testing.

Performance tuning of Oracle Database, applications and queries.

Conduct Pre-patch analysis for different types of patches as requested by customer.

Set up boxes and install required software and prepare operation guides for the same.

Work closely with application teams in troubleshooting issues, support root cause analysis and resolve issues.

Frequently tested and updated development databases to production as well as used database cloning.

Applying Patches 11.2.0.3 and applying Oracle DST Patches on Oracle database.

Actively involved in security administration adopting the principle of least privilege, managing default user accounts, implemented standard password security features, auditing database activity, and registering & applying security updates and Advanced Oracle security.

Used normal import and export and also datapump import and export for exporting and importing schemas, tables etc from one database to another.

Configure Oracle Advanced Security on 12c databases to implement Transparent Data Encryption at tablespace, table and column levels. Also configured Redaction using OEM's Policy expression builder.

Performance Tuning for Optimized results using Explain-Plan, SQL-Trace, STATS PACK Reports and AWR Reports.

Production Support for Critical Application Databases, work closely with

Extensively worked with dba_jobs, dba_scheduler_jobs, functions, procedures and packages.

Responsible for tuning the database performance issues like query tuning and memory tuning (SGA tuning) and also partitioned the tables and indexes for better performance.

Have used different tools like EXPLAIN PLAN, AWR, ADDM Oracle enterprise manager (GRID CONTROL)

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

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, RAC, ASM, RMAN, AWR, ADDM, SQL* Plus, SQL*Loader, OEM.



Contact this candidate