Database Administrator

• Aug 2023 - Present

Oracle GoldenGate Administrator

• Apr 2021 - Oct 2022

• Worked with clients, system admins, and developers to define information flow helping to transform business requirements into the environment-specific database. • Experienced working with multiple development methodologies such as Agile. • Upgrading Mobila Modernization project from 12c to 19c. • Installed and configured of GoldenGate on 19c database for data replication. • Setup goldengate during database migration from UNIX to Linux server. Analyzed database requirements… Show more • Worked with clients, system admins, and developers to define information flow helping to transform business requirements into the environment-specific database. • Experienced working with multiple development methodologies such as Agile. • Upgrading Mobila Modernization project from 12c to 19c. • Installed and configured of GoldenGate on 19c database for data replication. • Setup goldengate during database migration from UNIX to Linux server. Analyzed database requirements for developers and business system analysis. • Involved in database troubleshooting and maintenance activities and solved Goldengate issues such like abend, lagging, long transaction issues. • Resolved the issues in conflicts between the target and source database in Goldengate. • Good understating of GG monitoring via GG Monitor and Veridata. • Installed and configure Oracle Goldengate 19c and implemented DDL and Bi-directional replication. • Experienced in Oracle 11g, 12c, 18c, and 19c architecture. • Good Experience in implementing Goldengate classic architecture homogeneous, heterogeneous, and replicating databases using the goldengate and implemented unidirectional and Bi-directional, Peer-To- Peer replication on oracle databases. • Installed and configured Goldengate Jagent to work with OEM GoldenGate Plugin. • Good knowledge of Goldengate microservices 21c. • Created database links to retrieve data from multiple servers. • Performed Schema level and Table level data refreshes from production to QA/Dev environments using Datapump EXPDP/IMPDP. • Automated manual DBA tasks by writing UNIX Shell Scripting, Oracle PL/SQL language and Implemented UNIX Scripts using CRONJOB for daily activities and Windows Task Scheduler. Show less • Worked with clients, system admins, and developers to define information flow helping to transform business requirements into the environment-specific database. • Experienced working with multiple development methodologies such as Agile. • Upgrading Mobila Modernization project from 12c to 19c. • Installed and configured of GoldenGate on 19c database for data replication. • Setup goldengate during database migration from UNIX to Linux server. Analyzed database requirements… Show more • Worked with clients, system admins, and developers to define information flow helping to transform business requirements into the environment-specific database. • Experienced working with multiple development methodologies such as Agile. • Upgrading Mobila Modernization project from 12c to 19c. • Installed and configured of GoldenGate on 19c database for data replication. • Setup goldengate during database migration from UNIX to Linux server. Analyzed database requirements for developers and business system analysis. • Involved in database troubleshooting and maintenance activities and solved Goldengate issues such like abend, lagging, long transaction issues. • Resolved the issues in conflicts between the target and source database in Goldengate. • Good understating of GG monitoring via GG Monitor and Veridata. • Installed and configure Oracle Goldengate 19c and implemented DDL and Bi-directional replication. • Experienced in Oracle 11g, 12c, 18c, and 19c architecture. • Good Experience in implementing Goldengate classic architecture homogeneous, heterogeneous, and replicating databases using the goldengate and implemented unidirectional and Bi-directional, Peer-To- Peer replication on oracle databases. • Installed and configured Goldengate Jagent to work with OEM GoldenGate Plugin. • Good knowledge of Goldengate microservices 21c. • Created database links to retrieve data from multiple servers. • Performed Schema level and Table level data refreshes from production to QA/Dev environments using Datapump EXPDP/IMPDP. • Automated manual DBA tasks by writing UNIX Shell Scripting, Oracle PL/SQL language and Implemented UNIX Scripts using CRONJOB for daily activities and Windows Task Scheduler. Show less

Database Administrator

• May 2018 - Sep 2019

• Experienced as On-Call 24x7 production DBA support. • Worked with clients, system admins, and developers to define information flow helping to transform business requirements into the environment-specific database. • Well versed with different topologies of GoldenGate implementation. • Planned and upgraded databases using Patch Set Updates (PSU). • Performed Zero Downtime migrations from Non Exadata machines to Exadata machines using Oracle GoldenGate. • Monitored and… Show more • Experienced as On-Call 24x7 production DBA support. • Worked with clients, system admins, and developers to define information flow helping to transform business requirements into the environment-specific database. • Well versed with different topologies of GoldenGate implementation. • Planned and upgraded databases using Patch Set Updates (PSU). • Performed Zero Downtime migrations from Non Exadata machines to Exadata machines using Oracle GoldenGate. • Monitored and performance tuning of Goldengate sessions at Database level and GGSCI level and investigated failures using ggserr.log, report files, and LogDump utility. • Upgraded Oracle Goldengate from 11gR2 to 12c, implemented OGG 12c new features in mission-critical production environment. • Maintained Oracle Database and PL/SQL Code used to enhance features for Billing Systems. • Responsible for the creation and management of users, roles, profiles, and privileges. • Created primary structures such as tablespaces, tables, views, and indexes. • Increased department-wise utilization and productivity by 15%. Show less • Experienced as On-Call 24x7 production DBA support. • Worked with clients, system admins, and developers to define information flow helping to transform business requirements into the environment-specific database. • Well versed with different topologies of GoldenGate implementation. • Planned and upgraded databases using Patch Set Updates (PSU). • Performed Zero Downtime migrations from Non Exadata machines to Exadata machines using Oracle GoldenGate. • Monitored and… Show more • Experienced as On-Call 24x7 production DBA support. • Worked with clients, system admins, and developers to define information flow helping to transform business requirements into the environment-specific database. • Well versed with different topologies of GoldenGate implementation. • Planned and upgraded databases using Patch Set Updates (PSU). • Performed Zero Downtime migrations from Non Exadata machines to Exadata machines using Oracle GoldenGate. • Monitored and performance tuning of Goldengate sessions at Database level and GGSCI level and investigated failures using ggserr.log, report files, and LogDump utility. • Upgraded Oracle Goldengate from 11gR2 to 12c, implemented OGG 12c new features in mission-critical production environment. • Maintained Oracle Database and PL/SQL Code used to enhance features for Billing Systems. • Responsible for the creation and management of users, roles, profiles, and privileges. • Created primary structures such as tablespaces, tables, views, and indexes. • Increased department-wise utilization and productivity by 15%. Show less

Associate Database Administrator

• May 2016 - Apr 2018

• Developed and participated in database upgrade and patching. • Developed and worked in a RAC environment and also experienced in DataGuard. • Created database installations on client machine/server and handled overseas operations. • Hands-on experience in planning, designing, cloning, and refresh using ACTIVE, Manual, and RMAN. Oracle Backups and Recovery tasks such as complete/incomplete recovery block recovery, export/import logical and physical backup. • Checked and monitored… Show more • Developed and participated in database upgrade and patching. • Developed and worked in a RAC environment and also experienced in DataGuard. • Created database installations on client machine/server and handled overseas operations. • Hands-on experience in planning, designing, cloning, and refresh using ACTIVE, Manual, and RMAN. Oracle Backups and Recovery tasks such as complete/incomplete recovery block recovery, export/import logical and physical backup. • Checked and monitored the database’s performance every day and took preventive or corrective action. Show less • Developed and participated in database upgrade and patching. • Developed and worked in a RAC environment and also experienced in DataGuard. • Created database installations on client machine/server and handled overseas operations. • Hands-on experience in planning, designing, cloning, and refresh using ACTIVE, Manual, and RMAN. Oracle Backups and Recovery tasks such as complete/incomplete recovery block recovery, export/import logical and physical backup. • Checked and monitored… Show more • Developed and participated in database upgrade and patching. • Developed and worked in a RAC environment and also experienced in DataGuard. • Created database installations on client machine/server and handled overseas operations. • Hands-on experience in planning, designing, cloning, and refresh using ACTIVE, Manual, and RMAN. Oracle Backups and Recovery tasks such as complete/incomplete recovery block recovery, export/import logical and physical backup. • Checked and monitored the database’s performance every day and took preventive or corrective action. Show less

Junior Database Administrator

• Aug 2014 - Mar 2016

Key Responsibilities -Responsible for creating and managing tablespace and datafiles. -Installed, configured and managed database in UNIX/LINUX environments. -Maintained and updated the database schemas (Like schemas refresh) as requested by the Lead Oracle DBA. -Performed on request of change release upgrade. Key Responsibilities -Responsible for creating and managing tablespace and datafiles. -Installed, configured and managed database in UNIX/LINUX environments. -Maintained and updated the database schemas (Like schemas refresh) as requested by the Lead Oracle DBA. -Performed on request of change release upgrade.