Software Engineer Maintenance

Muhammad Nawaz **********@*****.***

Personal Details

Father Name: Muhammad Suhail Tabbassum

Date of birth: November 5th, 1986

Nationality: Pakistan

Location: Lahore, Pakistan

Gender: Male

Marital Status: Married

Tel: +92-333-*******

Skype: nawaz.sohail

Career Aim

I am energetic and self-motivated. My aim is to be an integral part in the organization’s growth utilizing best of my capabilities. I want to achieve my personal and corporate goals and to use the best of my Computer, Analytical, Developmental and Management skills in the challenging work environment.

Professional Experiences

Experience as Database Administrator and with strong knowledge of system integration, multi Operating systems skills. I carry Practical experience of Databases and strong knowledge of multiple Operating System (OS) Linux/Windows, application configurations and application maintenance.

Some major points of my professional experience include but are not limited to

DBA Experience of multiple platforms such as MySQL, MSSQL, Informix and Ingres/Vectorwise, MongoDB, MariaDB, Oracle for both Windows/Unix* environments.

Experienced in PL/SQL and T-SQL and related query languages.

8-years industry experience administering databases (MySQL, MSSQL, Informix, MariaDB, Oracle), OLTP/OLAP with strong SQL experience.

Experience with replication/HA in a complex and dynamic production environment also different replication topologies/techniques of replications in MySQL.

Ability to prioritize tasks, work independently and customer facing

System administration experience on Unix* platforms

Support experience in Big Data or data warehousing environments

July 2017 to Present Principal Software Engineer-DBA at TRG (Afiniti).

Managing Database Security and improving database performances.

Implementing database security practices (TDE & Encryption & Decryption etc.)

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

Performs database re-organisations as required to assist performance and ensure maximum uptime of the database

September 2016 to May 2017 Lead DBA at Intagleo Systems.

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 Puppetchef, 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

Implementing 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.

July 2014 to September 2016 Senior Software Engineer: Database at TRG.

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

Problem investigation and resolution, backup creation and maintenance, MySQL and database optimization and tuning.

Experience of working with Bash/Batch/Perl etc

implementing solutions for database performance monitoring, storage optimization, SQL tuning and configuration management

Perform maintenance, troubleshooting, tuning, optimization, installation, upgrades, backup/recovery, auditing, logging and data migration across multiple data centres and multiple database server architectures/systems

Point in time recovery for MSSQL and MySQL

Experience in Working MSSQL (2005,2008,2012) &MySQL 5.5,5.6 and 5.7

Database recoverability including backups, restores, log shipping, mirroring, replication etc.

Monitors databases for optimal performance and act to mitigate blocking and performance tuning issues.

Change management including maintenance of multiple development, test, QA, and production environments. Responsible for deploying approved changes to production

Understanding of, and experience with, server-client computing and relational database environments and extensive experience of batch and power-shell scripting

MSSQL and MySQL High Availability Solutions

Migration from MSSQL to MySQL and from MySQL to MSSSQL

Practical Experience of various OS like Windows and Unix*

SSIS Package Development and deployments

Talend Packages development and deployments.

September 2012 to July 2014 Senior Software Engineer: Database at i2cinc.

Installation and troubleshooting of different databases (MySQL, Informix, Oracle, PostgreSQL, Vectorwise, Paradox etc).

Performance Tuning of Databases being used in organization

Database and operating system’s Monitoring Tools (Xymon, Nagios etc)

Implementation and maintenance of MySQL enterprise Monitoring tool for all MySQL nodes

Working experience of Redhat/Solaris/SunOS/Centos environment

Level-0,Level-1 and Level-2 Backups on MySQL and Informix

Configuring and managing HDR & RSS in Informix

Support for Local& Production Databases related issue

Reviewing User defined routines and Procedures and extensive experience of shell scripting

Database backups and recovery Techniques

Table partitioning and switching in Informix

DB Auditing in Informix

Incidence management and Disaster Recovery.

June-2009 To September 2012 DBA at Allied Bank Pvt. (Ltd)

Installation and troubleshooting of MySQL

Database Performance Tuning

Maintenance of Data verification at CDB (Central Database)

Defining standard procedures for migration activities

Application configuration and customizing according to the organization need

Defining scope of an application

Embedding new change objects within the already existing domain

Conducting professional and user end trainings

Strong understanding of application Work Flow

Operational skills at organizational level

Strong understanding of Banking/Financial Systems

Communicating the application bugs to the concerned quarters and timely corrections.

Migrating from one application to another application

Academic Background

DEGREE (Session)

INSTITUTE

MARKS BSIT

2005-2009

Punjab University College Of Information Technology

77%

F.Sc (Pre-Engineering)

2002-2004

Govt College Gojra

63%

Matriculation

2002

GovtM.C.High School Gojra

79%

Interests &Hobbies

Keen in computer related stuff,Music, Movies, Sports Travel, Adventure,Swimming

Reference

Reference will be provided upon request.

Contact this candidate