Advanced Database Administrator
Walmart Global Technology Pvt Ltd
مجموع سنوات الخبرة :18 years, 10 أشهر
Responsibilities:
1) Supporting databases of Walmart tenants ( USGM, ASDA, Sams Club and GM Canada).
2) Supporting application stress test as part of holiday readiness.
3) Involved in database tunings for new systems before go-live to meet service SLAs.
4) Performed database switch over and make sure application is working seamlessly without any interruptions.
5) Setup golden gate replication for BI reporting.
6) GG upgradation.
7) Switchover involving Golden gate.
8)Configured standby db for critical db’s using broker.
9) Supporting Netezza/Cassandra and Greenplum db’s.
10)DB migration from standalone to RAC along with Golden gate.
11)Performance tuning of Golden gate replicat processes.
12)Fixing Golden gate issues.
Responsibilities:
1) Support almost all kind of oracle environments with 2-5 Node RAC, standalone and RAC standby’s.
2) Databases from oracle 8i to oracle 11g on Linux/Solaris/HPUX.
3) Performed RAC, DG and 11gR2 RAC (Grid Infra) installations/configuration.
4) Configured Active Data Guard in 11g RAC/standalone.
5) Worked on several Outages to quickly bring back the prod environment online with minimum downtime.
6) Performed upgradation and patching activities, applied base patches as well as PSU’s.
7) Have configured 11gR2 grid infra with RAC/standalone and have installed both 11g/10g RDBMS over it.
8) Have configured ASM using both ASMLIB disk paths as well as direct LUN’s.
9) Knowledge on Golden Gate and its implementation.
10) Have fixed table/index fragmentation issue.
11) Performance tuning of the database..
12) Database cloning ( RMAN duplicate/ Manual )
13) Maintaining standby databases and applying incremental backup’s when archive logs are missing at the primary site.
14) Performed switch over of databases during DR drill.
15) Managing Cold and Hot Backups, database export and imports & perform database maintenance.
16) Other regular Day to Day DBA activities like space management, handling user requests, acting on monitoring alerts, deployments and weekend maintenance activities.
17) Coordinate with onsite DBA’s, attend client meetings and transitions.
Responsibilities:
1) Installation of Oracle software.
2) Handling user raised calls.
3) Creating tablespaces and managing it.
4) Resolving Ora-7445/Ora-600 error.
5) Applying CPU and Patchset.
6) Recovery of dropped objects and datafiles.
7) Sarbanes Oxley remediation.
8) Space management of database.
9) Trouble block corruptions.
10) Rebuilding standby databases.
11)Taking export and import. as per the client requirement.
12) Configuring RAC services as per the request.
13) Installing and configuring Database and ASM.
14) Flashing back table and database in case of any logical corruptions encountered at the database level.
15) Database upgradation.
16) Configured DR with dataguard broker.
Responsibilities:
1) 24 x 7 Database production support
2) Tuning memory structures
3) Backup using RMAN
4) Creation of Database and configuring the database for development database
5) Installed and configured Oracle Database on RH Linux (Advanced Server) for development database
6) Implemented Standby for Disaster Recovery
7) Patching the Databases.
Completed BE Mechanical with distinction 72% in the year 2004.
Completed PCMB with 81% in 2000.
