Resume

Sign in

Oracle Database Administrator

Location:
Chicago, Illinois, United States
Salary:
$100,000
Posted:
August 29, 2017

Contact this candidate

Claude

Contact number: 313-***-****

E-mail ID: ac12in@r.postjobfree.com

Summary

Over 9 years of experience of Oracle Database Administrator including 10g, 11g and 12c

Managed databases on Linux, Solaris, Windows, AIX and HPUX.

Build RAC Clusters.

Build Disaster Recovery sites using Oracle Data Guard.

Installed and configured databases using silent install, OMF and via scripts.

Has extensive knowledge in dynamic views and dictionary tables.

Applied CPU and PSU patches.

Extensive experience in OS space and tablespace management.

Worked on database security and Fine Grain Auditing.

Extensive work on shell scripting and documentation.

Installed Oracle versions 10gR1/R2, 11GR1/R2, and 12c on environments Solaris, AIX, Linux and RHEL.

Migrated databases from Oracle Versions 9i/11g to 12c.

Excellent Experience as Production DBA with 24X7 supports.

Extensive experience in backup and restores using RMAN

Managed databases on Exadata and GoldenGate.

Built 10g/11g/12c Physical Standby Data Guard.

Cloned databases using RMAN duplicate and used Data Pump for object level refreshes.

Excellent Experience in installing and maintaining Oracle Data Guard to implement physical Standby Database for Disaster Recovery in 10g, 11g, 12c and Providing Critical Solutions with DR options

Experience in taking Logical Backups by using Oracle Utility EXPDP and IMPDP and experience in loading data from flat files to database using Oracle utility SQL*Loader

Managed databases using Exadata.

Experience in Migration of databases from standalone to RAC

Excellent experience of data migration, data archiving and data access techniques

Installed and applied patched to oracle database and application

Hands on experience in Hot/Cold Backup, Recovery Cloning of databases using RMAN with TSM Backup.

Skilled in setting up Standby Database using shell scripts and RMAN utility tool, activating and Re-building Standby Databases both Physical and Logical supported by DATAGUARD.

Implemented RMAN backup (Full, incremental and cumulative) and recovery, in complete recovery and disaster recovery using Data Guard.

Experience in tuning Different components and identifying bottle necks

Installed and managed Oracle GoldenGate.

Hands on Experience in Performance tuning and optimization of SQLs.

Analyzed database performance using ASH, AWR and ADDM reports.

Managed databases on Exadata.

Creating and Managing Users, Roles and Privileges with required security implementations

Expert in encryption for databases using Wallet Manager

Database replication using snapshot, materialized views and advance replication methods

Strong in writing shell scripts to setup corn jobs for checking Adaptive server's availability, backup of databases and crucial system tables, nightly batch jobs for data transfer between servers.

Flexible and excellent team player. Ready to work in any shift.

Excellent troubleshooting skills and quick learner.

Extensive coordination with offshore team.

EDUCATIONAL QUALIFICATION

Bachelors in Aviation Management, Illinois, USA

TECHNICAL SKILLS

Oracle 12c /11g/10g/9i, ASM, RAC, Partitioning, Exadata, GoldenGate, Upgrades, Migration,

Linux, Solaris, AIX, Windows, Exadata, Cloning, RMAN, Patching, 12c cloud control, SQL Tuning.

PROFESSIONAL EXPERIENCE

McDonalds, Oakbrook, IL June 2016 to June 2017

Oracle DBA

Responsibilities:

Install Oracle 11g RAC with 4 nodes on RHEL platform with ASM.

Planning, implementing various versions of Oracle Databases to 9i, 11G R2, 12c, installation and upgrade.

Administering and setting up of 11g RAC and 12c RAC cluster ware and instances.

Monitor database performance using OEM Cloud Control and run ADDM, ASH, AWR reports.

Experience with Unix Shell scripting, SQL, PL/SQL and upload data using SQL*Loader.

Migrate Database across different servers and platforms using and Data Pump Export/Import and perform database Refresh and RMAN Cloning.

Planned and implemented Disaster Recovery solutions using Oracle Standby Database/Data Guard

Rebuild Indexes, table partitioning, tuning memory usage and SQL tuning using Explain Plan, SQL Trace, TKPROF and Stats pack for best performance.

Manage alerts, notification, jobs and Solve ORA errors and Fix Bugs with the help of Oracle support and Meta Link.

Installed OEM agents

Administer RAC Database servers using srvctl, crsctl etc.

Restore and point-in-time Recovery of database using RMAN techniques.

Configured ASM and suggested feasible workarounds for ASM Metadata corruption and Configured user log on load balancing and failover on RAC database.

Worked closely with client’s team.

Worked closely with offshore team.

Provide on-call support

Applied CPU/PSU patches.

AX Comp, Berwyn, IL February 2012 to May 2016

Oracle DBA

Responsibilities:

Build Oracle 11g with Physical Stand by Data Guard.

Build RAC node clusters.

Created databases using scripts, OMF and via silent installs.

Installed Oracle versions 10gR1/R2, 11GR1/R2 and 12c on environments Solaris, AIX, Linux and RHEL.

Migrated databases from Oracle Versions 9i/11g to 12c.

Handling the code deployments developed by Developers on Dev, Test and Production.

Managing users, profiles, roles and table space according to the requirement.

Created shell script to automate jobs.

Database user backup using Export /Import Utility. And database backup using data pump.

Production refresh to PRR environment and conversion environment when required.

Done partitions on tables and indexes to get better performance on large tables.

Monitoring Backup report, Database sync report (Verifying Production & Standby Database Synchronization), AWR report and wait events reports using OEM and Custom scripts.

Configured OEM for the performance monitoring and database administration.

Monitored indexes and analyzed their status for performance tuning and query optimization

Used SQL Trace, TKPROF, STATSPACK, Prestart, Explain Plan, AWR and ADDM for database performance monitoring and tuning. Ensure availability of databases and all related services such as RAC, ASM, Oracle streams and Data Guard.

Installed Oracle Golden Gate and setup uni-directional replication.

Migrated Oracle Non-RAC databases to Oracle RAC databases.

Migrated Oracle database from file system to ASM.

Define database backup/restore procedures using RMAN and TSM. Manage database backups and perform recovery. Participate in DR exercise twice a year to validate recovery procedures.

Prepare documentation and baselines. Analyze gap assessment and create road maps to overcome those gaps using Oracle best practices.

Perform database tuning and performance monitoring at the OS level, DB level and SQL level. Analyze data and make recommendations relating to performance and efficiency of data storage. Perform capacity testing before implementing new major application release to production environment. Provide advice and solution to Application Development Team to have effective use of indexes, how to reduce waits or other advices from OEM Grid control.

Work with the system administrator and storage administrator to perform software installations, and to configure hardware and software so that it functions optimally with the Oracle infrastructure.

Monitor and maintain database security. Co-ordinate with Security administrator in adding, maintaining and removing users account, administering quotas, auditing, and checking for security issues.

Written shell scripts to automate tasks.

Provide after hours and weekend on-call support on a rotation basis.

Charming Shoppes Inc., Bensalem, PA June 2008 to January 2012

Oracle DBA

Responsibilities:

Installed, configured, and maintained Oracle 10g and 11g on Linux

Upgraded from Oracle 10g to 11g.

Performed the migration from Tandem to Oracle 11g.

Expertise in designing the table structure using Visio by creating ER diagram and normalized all the tables from the scratch according to the specifications provided.

Performed administrative maintenance, monitoring on Oracle database systems in a global 24x7 operational environment.

Performed Database Refresh from Production to Development databases.

. Used PL/SQL (stored Procedures, triggers, packages), SQL* PLUS, SQL* LOADER of oracle database.

Supported different Databases like Testing, Staging and Training.

Performed installation and configuration of Oracle 10g/11g RAC databases on Linux.

Upgraded the Oracle 10g database to 11gR2 version and also applied patch set and interim patches whenever required to make the database software up to date.

Installed RAC on Oracle 10g and worked on ASM feature of Oracle.

Worked closely with developers during release and used oracle advanced features to achieve minimum downtime.

Good experience in Performance tuning of large databases.

Data Guard administration and maintenance.

Monitoring Day-to-Day Backups, Log's & recovering them as per the requirement. Utilized Log Miner Technology & applied Application Database Transactions on other Databases.

Successfully implemented Backup & Recovery using RMAN, Hot and Cold backups.

Taking the RMAN incremental and cumulative backups.

Scheduling the databases backup using Cron tab and VERITAS net backup.

Perform Logical backup using full/partial export/import and data pump.

Creating Logical and Physical database structure, Creating and altering Tablespaces. Managing Users and Resources, Granting and revoking privileges through Roles.

Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.

Supported development teams by providing SQL statement tuning and optimizing ETL procedures and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, STATSPACK, and TKPROF.

Perform Daily Monitoring of Oracle Instances, monitor users, and table spaces, Memory Structures, Rollback Segments, Logs and Alerts.

Creation of Users and granting them the required Roles and Privileges accordingly.

Involvement in space management, managed quotas.

Implemented advanced features of Oracle 10g such as Automatic Database Diagnostic Monitor (ADDM), Automatic Workload Repository (AWR) for monitoring database performance.

Configuration of Listener and Net Service names using NETCA and NETMGR.

Cloned schemas, objects and data on new server using Data pump.

Managing databases on multiple servers.

Worked extensively on monitoring 10G grid control database, configuration of error notifications, installing listeners, and adding them to the grid control.

Environment: Oracle 11g/10g, UNIX RHEL 5.x, OEM (Grid Control), RMAN, RAC and Data Guard, Explain Plan, Oracle Support, SQL Developer, Data Pump, Business Objects, Toad, AWR, ADDM, SQL Loader



Contact this candidate