Asad Sultan Email & Phone Number

Chandigarh Area, India

New Delhi Area, India

• Maintaining and troubleshooting 24*7 Productions, Test and DR Databases.• Establish proper monitoring, measuring and reporting of service performance against Service Level Objectives, customer satisfaction, financial efficiencies and ensure maximum uptime of the database.• Administers all database objects, including tables, clusters, indexes, views, sequences, packages and procedures.• Installation, configuration of Oracle 11gR2 Database on Linux Server for RAC/non-RAC architectures using Disk or ASM.• Responsible for RAC Administration.• Responsible for Oracle Data guard Administration.• Responsible for Golden gate Administration.• Responsible patching both RAC and non- RAC database.• Worked with customer and Oracle support for RAC related issue fixing.• Maintenance and monitoring the ASM environment.• Monitoring the CPU load, Memory utilization and I/O of Servers.• Monitoring the backup jobs and checking the backups are running/completed successfully in both RMAN and EXPDP.• Monitoring backups of the database on a regular basis and work with backup team.• Check daily backup reports and re-run backups manually on failed database.• Creation and Maintenance of database storage structures such as Tablespaces.• Monitor the standby database and regularly checks the gap between the Production and standby database.• Resolve the gap between the Production and standby database.• Hands on experience on configuration and support for Golden Gate• Monitoring, troubleshooting and hands on experience on Golden Gate.

New Delhi Area, India

• Performed Export/Import and full database scanning.• Monitoring and resizing Tablespace, relocating data files for better disk I/O.• Maintained standby databases for staging environments.• Created roles, users and managed their privileges.• Responsible for monitoring & resizing Oracle database objects (Tablespaces, Tables etc.)• Responsible for managing Redo logs, Archive logs, Data files. • Troubleshooting of the database. • Responsible for extensive use of SQL, PL/SQL, SQL*PLUS• Use SSH, Putty and Remote Desktop to remotely administrating Oracle databases.• Linux Administrator Task like Installation, Job Scheduling etc.• Allocating system storage and planning future storage requirements for the database system.• Implemented DATAGUARD (Standby) for high availability/disaster recovery purpose.• Controlling and monitoring user access to the database.• Implemented backup and recovery of database using RMAN.

Mohali

Oracle Database:• Responsible for installing Oracle Database 12c, setup Instance Creation.• Installed patches and upgrades for various bugs.• Implemented traditional Hot and Cold Backups & Recovery.• Performed Export/Import and full database scanning.• Monitoring and resizing Tablespace, relocating data files for better disk I/O.• Maintained standby databases for staging environments.• Created roles and users and Managed there privileges.• Responsible for monitoring & resizing Oracle database objects (Tablespaces, Tables etc.)• Responsible for managing Redo logs, Archive logs, Data files. • Troubleshooting of the database. • Documented the problems and solution in the failures of production databases.• Responsible for extensive use of SQL, PL/SQL, SQL*PLUS• Use SSH, Putty and Remote Desktop to remotely administrating Oracle databases.• Linux Administrator Task like Installation, Job Scheduling etc.• Allocating system storage and planning future storage requirements for the database system.• Implemented DATAGUARD (Standby) for high availability/disaster recovery purpose.• Controlling and monitoring user access to the database.• Implemented backup and recovery of database using RMAN.Oracle Golden Gate:• Setup and configuration of Oracle Golden Gate 11g/12c for Oracle 11g/12c on Window & Linux Server and cross platforms.• Creation of wallet for oracle GoldenGate. • Golden Gate Director Installation and configuration on win and Linux Server. • Golden Gate Veridata Installation and configuration on win and Linux Server.• Database comparison thorough Golden Gate Veridata.