Edwin Jerome M

Experience

• 

  Solvo Soft

  Feb 2009 - Sept 2011

  Database Administrator
• 

  Secure-IQ

  Sept 2011 - May 2012

  Database Administrator
• 

  Infosys

  May 2012 - Mar 2018

  • Technology Specialist

    Apr 2017 - Mar 2018

  • Technology Analyst

    Jul 2014 - Apr 2017

  • Senior System Engineer

    May 2012 - Jul 2014
• 

  Tata Consultancy Services

  Mar 2018 - now

  DATABASE MIGRATION===============Successfully conducted over 200 database migrations using Oracle Golden Gate, ensuring zero downtime for mission-critical systems.Migrated large databases of 100TB, 200TB, and 300TB using Transportable Tablespace (TTS) and Cross-Platform Transportable Tablespace (XTTS) methods.Performed migrations of over 100+ Oracle databases to PostgreSQL using the EDB Migration Toolkit, ensuring smooth and efficient transitions.Led onsite as Technical Lead for the migration of 2000+ databases from Oracle 12c to Oracle 19c, managing the entire process from planning to execution.Configured and managed Oracle GoldenGate downstream processes in a 4-node RAC environment, ensuring seamless real-time replication.Executed end-to-end database migrations, ensuring smooth, efficient, and reliable upgrades from Oracle 12c to Oracle 19c across multiple platforms. Show less SENIOR DATABSE ADMINISTRATOR:ORACLE DATABASE ADMINISTRATION=========================Led end-to-end deployment of Oracle database servers with OEM 13c and upgraded 11g databases to 12c in both standalone and RAC environments. Also migrated the database from 12c to 19c Environments.Performed L3 database administration tasks, including performance tuning, troubleshooting, and database refreshes using RMAN for single-instance and RAC setups.Implemented high-availability solutions utilizing Oracle Data Guard to ensure business continuity.MSSQL DATABASE ADMINISTRATION========================Upgraded production MSSQL clusters from 2008R2 to 2012SP2, installed MSSQL versions 2008R2, 2012SP2, and 2014, and configured AAG (Always On Availability Group) on SQL Server 2012 in both standalone and WSFC cluster environments.Implemented and managed SQL Server mirroring solutions, SCOM monitoring tools, and performed backup and restoration of SQL databases.Troubleshoot SQL Server failover clusters and handle daily operational tasks.POSTGRESQL DATABASE ADMINISTRATION============================Installed PostgreSQL versions 8.4, 9.x, 11.x, 12.x, and 14 on Linux servers, and upgraded databases from 8.4 to 9.2 and from PG11 to PG14.Configured streaming replication and implemented backup and restoration operations using BART/BARMAN for PostgreSQL databases.Performed point-in-time recovery for PostgreSQL databases in production environments.MySQL DATABASE ADMINISTRATION========================Installed MySQL 5.7 on Linux servers and created/configured MySQL databases and users.Set up and configured disaster recovery (DR) solutions and MySQL Enterprise Monitor with email notifications.Performed database backup and restoration using export and import operations. Show less

  • Associate Consultant

    Jan 2025 - now

  • Assistant Consultant

    Mar 2018 - Dec 2024