Overview:

Oracle with MsSQL Database administration

Responsibilities:

Oracle DBA:

Install, configure, and upgrade Oracle database software.

Apply quarterly patches for Grid and Oracle home

Configure and maintain standby database.

Monitor database performance and implement optimization strategies.

Ensure database security and compliance with organizational policies.

Perform regular backups and recovery operations.

Collaborate with developers to design and implement database solutions.

Troubleshoot and resolve database-related issues promptly.

Develop and maintain database documentation and standards.

Plan and execute database migrations and upgrades.

Setup Oracle golden gate both uni-directional and bidirectional.

Maintain Oracle Golden Gate synchronization with source.

Identify the Oracle Golden Gate sync related issues and implement the best practices.

Identify the performance issues and implement the best practices.

User creation and access management.





Storage capacity planning to ensure ASM and tablespace were maintained under threshold and avoided repetitive space related incidents.

Create and maintain RAC with Data guard.

Administration of RAC database.

AWS RDS instance administration, Rehydration, engine upgrade and certificate renewal

MsSQL DBA:

Manage SQL Server databases

Configure and maintain database servers and processes

Monitor system’s health and performance

Ensure high levels of performance, availability, sustainability and security

Analyze, solve, and correct issues in real time

Provide suggestions for solutions

Refine and automate regular processes, track issues, and document changes

Assist developers with query tuning and schema refinement

Provide 24×7 support for critical production systems

Perform scheduled maintenance and support release deployment activities after hours

Respond to alerts and incidents promptly to minimize service disruptions.

Collaborate with Level 1 and Level 2 support and other teams to address escalated incidents.

📌 Senior Software Engineer-Oracle-MsSQL (Guindy)
🏢 Prodapt
📍 Guindy