Khalid Siddique

Experience

• 

  Innovative Channels Pvt Ltd

  Jan 2016 - Nov 2018

  Oracle System Engineer DBA & Database Consultant

  1. Installation of new oracle software and install new versions of DBMS software, application software, and other software related to DBMS administration. It is important that other IS staff members test new software before it is moved into a production environment.2. Security administration: One of the main duties of to monitor and administer DBMS security. This involves adding and removing users, administering quotas, auditing, and checking for security problems.3. Analyzes data stored in the database and makes recommendations relating to performance and efficiency of that data storage.4. Database design at the preliminary database-design stages, eliminating many problems that might occur.5. Configuration of hardware and software with the system Administrator: In many cases the system software can only be accessed by the system administrator. In this case, works closely with the system administrator to perform software installations, and to configure hardware and software so that it functions optimally with the DBMS.6. Data modeling and optimization: By modeling the data, it is possible to optimize the system layouts to take the most advantage of the I/O subsystem.7. Recover-ability is one of the most important and vital duty, Any type of error such as, data entry error, hardware failure, software failure, bugs, virus etc. can result in corrupting database.8. Planning and implementing a sound backup and recovery strategy.9. Responsible for create a separate Tablespaces within the database to hold user objects.10. Responsible for authorization of access data and integrity constraint specification. Show less

• 

  NRSP Microfinance Bank

  Dec 2018 - Dec 2020

  Database Administrator

  Availability of Primary and Standby Databases & Flexcube Applications.Backup of Databases & Applications.Restoration of Backup for Environment Readiness and Performance tuning.Managing security, users, roles, privileges, profile management.Automated solution for Frontend and Backend logs. Responsible for monitoring and taking of Production databases backups, using RMAN and Data Pump and User Managed Backup and Recovery (complete and in-complete recovery).Configure & Upgrade Primary, Standby Databases & Applications Database performance Tuning (Schemas, Indexes, Stats Gather, Partitioning Table/Indexes)Modifying the database structure, as necessary, from information given by application developers.Support OBI report, roles configure and user’s issues.Support 24/7, Resolving daily issues related to Oracle Databases, Load balancer OTD, WEBLOGIC, OBIEE. Show less

• 

  1LINK (Pvt) Limited

  Jan 2021 - May 2024

  • Manager Databases

    Jan 2023 - May 2024

  • Deputy Manager DBA

    Jan 2021 - Dec 2022
• 

  Oracle

  Jun 2024 - now

  Principal Advanced Services Engineer