Experience

The Bank Of Khyber (BOK)

• Pakistan
• Banking
• 1 - 100 Employee

• Database Administrator

  • Mar 2021 - Present

  Database BackupDatabase Restoration. Database BackupDatabase Restoration.



F3 Technologies Inc.

• United States
• IT Services and IT Consulting
• 1 - 100 Employee

• Database Administrator

  • Apr 2019 - Mar 2021

  1) Writing store procedures.2) Developing ssrs reports.3) implementation of cdc.4) manage service broker.5) data migration.6) fix run time issues 1) Writing store procedures.2) Developing ssrs reports.3) implementation of cdc.4) manage service broker.5) data migration.6) fix run time issues



MTBC Careers

• Pakistan
• Hospitals and Health Care
• 200 - 300 Employee

• Database Developer

  • Jan 2015 - Jan 2019

  1) Development and administration of SQL Server2) Implementing and managing triggers, indexes and constraints on database. 3) Implementing and managing stored procedures using T-SQL.4) Implementing and managing tables, views, synonymous, bulk update data, bulk insert data.5) Installation of SQL Server software and related products. 6) Taking and maintaining backups on drives.7) Performance monitoring using performance dashboard, activity monitor and DBCC commands. 8) Import data into SQL Server from SQL Server database, text file and excel.9) Analysing applications performance using query-execution plans, index utilization. 10) Writing database procedures, functions, triggers, queries. 11) Optimization of SQL Server stored procedures and SQL scripts. 12) Implementing managing SQL Server jobs.13) Ad-hoc reporting. 14) Implementation of business report on reporting server using SSRS.15) Replication (merge and snapshot).16) Maintenance plan.17) Table store partition. 18) Archiving database. 19) Implementing and monitoring mirroring of SQL Server. 20) Importing data Using ETL(from flat file to SQL Server, from SQL Server to flat file, from excel to SQL Server, from SQL Server to excel).21) Using ETL to change data types.22) Ttroubleshooting and resolving database problems.23) Performance Tuning and Optimization, using native monitoring and troubleshooting tools.24) Implement backups, restores and recovery models.24) Knowledge of indexes and index management.25) Monitor and maintain system health and security26) Provide 24x7 support and problem resolution for critical production databases.27) Schedule and Perform scheduled maintenance and support release deployment activities.28) Assist developers with complex query tuning and schema refinement.29) Plan for disaster recovery30) Install SQL software31) Configure database serversDesigned & developed SSIS packages & ETL Scripts to complete the day to day tasks of DBAs and developers.