Profile cover photo
You're now following
Error following user.
This user does not allow users to follow them.
You are already following this user.
Your membership plan only allows 0 follows. Upgrade here.
Successfully unfollowed
Error unfollowing user.
You have successfully recommended
Error recommending user.
Something went wrong. Please refresh the page and try again.
Email successfully verified.
User Avatar
$25 USD / hour
Flag of PAKISTAN
lahore, pakistan
$25 USD / hour
It's currently 7:59 PM here
Joined November 9, 2012
0 Recommendations

Muhammad Awais N.

@awais26

5.0 (29 reviews)
5.6
5.6
100%
100%
$25 USD / hour
Flag of PAKISTAN
lahore, pakistan
$25 USD / hour
100%
Jobs Completed
99%
On Budget
99%
On Time
5%
Repeat Hire Rate

SQL Server DBA Expert

Hi, I am DBA with 7+ years of experience in Sql Server Database Administration in Production, Test and Development Environment with MS Sql Server 2017, 2014, 2012, 2008R2 Systems along with Experience in managing Azure (IAAS & PAAS) databases. I am here to help you develop database according to your ideas that can tune up your business. I have personally worked for database development and administration to provide solutions for analyzing performance, Query optimization, Index Maintenance, Index tuning, Rebuilding, Reorganizing according to Fragmentation and Update statistics, DBCC commands to check Data integrity. Hands on Experience in High Availability Disaster Recovery techniques like Always on, Clustering, Mirroring, Log shipping, Replication like Translational, Snapshot. Good Experience in Database, Tables, Functions, Procedures, Views and T-SQL. Well Experience in Database Backups like Full/Differential/ Transactional log backup and Recovery, Point in Time Recovery. Experience in Database Automation tasks like Maintenance Plans, Jobs, Alerts, Sql Server Agent and monitoring and troubleshooting jobs. Experience in Migrating Sql Server 2000 to 2005/2008/2012/2014/2016.

Contact Muhammad Awais N. about your job

Log in to discuss any details over chat.

Portfolio

Reviews

Changes saved
Showing 1 - 5 out of 29 reviews
Filter reviews by:
5.0
$195.00 USD
Muhammad Awais N. excels as a freelancer, combining deep SQL server expertise with exceptional communication skills. He skillfully resolves performance issues, ensuring clients understand each solution. His professional and knowledgeable approach makes complex tasks seem effortless, truly setting him apart.
SQL
MySQL
Database Administration
Microsoft SQL Server
+1 more
C
Flag of Carlos O.
@CarlosAob
2 months ago
5.0
₹3,000.00 INR
Very nice guy, he has fixed our issues very quickly. Will hire him again in future.
SQL
Microsoft Access
Database Administration
Microsoft SQL Server
Database Development
User Avatar
Flag of Ahteshamuddin H.
@FutureAp
3 months ago
5.0
$150.00 USD
He did an excellent job. I appreciate that he was willing to work hard under my timeline requirements. He pays attention to detail. When I was having trouble getting him access to my system, he was patient and still delivered the work on time.
SQL
MySQL
Database Administration
Microsoft SQL Server
+1 more
C
Flag of Christian R.
@crodge12
3 months ago
5.0
$30.00 USD
It was a pleasure working with Muhammad
SQL
Microsoft Access
Database Administration
Database Programming
Database Development
User Avatar
Flag of Robert T.
@u2duttydread1
6 months ago
5.0
₹2,000.00 INR
I'm really happy with his work. Awais has good knowledge and expertise in MS SQL. I will surely hire him again in the future.
.NET
SQL
C# Programming
ASP.NET
Microsoft SQL Server
User Avatar
Flag of Neha S.
@nehasen18
6 months ago

Experience

Program Manager (core Database Administrator)

Punjab Information Technology Board
Jul 2019 - Mar 2022 (2 years, 8 months)
SQL server installation and configurations for SQL Server 2008/2019 High Availability and disaster recover solution Tune the queries, performance related issues like memory CPU and I/O issues Used SSIS an ETL tool of SQL Server to populate data from various data sources Designed various approaches like CDC (Change data capture), Auditing control Recovery strategy, Scheduling jobs Setup backup and restoration jobs for development and QA environments

Database Administrator

Tower Technologies
Jul 2017 - Jul 2019 (2 years)
Setup backup and restoration jobs for development and QA environments Replication and Database mirroring Analyze and optimize long running slow queries Reorganize and Rebuilding the indexes for better performance

Consultant Assistant Database Administrator

Land Record Management Information System Board of Revenue Punjab
Jul 2015 - Dec 2016 (1 year, 5 months)
SQL server installation and configurations Database Administration and Performance Scheduled Full and Transactional log backups for the user created in the production environment Setup backup and restoration jobs for development and QA environments Created transactional replication for the reporting applications CDC (Change data capture), Auditing control Recovery strategy, Scheduling jobs

Education

BS(IT)

University of Education, Pakistan 2010 - 2014
(4 years)

Qualifications

Microsoft Certified Professional

Microsoft
2017
Recognized as Microsoft Certified Professional in DBA Track.

Contact Muhammad Awais N. about your job

Log in to discuss any details over chat.

Verifications

Preferred Freelancer
Identity Verified
Payment Verified
Phone Verified
Email Verified
Facebook Connected

Certifications

SQL_1.png SQL 1 90%
Previous User Next User
Invite sent successfully!
Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.