Oracle Database Administrator

Job description
Job Location - Gurgaon Work Days - 6 days week Job Objective - To administer multiple Oracle (MUST) , Sqlserver databases spread across locations in a distributed environment Job Responsibility - 1.Support and Training • Providing User support (24x7) HRS – On call • Problem escalation to corporate team and third parties as appropriate. • Identifying and resolving database related issues. • Conducting period health checks on DBs • Formulating new requirements after taking inputs from implementation and support teams • Generating adhoc reports • Providing Data setup support for QA and Dev environment • Master Data maintenance • Monitoring and administering Report Queues • Monitoring and administering Golden gate replication routines • Troubleshoot DB issues • Identify bottlenecks and try resolving them 2.Coordination with Vendor • Coordinating with vendor about any new patches with respect to DB as well as applications, new requirement and bugs within specified timeline. 3.Knowledge Transfer • Providing technical training to the peers and subordinates within IT department 4.Release Deployment • Testing the product patches released by Vendor and track the issues till closure • Supporting the User Acceptance Testing for new features/functionalities added in HIS and related systems • Go-live support post deployment of new features 5.Following Departmental Processes • Maintaining the tracker of issues reported on day to day • Maintaining approval records • Any other duties given by the reporting manager Additional Requirements: • Willingness to travel across Medanta group of hospitals on short term or long term basis • Healthcare (provider space) knowledge is desirable Key Skills • Understanding on Oracle database architecture along with cloning, patching and upgrade • Expertise in installation/troubleshooting/monitoring of Oracle Golden Gate - 11g bidirectional replication • Experience with production critical/multi-terabyte Oracle Databases - 11g/10g administration, monitoring, proactive health check of the database • Knowledge in database backup/recovery including Hot Backup, Cold Backup and RMAN [Duplicate Database: Active/Backup] • Experience in SQL query tuning and database performance analysis. • Administration of oracle partitioned tables and their maintenance • Administration of Oracle Application Server / Oracle Forms Reports Server - 10g/11g along with Oracle WebLogic Server 11g will be additional advantage • Expertise in Disaster recovery strategies for production/non production databases. [Active/Passive Dataguard] • Experienced in packages and tools like SQL*Plus, PL/SQL, Oracle RMAN, OEM, OUI, DBCA, NETCA etc. • Proficiency in Security administration like auditing, creating users, roles, profiles, assigning object level and column level grants, controlling users access to system resources etc. • Basic UNIX shell commands and scripting [ssh, vi, grep, sed, awk etc.] • Time management, organizing, analytical/problem solving skills Desirable Skills • Understanding on Sql server database architecture along with administration, patching and upgrade Read more