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.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship