Oracle Database Administrator

About the job

Job ResponsibilitiesOracle Database Administrator will be providing technical and operational support for activities of Database Servers including installation troubleshooting performance monitoring tuning and optimizingMinimum Two 2 years of experience with Oracle version 12c19c and onwardsMinimum Two 2 years of experience with Oracle Exadata RAC and ASMMinimum Two 2 years of experience with Oracle Upgrade processMinimum Two 2 years of experience with patching the Oracle DatabaseInstall monitor and maintain Oracle implement monitoring and ing implement backup and recovery processes provide system and level 1 of SQL performance tuningWorking with Oracle support for resolving urgent and priority incidentsParticipate in the creation of development staging and production database instances and the migration from one environment to anotherHands on experience in regular maintenance on databases eg table reorganization Reindexing ArchivingHandson knowledge in proactive remediation of database operational problemsAbility to proactively identify troubleshoot and resolve live database systems issuesGood understanding of Change Management incident Management and service managementOracle Golden Gate JD P2Install and administer Oracle GoldenGate Classic MicroservicesManage Extract Data Pump and Replicat processesReplication PerformanceoMonitor replicationoLag latency data divergenceoTroubleshooting ABENDS trail file issues checkpoint issuesOperations Support Important for P2P3oProvide 24x7 production support oncall rotationoAnalyse logs and resolve incidents proactivelyRequired Secondary Database Skill SQL Server Administration P2 LevelInstalling configuring managing monitoring and troubleshooting SQL 2012 through SQL 20192022Min 2 years of experience in SQL Server Upgrade processInstalling Service Packs Cumulative Updates HotfixesUpgradingMigrating SQL Server from older versions to latest versionseditionsCreating and Configuring Databases as per requirement of Application Teams Performing Online Index Rebuild and ensuring weekend Index rebuild jobs succeedCreating and configuring Schema User windows and SQL Authentication Roles Linked Servers diff source and destination Backup Restore and Recovery ModelsLog Shipping Scenarios failover Switchover troubleshooting scenariosConfiguring AlwaysOn AG on standalone instancesConfiguring Replication type Transactional Snapshot MergeUnderstanding of Advanced SQL Server Architecture Relational Storage EnginesTroubleshooting Database slow performance situationsMonitoring and checking top wait types in SQL ServerResolving Blockings and Deadlocks using Extended Events and giving recommendations on Isolation Levels Indexes to avoid minimize blockings deadlocksUnderstanding of Locks also enabling disabling lock escalation on tables as per necessityHandling space management issues like Log File Full Data File Full TEMPDB FullExploring and understanding SQL Server New features implementationDesirable Secondary SkillsExperience with other RDBMS databases like DB2 MySQL PostgreSQL etcFamiliarity with database migration tools and ETL processes