概要



  • Senior DBA having more than 10 years of overall experience on MS SQL Server.  










  • SSMS, SSRS, SSAS, SSIS, Database Administration, Always On, HA, Replication expertise 




  • Excellent Technical experience in Requirement Analysis, Design, Implementation, Maintenance and Troubleshooting. 




  • Database Backups and recovery. 




  • Working on Azure Managed Instances. 




  • Collaboration and coordination with supervisor for demos, functionalities, challenges.  










  • Having good verbal and written communication skills. Excellent team collaboration and coordination.  




  • Experience in both, majorly in development and contribution in architecture of software development process.





工作经历

公司标识
Project Lead Cloud DB Services
Systems Limited
May 2023 - 代表 | Islamabad, Pakistan



Created complex solutions to fit client and business requirements. 


Analyze the system for possible business solutions/bugs/upgrades. 


Performance Tuning, Upgrade/Migration/Patch/Installation. 


High Availability Solutions – Always on Availability Groups, FCI and Replication.  








Configuring and troubleshooting SQL Server Integration Services (SSIS). 


SQL Server Reporting Services (SSRS). 


Transactional replication on Azure managed instance (Azure Cloud) 


Transparent Data Encryption (TDE).  


Performance monitoring of Server and Database. 








Implement and act in accordance with the organization\'s information security and privacy policies. 


Working on Azure Managed Instances. Taking backups of production databases on Azure BLOB storage. 


Ensure compliance with information security responsibilities specific to your job role. 


Protect assets from unauthorized access, disclosure, modification, destruction or interference. 


Installation and configuration of SSRS. 








Migration of SSRS from 2014 to 2019. 


Creation, maintenance, updates and troubleshooting of SSIS. 



公司标识
Senior Lead DBA
Medical Transcription Billing Company [MTBC]
May 2022 - May 2023 | Islamabad, Pakistan

Administering multi Tera Databases on different locations
Upgrade / migrate servers in merge replication from SQL server 2014 to 2019.
Reporting from different and remote location/Platforms.
Creating and managing stored procedures using T-SQL.
Query Optimization for different new or existing module using Query-Execution Plans, Index Utilization,
procedure Cache Utilization and Normalization Techniques.
Establishing and Maintaining Backups on Local and Remote Media.
Ad-hoc Reporting
Performance Monitoring Using Performance Monitor, DBCC Commands, Maintenance Plans.
Install upgrades and patches to existing databases servers
Monitoring Application Related Jobs and Data Replication Activities.
Work on conflicts occur during replication cycles.
Installation of SQL Server Software and Related Products.
Performance monitoring of Server and Database.
Implement and act in accordance with organization\'s information security and privacy policies.
Ensure compliance with information security responsibilities specific to your job role.
Protect assets from unauthorized access, disclosure, modification, destruction or interference.

公司标识
Database Developer
F3 Technologies (PVT) Limited
Jun 2021 - Jun 2022 | Islamabad, Pakistan

Collaboration with system architects, software architects and others to understand business or industry requirements
Working on Azure Managed Instances. Taking backups of production databases on Azure BLOB storage. 
Managing ALWAYSON Availability Groups on different locations. 
Upgrade servers in availability groups and apply patches. 
Performing transactional replication on Azure Managed Instance from traditional SQL server databases.
Assess technical proposals requesting changes or upgrades to the existing databases
Plan new designs for integration into a database structure, using knowledge of the characteristics of the systems being added to the structure 
Develop database architectural strategies at the modeling, design implementation stages to address business or industry requirements
ETL to AWS S3 bucket using parquet files
Transactional replication on Azure managed instance (Azure Cloud)
Determine technical solution feasibility by evaluating workflows problem definition requirements usage models proposed solutions
Implemented high level security policies for user accounts, passwords, roles and privileges across the enterprise database environments. 

公司标识
Database Administrator
PRAL (Pakistan Revenue Automation Ltd)
Jan 2020 - Jun 2021 | Islamabad, Pakistan

* When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or optimizing queries and index Implementation.* Optimization of SQL server, stored procedures and Scripts.* Ensure all database servers are backed up in a way that meets the business Recovery Point Objectives (RPO)* Allocating system storage and planning future storage requirements for the database system* Test backups to ensure we can meet the business Recovery Time Objectives (RTO)* Troubleshoot SQL Server service outages as they occur, including after-hours and weekends*Backing up and restoring databases*Configuration of SQL Server transactional replication*Document the company database environment* Server Migration from SQL server 2008,2012,2014 to SQL Server 2019

公司标识
LEAD DATABASE ADMINISTRATOR
MTBC
Jan 2018 - Jan 2020 | Rawalpindi, Pakistan


* Monitoring and optimizing the performance of the database * When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or optimizing queries and index Implementation. * Optimization of SQL server, stored procedures and Scripts.* Configuration of SSRS, SSIS & Replication (Merge).

公司标识
Assistant DBA
MTBC
Jan 2017 - Dec 2017 | Rawalpindi, Pakistan

 Allocating system storage and planning future storage requirements for the database system
 Test backups to ensure we can meet the business’ Recovery Time Objectives (RTO)
 Troubleshoot SQL Server service outages as they occur, including after-hours and weekends
 Backing up and restoring databases

公司标识
Database Developer
MTBC
Sep 2013 - Dec 2016 | Rawalpindi, Pakistan


* Assisted in development of different Module for MTBCs end users.* Designed and implemented stored procedures for certain certification.* Data migration from other databases (FoxPro, Access, Med Soft) to SQL Server through SQL (Import/Export) wizard or by scripting complex queries as well. * Worked on the data import for the Acquisitions getting signed up with MTBC. * Involved in MU Stage-2 & MU Stage-3 certification with a hand in database optimized Queries and SPs. * Day to Day, weekly and monthly Reporting. * SMS Service and Mail Server Configuration is also Deployed. * Query Optimization, Roles and weekly maintenance with schema changes.

学历

Allama Iqbal Open University (AIOU)
学士, 技术学士, Bachelors in Technology‎
Information Technology
等级 B+
2005

技能

熟练 Cooordination Skills
熟练 Core Analysis
熟练 Core Data
熟练 CVs Screening
熟练 Database
熟练 Database Design
熟练 Database Developer
熟练 Database Development
熟练 Database Migration
熟练 DR & HA Options for SQL Server Experience
熟练 Ecellent Communication Skills
中级 ETL Tools
中级 Microsoft Azure
熟练 Microsoft SQL Server
熟练 MS SQL Server
熟练 MS SQL Server Admin
初学者 MySQL
初学者 Oracle
初学者 PostgreSQL
熟练 Processing Knowledge
熟练 Query Language
熟练 Record Keeping
熟练 Revenue Analysis
中级 Server Admin
熟练 SQL Development
熟练 SQL Queries
熟练 SQL Swever
中级 SSIS
熟练 SSRS
中级 Tbricklaying

语言

熟练 旁遮普语
熟练 英语
熟练 乌尔都语