Kushal Ratnaker

Database installation, configuration, and administration. Database monitoring and tuning.

Database and application incident management.

Backup and restore of Databases.

Access management.

Writing and review documentation of database and application procedures.

Maintain, testing and implement disaster recovery plans.

Provide quality support and guidance to IT members.

Coordination of database and application support.

Ensures the coherence of locally developed solutions with the IT infrastructure in place.

Implements and applies the security rules and procedures in place in the Agency to ensure the integrity, availability

and confidentiality of data.

Install security and critical patches.

Configured Data guard broker between the primary and standby databases, perform Switchover/Failover and monitor

the data guard status via DGMGRL and GUI.

Architecture and design of Web logic infrastructure with cluster.

Technical interface between developers, project managers and infrastructure.

Assist testing phases of applications.

Assist technical documentation and reporting.

Deployment and troubleshooting of JAR, WAR, and EAR files in domain and clustered environments.

implementation and administration of Oracle Golden Gate Microservices architecture for real-time data replication and

integration across multiple environments.

EACEA, European Commission Database installation, configuration, and administration. Database monitoring and tuning. Database and application incident management. Backup and restore of Databases. Access management. Writing and review documentation of database and application procedures. Maintain, testing and implement disaster recovery plans. Provide quality support and guidance to IT members. Coordination of database and application support. Ensures the coherence of locally developed solutions with the IT infrastructure in place. Implements and applies the security rules and procedures in place in the Agency to ensure the integrity, availability and confidentiality of data. Install security and critical patches. Database upgradation from 12c R1 to Oracle 19c R1 using Auto Upgrade tool and 11g R2 to 12c R1 . Troubleshooting oracle CDC issues. Configured Data guard broker between the primary and standby databases, perform Switchover/Failover and monitor the data guard status via DGMGRL and GUI. Architecture and design of Web logic infrastructure with cluster. Technical interface between developers, project managers and infrastructure. Assist testing phases of applications. Assist technical documentation and reporting. Deployment and troubleshooting of JAR, WAR, and EAR files in domain and clustered environments. Upgradation of WebLogic servers in development, testing and production environment. Create, configure and tune web logic domains/applications for performance. JDBC Connection Pool configuration with Oracle. Troubleshooting, Load Balancing, Clustering, Deploying Applications, Performance Tuning and Maintenance.

CITI Bank Mexico Created RAC databases as per the client requirement in a 2-node cluster environment. Relocating services from Standby database to Primary database before bounce the standby database. CRS_STAT to collect statistics of nodes and services running on Clustered Database. Performed troubleshooting in ASM environment. Performed health checks in RAC instances using Crsctl and Srvctl utility. I have good knowledge on applying patches on Grid home and RDBMS home in rolling fashion method. Bounce the RAC databases in rolling fashion while applying OS patch and Server reboot. Designed backup and recovery strategy for dev/test and prod databases. Performance tuning for critical oracle databases. Resolving incidents for critical production issues.