●Main technologies worked on MySQL, AWS RDS, AWS DynamoDB and AWS Aurora. ●Includes administration, operations, support, maintenance, monitoring of database servers to ensure availability ●Recommend solutions and follows standards on database physical structure, functional capabilities & backups. ●Maintains database performance by calculating optimum values for database parameters; implementing new releases with AWS; completing maintenance requirements. ●Responsible to perform query optimization, database design optimization in addition to helping/reviews/feedbacks to stakeholders in writing complex queries, stored procedures/functions, views, DDL/DML script. ●Controlling access permissions, privileges to ensure data security. ●Project based company rules followed on the databases. Selected Achievements: Performed Normalization of tables with redundant columns leading to decrease in time taken to retrieve data from tables Vertically partitioned table as per requirement leading to less data being used on the server Horizontally partitioned table as per requirement leading to higher availability of data Created SPs to delete data in chunks that reduced 150GB table to 100GB without causing unavailability of the table Created Databases related SOPs from scratch for the team as well as documentation for databases that were being used Onboarded team to ticketing system for DB related issues which was implemented across other teams as well for smoother collaboration Set up an SP that would track user privileges across all databases creating ease in comparing user privileges in future Advanced tech skills & tools: MySQL, AWS RDS, AWS Aurora, AWS DynamoDB, Linux, PuTTY, MySQL Workbench

Afiniti | Sep 2020 - Jul 2022

Database Administrator

• Main technologies worked on MySQL, MySQL Workbench, GreenPlum, PostgreSQL and MSSQL • Includes installation, administration, operations, support, maintenance, monitoring & upgradation of database servers to ensure availability, security with optimal performance • Recommend solutions and follows standards on database physical structure, functional capabilities, security & backups. • Maintains database performance by calculating optimum values for database parameters; implementing new releases; completing maintenance requirements. • Maintains quality of service by establishing and enforcing organization standards. • Responsible to perform query optimization, database design optimization in addition to providing assistance/reviews/feedbacks to stakeholders in writing complex queries, stored procedures/functions, views, DDL/DML script. • Troubleshoot complex database issues in accurate and timely manner ensuring defined SLAs / OLAs. • Maintaining data standards, including adherence to the Data Protection Act. • Controlling access permissions, privileges to ensure data security. • Maintain database disaster recovery procedures to ensure continuous availability and speedy recovery.

Afiniti | Jun 2016 - Sep 2020

Technical Production Analyst - Team Lead

N/A

My Education

Take a look at my formal education

Postgraduate Diploma, Information TechnologyVirtual University of Pakistan | 2019

Bachelor of Science (BS), Electrical, Electronics and Communications EngineeringLahore University of Management Sciences | 2016

A-levels, SciencesLahore Grammar School | 2011

O-Levels, SciencesBeaconhouse School System | 2009

About Me

Actively looking for a job in Toronto, Ontario, Canada. I have been a part of Database Administration teams since 2016 and have been closely working with MySQL, MSSQL, PostgreSQL and alike. I want to expand my career to Data Analytics.

Create Your Data Portfolio for Free