Oracle Database Administrator

Job Description

Position title: Database Administrator R 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)