Database Architect - Microsoft Access Migration

Position Overview

We are seeking an experienced Database Architect to design, implement, and maintain our databases. The ideal candidate will have a strong background in SQL and a deep understanding of data modeling, database management, and performance tuning to ensure our data infrastructure is efficient and secure.

Key Responsibilities

• Convert MS Access Databases: Migrate existing MS Access databases from 2016 32-bit to 2024 64-bit versions, ensuring data integrity and functionality.
• Database Automation: Develop and implement complex stored procedures in SQL Server to automate MS Access databases, enhancing efficiency and performance.
• Database Design and Development: Design, develop, and maintain MS Access databases, including tables, queries, forms, reports, and switchboards.
• VBA and Macros: Upgrade existing VBA code and write new, enhanced VBA code and macros to automate tasks and improve database functionality.
• Data Integration: Leverage SQL Server Integration Services (SSIS) to efficiently integrate and transform data from multiple sources.
• Performance Optimization: Monitor and optimize database performance, ensuring efficient data retrieval and storage.
• User Support and Training: Provide support and training to end-users.
• Documentation: Create comprehensive documentation for database structures, processes, and procedures.
  
  

Qualifications

• 5 years of experience in building and maintaining MS Access databases.
• Proficiency in MS Access, including tables, queries, forms, reports, and switchboards.
• Strong knowledge of VBA and macros, with the ability to upgrade existing code and write enhanced VBA code.
• Experience with SQL Server, including complex stored procedures and SSIS.
  
  

In this position, you may have access to client or customer systems, confidential and/or proprietary information or data. This position is onsite and requires you to work closely with other individuals in a collaborative team environment.

Benefits

Creative Circle's Freelance Employee benefits package includes eligibility for Minimum Essential Coverage (MEC) medical plan, dental/vision/term life package, discount prescription program, critical illness, accident, tele-behavioral health, and 401(k) plan. Sick leave is provided to Candidates whose assignment work location is in a state or city subject to sick leave laws. A Minimum Value (MV) PPO medical plan, Employee Stock Purchase Plan, and paid holiday eligibility are based on length and dates of service.

Email Your Resume In Word To

Looking forward to receiving your resume through our website and going over the position with you. Clicking apply is the best way to apply, but you may also:

sammy.realon@jobalert.creativecircle.com

• Please do NOT change the email subject line in any way. You must keep the JobID: linkedin : SR9-1844876 -- in the email subject line for your application to be considered.***
  
  

Sammy Realon - Senior Recruiter, National Delivery

For Creative Circle to represent you for this opportunity, you must be currently authorized to work in the United States without the need of employer sponsorship for a non-immigrant visa such as a H-1B, TN, or O visa. We do not support or provide training for STEM/OPT programs. Additionally, you must be physically located in and perform the work for our client in the United States.

This job was first posted by Creative Circle on 03/14/2025 and applications will be accepted on an ongoing basis until the position is filled or closed.

Creative Circle is an Equal Opportunity Employer

All qualified applicants will receive consideration for employment without regard to race, color, creed, religion, sex (including pregnancy, childbirth, breastfeeding, or related medical conditions), age, sexual orientation, gender identity or expression, national origin, ancestry, citizenship, genetic information, registered domestic partner status, marital status, disability, status as a crime victim, protected veteran status, or any other characteristic protected by law. Creative Circle will consider qualified applicants with criminal histories in a manner consistent with the requirements of applicable state and local law, including but not limited to the Los Angeles County Fair Chance Ordinance, the San Francisco Fair Chance Ordinance, and the California Fair Chance Act. If you need a reasonable accommodation in the application process, please contact your Recruiter (the person you'll be interviewing with) or a member of our Human Resources team to make arrangements. United Healthcare creates and publishes the Transparency in Coverage Machine-Readable Files on behalf of Creative Circle.

,