This job offer is not available in your country.

Senior Access & SQL Specialist

ResearchFox ConsultingSalem,Tamil Nadu, IN

11 hours ago

Job description

Title : Senior Access & SQL Specialist

Team : AI Strategy & Transformation team (Integration Pod)

Location : Remote |

Experience : 7–10 years

Role Overview

We are looking for highly versatile, pragmatic individual to join our AI Strategy & Transformation team as a hands-on engineer who pairs deep Microsoft Access / VBA expertise with strong SQL data engineering. You’ll take day-to-day ownership of a mission-critical Access application, help migrate data and algorithms to SQL Server and Azure Synapse, and supporting other initiatives within that environment.

You’ll be highly fluent and capable of dealing with a complex Access application (with hundreds of objects, forms, and several thousand lines of VBA code). You’ll be adept at picking up complex form / code, diving in to understand how things work and reworking / improving or building out new capabilities. You’ll assume day-to-day ownership, improve reliability / change control, and partner to migrate core data stores and selected algorithms from SharePoint / Access to SQL Server and into our Azure Synapse environment.

Responsibilities (Access database)

Own day-to-day operations of the Access app (front end + back end) : forms, queries, reports, macros, and advanced VBA (class modules, error handling, logging).
Diagnose / optimize existing code; refactor for performance and maintainability; reduce technical debt.
Manage linked tables (within a SQL database in our Azure environment), implement pass-through queries, and tune for performance.
Establish disciplined SDLC for Access : versioning (ACCDE builds), backup / restore, regression testing, change logs, documentation, and release checklists.
Improve usability of forms and workflows for content managers.

Responsibilities (SQL & Azure)

Design and implement SQL Server / Azure SQL schemas, indexes, views, stored procedures, and UDFs to replace / augment Access data stores and calculations.

Plan and execute migrations of capabilities into SQL Server with reconciliation, validation, and rollback strategies.

Build / operate ELT / ETL with Azure Synapse and / or ADF; parameterize / orchestrate, monitor, and alert.

Collaborate with analysts / data scientists to deliver high-quality, well-documented datasets for analytics / BI (e.g., Power BI).

Contribute to secure data practices (RBAC, secrets management / Key Vault, row-level security where applicable).

Skills / Qualifications (must-have)

Microsoft Access expert : complex queries (joins, crosstabs), multi-form architectures, advanced VBA (API / ADO / DAO, performance tuning, robust error handling), pass-through queries, ODBC optimization.

SQL expert : strong T-SQL, execution-plan analysis, indexing strategies, window functions, set-based design, stored procedures / UDFs.

Data migration experience (SharePoint / Access → SQL Server / Azure SQL) with parity checks and rollback.

Engineering discipline : backups, release packaging, documentation, and change control for a business-critical system.

Communication : extremely clear written and spoken English in a must.

Data capable : strong data / numeracy is very important in order to understand and work with the complex data and algorithms in our environment.

Skills / Qualifications (nice-to-have)

Azure Synapse, Azure SQL Database / MI, Azure Data Factory; Azure DevOps / Git; PowerShell for automation.

Power BI exposure (datasets / models / DAX basics).

Data quality frameworks, metadata / cataloguing (e.g., Purview).

Experience with Data Governance (Quality, Lineage, Data dictionary, and Security).

Proficiency in programming languages such as Python for data engineering tasks.

How You Work :

Highly organized, self-starting, extremely methodical and conscientious, and able to manage complex projects.

Experience supporting and working with cross-functional teams in a dynamic environment.

Create a job alert for this search

Senior • Salem,Tamil Nadu, IN