Majid Khan

Experience

1. Production Engineer

   Afiniti

   Apr 2018 — Present · Washington, DC, US

   Microsoft SQL Server Administration and Optimization: Proficient in administering and optimizing Microsoft SQL Server databases (2012, 2014, 2016, 2019) in both clustered and non-clustered environments.Database Performance Tuning: Skilled in identifying performance bottlenecks and implementing tuning strategies using SQL Server Profiler, Database Tuning Advisor, and DMVs.Query Optimization: Expertise in advanced query optimization techniques, including indexing strategies, query rewriting, and execution plan analysis.IBM DB2 PureScale: Experience with IBM DB2 PureScale for high availability and scalability in large database environments.IBM InfoSphere Change Data Capture (CDC): Proficient in using IBM InfoSphere CDC for real-time data replication and synchronization across heterogeneous databases.DB2 Data Server Manager (DSM): Skilled in utilizing DB2 DSM for database administration, performance monitoring, and management tasks.MySQL: Practical experience with MySQL database administration, performance tuning, and query optimization.Oracle: Working knowledge of Oracle database administration and optimization techniques.ETL Processing: Strong background in designing and implementing ETL processes for efficient data transfer between systems.SQL Scripting: Proficient in writing complex SQL scripts for data manipulation, reporting, and automation tasks.SQL Server Reporting Services (SSRS): Experienced in developing, deploying, and managing reports using SSRS for business-critical data visualization.

Education

• George Mason University

  Bachelor of Applied Science - BASc, Information Technology

• Northern Virginia Community College

  Associate's degree, Information Technology

• Northern Virginia Community College

  Associate's degree, Information Technology

  2012 — 2015