Oracle Database Administrator

Position title:

oles and 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 their 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 the 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 the morning or afternoon shift and one weekend daily.

Skills and Experience:

o Bachelors degree in computer information systems, computer science or related discipline preferred

o Must have 5+ of database administration experience with Oracle cluster environment

o Must have performed Oracle version upgrades and migrations

o Experience with Oracle11g/12c RAC Enterprise installation and its troubleshooting

o Database analysis and design expertise through code review, AWR and ASH reports.

o Experience with Oracle tools and utilities like Toad, PL/SQL developer

o Tuning of SQL statements and PL/SQL code Great to Have:

o Comfortable with highly dynamic customer-driven environment

o Ability to write, debug and tune sql and pl/sql, packages, procedures, functions, triggers, etc.

o Experience with database monitoring and tuning tools such as OEM

o Solid experience with the Linux operating system and command set

o Thorough knowledge of physical and logical disk systems and their impact on database performance.

Understanding or experience with storage is a plus. High degree of skill with database commands and utilities such as exp, imp, sql loader, etc.

o Advanced knowledge of database administration tasks such as hot and cold backups, database recovery, tablespace additions, security, etc.

o Advanced installation and configuration experience.

o Must have excellent interpersonal and written communication skills

o Ability to work independently and in shift with US counterpart team

o Capable of working and managing multiple diverse.

He/She should also provide support as SQL Server Administrator working closely with other Database Administrators locally and in the US supporting a multi-database environment including Oracle, SQL server and in memory databases like memsql. He/She will be responsible for the maintenance and performance of critical SQL Server RDBMS systems to ensure the availability and consistent performance of our corporate applications.

Position location: Mumbai – Andheri (E).

Hours of operation: 1st shift (6 am to 2 pm), 2nd shift (12 am to 8 pm)