Sharif Wahid

Sr. System Engineer - DBA(Oracle, PostgreSql DBA & PL SQL Programmer) at Sonali Intellect Limited
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Bangladesh, BD

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

You need to have a working account to view this content.
Join now
You need to have a working account to view this content.
Join now

Credentials

  • PostgreSQL Database Administration on Windows/Linux
    Udemy
    Mar, 2023
    - Oct, 2024
  • Data Analyst with Python Track
    DataCamp
    Jul, 2022
    - Oct, 2024
  • The Complete PL/SQL Bootcamp
    Udemy
    Dec, 2021
    - Oct, 2024

Experience

  • Sonali Intellect Limited
    • Bangladesh
    • Banking
    • 1 - 100 Employee
    • Sr. System Engineer - DBA(Oracle, PostgreSql DBA & PL SQL Programmer)
      • Apr 2023 - Present

      • 24x7 Production database administration, support and monitoring to ensure a proactive problem recognition and resolution of database issues. • Monitoring database performance using ADDM, AWR, ASH, Stats pack and diagnostic SQL scripts. • Identified and tuned long running and resource intensive SQLs, PL/SQL programs, full table scans and applied solutions. • Design, test and implement RMAN backups, Recover, restore production databases as and when required. • Optimize table/index fragmentation and reduce row chaining/migration, corrupt block identification using the ANALYZE TABLE/INDEX feature. • Optimize SQL & PL/SQL Codes written by Developer. • Writing complex PL/SQL Scripts using collection, BULK COLLECT and FORALL. • Optimize EOD, Month End, June Closing And Year End long running Processes. • Writing and optimizing SQL queries, views, PL/SQL stored procedures, functions, Packages and triggers. • Performed routine such as space and index usage, locks, wait events, top sessions and background processes etc. Gather table and index statistics, index rebuild etc. • Resolved lock contention by detecting and modifying long running queries holding locks and applications explicitly locking objects. • Created and maintained table partition and maintained local/global indexes. • Cloning database for development and testing and demo environment using RMAN, Hot Backup. • Code, test, debug, and document more complex programs, and enhance existing programs to ensure data processing of production systems. Show less

    • Associate Consultant
      • Jun 2018 - Apr 2023

      • Writing complex PL/SQL Scripts using collection, BULK COLLECT and FORALL. • Optimize EOD, Month End, June Closing And Year End Processes. • Involved in writing and optimizing SQL queries, views, PL/SQL stored procedures, functions, Packages and triggers. • Performed routine such as space and index usage, locks, wait events, top sessions and background processes etc. Gather table and index statistics, index rebuild etc. • Perform Backup & Restore using RMAN and Data Pump. • Resolved lock contention by detecting and modifying long running queries holding locks and applications explicitly locking objects. • Data Migration Form Branch Banking Application to Core Banking Application. • Created and maintained table partition and maintained local/global indexes. • Setup and monitoring Schedule jobs to handle RMAN backup as well as export / Import Backup using data pump. • Cloning database for development and testing and demo environment using RMAN, Hot Backup. • Making sure Production Database is backed up regularly and recoverable without any issue. • Code, test, debug, and document more complex programs, and enhance existing programs to ensure that data processing production systems continue to meet user needs through review, analysis, and modifications. • Interpret business requirements and develop technical solutions from internal and external systems. • Systems development, implementation, upgrades and analyses. Show less

    • Junior Consultant
      • Apr 2017 - May 2019

      Design unit testing and generate test cases for unit tests.Debug PL/SQL codes to analyze and find exact solutions.Created records, tables, and collections to improve Query performance.Design ETL tools for database migration.Performed Database Administration of all database objects.

    • Engineering Trainee
      • Aug 2015 - Mar 2017

      Data Migration from Non-core (Legacy System) to CBS Branches (Sonali And Rupali Bank). Writing Migration Scripts ( PL/SQL Package, Procedure, Function, Trigger).

Education

  • Rajshahi University, Bangladesh
    Bachelor's degree, Computer Science and Engineering
    2009 - 2014
  • East West University
    Master's degree, Applied Statistics
    2019 - 2022
  • Lohagara Adarsha Mohavidyalaya
    HIgher Secondary Certificate, Science
    2005 - 2007
  • Lakshmipasha Adarsha Vidyalaya
    Secondary School Certificate, Science
    2000 - 2005

Community

You need to have a working account to view this content. Click here to join now