Interspence Solutions - Oracle Database Administrator

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 are committed to building a team of forward-thinking individuals ready to embrace innovation and redefine whats possible through technology.

Job Title : Oracle DBA

Location : Mumbai

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 : Bachelors 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