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.
Our client is undergoing a major digital transformation, driven by significant investments in cutting-edge technologies such as real-time data capture, Big Data platforms, in-memory databases, advanced analytical engines, and elastic search capabilities. A strong emphasis is also being placed on mobility, with most enterprise applications being transitioned into mobile platforms.
Additionally, Oracle has emerged as a core initiative, revolutionizing how IT solutions are developed, deployed, and managed enhancing both speed and scalability.
As this transformation unfolds, there is a growing demand for skilled, motivated professionals eager to contribute, learn, and grow. At Interspence, 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)
Hours of operation: 5:30 am to 1:30 pm/ 1:30 pm to 09:30 pm
Work Mode: Work from Home
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
