Database Administrator 06/2022 – present
Verimatrix GmbH, Ismaning, Deutschland
- Responsible for handling and governing database versions of Oracle Exadata, Mongo, Oracle, MySQL, PostgreSQL on Linux, Solaris and CentOS platform.
- Hands on experience in Aure Cloud integration with migration.
- Working experience in PL/SQL infrastructure. Performance tuning with modifying different db objects.
- Hands on experience with Integration frameworks offered by OIC to integrate with Oracle Cloud SaaS (ERP, EPM) applications
- End to End Database Migration from On-Prem to Cloud Infrastructure including Virtual Network Design
- Taking part in project implementation meetings, sales and operation of projects within the organisation.
- Responsible for Database Administration, Solution design, Database Migration and manageability
- Installed, configured administration of data replication solutions using Oracle Golden Gate 19C/12C/11g and worked with logdump, blowfish encryption, initial load, performance and tuning.
- Worked on replication and upgrade production databases zero downtime with Oracle Golden Gate.
- Takes care of L3 troubleshooting for Oracle Database 19C/12C/11g, Golden Gate, RAC and Dataguard, Attunity AWS migration tool, Attunity Migration Tool,
- Linux Shell scripts and python programming
- Monitoring and troubleshooting the Single Instance Database and RAC Database Performances through Database Tuning, System Tuning and Application Tuning using EXPLAIN PLAN, STATSPACK, AWR, ADDM, DBMS_SYSTEM, SQL ADVISOR, DBMS_STATS, TKPROF.
Rollout Engineer (Oracle) 01/2021 – 06/2022
European Computers Telecom, München, Deutschland
Client Projects: Deutsche Telekom, Virgin Media, Nokia, DTMS.
- Installed, configured administration of data replication solutions using Oracle Golden Gate 19C/12C/11g and worked with logdump, blowfish encryption, initial load, performance tuning.
- Working and administration of Azure cloud integration.
- In-depth understanding of data structure, joins, indexes for performance tuning.
- Responsible for administration of Oracle Exadata databases and technical troubleshooting.
- Takes care of L3 troubleshooting for Oracle Database 19C/12C/11g, Golden Gate, RAC and Dataguard, Attunity.
- End to End Database Migration from On-Prem to Cloud Infrastructure including Virtual Network Design, routing rules, security groups, Instance creation, and database deployment.
- Knowledge and hands on experience with Integration frameworks offered by OIC to integrate with Oracle Cloud SaaS (ERP, EPM) applications.
- Responsible for Database Administration, Solution design, Database Migration and manageability.
- Worked on replication and upgrade production databases zero downtime with Oracle Golden Gate.
- Takes care of L3 troubleshooting for Oracle Database 19C/12C/11g, Golden Gate, RAC and Dataguard, Attunity AWS migration tool.
- Attunity Migration Tool, Linux Shell scripts for RMAN backup,
- Managing Postgre and mysql database.
Senior Software Engineer (Oracle) 04/2020 – 12/2020
Gemini Solutions, Delhi, IN
Client Project: PIMCO, USA
- Installation and administration of Oracle 12c/11g RAC database and Oracle Exadata. Technical troubleshooting.
- Responsible for database design and database manageability according to clients need.
- Hands on experience working with Oracle Integration Cloud
- Responsible for end to end Oracle ERP Cloud integration project.
- Hands on experience with Integration frameworks offered by OIC to integrate with Oracle Cloud SaaS (ERP, EPM) applications
- Backup and Recovery of RAC database from media failure and instance failures. Tune instance recovery and configuration of RMAN for the RAC environment.
- End to End Database Migration from On-Prem to Cloud Infrastructure including Virtual Network Design, routing rules, security groups, Instance creation, and database deployment.
- Installation and administration of Oracle 12c/11g RAC database on Linux servers’ version 5 and 6.
- Backup and Recovery of RAC database from media failure and instance failures. Tune instance recovery and configuration of RMAN for the RAC environment.
- Analysis Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) for Single Instance Database and RAC Database.
- Installation and administration of Physical Standby Disaster Recovery Databases.
- Hands-on experience in setting up & managing Oracle Standby Databases using RMAN utility and Datapump utility, for both Physical and Logical supported by DATAGUARD.
Senior Software Support Engineer (Oracle) 07/2018 – 03/2020
R Systems, Delhi, IN.
Client Project: Attunity, Israel.
- Perform the proficient role in providing L3 level support, that requires Database Administration, maintenance and troubleshooting on the databases with Oracle releases 10g/11g/12c in 24x7 rotational shift support.
- Working on Oracle Cloud Infrastructure intensively for customers.
- Responsible for end to end Oracle ERP Cloud integration with Integration frameworks offered by OIC to integrate with Oracle Cloud SaaS (ERP, EPM) applications.
- Installation, upgrade and administration of Oracle 11g and 12c databases through GUI &silent mode.
- Installation and administration of Oracle 12c/11g RAC database on
Linux servers’ version 5 and 6.
- Backup and Recovery of RAC database from media failure and instance failures. Tune instance recovery and configuration of RMAN for the RAC environment.
- Monitoring and troubleshooting the Single Instance Database and RAC Database Performances through Database Tuning, System Tuning and Application Tuning using EXPLAIN PLAN, STATSPACK, AWR, ADDM, DBMS_SYSTEM, SQL ADVISOR, DBMS_STATS, TKPROF.
- Performance tuning in single instance and RAC database environment.
- Installation and administration of Physical Standby Disaster Recovery Databases.
- Hands-on experience in setting up & managing Oracle Standby Databases using RMAN utility and Datapump utility for both Physical and Logical supported by DATAGUARD.
- Attending client meetings on webex and over Lync chat call or skype for day to day planning and making strategy to implement it.
- Meeting clients to review SLAs on daily, weekly and monthly basis.
Senior Operation Professional (Oracle) 04/2016 – 06/2018
IBM, Delhi, IN.
Client Project: State Street Corporation, USA.
- Designed, installed, and configured high-performance active/active data replication solutions using Oracle Golden Gate 11g/12c replication for RAC and Standalone Database.
- Administration of Azure Cloud database. Troubleshooting and manageability.
- Responsible for end to end Oracle ERP Cloud integration.
- Experience in Oracle Cloud Integration (OIC) with Oracle SaaS applications.
- Installed, configured and administer oracle cloud grid control 12c and deployed agent monitor targets and setup dynamic group and matrix and polices.
- Linux Shell scripts for RMAN backup, databases and monitor physical standby databases.
- Installation, upgrade and administration of Oracle 11g and 12c databases through GUI &silent mode.
- Monitoring and troubleshooting the Single Instance Database and RAC Database Performances through Database Tuning, System Tuning and Application Tuning using EXPLAIN PLAN, STATSPACK, AWR, ADDM, DBMS_SYSTEM, SQL ADVISOR, DBMS_STATS, TKPROF.
- Performance tuning in single instance and RAC database environment.
- Hands-on experience in setting up & managing Oracle Standby Databases using RMAN utility and Datapump utility for both Physical and Logical supported by DATAGUARD.
Oracle Database Engineer 07/2015– 03/2016
Mahindra Comviva, Delhi, IN.
Client Projects: Reliance, MTS, Russia
- Installation, maintenance and support of Oracle Golden Gate 12c database on the production environment.
- Installation, upgrade and administration of Oracle 11g and 12c databases through GUI & silent mode.
- Installation and administration of Oracle 12c/11g RAC database on Linux servers’ version 5 and 6.
- Backup and Recovery of RAC database from media failure and instance failures. Tune instance recovery and configuration of RMAN for the RAC environment.
- Analysis Automatic Workload Repository (AWR) and Automatic Database Diagnostic Monitor (ADDM) for Single Instance Database and RAC Database.
- Performance tuning in single instance and RAC database environment.
- Installation and administration of Physical Standby Disaster Recovery Databases.
- Hands-on experience in setting up & managing Oracle Standby Databases using RMAN utility and Datapump utility, for both Physical and Logical supported by DATAGUARD.
- Database cloning to a different Unix Server, through user managed cloning, Database Cloning from hot & cold backups, RMAN database cloning to same/different servers.
- Diagnose database & application performance issues and using explain plan, TKPROF, AWR to generate reports for checking Performance.
Senior Associate 03/2013– 03/2014
iGATE, Delhi, IN.
Client Projects: Royal Bank of Canada
- Monitoring and maintaining computer systems and networks.
- Talking staff or clients through a series of actions, either face-to- face or over the telephone, to help set up systems or resolve issues.
- Proactively Monitoring file system growth, Alert Log and Archive Destination.
- Taking HOT and COLD backups using RMAN.
- Database cloning to a different Unix Server, through user managed cloning, Database Cloning from hot & cold backups, RMAN database cloning to same/different servers.
- Diagnose database & application performance issues and using explain plan, TKPROF, AWR to generate reports for checking Performance.
Client Technical Support Associate 11/2011– 02/2013
Dell, Delhi, IN.
Client Projects: Dell
- Proactively Monitoring file system growth, Alert Log and Archive Destination.
- Taking HOT and COLD backups using RMAN.
- Installing and configuring computer hardware operating systems and applications.
- Monitoring and maintaining computer systems and networks.
