Sultan Khan

Experience

• 

  NexGeN Inventive Information information Pvt. Ltd.

  Dec 2013 - Sept 2016

  Oracle Database Administrator

  This project involves production support and maintenance of Production servers of Multiple Client applications and databases. The database support operation includes routine statistics gathering, object maintenance, data replication , USER & log management.

• 

  HCLTech

  Nov 2016 - Feb 2020

  Specialist

  Over 5 years of experience in as an Oracle DBA in Production andDevelopment environment. With more than 2500 servers over variousplatforms like UNIX/Linux, with oracle versions including 10g, 11g, 12cproviding 24X7 support to the customer , Handling bridges RCA. Supporting DataWarehouse Database i.e. over 35 TB in size.Strong troubleshooting, problem-solving, analytical, and designskills. Coordinating with data load team mainly for planning data load fordatabases, Keeping eye on the performance of databases Monitoring the alert logs and tracing files regularly, Administrating database, managing users, profiles, table space, and schema. Monitor and maintain Crontab job schedules, Generating Reports like AWR, ADDM recommendations.Experience in Performance tuning the production database towards optimalperformance based on the changes in the database storage structures due toapplication change requirements. Monitoring and optimizing the performanceof the Database through Oracle utilities.Experience in Oracle 10g/11g/12C Data Guard and standby databases.Schema refresh and migration using datapump on different platforms.Zero Downtime Migration and Upgradation of the database across environments.SAN addition and Migration. OEM 13c Setup and ZDLRA configuration hands on.Troubleshoot GG process abended issue using logdump utility and checkingthe report, parameter files.Installation and Administer GG extract/replicate/pump process in active/active and active/passive environment.Testing and coordinating oracle patches/upgrades and monitoring, scheduling, planning backup & recovery strategy using hot/cold backups.Generating reports and applying rules in OEM and SNow setup. Show less

• 

  Diebold Nixdorf

  Feb 2020 - Oct 2022

  Senior Software Engineer
• 

  LTIMindtree

  Oct 2022 - now

  Technical Lead