Senior Oracle DBA
Cognizant Technology Solutions
Total years of experience :13 years, 6 Months
Project : Dexia (Banking Domain)
Organization: Cognizant Technology Solutions
Database : Oracle 11gR2 & 12c.
Duration : Jun-2020 To till present.
Platform : AIX 7 and OEL 6, RHEL 7.
Experience in Installation of oracle 12c software and databases for single and 2 node RAC environment.
Experience in configuration of Physical standby database.
Exposure of applying quarterly released patches as well as bug fix patches.
Created physical standby database for single and 2 node instances.
Performed Switch Over and Switch Back activity for DR test.
Resolving the archive gap by using incremental SCN backup.
Monitoring and maintaining ASM, RAC databases as well as dataguard.
Good exposure in RMAN backup and restoration (timestamp and SCN based, RMAN duplicate).
Upgraded database from 11.2 to 12c using DBUA as well as manual method.
Handling performance tuning issues using AWR, Explain plan, SQL tuning advisor, SQL profile and fixing SQL plan etc.
Following change management and Incident management process while working on daily BAU task.
Good exposure in Schema Refreshes using data pump (EXPDP/IMPDP).
Experience in monitoring and administrating databases through 13c OEM, installing 13c agents, adding and removing targets, setting alert thresholds etc.
Experience to configure, enable, disable oracle Vault and setting realms to protect schemas or schema objects.
Worked on TDE and Keystore to enable column and tablespace level.
Project : Alawwal Bank Riyadh-Saudi Arabia ( Onsite: Riyadh-KSA )
Organization: Cognizant Technology Solutions
Database : Oracle 11gR2 & 12c.
Duration : Oct-2018 To 06-May-2020.
Platform : AIX 7 and OEL 6.
Experience in Installation of oracle 11gR2 databases for 2 node RAC.
Configured the ASM and created the disks for ASM using ORACLEASM.
Configuring and managing the Disk using ASMLIB commands.
Creating, resizing and maintaining the disk groups for ASM instance.
Creating and relocating services in RAC instances.
Experience in configuration of two node dataguard for two node RAC database.
Monitoring and maintaining RAC databases as well as dataguard.
Exposure in RMAN backup restoration.
Upgraded database from 11.2 to 12c.
Supporting application team for their script deployment.
Handling performance tuning issues.
Monitoring and supporting MSSQL server databases.
Created MSSQL Server 2017 instances and created new databases.
Upgraded MSSQL server databases from 2008/2012/2014 to MSSQL 2017 latest version.
Performed backup and restoration on MSSQL databases.
Worked on User management and objects management in MSSQL server databases and troubleshoot the related issues.
Experience of Golden Gate installation, configuration, administration and troubleshooting issues.
Experience of MongoDB installation and administration like collection of documents, export/import, backup etc
Project : DCS-Operation (Data Centre Operations)
Organization: Cognizant Technology Solutions
Database : Oracle 10g, 11gR2 & 12c.
Duration :Jun-15 To Oct-2018
Platform : Red hat Linux 6, 6.5 and OEL 6.
Experience in handling the database in EXADATA environment.
Experience in Installation of 11gR2 grid infrastructure for two node RAC database.
Experience in Installation of oracle 11gR2/12c databases for 2 node RAC.
Experience in configuration of two node dataguard for two node RAC database.
Good exposure in cloning of databases with RMAN duplicate.
Good exposure in RMAN backup and restore.
Experience in applying PSU patches using opath utility.
Upgraded database from 11.2.03 to 11.2.0.4.
Experience in monitoring databases through 12c OEM.
Experience in handling RAC databases as well as 2 node DATAGUARD.
Good Exposure in resync DATAGUARD using incremental backup.
Providing assistance to development team as and when needed.
Configured Oracle Vault as well as enable, disable vault and setting realms to protect schemas or schema objects.
Project : British Petroleum UK/US (24x7)
Duration : Dec 2010 - Mar2014
Designation : Infrastructure Engineer
Organization: Mphasis an Hp Company
Database : Oracle 9i, 10g &11g.
Platform : Solaris/Linux/Windows
Working in shared infrastructure environment SIV1/2 with 1500 databases.
Handling and managing the databases in VERITAS cluster.
Worked on BMC remedy ticketing tool.
Worked experience of Change Management and Incident management processes.
Created new databases manually as well with DBCA.
Good exposure in Schema Refreshes.
Good exposure of handling the data guard like REBUILD and RESYNC.
Involved in the DR drill activity performed by application team.
Configured and repair the data guard broker.
Experience in cloning of database using COLD, HOT and RMAN
Experience in RMAN and Logical backups using Export and Data Pump utilities.
Experience in script deployment on OAT and PROD under RFC.
Experience in user and table space management.
Monitoring database, scheduling tasks, Creating Roles, assign required permissions to roles. Assign roles to database Users.
Experience in SOX password change activity.
Prepared SOP documentation for project.
Providing assistance to development team as and when needed.
Performance tuning using Oracle Enterprise Manager, AWR and ADDM.
Experience and good knowledge of OEM like adding/removing targets,
CPU/ Memory/ Swap utilization, metrics setting etc.
Applied patched using OPATCH utility.
Upgraded database from 9i to 10g.
Work experience in handling the databases on ASM storage.
Configure and manage the Disk using ASMLIB commands.
Created and maintained the disk groups for ASM instance.
Convert database from non ASM to ASM.
Monitoring the ASM instance.
Work experience in handling the databases in RAC environment.
Managing the clusterware using: CRSCTL CRS_STAT, OCRCONFIG, OCRDUMP utilities.
Managing and troubleshooting cluster and services running on the cluster.
Managing OCR and Voting disk by taking manual backup.
Apart from the above-mentioned tasks, daily monitoring was carried out to ensure database availability and smooth functioning of databases. Daily monitoring includes checking whether all databases are running, listener is running, disk space availability, checking for errors in alert logs and trace files, checking for invalid objects, etc. Corrective action is taken for any of the problems before start of business hours.