Job Information
Arena Technical Resources, LLC Oracle DBA in United States
Oracle DBA
Location: Remote
Job ID: 16371
Job Description
Job
Description:
Position Title: Oracle DBA
Location: Remote
Engagement: 20-25 hours per month
Clearance: US Citizen with the ability to obtain a public trust clearance required. This position supports a government contract
We are looking for an Oracle DBA to work with one of our top clients on a part time engagement. Below you will find the requirements of the role:
Oracle DBA Requirements
On-Call 24x7 production DBA support
Extensive knowledge of database server configuration and administration for Oracle 11g and 19c
Best practice RMAN configuration and operation
Best practice Data Pump configuration and operation
Performance tuning
Explain plans, sqltrace, etc.
Index tuning
Partitions and tablespace maintenance
User administration
Routine backup and restore
Routine database refresh and flashbacks
Experience using Oracle Upgrade Assistant
Implement security measures for Oracle database and host systems
Develop performance metrics
Assist developers with Oracle specific application development (query plans, indexes, etc.)
-Scriptingand the ability to work through the legacy Perl scripts is central to the role
Extensive knowledge ofPerl scriptsto support Oracle
Proficient in working with Oracle support
Day-to-Day role
Perform routine service requests
Database refresh, flashback setup
Upgrade 11g to 19c
Cloning development databases (update service names, tnsnames, etc.)
Archive tablespaces
Applying security patches
Work with break-fix team for On-call support
Develop and deliver routine performance / capacity / health reports
Environment
Oracle on Windows 2012 R2 environment
1 production server (two production databases)
2 staging servers (4 staging databases)
15 development/qa servers
Expectations
10 to 15 hours per month of routine service requests
20 to 30 hours per year for stand alone projects (e.g., upgrade production - application/database from 11g to 19c)
1 or 2 after-hours escalations per year (0 in past 12 months)
Participate in biweekly IT meeting
Must submit public trust security clearance application
Arena Technical Resources, LLC, (ATR) is an Equal Opportunity Employer (EOE) who will provide equal employment opportunity to employees and applicants for employment without regard to race, ethnicity, religion, color, sex, pregnancy, national origin, age, veteran status, ancestry, sexual orientation, gender identity or expression, marital status, family structure, genetic information, or mental or physical disability.
An Equal Opportunity
Employer M/F/D/V
Job
CategoryDatabase Admin/Developer
Job
ID16371
Job
Title
Oracle DBA
Job
LocationRemote
Hourly
Pay Rate60.00
70.00
Annual
Pay Rate
-
#
Required1
Apply
ToIZM@atr.com