Imran Mohamed

Experience

• 

  Wipro

  Jan 2008 - Aug 2011

  Database Specialist

  Project: Remit2India & HDFC Bank• Installation and configuration of oracle 10g/11g databases.• Installation and configuration of oracle 11g cluster ware. • Grid Infrastructure Administration include cluster ware, ASM disk group.• Configuring Data Guard (Physical Standby database) • Perform Quarterly Database PSU Patches.• Monitoring database space requirements and adjustment for future needs.• Involve in increasing performance of database through reversing and rebuilding index, tuning query, indexing etc.• Renaming Adding, resizing Data files.• Database Upgradation from legacy oracle 8/8i to 11g with minimum outage.• Taking Differential backups of the database using Recovery Manager (RMAN) regularly on to disk.• Performed different File recoveries in the database. • Configured Listeners on server side and TNS Aliases on the clients’ side.• Avoid Raw Migration/Chaining after analyzing the table.• Memory tuning by using ASMM (Automatic shared Memory Management). Sort area size, Buffer cache, Shared pool size, Different pool like Recycle pool, Keep pool.• Implemented Oracle Advanced Indexes, partitioning.• Generated AWR/ Stats pack report manually and by scripts. • Creating Materialized View and Using Query Rewrite for Performance.• Work closely with Informatics /BO team to identify Performance issue and tune SQL statement to boost performance and minimize timeline to complete ETL loads related jobs. Show less

• 

  HCL Comnet Limited

  Sept 2011 - Aug 2012

  Specialist

  Project: JPMC• Implemented and maintain physical standby database.• Exadata patching, monitoring, space management, tuning Queries using Smart Scan, HCC, Flash Cache and Storage Indexes.• Successfully configured Exadata to non-Exadata data guard.• Successfully conducted the DR Drills for different critical financial databases.• RMAN and manual cloning.• Monitor alert logs, space and object growth related problems in the databases.• Create and maintain documentation of database installations and other DBMS processes.• Installing, configuring, patches and upgrading of oracle server software.• Exposure to manual backup and recovery techniques.• Exposure to RMAN backup and recovery techniques• Experience with supporting reporting database warehouses.• Providing the day-to-day administration of production databases• Back-up and recovery of databases using RMAN.• OS space usage management, job scheduling etc.• Perform database tuning and performance monitoring.• Creating and Managing RMAN Catalog• Perform on-call activities for both day and night-time support.• Proactive monitoring of the database instances and takes preventive steps to ensure high availability.• Monitoring SQL Server Agent jobs run on time and complete successfully. • Create MS-SQL jobs, Delete jobs, and update jobs for ETLs. • Disaster recovery planning for MS-SQL: scheduling backups, restoring backup, point in time recovery.• Creating and Managing Maintenance task• Managing security of the Server logins and users, orphan logins and users.• Managing logs/Data file, • High availability: Managing Log shipping, troubleshooting. Managing Mirroring servers. Show less

• 

  Mphasis

  Dec 2012 - Aug 2014

  Sr DBA

  • Configuration and Maintenance of Exadata X5 and X3 Half and Full RAC Appliances.• Troubleshooting and patching of RAC and Standby system.• Perform Storage Maintenance.• Grid Infrastructure Administration include clusterware, ASM disk group.• Upgradation of cluster and RAC databases, applying critical PSU/listener patches on RAC/non RAC databases.• Supporting 5 node RAC warehouse size ranging 47 Terabytes. • Work closely with Informatics /BO team to identify Performance issue and tune SQL statement to boost performance and minimize timeline to complete ETL loads related jobs.• Configuration of Grid control and manage Grid agent (addition/deletion/configuration). • Administer and Manage / Patch / Backup / Production RAC Instances.• Identify and apply Critical Patch Updates security patches.• Management of other legacy application connecting to oracle applications.• Work with change control management team to study and implement changes as per the requirement of the company.• On call support co-ordination and management.• Interact with Build / Project Managers for smooth DBA / Technical support.• Project planning for New Projects - (Technical requirements, capacity planning, Identify DBA Leads and Point of Contact Assignments for the build from DBA team, Timelines for completion and release of instances).• Installed and configured MySQL on Linux environment.• Knowledge sharing and process documentation.• Consolidated and submit Status Reports to Management on weekly/Monthly activities.• Automation using python for database restoration, cloning, listener and alert log purging. Show less

• 

  Syntel Inc

  Aug 2014 - Jan 2018

  Exadata DBA

  • Planned and Migrated databases from legacy, DB2 and Exadata X2 to X5-2 Exadata Box.• Migration of oracle databases from X2 to X5 and DB2 to Oracle using GoldenGate.• Experience on installation and configuration and troubleshooting of Oracle products and patches, including Exadata, RAC, ASM, Clusterware, Data Guard, Grid/Cloud Control. ZFS and ZS4.• Oracle RAC, ASM and DataGuard, which includes Install, configure and maintain Gird Control DBs, administrating using CRSCTL and SRVCTL, Monitoring and Troubleshooting, Performance Tuning, Capacity planning, SCAN, Upgrade and Patching, ASM Management, Physical Standby Management etc.• Configured Transparent Data Encryption across all the databases and enabled auto logins for wallets during database startups also setup Oracle network encryption.• Design and configured database compression strategies based on database characteristics to reduce storage usage.• DB Creation, Backup and Recovery using RMAN, User Management, Monitoring and Troubleshooting, Performance Tuning, Cloning, DataPump and Exp/Imp, Upgrade and Patching, Data modeling (logical and physical database design), Application Support etc.• Routine daily, weekly and monthly monitoring and maintenance of all database environments.• Review and enhance backup and recovery strategies. Anticipate hardware requirements and storage capacity planning for development, testing, QA and production for growth and performance.• Diagnose system problems, evaluate alternative solutions, resolve locking conflicts/blocking and resource utilization. Thorough understanding of database performance monitoring and analysis tools.• Expertise in working with developers and engineers to analyze database performance and identify problems in areas such as: execution plans, index coverage, and Oracle statistics. Demonstrate ability to solve complex database administration problems.• Audits of incident to maintain incident/problem management. Show less

• 

  Facebook

  Jan 2018 - Nov 2022

  Exadata DBA

  Alpha Net Consulting LLC:• Understand client requirement, their business needs and the scope of the application or project, review and analyze existing systems.• Interact with the users of the systems to understand the functionality of the computer application and the specifications and requirements of the users.• Install and configure Oracle Clusterware and automatic storage management for high availability and load balancing on Exadata/non-Exadata platforms.• Upgrade existing databases to 12c/18c after consideration of Systems, applications, performance impact and security. • Download and analyze Exadata quarterly full stack patches list fixes and workarounds that are deemed critical for software used on Exadata Database Machine.• Apply latest image in rolling manner to Exadata Storages, Compute Nodes, InfiniBand Switches and Cisco Switch.• Based of the migration methods use approaches like physical dataguard, logical dataguard, transportable tablespace, datapump and golden gate.• Configure and Maintain Disaster Recovery solution for enterprise deployments makes use of storage replication technology using Oracle Data Guard and Active Data Guard.• RDBMS Backup Restore and Recovery planning and test on storage disk and tape.• RDMBS space monitoring and maintenance, storage capacity monitoring and planning.• Configured TDE wallets with Oracle Key Vault appliance.• Administering MySQL and configuring Replica Sets as per the Application requirement.• Installation and Configuration: Installation of SQL Server of versions (2008, 2008 R2, 2012 2014) on Standalone Environments. Installation of Patches/Hotfixes. Configuration of Server and Databases as per user requests. • Users access management and Security: Creating Logins and providing the access to the server and databases. Granting Access and revoking access of users. Show less

• 

  Oracle

  Nov 2022 - now

  Senior Principal Advanced Support Engineer at Oracle