Edwin Jerome M

Edwin Jerome M

Database Administrator

Followers of Edwin Jerome M616 followers
location of Edwin Jerome MHelsingborg, Skåne County, Sweden

Connect with Edwin Jerome M to Send Message

Connect

Connect with Edwin Jerome M to Send Message

Connect
  • Timeline

  • About me

    Senior Database Engineer | Database Migration | Oracle DBA | PostgreSQL DBA | MSSQL DBA | MySQL DBA

  • Education

    • MSP Solai Nadar Memorial higher secondary School

      2000 - 2004
      High School Mathematics First Class
    • Anna University Chennai

      2004 - 2008
      Bachelor's Degree EEE First Class

      Activities and Societies: NSS Team In College

  • 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
  • Licenses & Certifications

    • MCPS: Microsoft Certified Professional

      Microsoft
      Jan 2014
      View certificate certificate
    • Oracle Cloud Infrastructure 2019 Cloud Operations Certified Associate

      Oracle
      Jul 2020
      View certificate certificate
    • MCITP: Database Administrator 2008

      Microsoft
      May 2014
      View certificate certificate
    • EDB Postgres® AI Factory Workshop Certified

      ENTERPRISEDB SOFTWARE INDIA PRIVATE LIMITED
      Nov 2025
      View certificate certificate
    • Professional Cloud Architect

      Google Cloud
      Dec 2023
      View certificate certificate
    • Oracle Database 11g Administrator Certified Associate

      Oracle
      Oct 2015
      View certificate certificate
    • AWS Certified Solutions Architect - Associate

      Amazon Web Services (AWS)
      Dec 2019
    • Oracle Autonomous Database Cloud 2019 Certified Specialist

      Oracle
      Jul 2020
      View certificate certificate
    • MCTS: SQL Server 2008, Implementation and Maintenance

      Microsoft
      Mar 2014
      View certificate certificate
    • Oracle Cloud Infrastructure 2019 Cloud Operations Certified Associate

      Oracle
      Jul 2020
      View certificate certificate