وظائف Gerab System Solutions LLC

<section><p class="heading jdMain">Job Description</p><p class="heading">Roles &amp; Responsibilities</p><div class="paragraph"><p>We are seeking an experienced Senior Oracle Core Database Administrator with over 10 years of hands-on experience in designing, implementing, administering, upgrading, troubleshooting, and optimizing enterprise Oracle database environments. The ideal candidate must possess strong expertise in Oracle Database 19c, Oracle RAC, Oracle Data Guard with Fast-Start Failover (FSFO), Oracle GoldenGate Microservices 23ai, Oracle Enterprise Manager (OEM) 24ai, Oracle Audit Vault, database performance tuning, automation, and high availability solutions supporting mission-critical production environments.</p><p><strong>Key Responsibilities</strong></p><p><br></p><ul><li><p>Install, configure, administer, upgrade, migrate, patch, troubleshoot, and maintain Oracle Database 19c environments across Production, DR, UAT, QA, and Development.</p></li><li><p>Install, configure, administer, and support Oracle RAC 19c, Oracle Grid Infrastructure, and Oracle ASM.</p></li><li><p>Design, implement, administer, monitor, and troubleshoot Oracle Data Guard environments, including Active Data Guard, Data Guard Broker, Fast-Start Failover (FSFO), Switchover, Failover, and Disaster Recovery testing.</p></li><li><p>Install, configure, administer, monitor, and troubleshoot Oracle GoldenGate Microservices 23ai Hub architecture for Production and Disaster Recovery environments, including automatic failover, automatic detection of new primary databases following Data Guard role transitions, and continuous replication with minimal downtime.</p></li><li><p>Install, configure, administer, and monitor Oracle Enterprise Manager (OEM) 24ai for databases, RAC, ASM, Data Guard, GoldenGate, and infrastructure components, including alerting, incident management, compliance monitoring, reporting, and proactive health monitoring.</p></li><li><p>Perform Oracle database performance analysis and tuning by identifying and resolving database, SQL, PL/SQL, storage, memory, I/O, ASM, RAC, and application performance bottlenecks using AWR, ASH, ADDM, SQL Tuning Advisor, SQL Monitor, execution plans, optimizer statistics, and performance diagnostics to ensure optimal database performance and availability.</p></li><li><p>Develop advanced SQL, PL/SQL, Shell scripting, and automation solutions for database administration, health checks, monitoring, reporting, backup validation, maintenance activities, and operational efficiency.</p></li><li><p>Perform database cloning, refresh, migration, backup, recovery, logical export/import, and database refresh activities using RMAN, EXPDP, and IMPDP.</p></li><li><p>Plan and execute Oracle Release Updates (RU), OJVM patches, Grid Infrastructure patching, one-off patches, database upgrades, and security patching while minimizing business downtime.</p></li><li><p>Troubleshoot complex Oracle Database, RAC, ASM, Data Guard, GoldenGate, OEM, Audit Vault, and performance-related issues, perform root cause analysis (RCA), and coordinate with Oracle Support through Service Requests (SRs) to resolve critical production incidents.</p></li><li><p>Perform application data analysis, validation, verification, reconciliation, and integrity checks within the Oracle database to ensure data consistency and accuracy.</p></li><li><p>Prepare and maintain comprehensive technical documentation including Standard Operating Procedures (SOPs), installation guides, configuration documents, implementation plans, migration runbooks, rollback procedures, operational manuals, architecture diagrams, disaster recovery procedures, health check reports, RCA reports, patching and upgrade documentation, knowledge transfer documents, and other project deliverables as required by the customer.</p></li><li><p>Collaborate with application, infrastructure, network, storage, and security teams to deliver highly available, secure, and optimized database solutions while adhering to project timelines and service level agreements.</p></li><li><p>Participate in project planning, technical workshops, architecture reviews, change management, risk assessment, implementation planning, and production cutover activities.</p></li><li><p>Provide 24×7 production support and participate in planned maintenance, emergency support, and non-business-hour activities whenever required.</p></li></ul><p><strong>&nbsp;</strong></p><p><strong>Additional Professional Requirements</strong></p><p><br></p><ul><li><p>Excellent customer-facing, communication, presentation, and stakeholder management skills with the ability to interact confidently with technical teams, management, and business users.</p></li><li><p>Strong analytical and problem-solving skills with the ability to perform effectively under pressure and manage multiple critical priorities simultaneously.</p></li><li><p>Ability to understand customer business requirements and translate them into practical technical solutions while communicating effectively with both technical and non-technical stakeholders.</p></li><li><p>Professional attitude, strong business etiquette, customer service orientation, and the ability to represent the organization during customer meetings, workshops, audits, and onsite.</p></li><li><p>Demonstrated ability to work independently as well as within cross-functional teams while maintaining high standards of quality, documentation, and customer satisfaction.</p></li><li><p>Willingness to provide after-hours, weekend, holiday, and emergency support whenever required to maintain business continuity and meet SLA commitments.</p></li></ul></div></section><section><p class="heading">Desired Candidate Profile</p><p class="paragraph"></p><p><strong>Experience:</strong> 10+ Years in Core Oracle Apps DBA</p><br><p><strong>Required Technical Skills</strong><br></p><ul><li><p>Oracle Database 19c Administration</p></li><li><p>Oracle RAC 19c</p></li><li><p>Oracle Grid Infrastructure and ASM</p></li><li><p>Oracle Data Guard and Active Data Guard</p></li><li><p>Data Guard Broker with Fast-Start Failover (FSFO)</p></li><li><p>Oracle GoldenGate Microservices 23ai Hub Architecture</p></li><li><p>Oracle Enterprise Manager (OEM) 24ai</p></li><li><p>Oracle RMAN Backup and Recovery</p></li><li><p>Oracle Data Pump (EXPDP/IMPDP)</p></li><li><p>SQL, PL/SQL, and Shell Scripting</p></li><li><p>Oracle Database Performance Tuning (AWR, ASH, ADDM, SQL Tuning)</p></li><li><p>Linux / Oracle Linux Administration</p></li><li><p>Database Cloning and Migration</p></li><li><p>Automation and Scripting<br></p></li></ul><p><strong>Certifications (Mandatory)</strong><br></p><ul><li><p>Oracle Certified Associate (OCA) – Oracle Database 19c Administrator</p></li><li><p>Oracle Certified Professional (OCP) – Oracle Database 19c Administrator</p></li></ul><p></p></section>