خلاصہ

Seeking a team where my passion and self-motivation can be leveraged to work on multiple concurrent projects and my professionalism can diffuse high pressure situations. Having excellent customer service skills and the ability to work effectively with clients and team members.
I start my day with a learning mindset and believe in continuous learning, always seek new opportunities and challenges to grow myself and others. I enjoy working in a diverse environment and love making best use of technology.

Below is my professional summary.

1. Installation and configuration of SQL Server in accordance to business needs and requirements.
2. Designing, implementing and documenting high availability and disaster recovery solutions using different methodologies i.e. backup/ restore, Log Shipping, Replication, AlwaysOn and Failover Clustering.
3. Designing, implementing and documenting consolidation strategies.
4. Critical Alerts Configuration to ensure continuous business operations and to mitigate / minimize downtime.
5. Testing for new applications or modifications. Testing in pre-production environment before live implementation to test software updates, bug fixes, SQL cumulative updates, service packs, upgrades and OS releases. Responsible for remedial maintenance with updates to other teams as necessary.
6. Manage and perform database maintenance (Index / Statistics) using different automated script to ensure optimal database performance.
7. Designing, implementing and documenting backup and restore strategies to meet the business RPOs and RTOs.
8. Documenting backup and restore scripts and making it available to the team and ensuring backup is valid and restorable.
9. Troubleshoot different database issues to support mission critical applications.
10. Expert T.SQL Development i.e. Stored Procedures, Views, Functions and Triggers.
11. Tuning Queries for different reports and applications.

تجربہ

کمپنی کا لوگو
Senior Arhitect Database & BI , Senior T.SQL Developer
Adrem Technologies
اپریل ۲۰۱۴ - موجودہ | Dubai, United Arab Emirates

کمپنی کا لوگو
.net developer / T-SQL Developer / SQL DBA / BI Consultant
Supreme Group
مارچ ۲۰۱۱ - اپریل ۲۰۱۴ | Dubai, United Arab Emirates

• Maintenance and Administration of SQL Server databases and Multidimensional Cubes (Process, Backup, Restore) and enhancement to existing data warehouse.
• SQL Server installation, configuration, maintenance, upgrade and patch management.
• Designing, documenting, cleaning and implementation of data mart using SSIS, SSAS both Multi-Dimensional and Tabular.
• Application development using C#, VB.net and ASP.net.
• T-SQL development and helping the development team in troubleshooting different database issues and in writing optimal and advance queries (adhoc and stored procedures).
• Exploring and analyzing new SQL features and educating the team on how to use it.
• Troubleshooting different SQL server issues to support business critical applications and ensure best database performance.
• Documenting, Designing and implementation of Database backup and restore strategies.
• Report Development using SSRS / Crystal Reports and Power BI.

کمپنی کا لوگو
Software Engineer / SQL Developer.
ERAD International
جولائی ۲۰۰۹ - مارچ ۲۰۱۱ | Dubai, United Arab Emirates

• .Net development using C#, VB.net and ASP.net
• Integration with different applications using Rest APIs, web services.
• Troubleshooting, designing, installation, upgrade and maintenance of SQL Server.
• Maintaining SQL Server database to ensure optimal performance.
• Web and windows-based application development using C#, VB.net and Asp.net.
• Report development using SSRS.
• Data migration (from production to staging server) using SQL Server Import / Export, SSIS and Replication.
• T-SQL Development.

کمپنی کا لوگو
Software Engineer
TKXEL
جولائی ۲۰۰۸ - جون ۲۰۰۹ | Lahore, Pakistan

1. Software Development using VB.net, C# and Asp.net
2. T-SQL Development, writing optimal and optimized stored procedures.
3. Gathering Requirements.
4. Web Services development.

تعلیم

Microsoft
سرٹیفیکیشن, Microsoft Professional Program‎
Data Science
نامکمل
2018
Microsoft Corporation (License# MS 0610128238)
سرٹیفیکیشن, Microsoft Professional Program‎
Big Data
مکمل
2016
Microsoft Corporation (License# MS 0610128238)
سرٹیفیکیشن, Querying Microsoft SQL Server 2012 / 2014‎
T.SQL
مکمل
2014
Microsoft
سرٹیفیکیشن, Administering Microsoft SQL Server 2012 / 2014‎
Database Administration
مکمل
2014
Virtual University of Pakistan
بی سی ایس / بی ایس, Computer Science‎
Computer Science
درجہ B
2008

پیشہ ورانہ مہارتیں

ماہر .Net
متوسط Automation Languages Command
ابتدائی AWS RDS
ماہر BI
ابتدائی Crystal Reports 10.0
ماہر HA / DR
ماہر MSSQL
ماہر Optimizing SQL Performnace
ماہر Performance Tuning
ماہر Query Language
ماہر SQL Azure
ماہر SSAS
ماہر SSIS
ماہر SSRS
ماہر Troubleshooting
ماہر TSQL
ماہر Writing Stored Procedures

زبانیں

ماہر پشتو
ماہر اردو
ماہر انگریزی

آپ کن کمپنیز کی پیروی کر رہے ہیں