Oracle DBA

$124,800 - $135,200/Yr

Innova Solutions USA - Pennington, NJ

posted 2 months ago

Full-time - Senior
Pennington, NJ
10,001+ employees
Professional, Scientific, and Technical Services

About the position

Innova Solutions is seeking an experienced Oracle DBA to join our team in a hybrid position, requiring three days onsite. This role is critical for designing, developing, implementing, enhancing, and supporting database systems that align with our business goals. The ideal candidate will have a minimum of 10 years of experience in Oracle Database Administration, with a strong focus on database design, replication, performance monitoring, tuning, backup and recovery, scripting, software installation, and upgrades. The position requires proactive maintenance of production databases that utilize multiple master replication, specifically with Oracle GoldenGate. The Oracle DBA will be responsible for all aspects of database management, including troubleshooting and monitoring, and will partner with other operations teams to maximize system availability. The role also involves providing backup, restore, and replication support for production databases, administering database users, and ensuring database security in compliance with enterprise-wide guidelines. Documentation of production policies, procedures, server configurations, error logs, maintenance records, and troubleshooting instructions is essential. As a subject matter expert, the Oracle DBA will manage multiple moderately complex projects and direct team activities related to special initiatives or operations. The position requires working under minimal supervision, with general guidance from more seasoned consultants or managers, and involves complex problem-solving where in-depth evaluation of various factors is necessary. The candidate will exercise judgment within broadly defined practices and policies to select appropriate methods and techniques for achieving results. Work leadership may include assigning tasks and resolving issues within the team.

Responsibilities

  • Design, develop, implement, enhance, and support database systems in alignment with business goals.
  • Manage all aspects of database design, including replication and performance monitoring.
  • Perform backup and recovery operations, ensuring data integrity and availability.
  • Administer database users and enforce security protocols according to enterprise guidelines.
  • Create and maintain comprehensive documentation for production policies and procedures.
  • Identify, troubleshoot, and resolve issues affecting systems and database products.
  • Collaborate with operations teams to maximize system availability and performance.
  • Lead multiple moderately complex projects and direct team activities related to database management.

Requirements

  • Minimum 10 years of experience in Oracle Database Administration.
  • 5-6 years of experience in Oracle Exadata Administration.
  • Experience with Oracle Enterprise Manager (OEM).
  • 5-6 years of experience with Oracle GoldenGate, including implementation and troubleshooting.
  • 5-6 years of experience in Linux shell scripting.
  • Strong verbal and written communication skills.
  • In-depth understanding of High Availability and Disaster Recovery solutions.
  • Experience with Oracle ZFS appliance and exposure to Foglight Monitoring tool.
  • Project management and oversight experience.

Nice-to-haves

  • Experience with ETL processes.
  • Proficiency in Oracle PL/SQL.
  • Production support experience.

Benefits

  • Medical & pharmacy coverage
  • Dental/vision insurance
  • 401(k)
  • Health saving account (HSA)
  • Flexible spending account (FSA)
  • Life Insurance
  • Pet Insurance
  • Short term and Long term Disability
  • Accident & Critical illness coverage
  • Pre-paid legal & ID theft protection
  • Sick time and other types of paid leaves
  • Employee Assistance Program (EAP)
© 2024 Teal Labs, Inc
Privacy PolicyTerms of Service