Muhammad Azim
Islamabad
Summary
Personable, detail-oriented, Database Administrator bringing more than 23 years' experience in the design and administration of databases, high expertise in managing multiple servers in multi-instance environments, performance optimization and proactive monitoring. Adept at delivering comprehensive database support to diagnose and resolve unique, recurring problems. Outstanding ability to support many projects at once while working within strict deadlines. Strong technical knowledge of database architecture in fast-paced, deadline-driven environments. Proven track record of managing 100's of database and legacy database conversions
Overview
24
24
years of professional experience
3
3
Languages
Work History
Sr. Enterprise Database Architect
Wiseman Innovations SMC Limited
Islamabad
01.2019 - Current
- Managing and administering SQL server databases & workloads in Azure cloud (IaaS)
- Hands-on experience in managing, administering databases in Azure environments
- Provision Database instances
- Maintain configuration of database instances including replication setup, parameter settings and identification of appropriate instance types/sizes
- Maintain database monitoring tools and alerts and develops new monitoring and alerting capabilities as needed
- Respond quickly and effectively to production issues, troubleshooting solutions, and taking responsibility for seeing those solutions through resolution
- Identify root cause and corrective actions for highly complex availability, capacity, security, performance, and quality issues affecting the database
- Ensure performance, security, and availability of databases
- Recommend and implement performance tuning solutions, such as indexing and partitioning
- Handle common database procedures, such as upgrade, backup, recovery, and migration
- Profile server resource usage optimize and tweak as necessary
- Monitor production database(s) in Azure, identifying emerging data-related issues, including system-level and
- SQL-level performance and database storage utilization; performing tuning and initiating proactive mitigating measures as appropriate; provides data-related incident response; and coordinates with others as necessary
- Work on multiple high priority tasks and adjust to priorities and deadlines to support internal and external stakeholders' deliverables.
Manager
Pakistan Revenue Automation Ltd
Islamabad
01.2007 - 01.2019
- Databases
- Lead the enterprise data center transition/migration project from databases standpoint and managed the SAN allocation strategy for all the enterprise SQL Server databases
- Prepared detail checklists, worksheets, configuration documents, implementation work flows, duty rosters for DBAs, Cluster architecture diagrams, replication architecture diagrams and other related documents
- 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, 2016 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 development of various recovery strategies that included media failure, user failure, and partial and complete recovery
- Fulfilling DBA daily, weekly and monthly activities including user management, space management, replication monitoring & trouble shooting, SQL Server Cluster administration and monitoring
- 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 wide SQL Server instances
- 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 standards for T-SQL, policies, practices and procedures
- Automated various DB tasks like Index reorganization/rebuild, data batch uploads, Full, Differential and
- Transaction log backup by creating and scheduling SQL Server agent jobs
- Implemented high level security policies for user accounts, passwords, profiles, roles and privileges across the enterprise database environments
- Finalized and documented several business rules for data integration tasks that led to designing and development of SSIS packages and related ETL scripts
- MIS reporting for domain specific reports related to tax collections, tax shortfalls, tax withheld, sector and region wise summaries and reports related to annual national budgets
System Engineer
NEC Corporation Japan
Islamabad
01.2005 - 01.2006
- Managed Sun Solaris 8 Operating system on Sunblade2500 system; Installation of Sun Solaris 8 OS, HP Open
- View 7.0, and NEC Pasolink Network Management System (PNMS)
- Pasolink trouble shooting, link configuration and Active and History Alarms reporting with the help of PNMS
- Managed the preparation of daily task schedule for the all the regional PNMS implementation teams
- Managed the site access approvals for the PNMS implementation team’s sites visits; deployment of PNMS implementation filed teams according regional needs
- IP addresses management across 40 plus regional subnets of over 8000 Network Elements (NE)
- Customer interaction for the provisioning of high-level NMS equipment for NMS interconnect
- Managed preparation and dissemination of weekly and daily NMS visibility progress reports for customer
Database Administrator
Pakistan Revenue Automation (Pvt.) Ltd
Islamabad
01.2003 - 01.2005
- 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 implementing of data quality control and business specific validation checks
- Processing and reorganizing data to and for databases and/or files, and preparing data management procedures
System Manager
Pakistan Revenue Automation (Pvt.) Ltd
Islamabad
01.1999 - 01.2003
- 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 2000 reports, and database optimization; supported developers with Oracle-related projects by creating new triggers, columns, tables, sequences and roles when requested
- 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 tax payers identification/registrations and electronic tax audits; the task required Data Migration & Integration; Oracle
- SQL & PL/SQL scripting and Oracle Report Builder 6i report designing.
Education
POST GRADUATE DIPLOMA - COMPUTER SCIENCE
Quaid-e-Azam University
BACHELOR OF SCIENCE - MATHEMATICS & PHYSICS
University of Peshawar
Skills
Technical Knowledgeundefined
Timeline
Sr. Enterprise Database Architect
Wiseman Innovations SMC Limited
01.2019 - Current
Manager
Pakistan Revenue Automation Ltd
01.2007 - 01.2019
System Engineer
NEC Corporation Japan
01.2005 - 01.2006
Database Administrator
Pakistan Revenue Automation (Pvt.) Ltd
01.2003 - 01.2005
System Manager
Pakistan Revenue Automation (Pvt.) Ltd
01.1999 - 01.2003
POST GRADUATE DIPLOMA - COMPUTER SCIENCE
Quaid-e-Azam University
BACHELOR OF SCIENCE - MATHEMATICS & PHYSICS
University of Peshawar
Similar Profiles
Hamza Ali TajHamza Ali Taj
Software Engineer at Wiseman InnovationsSoftware Engineer at Wiseman Innovations
Adnan KhaliqAdnan Khaliq
Principal Support Engineer at Wiseman InnovationsPrincipal Support Engineer at Wiseman Innovations
Khurram ImtiazKhurram Imtiaz
Associate Manager at Wiseman Innovations/DataQ Health(Dallas, US)Associate Manager at Wiseman Innovations/DataQ Health(Dallas, US)