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)

Hours of operation: 5:30 am to 1:30 pm/ 1:30 pm to 09:30 pm

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