Oracle Database Administrator, Senior - Remote Job at Bajong, Phoenix, AZ

ZDVkenROa1JLUFR2enk0S0g4Y2h1TGFrdHc9PQ==
  • Bajong
  • Phoenix, AZ

Job Description

High skilled oracle database administrator with 8 years of experience in oracle database version 10g, 11g, 12c and 19c in development and production environments
I have proactively monitored and tuned system available resources using tools and utilities like OEM, customized scripts, AWR report, ASH, the Explain plan SQL tuning advisor to keep the performance of database systems up and running. Possess complete SDLC knowledge with great working experience on Oracle 10g, 11g, 12c and 19c versions.

TECHNICAL ENVIRONMENT

OPERATING SYSTEMS: Red Hat Linux RHEL 5.x/6.x/7.x, AIX 6.x, MS SQL SERVER, Solaris10/11and Windows 2000-20xx

RDBMS:Oracle 10g/11g/12c/19c
LANGUAGES:SQL, PL/SQL, UNIX Shell Scripting, Ksh, bash Scripting
SOFTWARE/ APPLICATIONS/ TOOLS:Oracle Enterprise Manager (OEM) , Oracle Data Guard, Agents, RAC, ASM, Sql Developer, TOAD, Exp/Imp, DBCA, DBUA, Recovery Manager (RMAN), DataPump (expdp/impdp), SRVCTL, AWS, SQL*Plus, Recovery catalog, Crontab, Golden Gate, Data Guard, TDE, Data Redaction etc.
TUNING TOOLS:SQL TRACE, TKPROF, EXPLAIN PLAN, AWR, ASH, SQL TUNING ADVISOR, ADDM, ORACLE DATABASE REPLAY, SQL ACCESS ADVISOR etc

ORACLE DATABASE

-Golden gate for replication
-Data guard for disaster recovery
-RAC for availability
-Performance Tuning/Analysis
-Testing
-AWS migration
-ASM
-Production Support
-OEM Grid/ cloud control
-Shell Scripting
-Multitenant Architecture
-Installations and Configurations
-Upgrade and Patches
-Database administration
-RMAN (Recovery Manager)
-
-Data pump and export/import
-Transportable Tablespace
-AWR, ADDM, ASH, Explain plan
-SQL TRACE, TK PROF
-SQL Tuning & Access Advisor
MS SQL server

Backup and recovery
Use SSMS
Mirroring
Performance tuning
Upgrade and patching

DATABASE $ SOFTWARE SUPPORTED

Oracle- 10g,11g,12c, and 19c
MS SQL server- 2012,2014

OPERATING SYSTEM

Linux (Red-Hat), Unix, Solaris, Window, Aix

PROFESSIONAL EXPERIENCE

Taylor Farm - Annapolis, M. DJune 2020 - Present
Role: Oracle Database Administrator

-Installation, configuration, Maintenance and Support of Oracle 11g , 12c and 19c RAC Databases
-Creation, Configuration and Setting up of RMAN Catalog databases and registering target Databases with the Catalog.
-Responsible for Backup and recovery of the databases using RMAN Tool (Recovery Manager) and Database Flashback using GRP (Guaranteed Restore Point) and Export and Import (Data pump and Normal) for restoring the specific objects at the database level.
-Applying upgrade patch, maintenance and interim (Opatch) patches on all the databases.
-Applying Rolling PATCHING in the RAC environment to enhance availability.
-Refreshing Dev and Test instances with data from Production on a regular basis.
-RMAN point in time recovery and Instance recovery done on 11g.
-Developed compliance reports and performed auditing at higher levels.
-Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab.
-Experience in UNIX/SHELL scripts for providing the reports and daily production exports.
-Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
-Extensive experience in RMAN recovery testing, RAC and standalone database.
-Experience in setting up Oracle ASM storage for Oracle RAC databases.
-Experience in configuring TDE in 12 and 19c database
-Built S3 buckets and managed policies for S3 buckets and used S3 bucket for storage and backup on AWS.
-Work with other teams conform to various requirements including security and compliance of managed servers.
-Experience in migration from oracle database to AWS
-Extensive experience using SQL trace to trace user sessions
-Successfully implemented Backup & Recovery using RMAN which includes hot backups and Cold backups.
-Worked extensively on Performance tuning of Queries by maintaining Aggregates, Compression, partition, indexing and use of Hints, Stored outlines, Statistics.
-Supported development teams by providing SQL statement tuning and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, AWR, ASH, ADDM
-Performing monthly and annual performance reports for trend analysis and capacity planning.
-Assist in SQL tuning and providing consultation such as creating Materialized views, adding indices, dropping unnecessary indices, using hints wherever possible, amongst others.
-Troubleshooting of various database performances by proper diagnosis at all levels like SQL, PL/SQL, database design, database tables, indexes, Instance, memory, operating system and java calls.
-Experience in Oracle Data warehouse DBA skills relating to administration and management environments, Oracle OLTP.
-Implementing Data pump, conventional export/import utility of Oracle 11g, 10g for re-organizing Databases/Schemas/Tables to improve the performance.
-Used import/export utilities for cloning/migration of small sized databases and Data pump import/export to move data between 10g and 10g/11g environments.
-Implemented proactive monitoring using EXPLAIN PLAN, SQL tuning advisor.
-Database monitoring/maintenance, replication process and performance tuning are done using OEM (Oracle Enterprise Manager).
-Implemented Flashback technology of the Oracle 11g, 10g along with Recycle bin for a faster recovery of the databases and database objects.
-Performed full & incremental backup (cumulative and differential) using RMAN and implemented recovery strategies.
-Refreshed/cloned databases using RMAN utility.
-Successful in applying RDBMS patches, security patches for improving the security and functionality of the databases.
-Participated in Disaster Recovery Drills (PHYSICAL STANDBY DATAGUARD) and documented database and application validation steps.
-Participated in a 2 node RAC running on ASM cluster for Availability and Scalability.

Pfizer - PeapackNJ.Jan 2017-May 2020
Role: Oracle Database Administrator

Responsibilities:

-Installation, configuration, Maintenance and Support of Oracle 11g and 12c (Multitenant and NON-CDB) Databases
-Worked as a team member for 24x7 support with on-call rotation in all PROD, UAT, PERF, and DEV environments.
-Install and Manage Oracle Server, Oracle Cluster Server (10g, 11g, 12c, and 19c), RAC/Non-RAC Database Instances and configuration as per the Application requirement and Environment Policies.
- Create, maintain and provide information including updates, and reports on current database configurations to application as/and when required.
-Manage Database File System Management, ASM Disk group, User Management, Change Management, Database Commissioning/Decommissioning, and Data Refresh.
- Expert in identifying, operational issues (such as locking, conflict, latch contention, rollback requirements, etc) for database instances and inform the trend captured to application team(s). Monitor the alerts reported by monitoring scripts and OEM related to Database availability, Performance, Network Connections, and database alert logs.
-Great knowledge in finding the root cause of the problem, resolution, prevention, and recording of details.
-Worked with team to migrate on-prem database to AWS RDS for Oracle using DMS and Oracle Data pump. Setup and Managed RDS instances running on Oracle Standard and Enterprise Edition version 19c.
-Perform Application deployments of New Environments, Install and configure Binary and creating database, Upgrade and database Patching.
Responsible for Backup and recovery of the databases using RMAN Tool (Recovery Manager) and Database Flashback using GRP (Guaranteed Restore Point) and Export and Import (Data pump and Normal) for restoring the specific objects at the database level.
-Building Oracle Standby databases, both Active Data guard for real-time replication and normal Data guard for disaster recovery also referred as BCP clone purposes.
-Applying Rolling PATCHING in the RAC environment to enhance availability.
-Refreshing Dev and Test instances with data from Production on a regular basis.
-Installed Oracle 11g and 19c on Linux platform using ASM.
-RMAN point in time recovery and Instance recovery done on 11g, 12c and 19c.
-Scheduling repetitive activities like gathering schema statistics, exports, table space usage report using crontab.
-Experience in UNIX/SHELL scripts for providing the reports.
-Implemented and managed optimum physical database design (table spaces, data files, extents, redo logs, archive logs) and assessed database capacity by monitoring online storage, growth and file system space, in adherence to the Optimal Flex Architecture.
-Provided instance level performance monitoring and tuning for Event Waits, Sessions, Physical and Logical IO and Memory Usage.
-Extensive experience in RMAN recovery testing, RAC and standalone database.
-Experience in setting up Oracle ASM storage for Oracle RAC databases.
-Performed database replication through Golden Gate.
-Implemented Data Guard with high availability and performance configurations and participated in Data Guard Fail over tests.
-Successfully implemented Backup & Recovery using RMAN which includes hot backups and Cold backups.
-Worked extensively on Performance tuning by partition, indexing, use of Hints and gather Statistics.
-Supported development teams by providing SQL statement tuning and removing load and query performance bottlenecks by using tools EXPLAIN PLAN, AWR, ASH, ADDM
-Performing monthly and annual performance reports for trend analysis and capacity planning.
Employment Type: Full-Time
Salary: $ 120.00 Per Year

Job Tags

Full time, Work experience placement, Interim role, Remote job, Work alone, Flexible hours,

Similar Jobs

Senior Helpers - Worcester, MA

Caregiver-CNA Job at Senior Helpers - Worcester, MA

 ...clients as you would treat your own family members in their time of need.Requirements:* Reliable Transportation: Must be willing to travel 5-25 miles from our office (no long-distance commutes).* Proof of Car Insurance: Ensure your vehicle is insured.* References:... 

Talent Pairing

English Transcriptionist/Editor (Contract Position) Job at Talent Pairing

 ...This is a remote position. We are seeking skilled transcriptionists/editors for contract work to transcribe recorded audio and refine imperfect transcriptions using our proprietary internet-based software. In this role, you will be responsible for accurately transcribing... 

Webuild Services LLC / Webuild Staffing

Structural Engineer- Steel Design (EIT) Job at Webuild Services LLC / Webuild Staffing

Structural Engineer - EIT Webuild (webuildstaffing.com ) is seeking a Civil / Structural Engineer to perform structural steel design / detailing for one of the nation's leading signage / outdoor structure engineering, fabrication and construction firms in the nation.... 

The Borgen Project

Writer/Journalist Internship Job at The Borgen Project

Are you passionate about making a difference in the world? Look no further! The Borgen Project is an international organization that works at the political level to improve living conditions for people impacted by war, famine and poverty. With 20 years of experience...

Hollywood Feed

Class A Delivery Route Driver Job Job at Hollywood Feed

Class A Delivery Route Driver JobLOOKING FOR FULL TIME CLASS A CDL DELIVERY DRIVER BASED OUT OF ATLANTA, GA. (Will deliver to all locations in surrounding areas and East to the Carolinas)Premium pay in the $60,000 salary rangeVacation starts at 6 monthsWeekly pay...