Database Architect

Database Architect

Contract role

Location- Englewood CO

Onsite position

Payrate- 65 to 72/hr on W2

Job Duties and Responsibilities:

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

Qualifications:

1. Experience: 5 to 7 years of experience in building and maintaining MS Access databases.
2. Technical Skills:

• 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.

1. Education: Bachelor's degree in Computer Science, Information Technology, or a related field (preferred).
2. Problem-Solving Skills: Strong analytical and problem-solving skills to troubleshoot and resolve database issues.
3. Communication Skills: Excellent verbal and written communication skills to interact with team members and end-users.
4. Attention to Detail: High level of attention to detail to ensure data accuracy and integrity.