Indra Jain Email and Phone Number

Responsible for - Managing complete life cycle of database which involves. 1. Clusterware and Database Installation. 2. Clusterware and Database Creation, Patching and Upgrades.- Keeping database compliance as per PCI DSS standards.- Keeping databases non vulnerable by addressing vulnerabilities on regular basis.- Managing Goldengate services for data replication across data centers.- Migrating data between On-premises databases and AWS RDS instance. - Team management.

Responsible for - Database administration and monitoring for different business verticals across worldpay.- Participate in internal and external PCI audit for Worldpay Total. Fix database vulnerabilities found during audit scan.- DB Migration works.- Analyze and implement database changes of application release for worldpay total.- Create and use knowledge articles.Projects worked on :1. Oracle databases Upgrade.In order to meet PCI compliance in 2016, It was mandatory to upgrade databases running on EOL version 10G to Oracle supported version 11G.2. Database MigrationAs part of consolidation process post merger, Database ( version 11G), running on rented data centers, were to be migrated to worldpay owned data centers with upgraded version (12C).

Integrate Oracle Goldengate with database for data replication. In house production was not coping with data volume. Oracle Goldengate 12C was deployed with bi-direction mapping and used extensive data transformation.

Responsible for - Analyze service requests logged by customer and provide solutions as per severity level.- Write and publish knowledge articles in Oracle Knowledge Base.- Identify and raise the bugs to development team .- Coordinate with teams inside oracle across the globe . - Render training sessions.

Worked as Oracle DBA with two clients.Responsible for database administration.- DB software installation, configuration, patching and upgrading.- Configure and manage standby databases to maintain high availability.- Configuring and implement database backup policy using RMAN.- Restore and Recovery of databases from critical failures. - Plan and execute DR drills.- Manage database security by creating new users, roles, profiles, and provide required user privileges.- Data loading /unloading with oracle utilities – Datapump, Conventional Export/Import.In addition, My responsibilities involves to mentor new team members.