Oracle Administrator position

Integrated Resources Inc.; Detroit (MI); On-site; USD 100,000 - 140,000; Full time

Job summary

A leading staffing firm seeks a skilled Oracle DBA with extensive experience in database migration and administration. The successful candidate will manage Oracle databases, implement security best practices, and support high availability configurations. This position offers a competitive salary and the opportunity to work in a dynamic IT environment.

Qualifications

• 10+ years of Oracle DBA experience.
• Experience with Oracle 12c and RAC.
• Familiarity with Oracle Agile/PLM and EBS installation.

Responsibilities

• Migrate databases from HP Unix to Solaris OS and upgrade to Oracle 12c.
• Provide support during all stages of database implementation.
• Troubleshoot and resolve complex Oracle issues.

Skills

Oracle RAC

Database performance tuning

Oracle backup and recovery

Customer service skills

Job description

A Few Words About Us
Integrated Resources, Inc is a premier staffing firm recognized as one of the tri-states most well-respected professional specialty firms. IRI has built its reputation on excellent service and integrity since its inception in 1996. Our mission centers on delivering only the best quality talent, the first time and every time. We provide quality resources in four specialty areas: Information Technology (IT), Clinical Research, Rehabilitation Therapy, and Nursing.

Job Description

Responsibilities:

1. Migrate databases from HP Unix to Solaris OS Platform.
2. Upgrade databases to Oracle 12c.
3. Install, configure RAC databases for high availability.
4. Provide support during all stages of database implementation and deployments.
5. Participate in project meetings to understand application and database requirements.
6. Work independently to resolve complex Oracle issues.
7. Run diagnostic tools to identify database performance bottlenecks and take corrective actions.
8. Tune SQL queries in collaboration with development teams.
9. Troubleshoot Oracle performance and other issues independently or with other DBAs.
10. Manage backup and recovery for Oracle instances.
11. Plan and manage database and resource capacity.
12. Implement and enforce database security in accordance with best practices, SOX regulations, and company policies.
13. Install new Oracle instances and perform upgrades.
14. Set up and resolve issues with Oracle Data Guard environments.

Requirements:

1. Minimum 10+ years of Oracle DBA experience.
2. Proficiency with Oracle RAC (design, configuration, installation, tuning), including Oracle 12c.
3. Experience with Golden Gate technology.
4. Proficiency with ASM, RMAN, and Active Data Guard database technologies.
5. Strong production support and customer service skills.
6. Experience with Oracle Database administration on HP/Solaris and Linux environments.
7. Knowledge of Oracle database tuning and performance tools such as statspack, AWR, ADDM, ASH, and UNIX commands.
8. Experience with Oracle backup and recovery procedures.
9. Familiarity with Oracle Enterprise Manager/Grid Control.
10. Understanding of enterprise data architecture principles.
11. Ability to develop data requirements and configure database parameters accordingly.

Qualifications

Experience with system administration of the following products (listed in order of preference):

1. At least 1 year of hands-on Oracle Agile/PLM R9.3.3 installation, administration, and support experience.
2. At least 1 year of hands-on Oracle GRC (AACG 8.6.5) installation, administration, and support experience.
3. At least 2 years of hands-on Oracle EBS (R11.5, 12.1, 12.2) installation, administration, and support experience.