خلاصہ



  • 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
مئی ۲۰۲۳ - موجودہ | 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]
مئی ۲۰۲۲ - مئی ۲۰۲۳ | 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
جون ۲۰۲۱ - جون ۲۰۲۲ | 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)
جنوری ۲۰۲۰ - جون ۲۰۲۱ | 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
جنوری ۲۰۱۸ - جنوری ۲۰۲۰ | 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
جنوری ۲۰۱۷ - دسمبر ۲۰۱۷ | 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
ستمبر ۲۰۱۳ - دسمبر ۲۰۱٦ | 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

زبانیں

ماہر پنجابی
ماہر انگریزی
ماہر اردو

آپ کن کمپنیز کی پیروی کر رہے ہیں