Oracle DBA Consultant Resume MD - Hire IT People

SUMMARY:

Skilled Oracle DBA with 6+ years of experience.
SQL*Plus and Linux proficient, creating Database using DBCA or manually.
Installation and Administration of RHEL Linux/Ubuntu.
Bash Shell Scripting for task automation.
Taking care of issues reported using the JIRA ticketing system. RMAN backup, cloning and recovery of databases. Linux scripting with decision making trees to automate repetitive tasks such as backing up of databases, logging, data entry and notifying the DBA via email if errors occur. Proficiency with Office Application Software.

TECHNICAL SKILLS:

Languages: SQL*Plus, Linux Shell Scripting, PL/SQL, PHP, MySQL, HTML5, APACHE, CSS, XML, Java, JavaScript, Visual, C, C++.

Software: Putty, MobaXterm, SQL Developer, TOAD, Eclipse (Android Developer), NetBeans, JCreator, GitHub.

OS: LINUX - Red Hat Enterprise, Linux Ubuntu, MAC OS X, Windows - NT 2000, Windows 2003, Windows XP, Windows Vista, Windows 7.

PROFESSIONAL EXPERIENCE:

Oracle DBA Consultant

Confidential,MD

Responsibilities:

Administering a 850GB production environment with a two - node Real Application Cluster hosting Oracle 12C (12.1.0.2) on Red Hat Linux (RHEL 6.6) operating system with Tomcat/Weblogic servers as the application servers.
Administering a 120GB development database environment on single instance servers hosting 12C (12.1.0.2) database on Red Hat Linux (RHEL 6.6) operating systems.
Administering a 170GB QA environment with single instance Oracle database servers on 12C (12.1.0.2) on Red Hat Linux (RHEL 6.6) operating systems.
Create, implement and manage custom Oracle databases on Linux and windows platforms.
Providing Oracle database administrative support to various user groups (application developers, data managers etc.)
Creating and maintaining Oracle database objects (schemas, tables, indexes etc.).
Performing backup and recovery tasks on Oracle database using RMAN and cold back-ups, using shell scripts for both.
Create database recovery catalogs.
Using RMAN to restore and recover control and data files respectively.
Performing a flashback and point in time recovery.
Creating a database recovery catalog and registering databases to the recovery catalog database.
Scheduling backups using the crontab utility.
Supporting system administration groups with maintaining oracle database servers and in pre production, test, training, and development environments.
Analyzing and tuning voluminous SQL code.
24/hr support provided during on-call rotation.
Tuning database objects to run smoothly by analyzing query paths (creating explain path tables) and using efficient indexing.
Control and monitor user access to the database using roles, and profiles.
Performing data migration from a database in one server to a database housed on another server using database link.
Migrating data using the data pump export (expdp) and import (impdp).
Creating non-default listeners for database, registering database and listeners to OEM Cloud Control 12C.
Performing capacity planning in terms of memory and disk usage, establishing benchmarks for business and technical performance.
Confugured Amazon AWS EC2 cloud server and created Database.
Migrated schemas and applications to the Amazon AWS EC2 cloud instance.
Upgraded 11G databases to 12C.

Oracle DBA Consultant

Confidential,MD

Responsibilities:

Supported system administration groups with Oracle database server maintenance and in pre-production, test, training, and development environments.
Worked in an Oracle 11gr2(11.2.0.3) database environment hosting Tomcat/WebLogic application servers.
Providing 24/7 database administration support in both development and production environments.
Provided Oracle database administrative support to various user groups (application developers, datamanagers, etc.).
Created and maintained Oracle database objects (schemas, tables, indexes, etc.).
Managed a half-terabyte sized production database environment.
Database monitoring and extensive performance tuning.
Analyzed and tuned SQL code.
Tuned database objects to run smoothly by analyzing query paths and using efficient indexing.
Wrote shell scripts to automate and perform backup and recovery tasks on Oracle databases using RMAN backups, hot and cold backups.
Implemented and enforced database security by creating users, roles, and privileges.
Performed capacity planning in terms of memory and disk usage, established benchmarks for business and technical performance.
Using RMAN to restore and recover control and data files respectively.
Migrated data using the data pump export (expdp) and import (impdp).
Scheduled backups using Linux’s crontab utility.
Performed flashback and point in time recoveries.
Performed Patch Set Updates (PSUs).
Created database recovery catalogs.
Effectively migrated databases within the same downtime window.
Created non-default listeners for databases both manually and used Oracle Net Configuration Assistant (NETCA).

We provide IT Staff Augmentation Services!

Oracle Dba Consultant Resume

MD

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship