Oracle DBA
Network International Payment Solutions
Total des années d'expérience :0 years, 0 Mois
• 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.
Database Management\[ORACLE DBA\]
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.
Project 1Client: Pershing (U.S.A)
RDBMS: SQL Server
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
in
–