Total Years of Experience: None
January 2017
To Present
Oracle DBA
at Network International Payment Solutions
Location :
United Arab Emirates - Dubai
• RMAN backups.
• Installation of Oracle Softwares 11g & 12c binary and grid &18c, 19c and build the databases.
• DB cloning using hot backup and cold backup.
• Database upgradation (11g to 12c) & (11203 to 11204).
• Worked with Application and sustain teams.
• Administration of Real Application Cluster (RAC) 11g and 12c environments.
• Monitoring tablespace growth & ASM diskgroup creation and addition.
• Working with storage team for database snap refresh and renaming the database.
• Involved for DR Drill Activity.
• Configured OEM.
• Performance tuning.
• Pre prod database refresh using Rman, delphix tool & network tool and Bamboo.
• Monitoring Storage Space in file systems.
• Scheduling and managing Backup and Gather stats thru crontab and Bamboo.
• Giving Support for production changes following with change request Management.
• .Created Wallet Encryption for databases.
• Database patching for RAC And Non RAC Environment.
• Database refresh using datapump.
• Worked with oracle SR for severity 1 then fixed the issue.
• Installation of Oracle Softwares 11g & 12c binary and grid &18c, 19c and build the databases.
• DB cloning using hot backup and cold backup.
• Database upgradation (11g to 12c) & (11203 to 11204).
• Worked with Application and sustain teams.
• Administration of Real Application Cluster (RAC) 11g and 12c environments.
• Monitoring tablespace growth & ASM diskgroup creation and addition.
• Working with storage team for database snap refresh and renaming the database.
• Involved for DR Drill Activity.
• Configured OEM.
• Performance tuning.
• Pre prod database refresh using Rman, delphix tool & network tool and Bamboo.
• Monitoring Storage Space in file systems.
• Scheduling and managing Backup and Gather stats thru crontab and Bamboo.
• Giving Support for production changes following with change request Management.
• .Created Wallet Encryption for databases.
• Database patching for RAC And Non RAC Environment.
• Database refresh using datapump.
• Worked with oracle SR for severity 1 then fixed the issue.
January 2017
To Present
DBA
at ORACLE
Location :
United Arab Emirates
July 2013
To August 2015
Technical Lead
at Inautix Technologies India Pvt Ltd(BNY MELLON)
Location :
India
Database Management\[ORACLE DBA\]
February 2008
To August 2015
PROJECT DETAILS
at Network International Payment Solutions LLC
Location :
United Arab Emirates
February 2010
To June 2013
Senior Database Administrator
at Inautix Technologies India Pvt Ltd
Location :
India
Project 2 Client : Bank of Newyork Mellon (U.S.A)
RDBMS: Oracle 10g, 11g, 12c, Sql Server 2012
Operating System : Sun Solaris, AIX, Windows XP, 2008
Responsibilities:
•Taking backups and moving the backup copies and archived logs to the backup destination, periodically clearing the archived log files.
•Used diagnostic tools like AWR, statspack, explain plan, sqltrace with tkprof and autotrace, Log monitoring and managing RAC nodes.
•Assign routing protocols and routing table configuration
•Responsible for administrating Single instance databases and administrating ASM.
•Managing physical standby database.
•Working as an Oracle 9i and 10g, 11g databases administrator with UNIX environment
•Successfully Performed data Backups, Restore/Recovery activity on many critical production databases with and without using RMAN.
•Successfully recovered more corrupted blocks from the database with and without using RMAN.
•Review the DB Objects like Triggers, PL/SQL Codes.
•Creating Tables, Constraints, Sequences, Indexes and etc.
•Impact analysis due to table changes.
•Change Control.
•Working with PL/SQL, Cognos and Weblogic team and support them in need basis.
•MS SQL Server 2012 Installation, Cloning, Job Schedulling &Trouble shooting.
•Applied DDL & DML Changes on Development, QA, UAT, XAT & PROD Region on SQL Server.
•Worked with Onsite DBA, Sustain DBA.
RDBMS: Oracle 10g, 11g, 12c, Sql Server 2012
Operating System : Sun Solaris, AIX, Windows XP, 2008
Responsibilities:
•Taking backups and moving the backup copies and archived logs to the backup destination, periodically clearing the archived log files.
•Used diagnostic tools like AWR, statspack, explain plan, sqltrace with tkprof and autotrace, Log monitoring and managing RAC nodes.
•Assign routing protocols and routing table configuration
•Responsible for administrating Single instance databases and administrating ASM.
•Managing physical standby database.
•Working as an Oracle 9i and 10g, 11g databases administrator with UNIX environment
•Successfully Performed data Backups, Restore/Recovery activity on many critical production databases with and without using RMAN.
•Successfully recovered more corrupted blocks from the database with and without using RMAN.
•Review the DB Objects like Triggers, PL/SQL Codes.
•Creating Tables, Constraints, Sequences, Indexes and etc.
•Impact analysis due to table changes.
•Change Control.
•Working with PL/SQL, Cognos and Weblogic team and support them in need basis.
•MS SQL Server 2012 Installation, Cloning, Job Schedulling &Trouble shooting.
•Applied DDL & DML Changes on Development, QA, UAT, XAT & PROD Region on SQL Server.
•Worked with Onsite DBA, Sustain DBA.
February 2008
To January 2010
Database Administrator
at Inautix Technologies India Pvt Ltd
Location :
India
Project 1Client: Pershing (U.S.A)
RDBMS: SQL Server
RDBMS: SQL Server
January 2000
To January 2005
ORACLE DBA
at Network International Payment Solutions LLC
Location :
United Arab Emirates
DBA 9i, 10g, 11g, 12c, 18c, 19c
•Management (10+ Years Experience)
•Using Export, Import utility
•ExportDataPump,
•ImportDataPump.
•Cold Backup - Hot Backup
•Recovery manager-RMAN
•RAC, Data Guard, Delphix, Golden Gate
•SQL* Loader, DBV utility
•Oracle Cloud (AWS).
•Flashback Database
•DBLINK, Materialized View, Performance Tuning
•Partition Table
•Cloning Database
•AWR $ ADDM, ASH, OEM
•DBNEWID, CSSCAN utility
•DB Artision tool, SQL Back track
•Sql Server
•Management (10+ Years Experience)
•Using Export, Import utility
•ExportDataPump,
•ImportDataPump.
•Cold Backup - Hot Backup
•Recovery manager-RMAN
•RAC, Data Guard, Delphix, Golden Gate
•SQL* Loader, DBV utility
•Oracle Cloud (AWS).
•Flashback Database
•DBLINK, Materialized View, Performance Tuning
•Partition Table
•Cloning Database
•AWR $ ADDM, ASH, OEM
•DBNEWID, CSSCAN utility
•DB Artision tool, SQL Back track
•Sql Server
Share on Facebook
Share on Twitter
Share Via Email