Oracle Database Administrator

Masterapp Labs

Austin, TX, United States

about 2 months ago

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Experience level

Expert

Experience required

8 years minimum

Working hours

Regular working hours

Job source

dice.com

Tech stack

Databases Data Dictionary Data Integrity Extract Transform Load (ETL) Database Security Oracle Data Guard Linux Disaster Recovery Oracle Databases Oracle (Applications) Performance Tuning Software Engineering

+4 more

SQL Databases Scripting Database Performance People Soft

Job description

Perform database administration activities including installation, configuration, maintenance, and monitoring of Oracle database environments.
Support Oracle database upgrades, patching, and environment management activities.
Monitor database performance, perform tuning, and implement improvements to ensure system efficiency.
Design, maintain, and support logical and physical database models.
Manage database security, backup, recovery, and disaster recovery procedures.
Create and maintain database environments to support application development and ETL activities.
Analyze and resolve database issues while ensuring data integrity and availability.
Support database performance monitoring, capacity planning, and optimization activities.
Maintain database standards, data dictionary, and database documentation.
Provide technical assistance to application teams and users related to database access and data issues.
Support database changes, testing, and deployment activities across environments.
Assist with database software installation, configuration, and troubleshooting., We are seeking a Senior Operational Oracle DBA to ensure the stability, patching, and scalability of critical database environments that support multiple concurrent ERP implementations and upgrades., Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity. Years Required/Preferred Experience 8 Required Infrastructure management with Oracle 19c version or higher 8 Required Grid infrastructure (ASM, Clusterware) 8 Required High-availability (GoldenGate, Active Data Guard) 8 Required Advanced scripting (Linux, SQL) 4 Preferred Experience working with a public sector organization (Federal, State, or Local Government) 2 Preferred Experience working with a hosting vendor 2 Preferred Experience working with Oracle PeopleSoft products

Requirements

The primary responsibility is to design and execute database upgrades from Oracle 19c to Oracle 23ai, and to maintain multiple environments that support ETL activities. Candidates must have hands-on experience with Grid Infrastructure setup and maintenance, security vulnerability compliance, and performance tuning.