Experience

EAGLE.bank

• United States
• Banking
• 1 - 100 Employee

• DBA

  • Sep 2020 - Present

  Worked as a team member for 24x7 support with on call rotation in all prod, QA and dev environments. • Setup New databases on Clustered and Non-clustered environment and Implemented Maximum Availability Architecture using RAC, DATAGUARD and Golden Gate • Upgrade 11g RAC to 12c RAC and Administering the RAC Environment through SRVCTL and CRSCTL and applied patches in rolling fashion. • Worked on 12c RAC new builds and administering 12c RAC and managed ASM on RAC • Creating Volume and Configured ACFS on ASM diskgroup and extensively worked on creation oracle Databases with ASM filesystem. • Configured diskgroups with different redundancy levels and created fail groups and managing and tuning ASM parameters • Configuration & Troubleshooting the Oracle Dataguard & GoldenGate environment in Oracle 11g & 12c versions. • configured Oracle Golden Gate 11g, Implemented uni-directional and bi-directional replication. • Full database, Schema refresh using RMAN, Datapump and Implemented the Backup strategies using RMAN catalog and nocatalog methods. • Setting up of Oracle and Application user accounts and passwords, monitoring application security. • Proficient in Oracle High Availability features like RAC, DATA GUARD, GRID CONTROL • Responsible to improve the performance by Using the Hints, Indexes, Explain Plan. • Proficient with Oracle Performance Tuning Utilities like ADDM, AWR, ASH, SQL-Tuning Advisor, DBV, ESTIMATE, ANALYSE, SQLTRACE, and TKPROF and gathered DBMS statistics. • Performed Data file recovery from logical and physical block corruptions. • Configured RAC database with 4 nodes. Implemented Data Guard, Physical and logical Stand by databases to ensure high availability, data protection and disaster recovery. • Experience working with SQL, PL/SQL, stored procedures, functions, packages, triggers. • Work with Oracle Data Pump (expdp and impdp) which provides high speed, parallel, bulk data and metadata movement of Oracle database contents. Show less



TD

• Pakistan
• Technology, Information and Media
• 1 - 100 Employee

• Oracle Database Administrator

  • Jan 2018 - Sep 2021

  Supported multiple databases for production, development, test and staging purposes on Sun Solaris, Linux, and Windows environments. Installed, configured, Maintained, Upgraded and Supported Oracle 11g and 12c Databases. Managed and monitored databases using OEM grid. Applied the Database (RDBMS) Patches, PSU patches and one-off patches for Bug resolution using opatch utility. Proficient with Veritas/NetBackup storage systems Shell scripting for post and pre-validation automation for the ansible team. Cloned/Migrated databases using RMAN and traditional Datapump export/import utilities in Oracle 10gR2. Implemented recovery strategies whenever required and successfully recovered databases in case database crash, media/disk failures by using RMAN. Scheduling the Physical backups (hot & cold) in CRON tab using RMAN utility and monitoring the scheduled repetitive activities like gathering schema statistics, exports, tablespace usage report. Installation, configuration, upgrade, and performance tuning of Oracle 12c, 10g, 11g RAC. Installed and configured oracle Grid control (12c and 11g) . Upgraded/Migration of Databases from Oracle 9i to 10g, 10g to 11g and 11g to 12c. Responsible for Creating Users, Groups, Roles, Profiles and assigning the users to groups and grant necessary privileges to the relevant groups. Performed database real-time replication through Golden Gate. Built Oracle Standby databases, both Active Dataguard for real-time replication and normal Dataguard for disaster recovery also referred as BCP clone purposes. Migrated Oracle databases 11g (11.2.0.4) from Linux Boxes to EXADATA machine using data guard switchover and Export & Import. Refreshed Dev and Test instances with data from Production on a regular basis. Developed PL/SQL packages, DML, DDL, Oracle tables, Stored Procedures, functions, cursors, triggers and UNIX shell scripts. Provided instance level performance monitoring and tuning for Event Waits, Blocking Sessions, Show less