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 what’s possible through technology.



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
 
 
View all job openings