We provide IT Staff Augmentation Services!

Database Consultant Resume

SUMMARY:

IT professional with 15 years of experience and have exposure in Database Architecture Development, emerging technologies, disaster recovery and automation. Enjoy working as an important and key player with a team of IT professionals.

SKILLS:

Database: 8i, 9i, 10g, 11g, 12c Dataguard (from 11g) and RAC (Real Application Clusters from 9i), MS SQL Server

Operating System: Solaris 7, 8, 9, RHEL Linux 5x, Windows

Applications: Enterprise Manager Cloud Control 12c

Environment: JD Edwards EnterpriseOne (Financial Management)

EXPERIENCE:

Confidential

Database Consultant

Responsibilities:

  • Provided remote consultancy to Confidential on per case basis.

Database Administrator

Confidential

Responsibilities:

  • Oracle 8i, 9i, 10g, 11g, 12c Installation/Creation/Upgradation/Cloning.
  • Configure database initialization parameters.
  • Managing Tablespaces and data files, redo log groups and members.
  • Creating and Rebuilding indexes, Creating and Refreshing of Materialized views, Analyzing Schemas.
  • Design, Implementation and monitoring of backup and recovery activities using RMAN/EMCC and Export/Import/Data Pump utilities.
  • Restoring and recovering RMAN backups in case of Database Failures.
  • Scheduling the databases backup. Monitored Day - to-Day backups, logs and recovering them as per the requirements.
  • Performing daily maintenance including monitoring backups, managing disk space and maintaining database objects.
  • Performing Database tuning & performance monitoring using various Advisory utilities of EMCC.
  • Used Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) for performance and tuning.
  • Oracle user management by creating users and granting them roles and privileges.
  • Daily health checkups and Monitoring Trace file. Checking errors in Alert Log.
  • Providing support to development team, like Database changes, Trace and kill sessions.
  • Day to day monitoring like availability of system, listener, database, alert log file, trace file.
  • Oracle data movement using export / import and Datapump.
  • Undertaking Patch Management and Version Control. Patching Database with OPatch and PSU patching.
  • Participated in Oracle Data Guard Installation for Oracle Database. Implemented Dataguard with maximum availability, protection and performance modes.
  • Monitor and optimize the performance of the database Configured to achieve high availability, load balancing and automatic failover / switchover functionality using Dataguard.
  • Add/Remove to/from existing Real Application Cluster (RAC) environment.
  • Performing Disk Management using ASM (Automatic Storage Management) in RAC.
  • Participated in on-call rotation and working after hours and or on weekends.

Hire Now