Muhammad Nawaz Sohail
Program Architect
Lahore
Summary of Career
1. Responsible for Installation, Maintenance, performance tuning of organization's database infrastructure and information system.
2. Manages database resources, including allocation of system storage. Working with the capacity management function, plans for future storage requirements, and prepares cases for additional resources
3. Responsible for plan, organize, direct, control and monitor the 24/7 database management system to support mission critical databases for financial applications.
4. Practical working experience of different database technologies which includes but are not limited to MySQL, MariaDB, Percona MySQL, MSSSQL, Informix , Oracle, Postgress, Ingres, vectorwise • Practical working experience of NoSQL databases which includes but are not limited to e.g. MongoDB, Redis, Cassandra etc
5. Responsible for data security and all operations related to data life cycle Proactively monitor the data subsystems for application performance and availability and take corrective action where needed
6. All aspects of database administration including installation, configuration, upgrades, patching, migration, capacity planning, performance tuning, backup and recovery
7. Change management including maintenance of multiple development, test, QA, and production environments. Responsible for deploying approved changes to production
8. Troubleshoot database-related application performance issues and perform routine and proactive maintenance activities
9. Database and operating system’s Monitoring Tools (Xymon , Nagios etc)
10. Working experience of Redhat/Solaris/SunOS/Centos/Windows environment
Experience as DBA Team Lead
Intagleo Systems Pvt Ltd
16 September 2016
31 May 2017
I have worked as Lead DBA. Objective of the job is to ensure that DB operations are properly in lined and working properly as per organization's Service Level Agreement and to make sure that Databases are available 24/7.
• Performing pre-requisites for database migration
• Finalizing the road-map for migration
• Strong knowledge of various migration tools and options for MySQL DB migration.
• Experience managing Linux systems with configuration management tools such as Puppet chef, ansible etc.
• All aspects of database administration including installation, configuration, upgrades, patching, migration, capacity planning, performance tuning, backup and recovery
• Responsible for database administration support for production, development, and test environments to include day-to-day monitoring and maintenance
• Implemeting HA solutions for MariaDB/MySQL
• Extensive experience with database backup, restoration, and migrations.
• Technical Trainings and presentation to different teams
• Automation of recurring Tasks
• Implementation of MySQL Cluster
• Experience working with Cloud Base solutions (Amazon, Azure etc).
• Experience in using Percona utilities
• Installation ,configuration and management of hadoop file-system
• Exploring NoSQL databases (Redis , Cassandra , Hive , Mongo etc)
• Collaborating with development, QA, DevOps and product teams to define requirements, conduct effective planning, and architect the design of optimal database solutions
• Manage database security, disaster recovery, and capacity planning.
• Monitor and ensure 24x7x365 databases availability and stable operation
• Ability to work with developers to troubleshoot and remediate challenging database problems.
• Managing and assigning tasks among the team and delegation of responsibilities
Experience as Program Architect
TRG
03 July 2017
19 July 2019
Involved in DB Design and architecture
Responsible for data security and all operations related to data life cycle
Proactively monitor the data subsystems for application performance and availability and take corrective action where needed
Bachelor 01 February 2009
IT, Databases, Networking etc