Afzal Khan Khan

• Having around 7 years of experience as SQL Database Administrator
• Installing, configuring, managing, monitoring and troubleshooting SQL 2005 - SQL 2019 Performing unattended
installations.
• Handled Slipstream installations. And Installing Service Packs, Cumulative Updates, Hotfixes.
• Upgrading/Migrating SQL Server from older (from SQL 2005) to newer (till SQL 2019).
• Granting permissions also adding logins/users to roles in SQL Server Security
• Creating and Configuring Databases as per requirement of Application Teams.
• Backup Types (Full/Differential/Log) & Restore Scenarios Point-in-Time.
• Experience in taking backups across multiple files and locations to improve backup performance.
• Practical experience in enabling TDE on production database environments with Always On Availability Groups (AG).
• Handling Master, Model, MSDB, TEMPDB and Resource database corruptions.
• Knowledge of configuring Active Directory and adding VMs/Servers to Domain.
• Good Exposure on Configuring HADR like Mirroring, Clustering, Always-On AG, (DAG) & Replication.
• Ability to Create Indexes on tables to improve performance as per Dev/App team.
• Troubleshooting slow performing queries & giving tuning suggestions on Index, Statistics.
• Resolving Blockings and locking’s in the SQL Server.
• Providing 24/7 support and On-Call responsibilities for the production databases and servers.
• MS SQL Installation of SQL Server 2008/2012/2014/2016/2019, Configuring Availability Groups, and applying service packs.
• Interacting and collaborating with Management, Development teams, Functional teams, network teams and Systems administrators.
• Involved in Installing SQL Server and its service packs, and also client installations
• Checking the status of backup, troubleshooting the failed backups and restoration
• On-Call responsibilities for Production database systems.
• Monitoring SQL Server performance using extended events/profiler.
• Creating Indexes on tables to improve the performance as per Dev/App teams.
• Performing SQL server daily health check and preparing a report based on it.
• Scheduled and maintain routine Jobs, Alerts and Maintenance Plans.
• Monitoring the Logs for successful execution of all the specified jobs.
• Reviewing SQL Server and SQL Agent Error Logs.

• Installation and support for Intraoral Equipment provided by Planmeca Romexis Dental Application, intraoral sensors, CADCAM milling machine, CBCT X-Rays machines like Planmeca 2D, 3D and Cephalometric, Planmeca Emerald scanner.
• Responsible of major government, Private hospitals and clinics for technical support services ( i.e. National Guard(Ryd, Dammam & Alhasa), KFSC, Security Training City(Riyadh) MOH dental center Hail, MOH Dental Center Al JOUF, Suleiman Habib hospital (Rayyan), SMCH, consultant Clinics etc.)
• Installation and support for all Dental related Planmeca imaging Products.
• Installing Upgrading Planmeca Romexis Application Server and Client.
• Configure PMBridge with dynamic ports.
• Installing and Configuring intraoral camera.
• Maintenance scheduling and demands from the customer.
• Setting up Planmeca Romexis backup and Planmeca Romexis log files.
• Responsible of Technical support services for major Dental colleges in Riyadh and other regions which are under company portfolio. (I.e. KSU, KAAUH, Princess Noura University, FARABI dental college, Imam university, Majma University, Um-ul-Qura University, Jizan university).
• Responsible of conducting training session for all the customers on the software which are on company portfolio (Dental related).
• Supervising Technical Team members from other regions on various projects
• Dealing with Planmeca Finland development team on customization and integration for various Projects.
• Dealing with Planmeca Finland for warranty and paid repair of Intraoral Equipment.
• Hardware: Intra-Oral Cameras, RVG Sensors and X-Ray machines.
• Supervising Server installation, Clustering, Networking.
• Responsible for training end users on software/applications/hardware installed
• Dental Picture Archiving Communication Systems (Planmeca Finland)
• Imaging Software (Planmeca Finland)
• Dealing with CareStream UK development team on customization and integration for various Projects.
• Dealing with CareStream France for warranty and paid repair of Intraoral Equipment.
• Software: Dental Practice Management Software. CareStream Dental R4 Clinical+
• Dental Picture Archiving Communication Systems (Carestream Dental - UK/France)
• Dental Practice Management Software (Carestream Dental - UK)
• Imaging Software (Carestream Dental - France)
• Systems Integrations.
• Virtual Machines installations.
• Cluster Environments.

• System Administration tasks on LAN and WAN administration Windows 2000, and Windows Server 2003 Servers Domain Administration.
• Installation and Support of Windows 2000/2003/2008 servers, networking components and applications.
• Working with Active Directory. Assign and create user accounts and grant permissions to shared resources.
• Installation, configuration, and troubleshooting of Windows 2000/2003 Servers: Group Policies, Active Directory, Security, DHCP, DNS, and EXCHANGE 2003, and Windows Office Suites.
• Provided all hardware and software support for end-users as well as computers and printers.
• Working with Active Directory. Assign and create user accounts and grant permissions to shared resources.
• Assure senior management of data protection by demonstrating permission settings.
• installation, Configuration, Troubleshooting and Maintenance Support of ISA Server 2000/2003/2007.
• Experience working with Active Directory. Assign and create user accounts and grant permissions to shared resources. Assure senior management of data protection by demonstrating permission settings.
• Hardware and Software Installation, Configuration and Upgradation, Computer Assembling, Maintenance and Troubleshooting of PCs & peripherals.
• Managing, Monitoring and optimizing System Performance, Reliability and Availability.
• Supporting Windows 2000 and 2003 & 2008 based Computers and Networks.
• Designed Local Area Network using CAT 5, CAT 6 medium over 100 systems.
• Providing DNS, DHCP and WINS,
• Virtual Private Networks, TCP/IP.
• Hardware Maintenance & Servicing.