We provide IT Staff Augmentation Services!

Oracle Developer Resume

4.00/5 (Submit Your Rating)

Lowell, MA

Hire Now

SUMMARY

Seeking to obtain a position of Database Administrator, eager to showcase the knowledge obtained as a student in Database Management Technologies.

TECHNICAL SKILLS

Oracle:  SQL scripting (using SQL*Plus), DBCA and EM utilities,grant, role, object management), table spaces, tables, indexes),, DB Control, AWR, ASH, ADDM),Tune database SQL (explain plan generation, SQL re - write, optimal indexing, full table scan avoidance),GUI and command line 

Operating Systems:  Linux kernels used Red Hat ES 4/5, Oracle Enterprise Linux, Fedora. Windows Win 7 - 8/Server2012,Install and configure Linux on base hardware platform as well as in virtualized environments,Utilization of common shells and utilities including C Shells, Vi Editor, SED, AWK

PROFESSIONAL EXPERIENCE

Oracle Developer

Confidential, Lowell, MA

  • Installed, upgraded and patched Oracle software (version 10r1 - > 11r2 )
  • Migrated 11g production databases (pre-upgrade, database migration and conversion)
  • Performed schema comparisons to ensure all objects migrated successfully
  • Implemented Oracle 11g Data Guard (DG) physical standby databases (3 nodes)
  • Configured high availability (HA) of Oracle DG instances using Data Guard Broker/Observer
  • Developed and implemented Oracle backup and recovery plan (cold/hot/export backups)
  • Installed and configured Oracle Recovery Manager (repository, accounts, backup scripts)
  • Performed database cloning using backup trace (manual) and RMAN clone utility option
  • Utilized transportable table spaces to export/import objects between databases
  • Created and configured 11g Grid Infrastructure including cluster services (ohad)
  • Create and configured Automatic Storage Manager (ASM) instance for use with database
  • Relocated databases from file system management to ASM storage (OMF)
  • Conducted performance analysis of production instances (Statspack, AWR, ADDM, Advisors)
  • Reorganized dictionary managed database to locally managed tablespaces, uniform extents
  • Moved tables and indexes into proper extent sizing for optimal storage and IO performance
  • Increased database IO performance through improved configuration and utilization of SGA
  • Conducted instance tuning including pfile adjustments (optimizer, targets, buffers, etc.)
  • Performed redo log tuning including adjustments to fast start mttr and checkpoint settings
  • Implemented automatic memory management (AMM) for several project databases
  • Performed security analysis using interrogation scripts, tools and checklists
  • Monitored and analyzed diag directory s database alert logs, user and system trace files
  • Resolved ORA errors, as required, using Oracle documentation and Oracle Support site
  • Implemented Oracle Database Vault including configuration of roles, rule sets and reports
  • Wrote SQL scripts in support of application requirements
  • Performed SQL traces and utilized TKPROF to examine SQL execution plans
  • Optimized SQL to improve performance (utilized SQL Advisor, indexes, hints, and profiling)
  • Utilize tools including Enterprise Manager, and SQL Developer to manage databases
  • Conducted database testing as required for each project before rollout from test to prod
  • Provided technical support of the RDBMS environment to management and end users
  • Project lead on resolution of design and functional issues during/after development
  • Created project documentation including design, architecture, configuration, and implementation

Hire Now
Report an issue

We'd love your feedback!

Privacy Policy
Resume Categories
Client Services
Job Seekers
Visa Sponsorship