Niaz Ur Rehman Dawar Email & Phone Number

Riyadh, Sa

Riyadh, Sa

SQL Server Mastery:Leveraging an in-depth understanding of SQL Server details, I provide services in database administration, prioritizing optimal performance and reliability for clients.Server Health Assessment:Conducting comprehensive server health assessments, I proactively identify and address potential issues, contributing to the establishment of a robust and stable database environment.Always On Availability and Disaster Management:Implementing and managing availability solutions, I focus on availability and disaster recovery, ensuring business continuity even in the face of unforeseen challenges.SSIS Package Development:Proficient in developing troubleshooting SSIS packages, I facilitate seamless data migrations to and from SQL Server, contributing to efficient and secure data management processes for clients.SQL Query Optimization:Demonstrating expertise in writing and analyzing complex SQL queries, I concentrate on performance tuning and indexing strategies, enhancing overall database efficiency.Cloud Experience:With proficiency in Azure, I provide comprehensive cloud solutions. This includes - Cloud architecture, - Resource management, and deployment of scalable and resilient solutions. I specialize in Azure Cloud computing models, - Azure SQL Server solutions, - Storage redundancy setup, - Azure Site Recovery setup. My expertise extends to cloud-based database solutions, migration, and the implementation of availability and disaster recovery strategies tailored to client needs.

Karachi

- Database management including Installation, database configuration, security implementation, database optimization, develop backup and recovery strategies, data migration plans- Designed, developed and successfully implemented Web, Desktop and Cloud based application using Microsoft SQL Server and Azure Cloud Services.- Proficiently writing complex PowerShell Scripts, SQL queries, stored procedures, functions, and designing and implementing database schemas.

Madina Munawarah, Ksa

Taibah University, Ministry of Higher Educationhttps://taibahu.edu.sa/Pages/AR/Home.aspxLocation: Madinah Al Munawwarah, Kingdom of Saudi ArabiaPosition: Full-time Faculty MemberResponsibilities and Courses Taught:As a full-time faculty member at Taibah University, Ministry of Higher Education, I have been actively involved in imparting knowledge and skills to diploma and BS(CS) students. My teaching portfolio encompasses a diverse range of courses, contributing to the holistic development of students in the field of computer science. Key courses taught include:Computer Programming Languages: Guiding students in mastering various programming languages, providing a foundation for software development.Internet Application Programming: Instructing on the development of web applications, including both frontend and backend technologies.Smartphone Application Development: Covering the principles and practices of developing applications for mobile platforms.Database Management System: Educating students on the principles and techniques of managing and organizing databases effectively.Other subjects include System Analysis and Design,Data Structure & Analysis, Algorithms Analysis and Parallel ComputingProfessional Ethics: Instilling a strong sense of professional ethics and responsibility in the field of computer science.Software Project Management: Equipping students with the skills needed to effectively manage software development projects from inception to completion.

Saudi Arabia

- Experienced SQL Server Database Administrator with a tenure at PetroChina International from 2014 to 2017, working remotely.- Skilled in troubleshooting SQL Agent jobs, optimizing performance for streamlined data processing.- Expertise in utilizing SSRS & SSIS for reporting and data integration.- Specialized in configuring and managing Failover Clustering for resilient system architectures.- Dedicated to ensuring data integrity, minimizing downtime, and delivering high-quality solutions in a remote work environment.- Industry-specific knowledge in supporting the energy sector's data management needs.

Jeddah Governorate, Saudi Arabia

Global Arabian for Modern Application (GAMA), Jeddah, KSAOfficial Website : https://www.gama-ksa.com/ Position: DBA and DeveloperEmployment Type: Full-timeKey Contributions and Responsibilities:As a dedicated member of the GAMA team, I played a crucial role in development and analysis, focusing on B2B (Business-to-Business), B2C (Business-to-Consumer), and B2G (Business-to-Government) applications. My contributions spanned various technologies and projects.Technological Expertise: I excel in developing complex stored procedures, optimizing queries, redesigning database components, integrating with government databases, and implementing policy triggers for adherence to government regulations.Umrah Application Project: Played a significant role in the Umrah Application project. Further details about this project can be found in the projects section, highlighting my involvement in a specific and impactful initiative.B2B, B2C, B2G Development: Successfully contributed to the development and analysis of applications catering to diverse business models, enhancing functionality for business, consumer, and government interactions.Full-time and Part-time Engagement: Demonstrated flexibility and commitment by working both on a full-time and part-time basis, showcasing dedication to project success and organizational goals.Project Duration: Engaged with GAMA from February 2009 to December 2013, contributing to the company's success over a substantial period.This experience allowed me to work on a variety of projects, hone my skills in multiple technologies, and actively participate in the development of solutions catering to different business domains. My time at GAMA was marked by continuous learning, effective collaboration, and a commitment to delivering high-quality applications.

Islamabad Pakistan

OGDCL, a key player in the oil exploration and production sector under the Government of Pakistan, manages an extensive network comprising over 50 oil fields and 20 processing plants. Our responsibility involved systematically capturing data from each well, encompassing over 100 distinct parameters, and storing it in SQL Server databases. Leveraging the Avocet Production Operation Software by Schlumberger, we facilitated the presentation of comprehensive data to the senior management with a help of OFM Analytics, enabling them to assess change impacts and analyze well behavior effectively.

Responsibilities:As a Software Developer at Synergy Computers, the key focus is on developing a Retail Banking Solution. The role involves utilizing the following technologies:Visual Basic 6.0 (VB 6.0): Leveraging VB 6.0 for the development of user interfaces, business logic, and integration with other components.Crystal Report: Designing and implementing comprehensive reporting solutions using Crystal Report, ensuring accurate and visually appealing representation of data.SQL Server: Employing SQL Server for robust database management, including data storage, retrieval, and optimization for the Retail Banking Solution.Job Scope:Development: Actively involved in the design and coding phases of the Retail Banking Solution, ensuring adherence to best practices and project requirements. Reporting: Designing and implementing Crystal Reports to provide meaningful insights and analysis within the Retail Banking Solution.

Part time

M.Phil, Computer Science, A

Activities and Societies: - A Lightweight Incentive Scheme for Services Advertisement and Discovery in Bus-based VANET - Geometry-based 3D.

Master, Computer Science

Master

Graduation, Computer Science, Math, Economics

Graduation

Acp, Computer Science

ACCP - Aptech Certified Computer Professional

Foundation Degree, Pre-Engineering, A

F.Sc (Pre-Engineering)