About the role
Oracle Golden Gate JD for P3 level
Job Responsibilities
Oracle Database Administrator will be providing technical and operational support for activities of Database Servers including installation troubleshooting performance monitoring tuning and optimizing
Minimum Four 4 years of experience with Oracle version 12c19c and onwards
Minimum Four 4 years of experience with Oracle Exadata RAC and ASM configurations and management
Minimum Three 3 years of experience with upgrading migrating Oracle databases
Minimum Three 3 years of experience with patching the grid and database
Install monitor and maintain Oracle implement monitoring and ing implement backup and recovery processes provide system and SQL performance tuning
knowledge in programming languages such as UNIX shell scripting PLSQL or Perl experience
Min two 2 years of experience with Oracle native tools like RMAN data pump SQL Loader
Estimate Oracle database capacities develop methods for monitoring estimating database capacity and usage
Working with Oracle support for resolving urgent and priority incidents
Participate in the creation of development staging and production database instances and the migration from one environment to another
Hands on experience in regular maintenance on databases eg table reorganization Reindexing Archiving
Handson knowledge in proactive remediation of database operational problems
Ability to proactively identify troubleshoot and resolve live database systems issues
Good understanding of Change Management incident Management and service management
Strong Knowledge in IaaS PaaS cloud database environment and configuration
Oracle Golden Gate JD
Install configure and administer Oracle GoldenGate Classic Microservices
Set up and manage Extract Data Pump and Replicat processes
Replication Performance
oMonitor replication
oLag latency data divergence
o
Troubleshoot
oABENDS trail file issues checkpoint issues
oPerform performance tuning and optimisation of replication pipelines
oImplement DDLDML replication strategies
Operations Support Important for P2P3
oProvide 24x7 production support oncall rotation
oAnalyse logs and resolve incidents proactively
Perform
oGoldenGate upgrades patching migrations
Support data consistency reconciliation and correction activities
Required Secondary Database Skill SQL Server Administration
Installing configuring managing monitoring and troubleshooting SQL 2005 through SQL 20192022
Min 4 years of experience in SQL Server Upgrade and Migration services
Installing Service Packs Cumulative Updates Hotfixes
UpgradingMigrating SQL Server from olderoldest SQL 2005 to latest versionseditions
Creating and Configuring Databases as per requirement of Application Teams Performing Online Index Rebuild and ensuring weekend Index rebuild jobs succeed
Creating and configuring Schema User windows and SQL Authentication Roles Linked Servers diff source and destination Backup Restore and Recovery Models
Log Shipping Scenarios failover Switchover troubleshooting scenarios
Configuring AlwaysOn AG on standalone instances across Windows Cluster in Synchronous mode and Asynchronous mode
Configuring Replication type Transactional Snapshot Merge
Troubleshooting Transaction Replication for Agent failures primary key violation errors adding tables to existing replication monitor troubleshoot through Replication Monitor
Understanding of Advanced SQL Server Architecture Relational Storage Engines
Background process exploration of Checkpoint Lazy writer Eager writer Log Write
Understanding of SQL Server Indexes and data structure level BTree level focus towards Heap Clustered and NonClustered indexes
Diagnosing Server slow Application slow Database slow performance situations
Monitoring and checking top wait types in SQL Server
Resolving Blockings and Deadlocks using Extended Events and giving recommendations on Isolation Levels Indexes to avoid minimize blockings deadlocks
Understanding of Locks also enabling disabling lock escalation on tables as per necessity
Handling space management issues like Log File Full Data File Full TEMPDB Full
Implementing best practices through SQL Server Hardening methods
Exploring new features like Resource Governor Policy Based Management Auditing Transparent Data Encryption Always Encrypted InMemory OLTP Query Store
Desirable Secondary Skills
Experience with other RDBMS databases like DB2 MySQL PostgreSQL etc
Familiarity with database migration tools and ETL processes
Understanding of Database Design and Modelling
Knowledge of Bigdata Azure Azure SQL AWS Cloud
Experience with data warehousing and analytics