Download PDF

Asad Mahmood

MSSQL Server Database Administrator

Work History


Database Engineer II

S&P Global Market Intelligence
  • Managing all the aspects of production and Development Environments
  • Ensure that new database code meets company standards for readability, reliability, and performance
  • Each week, give developers a list of the top 10 most resource-intensive queries on the server and suggest ways to improve performance on each
  • Design indexes for existing applications, choosing when to add or remove indexes
  • When users complain about the performance of a particular query, help developers improve the performance of that query by tweaking it or modifying indexes
  • Conduct SQL Server lunch-and-learn sessions for team and application developers
  • Conduct open session with developers to implement the most efficient database designs (tables, datatypes, stored procedures, functions, etc)

Database Administrator

Pakistan Telecommunication Company Islamabad

Responsible for the technical and administration aspects of the company's data warehouse infrastructure using MSSQL Server 2012 , Teradata , Oracle and Informatica. Also the first point of contact for providing technical support as well as specialist technical input.


Sql Server Database Developer

Medical Transcription & Billing Company
  • Create Entity Relationship (ER) Diagrams to the proposed database
  • Create database objects such as tables, views, stored procedures, Triggers etc.
  • Maintain referential integrity, domain integrity and column integrity by using the available options such as constraints etc.
  • Identify columns for Primary Keys in all the tables at the design time and create them.
  • Create functions to provide custom functionality as per the requirements.
  • Be aware of potential blocking, deadlocking and write code to avoid those situations.
  • Develop reports in SQL Server Reporting Services.
  • Identify and write best possible code in case of new deployments or when rewriting code when migrating to newer version of SQL Server.
  • participate in discussions involving the application creation and understand the requirements and provide the back-end functionality for the applications.

Sql Server Database Administrator

Protege Global Islamabad 
  • Ensure all database servers are backed up in a way that meets the business’s Recovery Point Objectives (RPO)
  • 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
  • Configure SQL Server monitoring utilities to minimize false alarms
  • As new systems are brought in-house, choose whether to use clustering, log shipping, mirroring, Windows Azure, or other technologies
  • Install and configure new SQL Servers
  • Deploy database change scripts provided by third party vendors
  • When performance issues arise, determine the most effective way to increase performance including hardware purchases, server configuration changes, or index/query changes
  • Document the company’s database environment


Database Administration

Install and configure new SQL Servers. Deployment of database changes. Ensuring database backups. Database health checks and monitoring. Performance tuning and optimization. Document the company’s database environment

Database Development

Crating Tables, T-Sql queries and scripts ,Indexe, stored procedures, functions, triggers

Data Modeling

Based of requirements construct Entity Relationship diagram



BS Software Engineering

International Islamic University Islamabad

Completed my professional degree in the filed of Software. Learn all the aspects of the software system like Requirement gathering, Design, development, maintenance, testing, and evaluation of the software system