About

SQL Server Expert Job: Configure ODBC Linked Server for AdvancedMD Data Warehouse Server setup, updated. Need only the Linked Server integration. I need an experienced SQL Server professional to configure an ODBC linked server connection to AdvancedMD's ODBC Access Kit and help set up our local data warehouse for healthcare reporting. ## Scope of Work - Set up SQL Server linked server using Microsoft OLE DB Provider for ODBC Driver - Configure System DSN with provided office key credentials - Test connection and troubleshoot any connectivity issues - Assist with initial setup of data warehouse tables using provided SQL scripts - Document the configuration for future reference Files: https://drive.google.com/drive/folders/119ztgyxTxj0_huufkH58n3y1b6HzwxvS?usp=sharing ## Technical Requirements **Must Have:** - Expert-level MS SQL Server administration experience - Proven experience configuring ODBC linked servers - Experience with Microsoft OLE DB Provider for ODBC Drivers - Strong troubleshooting skills for ODBC/SQL connectivity issues ## What I'll Provide - Running Windows Server with SQL 2019 and SMSS - ODBC driver installer files - All key credentials and connection details - Remote access to the Windows server/workstation ## To Apply Please include: 1. Your experience with ODBC linked server configurations (specific examples) **Looking for someone who can start immediately and complete this quickly. Clear communication and documented experience with similar projects are essential.**