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 Title : Oracle DBA
Location : Type : Full-Time Mode : Work from Home (8 hrs rotational Summary :
Responsibilities
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 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 : Bachelors degree in computer information systems, computer science or related discipline 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
(ref:hirist.tech)
