Khater Ali

 More than 12+ years of experience in the area of Oracle Database Administration.
 Currently associate with Shift Technology, as a Senior Oracle Database Administrator(Expert) in Shift technologies (Client : GOSI) overall I have 12+ Years of DBA experience (Oracle & MSSQL Server)
 Previously working in Oracle Corporation India Private Limited as an IC-4 Oracle DBA (Principal Software Engineer)
 Worked in various projects for many multinational companies including HCL Comnet, Wipro infotech, Hewlett Packard and ORACLE India PVT LTD
 Expert in Oracle Exadata Concepts
 Helping oracle customer to resolve all type of Oracle database DBA issues at their environment..
 Expertise in Database planning, design, administration, performance tuning, migration, backup and recovery.
 Experienced in RMAN, Oracle Real Application clusters (RAC) and oracle high availability solutions - oracle dataguard Etc.
 Ensure Oracle database systems operate efficiently and securely
 Handled Oracle 8i/9i/10G/11G/12C Databases
 Working knowledge in oracle Apps DBA (EBS R12)
 Superior communication, presentation, analytical and problem solving skill. Work well with all levels of business
SQL Server Database
 Installed SQL Server 2005-2008, 2012, 2014 and Share Point and applied Service Packs and hot fixes on production, development and backup servers
 Implemented techniques like backups, restore, clustering, replication, Log Shipping and DB Mirroring in SQL Server.

 Database Upgraded from 10G to 11G (11.2.0.3) Standalone & RAC environment with Dataguard (MAA) + DataBroker Setup, used RMAN Techniques for Upgrade from 10g to 11G
 Configured 11G Dataguard switchover test using manual & DG Broker method
 11G Tablespace Encryption & Wallet
 Configured Three Node 10G RAC servers with 1TB ASM Disk
 Implemented Necessary Patches in the RAC Nodes
 RAC Database migration between the Data centres
 RMAN DB Cloning & Adding the RAC Instance
 10g to 11g migration (11.2.0.3)
 12C Database(PDB/CDB) Backup management using RMAN
 Implemented Necessary Patches in the RAC Nodes
 Extensively used Oracle utilities like Export/Import, Datapump, Log Miner, DBVerify, Oracle Trace, DBCA, DBUA, TKPROF
 Extensive Troubleshooting Highly/Medium/Less Critical Jobs of Production/QA/Test

 Installation, configuration and upgrading of Oracle server software and related products.
 Version up gradation and patch installation.
 Creating primary database storage structures and modifying the database structures as and when require.
 Standby database creation with/without data guard and maintenance.
 Standby database switchover/Failover testing.
 Duplicate database creation.
 Schema refresh.
 Monitoring/Maintaining the database and Performance tuning as per requirement.
 Oracle User account, profile and role management..
 Environment being in abend due to different reasons like Insufficient Space, User Account Being Lock, Backup Issues, Object Statistics Being Locked etc
 Using Shell script, sending mails for alert errors, locks, Invalid objects, broken jobs, etc.
 Working SQLSERVER on purging Transaction logs.

 Oracle Installation - Install Oracle at Production DB server and Production Application Server.
 Space Allocation Plan - Check No of Mount points available. Plan place for data files and other files to be placed.
 Database Creation - Create Empty Database, Creating User, Schemas, Tablespaces as per the requirement
 Create Tables, Views, Indexes, Sequences and then alter tables and view as per the scripts ( created for informix structure)
 Check all the tables should be partitioned properly.
 Data Extraction from Tape - Extracting data from tape drive and unconverting them into readable format ie untarring files
 Data Loading - Checking the data loaded using the SQL loader utility. Tables having Column of data type interval is firstly loaded into intermediate oracle tables and then into target Oracle tables.
 CPU/PSU patches applied

 Creating Database Design, Data Dictionary
 Implementing Standards/Strategies (Backup/Recovery, Capacity Planning
 Database Cloning
 Database Up-gradation from 8i to 9i and apply requisite Patches
 Database Recovery and Periodic Backups using both Conventional Method and RMAN
 Database Tuning using Troubleshooting and Performance Views
 SQL Statement Tuning - Analysis of Explain Plans, SQL Trace, TKPROF, Tuning Hints and Analysis of STATPACK
 Database Creation Managing Oracle Instances, control file, redo log files
 Managing Users, Privileges & roles
 Export / Import utility
 Monitoring and Managing Storage,
 EXPDP/IMPDP utility to refresh schema and database level

 Install ORACLE software(oracle8i, oracle9i DB), applying patches& administer databases
 Establish and maintain sound backup and recovery policies (ONLINE & OFFLINE) and procedures.
 Implement and maintain database security (create and maintain users and roles, assign privileges), client/server database connectivity.
 Support application developers with schema design and SQL statement tuning (SQL queries)
 Setup and maintain documentation and standards
 migration and logical backups(export, import-table, user level, tablespace, database)
 Creating tablespaces, schemas and resizing the datafiles.