Zainulabedin Shaikh

Role Core Database Administrator

Client's Of Luxoft :- AT&T (USA client)

Environment Linux, 7. oracle Linux 8

Database Oracle 11g,12c,19c , RAC

• Conducted tests to identify issues and make necessary modifications.
• Streamlined backup and recovery processes, enhancing overall system stability and availability.
• Administered, supported, and monitored databases by proactively resolving database issues and maintaining servers.
• Provided timely resolution of critical production issues, minimizing downtime and avoiding potential revenue loss.
• Optimized database performance by monitoring health and implementing tuning recommendations.
• Established proactive monitoring solutions that alerted administrators to potential issues before they escalated into major problems.
• Set up and controlled user access levels across databases to protect important data.

Client's Of ATOS Syntel :- Allstate (USA client)

Environment : Linux, 6.5. oracle Linux 7

Database : Oracle 11g,12c,19c

Responsibilities:-

Installed and configured 2 node 10g and 11g RAC.

Monitoring Mail alerts and Service now ticketing tool.

install 12c grid and deployed agent.

Refresh the oracle database for testing.

Executing the given scripts(INSERT/DELETE/UPDATE) from customer

Monitoring mount points and Checking Table space growth.

Monitoring sessions and checking CPU utilization.

Checking RMAN hung, Trace file, Alert Log & shared pool memory issues.

Creating a standard change for extend the file system/disk space

utilization exceeds 90 threshold & archive free space issues.

Responsible for the setting up of Memory restriction and monitoring CPU utilization, blockings and issues.

Role Core Database Administrator and EBS Dba

Client's Of UnionSys :- Techsignia (QLG, MPower,)

Environment Linux, 5.5. oracle Linux 5.5,cent OS 4.5, Solaris 10, Hp

Database

Oracle 10,11g,12c oracle EBS 12.1.x,12.2 (application)

Responsibilities:-

Implement Oracle Audit Vault and firewall.

implement Tablespace Data Encryption for non system data files.

applying Ebs patches using adpatch utility.

Installation oracle EBS 12.1.x on Linux 5.5 and sun-Solaris 10

install 12c grid and deployed agent and done data masking.

cloning the database and application using Rapid clone.

Monitoring mount points and Checking Table space growth.

Monitoring sessions and checking CPU utilization.

Performing database Cloning.

Refreshing Schemas for prod to Dev.

Instrumental in scheduling of Automated Physical and Logical Backups of databases.

recovering the archive logs gap in standby database using Rman incremental backups.

Applying CPU Patches using OPATCH utility

Planning and Creating Database required for Production, Development and Test usage.

Steering the efforts in carrying out DBA activities like installation, (Using Export/Import Utility/RMAN), User Management,troubleshooting etc.

Starting oracle RAC node using Servctl command.

Adding data file in ASM storage system.

Installing, configuring and upgrading of Oracle Server software and related products.

Possess profound knowledge of Oracle architecture, Oracle 10g, 11g server installation, configuration and creating databases using DBCA utility. Using NETCA for creating Listener and Tnsname file.

Reorganization of database using Export and Import Utility

Purging Log files of Application and Oracle database.

Entrusted with the task of taking Daily and weekly backups (Logical

and Physical).

Role Junior Database Administrator.

Client's Of UnionSys:- AirTel Bharti

Environment Linux AS4.5,5.5,win-2003, Hp Unix & AIX

Database Oracle 10g

Responsibilities:-

Checking alert log files to monitor database activities.

Monitoring mount points and Checking Table space growth.

Monitoring sessions and checking CPU utilization.

Performing database Cloning.

Schema and Database refreshes.

Maintenance of production database.

Database Recovery using the physical backups.

Monitoring and Scheduling backups using cron Jobs

Performing database Reorganization to remove fragmentation using Export/Import utilities.

Checking backups log files to ensure backups are properly ended.

Configuration of tnsnames and listeners.

Responsible for database refreshes. Database Logical backup using Export/Import and Data pump

Implementation of oracle security by creating roles and privileges and profiles.

Actively participate in Designing & Creating Database, Creating and Managing User, Backup & Recover Database in Critical Stage

Handling the task of maintaining monthly/weekly Database such as