Oracle DBA Professional

Interspence Solutions Llp; Mumbai; Remote; INR 1,200,000 - 1,800,000; Full time

Job summary

Interspence Solutions LLP, Mumbai, is seeking a production/development-oriented Oracle DBA to support a multi-database environment (Oracle, PostgreSQL, MongoDB, Elasticsearch, SingleStore) in a remote-capable role. The candidate will join a team of DBAs, work in shifts, and handle high-availability configurations, RAC, RMAN backups, and performance tuning.

The role requires strong Oracle DBA skills, experience with Oracle RAC and upgrades, and ability to work with global teams across time zones.

Qualifications

• Bachelor's degree in computer information systems, computer science or related discipline preferred.
• 5+ years of database administration experience with Oracle cluster environment.
• Experience with Oracle12c/19c RAC Enterprise installation and troubleshooting.

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 to ensure optimum performance and resource 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 troubleshoot RAC nodes.
• Participate in design and review of application codes.
• Develop shell scripts for monitoring.
• Develop procedures for data migration and application development.
• Perform exports, RMAN backups and data extracts as required.

Skills

Oracle RAC experience

Oracle upgrades

AWR/ASH reports

PL/SQL development

OEM monitoring

Education

Bachelor's degree in CS/IS

Tools

Toad

PL/SQL Developer

Oracle Enterprise Manager

Job description

Oracle DBA

About Company

Established in August 2017, Interspence Solutions LLP ( Interspence Solutions ) is a 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 IT leadership 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 closely with other Database Administrators locally and in the US supporting a multi-database environment including Oracle, PostgreSQL, MongoDB, Elasticsearch and in memory databases like SingleStore.

Key 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 to ensure optimum performance and resource 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 perform troubleshooting 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 discipline preferred

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 database performance.
• Understanding or experience of storage is a plus.
• Advanced knowledge of database administration tasks such as hot and cold backups, database recovery, tablespace additions, security, etc.
• Advanced installation and configuration experience.
• Capable of working and managing multiple diverse projects

Job Type

Full Time

Job Location

Mumbai