Oracle Database Administrator

SubscribeIT; United States; Remote; USD 90,000 - 130,000; Full time

Job summary

A leading company in the IT sector is seeking an Oracle Database Administrator to design and maintain core database applications. The role involves managing multiple Oracle instances and ensuring data integrity and security while meeting SLAs. Candidates should have a Bachelor's degree in computer engineering or science and proven experience with Oracle databases on AIX.

Qualifications

• Proven experience as an Oracle Database Administrator on AIX (10g-19c).
• Experience with DB design, capacity planning, and performance tuning.

Responsibilities

• Design, develop, implement, and maintain core Oracle database applications.
• Create and maintain 57 Oracle instances on AIX.
• Perform performance testing and evaluation to ensure data security.

Skills

Communication

Problem-Solving

Education

Bachelor's degree in computer engineering or science

Tools

Oracle RAC

Data Guard

RMAN

Data Pump

Job description

Subscribe IT is a Platinum IBM Business Partner focused on providing IBM Managed Services to its clients across North America and Europe. Our solutions are available on-premises, in public clouds, or hosted on our own secured infrastructure at a simple monthly price. We offer operational management, consulting, licensing optimization, and application development.
Some of the software brands we support include: BigFix, Cognos, Db2, Guardium, IIB, Informix, Infosphere, MaaS360, Maximo, Netezza, Notes, QRadar, Tealeaf, Watson, WebSphere Application Server, and WebSphere MQ.

Website: http://www.subscribeit.com
Industry: Information Technology & Services Company
Headquarters: Dallas, TX
Type: Privately Held
Founded: 2012
Specialties: Cloud Hosting, Business Analytics (Watson, Cognos...), IBM BigFix Endpoint Management, IBM Security Qradar & Guardium, IBM DB2, WebSphere, Rational & Informix, IBM Information Server, PureData, Netezza, Managed Service Provider, IBM MaaS 360, and IBM Software Licensing.

Responsibilities for Oracle Database Administrators:

1. Design, develop, implement, and maintain core Oracle database applications.
2. Create and maintain 57 Oracle instances on AIX, ranging from Oracle Database versions 10g to 19c.
3. Develop storage database structures with high-level security features.
4. Alter storage structures to meet evolving company needs.
5. Set up database user accounts, control, and monitor user access.
6. Train users on database access.
7. Debug malfunctioning programs affecting database integrity.
8. Create autonomous backups and contribute to disaster recovery plans.
9. Maintain archived data on tape.
10. Perform performance testing and evaluation to ensure data security, privacy, and integrity, identifying bottlenecks and deadlocks.
11. Update database security protocols regularly.
12. Install and upgrade Oracle server and tools.
13. Plan future storage requirements.
14. Create primary database storage structures (tablespaces).
15. Create primary objects (tables, views, indexes).
16. Execute data migration jobs and scripts.
17. Modify database structures as needed based on developer input.
18. Enroll users and maintain system security.
19. Ensure compliance with Oracle license agreements.
20. Contact Oracle for technical support.
21. Ensure SLAs & KPIs are met, coordinating with support teams during major incidents.

Technical and Professional Requirements:

• Bachelor's degree in computer engineering or science.
• Proven experience as an Oracle Database Administrator on AIX (10g-19c) and various Oracle versions.
• Experience with Oracle RAC on AIX and Linux.
• Familiarity with Oracle database design, coding, and documentation.
• Ability to visualize algorithmic structures.
• Experience in DB design, capacity planning, performance tuning, storage management, backup/recovery, schema management, reporting, and clustering technologies.
• Proficiency with Oracle management tools (Data Guard, RMAN, Data Pump), Partitioning, and architecture design.
• Hands-on experience with DB standards and translating requirements into infrastructure deployment.
• Excellent communication and problem-solving skills.