Jump to main content

Search Jobs

Senior MS Access Consultant - 6 Month Contract (Closed)

Job Highlights
Toronto
Contract

ARE YOU A SENIOR MS ACCESS DEVELOPMENT CONSULTANT LOOKING FOR AN EXCITING OPPORTUNITY IN A COMPLEX ENVIRONMENT? Our client, located in downtown Toronto,  would like a person with a strong Microsoft Access background and business acumen to help them in data manipulation and continuous database design and performance enhancement.

 

Senior MS Access Consultant - 6 Month Contract

 

About the Opportunity

  • Expert level of experience as an MS Access Developer working with database analysis, design and development, including applications and data migration/conversion
  • Gain a deep understanding of the application business logic, schema and features to be able to assist the development team with the design of database schema's, views, triggers
  • Expert with performance testing and enhancement in an MS Access based solution
  • Develop, implement, administer and maintain the security and integrity of the databases
  • Experience with optimizing MS Access performance in a large complex environment
  • Experience working with MS Access integration with other information systems
  • Resolve database performance, capacity, replication and other distributed data issues
  • Strong ability to convert MS Access queries and VBA code to SQL Server functions and stored procedures to improve performance and transaction handling
  • Experience working with complex database environments where data is being pulled from multiple data sources
  • Experience working with volatile data (not data with permanent structure) where you have to pull data from multiple locations and deliver it into one database while being able to address ripple effects and provide solutions based on findings
  • Experience working with interconnected database some of which is used for automatically generating Excel spreadsheets
  • Experience working in large user based environments where most users are remote
  • Experience working with a database of 1,000,000+ records
  • Experience developing seamless access to data sources
  • Complete other duties, tasks and activities as they arise

 

About You

  • Minimum 5+ years working with MS Access development as a senior consultant
  • An educational background in computer science or software engineering is an asset
  • Exceptional Excel skills are required
  • Design and Implementation for High Performance (Low Latency, High Throughput) Systems
  • Knowledge of reporting and query tools and practices
  • Technical documentation skills
  • Exceptional organizational, planning, time management, communication and interpersonal skills
  • Ability to work independently and in small groups/teams
  • Assistance in on-going technology improvement
  • MS Access certifications or training is preferred

 

How to Apply

Click the “Apply Now” button and follow the instructions to submit your resume. Please note that we only accept documents in MS Word or Rich Text formats. When referencing this job, quote #22351.

You must currently reside within the Greater Toronto Area and be permitted to work in Canada to be considered for this opportunity. A recruiter will be in touch with you if your profile meets our client’s requirements for this role.

 

About Lannick

Lannick is the premier professional recruitment and staffing firm in the Greater Toronto Area. Founded in 1985, Lannick provides best-in-class finance, accounting and technology professionals at all roles and levels through its three divisions: Lannick Finance & Accounting, Pro Count Staffing and Lannick Technology. Lannick places more than 1,000 candidates annually and is a preferred vendor for Canada’s most successful organizations. Learn more at www.lannick.com.