Amir Ashamalla
Mentor
(28 reviews)
US$8.00
For every 15 mins
52
Sessions/Jobs
ABOUT ME
Motivated Doctor with over 20 years experience
Motivated Doctor with over 20 years experience
An experienced Doctor (Ph.D. holder), motivated and committed professional with over 20 years of experience in the industry. My extensive skills were acquired in the private and academic sectors.
Arabic, English
Sydney (+10:00)
Joined July 2022
EXPERTISE
20 years experience | 6 endorsements
6 years experience
6 years experience
7 years experience
5 years experience
10 years experience
25 years experience | 2 endorsements
REVIEWS FROM CLIENTS
(28 reviews)
Dianna Lally
March 2023
Amir assisted with some unusual activity in PowerBI. We honed in on the issues and successfully resolved them. Thank you Amir!
Dianna Lally
March 2023
Amir was helpful in trying to resolve a few buggy items in Power BI. I appreciate his patience and review of my work :-).
John A Larson
November 2022
Amir did a great job for me and is always very helpful in helping me troubleshoot my issues.
John A Larson
September 2022
Amir quickly resolved a challenge I was having with performing complex calculations in excel.
John A Larson
September 2022
Amir solved a very complicated challenge that I had in excel. He is very knowledgeable and efficient working with Excel and Power BI,
Dan Williams
September 2022
Knowledgeable about power Bi and got me where i needed to go.
Anna Sharpe
September 2022
Amir is a really great teacher.
Tomasz Ksionek
September 2022
Amir is a very good and helpful teacher.
Anna Sharpe
September 2022
Amir is a great mentor.
David Stamm
August 2022
Amir was great to work with. Friendly and patient. He was very aware of the time aspect of the session and wanted to provide good value and not just run up the clock. Overall a great experience. Thanks Amir.
EMPLOYMENTS
Senior Database Administrator
The university of New South wales
2019-11-01-Present
• Maintaining current Data center and AWS Cloud SQL server infrastructure and databases
• Designing and implementing database security st...
• Maintaining current Data center and AWS Cloud SQL server infrastructure and databases
• Designing and implementing database security standards.
• Designing, Planning and implementing changes required for current and future SQL database installations.
• Planning SQL 2008, 2008R2 upgrades.
• Decommissioning and Consolidating SQL 2005 and 2008 servers.
• Enhancing and optimizing SQL server performance.
• Testing DR solutions and verifying replication.
• Planning, Designing and Implementing a new database and website to collect information about database Servers.
MySQL
Excel
Microsoft SQL Server
View more
MySQL
Excel
Microsoft SQL Server
Microsoft Power BI
AWS (Amazon Web Services)
View more
Database Specialist
The university of Sydney
2010-08-01-2019-11-01
• Maintaining current SQL server infrastructure and databases including sharePoint, IRMA, ECHO...etc.
• Designing and implementing databa...
• Maintaining current SQL server infrastructure and databases including sharePoint, IRMA, ECHO...etc.
• Designing and implementing database security standards.
• Designing, Planning and implementing changes required for current and future SQL database installations.
• Planning SQL 2000/2005 upgrade to SQL 2008, 2008R2, 2012 and 2016.
• Decommissioning and Consolidating SQL 2000, 2005 and 2008 servers.
• Patching SQL server with the latest Microsoft patches.
• Testing DR solutions and verifying replication.
• Planning, Designing and Implementing a new database and website to collect information about database Servers.
Excel
SQLite
Azure
View more
Excel
SQLite
Azure
Microsoft SQL Server
Microsoft Power BI
AWS (Amazon Web Services)
View more
DBA
RaboBank
2009-07-01-2010-03-01
• Designing and implementing database security standards.
• Comparing database implementation to the bank standards.
• Planning and imple...
• Designing and implementing database security standards.
• Comparing database implementation to the bank standards.
• Planning and implementing changes required for current and future SQL database installations to meet bank standards.
• Planning SQL 2000/2005 upgrade to 2008.
• Decommissioning and Consolidating SQL 2000 and 2005 servers.
• Patching SQL server with the latest Microsoft patches.
• Testing DR solutions and verifying replication.
• Identifying and reporting key risk elements that the bank could face and planning to avoid, reduce the risk factor
Microsoft SQL Server
View more
Microsoft SQL Server
View more
PROJECTS
SQL Reports
UNSW
2021
Created colourfull email reports, sent daily that highlight tasks assigned to employees when delayed as red, in risk of delay as amber, ...
Created colourfull email reports, sent daily that highlight tasks assigned to employees when delayed as red, in risk of delay as amber, and on track as green.
HTML
Microsoft SQL Server
View more
HTML
Microsoft SQL Server
View more
Mobile Appliecation with AWS Backend
2022
Developed a mobile application (Android and iPhone) with its backend AWS services. This included authentication, Database, Notifications...
Developed a mobile application (Android and iPhone) with its backend AWS services. This included authentication, Database, Notifications, and file storage
Java
Amazon S3
Android Studio
View more
Java
Amazon S3
Android Studio
Swift
AWS DynamoDB
iOS
AWS (Amazon Web Services)
View more