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

YWhQdTBZZDc2eHZ3bE5Vak5YTjZ6azZmQ2c9PQ==
  • 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

Humana

Counsel Job at Humana

 ...of our caring community and help us put health first The Counsel provides a full range of legal advice and services. The Counsel...  ...orientation, gender identity, national origin, age, marital status, genetic information, disability or because he or she is a protected... 

Campus Ink

Production & Fulfillment Assistant Job at Campus Ink

 ...on design, brand management, and e-commerce solutions located in Urbana, IL. We are now recruiting candidates to join our growing production team! Daily tasks may include: Picking shirts for use in production area Cutting Vinals to the right shape for the shirts... 

Hyatt

AM or PM Server- VAGA Restaurant Job at Hyatt

 ...you'll also be part of a vibrant community. Apply now to join our team and experience the best of Southern California living. Restaurant servers are responsible for submitting guest menu selections and presenting these food and beverage preferences. The right person... 

IVP TRANSPORT LLC

CDL Regional Tanker/HazMat Driver Job at IVP TRANSPORT LLC

 ...CDL A Hazmat Local Driver - QUANTIX LIQUIDS Qualifications : ~ Safe, Dependable, and Punctual driver. ~2-years of Tanker and HazMat experience. ~ Understands and speaks English. Responsibilities: Driving job position that consists of keeping track... 

University of Pennsylvania

Pediatric Plastic-Craniofacial Surgeon | University of Pennsylvania Job at University of Pennsylvania

 ...Pediatric Plastic-Craniofacial Surgeon Location: Philadelphia, PA Open Date: May 09, 2024 Deadline: May 09, 2026 at 11:59...  ...Time Children's Hospital of Philadelphia and the Department of Surgery at the Perelman School of Medicine at the University of Pennsylvania...