We provide IT Staff Augmentation Services!

Oracle Database Administrator Resume

Rockville, MD

Professional Summary:

  • Proficient in Installation, Troubleshoot, Maintenance and technical Support for Oracle (11g and 10g) Databases, Grid Control, RAC and OEM.
  • Experienced in Performance Tuning such as tuning of application, shared pool, buffer cache, I/O distribution, rollback segments, and redo mechanisms.
  • Highly skilled in Oracle DBA - Installation, Administration, creating Backup & Recovery Strategy Implementation, Performance Monitoring/Tuning, Encryption and Database Security for Databases having more than 300+ users.
  • Maintenance and development of database objects like Queues, Tables, indexes, Stored Procedure, constraints, triggers, Table & Index Partitioning, DB links, users, roles, profile and SQL NET and Listener.
  • Experienced in planning and implementation of Backup and Recovery strategy, used physical backup and logical backup using EXPORT/IMPORT, Expert in disaster recovery.
  • In-depth knowledge of setting up RMAN backups using control file and Recovery Catalog, and maintaining catalog schema. Proficient in creating auxiliary and duplicate databases using RMAN.
  • Strong knowledge in Migrating Oracle 10g to 11g.
  • Strong technical and analytical skills with excellent interpersonal and communications abilities.

Professional Experience:

Confidential

Oracle Database Administrator

Responsibilities:

  • Performs regular health checkup of production and test databases and performance of Oracle application system.
  • Performs backup and recovery using RMAN, Flashback Technology and user managed backups.
  • Managing and performing Tablespace Management, Undo Management, Redo log management, Control file management, online Redo log management and user privilege management.
  • Administer and manage the Oracle Instance using custom scripts and 10g Oracle Enterprise Manager (OEM) database control and Grid Control.
  • Performs Database tuning such as memory tuning, Application tuning using tools like TKPROF, EXPLAIN PLAN, PLAN TABLE, HINTS, ADDM, and SQL/Session TRACE.
  • Performs database physical and logical design and procedures for Production, Development, Q&A, Test and Training servers.
  • Supporting standby database and performs failover and switchover from primary to standby database when needed using TAF.
  • Performing Database or schema level refreshes using the traditional EXPORT/IMPORT and Data pump or backup utilities.
  • Utilized Oracle 10g Data Pump IMPORT and EXPORT utilities to implement database setup and successfully performed active failover in the event of production failure.
  • Creating and managing LOBs. Creating Regular views, sequences, partitions, and refreshing Materialized Views as needed by the development team.
  • On-call database support.

Confidential

Jnr IT Specialist – DBA (Contractor)

Responsibilities:

  • Created and configured database by making changes to the Initialization Parameters in parameter file and dynamically in session
  • Performed backup and recovery using Oracle 10g's user managed backup such as automated or manual cold backup and hot backup procedures.
  • Wrote scripts for informing the DBA’s regarding the status, performance and Space Management of the Database.
  • Performed tuning such as database tuning, SQL tuning such as query optimization (RULE and COST BASED), AUTOTRACE, and SQL Profile.
  • Prepared and reviewed database specifications, testing and changing control management programs migrations. Upgraded the database from 9i to 10g database and applied database patches (CPU).
  • Worked with IT support to ensure secure access to database and applications by configuring and limiting access to servers and folders; managing users, groups and memberships, managing LDAP directories using Oracle Identity Manager (OID/SSO), tuning, capacity planning and connectivity issues.
  • In depth knowledge of setting up RMAN backups and recovery, RMAN tuning, and maintaining catalog schema. Proficient in creating auxiliary and duplicate database using RMAN.
  • Wrote several ad hoc scripts for daily DBA activities such as backups, user creations, granting roles and privileges, archiving of alert logs, verifying error entries and checking for space usages/overages.

Hire Now