• Working as a senior database Engineer, Leading all Database projects in digitify.• Arranging Scrum with database Team on daily basis.• AWS RDS/aurora Database base design for fintech client and implementation and Documentation• Implementation of AWS RDS/aurora / Azure for MYSQL Best practices.• Implementation of AWS RDS/aurora / Azure for MYSQL backup and point in time recovery.• Implementation of monitoring AWS RDS/aurora / Azure for MYSQL cloud watch.• Implementation of audit logs on AWS RDS/aurora / Azure for MYSQL.• Implementation of events and store procedures for archiving.• MySQL HA Database base design for fintech client and implementation and Documentation.• MySQL Database encryption implementation and Design.• MySQL Database Backup implementation and Documentation and Automation.• MySQL Query review and query optimization, index creation, table partition.• Archiving of large tables from production to non-production environment.• Script review and script deployment.• Automation of monitoring scripts in bash.• Performance tuning of Mysql database.• Tableau server for data Analytics Administration

• Installation, administration, monitoring & support, maintenance, up-gradations MySQL database servers to ensure 24/7 availability.• Manage database instance running on Linux Machines, window Machines andAWS Cloud.• Implements standardized solutions to manage database physical structures, functional capabilities, security, backups, replication, archiving/purging etc.• Maintains quality of service by practicing defined SOPs, organizational standards,Compliance requirements & change management process.• Database performance tuning especially SQL query optimization and scriptsReviews.• Troubleshoot & resolve production database issues in accurate and timely manner within defined SLAs / OLAs & practice ITIL incident/problem management process.• Manage database physical & logical structures, access & authorization,Maintenance plans, database resources & standard DBA tasks.• Maintain a good, healthy & friendly environment within & outside team.• Provide requested reports like RCA, Database Health Report etc.• SQL Optimization, Research and development on latest features in MySQL and Cloud based technologies.

The Resource Group (TRG) Pakistan is the country’s largest provider of BPO services with 4 locations in Karachi and Lahore – Pakistan’s largest cities and financial centers.My duties include to take care of DB operations using MySQL Replication and MySQL Cluster Technologies mainly.Duties include:o Install/configure MySQL Serverso High Availability using MySQL Replication,MYSql fabric,MYSQL5.7 multisource replication.o Monitoring and Performance Management of MySQL Serverso Backup & Recovery using SQL and LVM backupso Various projects like MySQL Cluster, MySQL Proxy,Tungsten Replicator, Percona XtraDB Cluster etc.o Monitoring the performance of Database servers using MYSQL5.7 sys schema.o Performance Managemento High Availability Application Clustero Work on Percona toolkit for different operations for database administration.

Internship