Oracle DBA

Interspence Solutions LLP; Mumbai; Remote; INR 1,200,000 - 2,200,000; Full time

Benefits offered by this job

Work from home

8 hrs rotational shifts

Job summary

Interspence Solutions LLP in Mumbai is seeking an experienced Oracle DBA to support a multi-database environment including Oracle, PostgreSQL, MongoDB, Elasticsearch and SingleStore. The role involves performance tuning, backups, RAC management and collaboration with US-based teams.

The ideal candidate has 5+ years of DBA experience in Oracle RAC and upgrades, plus strong Linux and scripting skills. This is a full-time remote position with 8-hour shifts and weekend coverage.

Qualifications

• 5+ years of database administration experience with Oracle cluster environment.
• Experience with Oracle 12c/19c RAC Enterprise installation and troubleshooting.
• Knowledge of RMAN backups and data extraction, performance tuning.
• Proficient with Linux OS, shell scripting and monitoring tools.

Responsibilities

• Understand and apply advanced database administration, management and performance tuning techniques.
• Provide advanced technical troubleshooting for applications and database systems.
• Configure and tune Oracle and Linux OS parameters for optimum performance.
• Manage standby databases, snapshots and other advanced database features.
• Use databases replication tools like GoldenGate.
• Manage Oracle RAC environments and perform troubleshooting with RAC nodes.
• Develop shell scripts for monitoring and data migration procedures.
• Participate in design/review of application codes and attend project meetings.

Skills

Oracle RAC expertise

Database administration

Linux administration

Shell scripting

Troubleshooting

Education

Bachelor’s degree in CS/IS or related

Tools

Toad

PL/SQL Developer

Oracle OEM

GoldenGate

RMAN

Job description

About Company:

Established in August 2017, Interspence Solutions LLP (Interspence Solutions) isa dynamic IT consulting and support services company, focused on delivering high-value technology solutions within the manufacturing and process industries. We areproud to be in a long-term strategic partnership with a major U.S.-based Oil & Gascorporation, providing skilled IT resources and services under the guidance of their ITleadership team.

Job Title: Oracle DBA

Location: Mumbai

Department: DBA

Employment Type: Full-Time (Remote)

Work Mode: Work from Home (8 hrs rotational shifts)

Position Summary:

You will be a production/development-oriented Sr. Database Administrator working closelywith other Database Administrators locally and in the US supporting a multi-databaseenvironment including Oracle, PostgreSQL, MongoDB, Elasticsearch and in memorydatabases like SingleStore.

Key Responsibilities:

• Understand and apply advanced database administration, management and performance tuningtechniques.
• Provide advanced technical troubleshooting for applications and database systems
• Configure and tune oracle and Linux OS parameters to ensure optimum performance andresource utilization
• Understand server clustering techniques and its impact on database configuration and performance
• Manage standby databases, snapshots and other advanced database features
• Use databases replication tools like Goldengate etc.
• Manage Oracle Real Application Clusters (RAC) environments and be able to performtroubleshooting with RAC nodes
• Participate in design and review of application codes
• Develop shell scripts for monitoring
• Develop procedures and processes for data migration and application development
• Participate in meetings and conference calls related to project and troubleshooting activities
• Perform exports, RMAN backups and data extracts as required
• Develop strong working knowledge of key applications and their interaction with the database(s).
• You may be required to work in morning or afternoon shift and one weekend daily.

Qualifications:

• Bachelor’s degree in computer information systems, computer science or related disciplinepreferred

Preferred Skills:

• Must have 5+ of database administration experience with Oracle cluster environment
• Must have performed Oracle version upgrades and migrations
• Experience with Oracle12c/19c RAC Enterprise installation and its troubleshooting
• Database analysis and design expertise through code review, AWR and ASH reports.
• Experience with Oracle tools and utilities like Toad, PL/SQL developer.
• Tuning of SQL statements and PL/SQL code
• Experience with database monitoring and tuning tools such as OEM
• Ability to work independently and in shift with remote counterpart team
• Excellent interpersonal and written communication skills

Good to Have:

• Experience with multi node Exadata clusters.
• Experience with other database systems such as SingleStore and PostgreSQL
• Comfortable with highly dynamic customer driven environment
• Solid experience with the Linux operating system and command set
• Thorough knowledge of physical and logical disk systems and their impact on databaseperformance.
• Understanding or experience of storage is a plus.
• Advanced knowledge of database administration tasks such as hot and cold backups, databaserecovery, tablespace additions, security, etc.
• Advanced installation and configuration experience.
• Capable of working and managing multiple diverse projects