Occupation:Database Administrator |
Location:Skokie, IL |
Education Level:Bachelor |
Will Relocate:YES |
Description
PROFESSIONAL SUMMARY * Over 7 years of experience as an IT professional along with extensive experience as an Oracle DBA in Production, Development and Test environments, and transforming business strategies of various organizations into efficient and integrated global business solutions. * Installed Oracle versions 10g / 11g/ 12c on environments Windows, Linux and Solaris * Migrated databases from Oracle Versions 10g to 12c * Worked on OEM, DB console, Grid Control and Cloud Control * Proficient in installation and configuration of Oracle 11g, 10g, 9i on all UNIX platforms * Managed databases on Windows. * Performed Data Migration * Build 10g and 11g Physical Standby Data Guard * Expertise in installing, configuring and maintaining Oracle 11g & 10g RAC (Real Applications Clusters) with ASM & OCFS2 file systems on RHEL, AIX, and HP-UX. * Upgraded oracle databases from 9i to 10g and 10g to 11g using both manual method and DBUA. * Performed RMAN backups (Full, Incremental and Cumulative) and recovery, incomplete recovery and disaster recovery using Standby database or Data Guard. * Have implemented two type of standby databases supported by Data Guard, logical standby and physical standby databases in 11gR2 on two node RAC * Worked on large-scale databases with size around 10TB in large system environments. * Having hands on experience in Hot/Cold Backup, Recovery and Cloning of databases using RMAN with Veritas NetBackup and Comm Vault. * Created databases using DBCA, silent install and via scripts. * Applied CPU and PSU patches. * Good experience in database performance tuning using tools like STATSPACK, TKPROF, EXPLAIN PLAN, AWR, ADDM and Tuning of SGA, distribution of disk I/O, Sizing of tables. * Provided 24x7 on-call production database supports with timely resolution of tickets. * Involved in Logical and physical modelling using Erwin and Data loading using SQL*Loader. * Good knowledge in implementing Oracle Flashback technology for faster recovery of tables/database. * Expertise in using Oracle Enterprise Manager (OEM) and setup of Oracle Grid Control. * Management of Schemas, Objects & Partitioning the tables & indexes * Automating the daily routine activities and Schedule maintenance jobs by creating/developing UNIX shell scripts and Oracle scheduler jobs. * Planning the backups using RMAN, logical (import/export, impdp/expdp), hot and cold backup. * Oracle Database capacity planning, Creating & Managing Database Structures, space management, storage allocation and different type of storage structure (SAN/NAS) * Worked closely with the Oracle developers for the better performance in Applications in writing the Packages, Triggers, Materialized Views and Indexes on the tables. * Used TOAD and SQL Developer extensively along with command line interface utilities like xshell and putty * Provided 24/7 support during on-call. * Worked with offshore team. * ExaData extensive experience as an Oracle DBA
Accomplishments
Highlights:
Keywords
