Oracle Database Administrator

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

Work arrangement
No