Muhammad Azeem Email & Phone Number

Islamabad, Islāmābād, Pakistan

• Managing and administering SQL Server (2016, 2019, 2022), database instances in Azure cloud (IaaS)
• Lead the SQL Server storage transition activity, recommended addition of new volumes, type of IOPs required, block size, and allocation of over 150 databases on new volumes guaranteed contention free concurrent IOs. IO.
• Implemented horizontal table partitioning to overcome data warehouse large data deletions overheads by introducing partition truncation for specific partition key value. ETL workload improved by 100x
• Implemented a robust backup strategy to overcome flaws of legacy backup policy. Differential backup introduced for large databases while their full backups frequency moved to weekly basis. An overall 100x backup time.
• Implemented a new process to proactively monitor SQL Server production hour stored procedure executions. The process outcome a daily huddle of product leads to discuss and assign stories to respective stockholders. SQL.
• Implemented new index maintenance task that divided the rebuild of indexes of partition and non-partition tables into two separate tasks. Only partition with data changes is selected for index rebuild. 50x faster index.

Islamabad, Pakistan

• Lead the enterprise data center transition/migration project from databases perspective and managed the SAN allocation strategy for all the enterprise SQL Server databases. Prepared detail checklists, worksheets.
• Designed and implemented 5 node active/active load balanced and highly available SQL Server 2012 FCI cluster.
• Implemented database Replications in SQL Server 2005, 2012 for High Availability, DR and Reporting
• Redesigned a thorough backup and recovery strategy for all major production systems. This initiative involved the design and development of scripts used for physical backups. Also included in this effort was the.
• Established the Database Administrators Procedures. This outlines all standards for the DBA Group including installing SQL Server, creating databases, DBA tools, administration and monitoring, naming standards, coding.
• Automated monitoring infrastructure by using windows power shell and T-SQL scripts. This allowed our operational DBA team to efficiently gather database metadata, exceptions, and performance statistics of enterprise.

Islamabad, Pakitsan

• Managed Sun Solaris 8 Operating system on Sunblade2500 system.
• Installation of Sun Solaris 8 OS/ patches, HP Open View 7.0/ patches, and NEC Pasolink Network Management System (PNMS).
• Pasolink network trouble shooting, link configuration and Active and History Alarms reporting with the help of PNMS.
• PNMS network designing with help of NEC Net Config Tool and Path Loss.
• On site PNMS link configuration, trouble shooting and Net Configuration deployment with help of NEC Pasolink Network Management Terminal (PNMT)
• PNMS integration with the Upper SNMP NMS Manager (Hp TEMIP).

Islamabad, Pakistan

• Provided the Seasonal support to the Data Entry project of 1.4 Million Income Tax Returns at the National Data Entry Centre. Resolved data entry issues of data entry clerks, EDP supervisors and document scanning staff.
• Generated and distributed daily, weekly and monthly data entry progress reports using ad-hoc T-SQL scripting
• Generated and distributed domain specific reports related to tax collections, tax shortfalls, tax withheld, sector and region wise summaries and reports related to annual national budget
• Designed and implemented database backup and recovery plan.
• Maintained and administrated SQL Server 2000 Database that include security implementation, performance tuning and capacity planning.
• As a team player took part in the data analysis project of 1.2 million Income Tax Returns for tax year 2004. Performed the data cleansing according to the business rules. Specific tasks included preparing, testing, and.

Islamabad, Pakistan

• Performed Oracle database management tasks for Oracle7, 8i on IBM AIX, tasks included application support, database objects management, database security and access control, MIS reporting via SQL Pluss and developer.
• Managed database and OS backups and recovery; managed AIX user privileges & permissions and files & directory access permissions
• Provided technical support to the annual regional data entry project of seventy thousand income tax returns
• Performed in-depth cross database analysis between Income Tax and Withholding Agents databases for new taxpayers identification/registrations
• Carried out electronic tax audits; the task required Data Migration & Integration; Oracle SQL & PL/SQL scripting and Oracle Report Builder 6i report designing.

Post Graduate, Ict

Post Graduate Diploma in CS

Graduation, Physical Sciences

Bachelor of Sciences (Maths, Physics)