Medanta | Oracle Database Administrator

Job Location - Gurgaon Work Days - 6 days weekJob Objective - To administer multiple Oracle (MUST) , Sqlserver databases spread across locations in a distributed environmentJob Responsibility -1.Support and TrainingProviding User support (24x7) HRS - On callProblem escalation to corporate team and third parties as appropriate.Identifying and resolving database related issues.Conducting period health checks on DBsFormulating new requirements after taking inputs from implementation and support teamsGenerating adhoc reportsProviding Data setup support for QA and Dev environmentMaster Data maintenanceMonitoring and administering Report QueuesMonitoring and administering Golden gate replication routinesTroubleshoot DB issuesIdentify bottlenecks and try resolving them2.Coordination with VendorCoordinating with vendor about any new patches with respect to DB as well as applications, new requirement and bugs within specified timeline.3.Knowledge TransferProviding technical training to the peers and subordinates within IT department4.Release DeploymentTesting the product patches released by Vendor and track the issues till closureSupporting the User Acceptance Testing for new features/functionalities added in HIS and related systemsGo-live support post deployment of new features5.Following Departmental ProcessesMaintaining the tracker of issues reported on day to dayMaintaining approval recordsAny other duties given by the reporting managerAdditional Requirements:Willingness to travel across Medanta group of hospitals on short term or long term basisHealthcare (provider space) knowledge is desirableKey SkillsUnderstanding on Oracle database architecture along with cloning, patching and upgradeExpertise in installation/troubleshooting/monitoring of Oracle Golden Gate - 11g bidirectional replicationExperience with production critical/multi-terabyte Oracle Databases - 11g/10g administration, monitoring, proactive health check of the databaseKnowledge 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 maintenanceAdministration of Oracle Application Server / Oracle Forms & Reports Server - 10g/11g along with Oracle WebLogic Server 11g will be additional advantageExpertise 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 skillsDesirable SkillsUnderstanding on Sql server database architecture along with administration, patching and upgrade AGG